Is there a way to connect the DataLake with DBT?

[benedikt-buchert]

Hi, I'm trying to access the Data Lake via DBT (Data Base Transform Tool). Are DBT and Adobe Experience Platform compatible? I have tried to use the Postgres connector (https://docs.getdbt.com/reference/warehouse-setups/postgres-setup) with the following settings. adobe_experienceplattform: outputs: dev: type: postgres host: myTenant.platform-query.adobe.io user: myuser@AdobeOrg password: tempPasswordCopiedFromThe Interface port: 80 dbname: "mySandbox:all" schema: "myschema?" threads: 1 keepalives_idle: 0 # default 0, indicating the system default connect_timeout: 10 # default 10 seconds #search_path: [optional, override the default Postgres search_path] #role: [optional, set the role DBT assumes when executing queries] #sslmode: prefer target: dev But I'm getting the following error: Database Error ErrorCode: 42P02 Database "all" does not exist Am I using the correct connector? There is also: https://docs.getdbt.com/reference/warehouse-setups/spark-setup

[_Manoj_Kumar_ · Accepted solution]

Hello @benedikt-buchert 

I was facing the same connection issue when using the pgAdmin client. But it worked with DBvisualizer.  

More details on the clients are available here.

Connect Clients to Query Service | Adobe Experience Platform

[benedikt-buchert]

Hi @_Manoj_Kumar_ thank you.

I was able to connect via other Database tools. But I want to use DBT to better organize my queries and use the extended functionality of DBT:

[benedikt-buchert]

So essentially this means it is not possible?