Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Cue the extraordinary. Show-stopping experiences that raise the digital bar. Apply now for the 2023 Adobe Experience Maker Awards.
SOLVED

Is there a way to connect the DataLake with DBT?

Avatar

Level 2
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
1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 2

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:

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now