Is there a way to connect the DataLake with DBT? | Community
Skip to main content
benedikt-buchert
Level 2
November 19, 2022
Solved

Is there a way to connect the DataLake with DBT?

  • November 19, 2022
  • 1 reply
  • 1704 views
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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Manoj_Kumar

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

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
November 23, 2022

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

Manoj     Find me on LinkedIn
benedikt-buchert
Level 2
November 28, 2022

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: