Hi, I am trying to run meltano locally using docke...
# troubleshooting
h
Hi, I am trying to run meltano locally using docker image
meltano/meltano:v1.96.0-python3.7
sync from
postgres
to
snowflake
. I am getting the error below
Copy code
Cannot perform CREATE TABLE. This session does not have a current database. Call 'USE DATABASE', or use a qualified name
a
In the config for target-snowflake, can you make sure you have a valid config value for the database name setting?
h
dbname: DATA_DEV
a
Yeah, that should do it.
The other possibility though is that the role you are running under might not have access to that db. Can you check that the DB exists and the role can access it?
h
granted access on all the underlying objects but not usage on the DB. thank you
a
Been there 😅