Solved
Is there a way to connect the DataLake with DBT?
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