CODEWITHSUNDEEP
snowflake-cloud-data-platformazure-data-factoryazure-adflinked-service
Divya Pardeshi
Divya Pardeshi

Reputation: 11

Error while making dataset Connection with Snowflake in Azure ADF dataset

I have two linked services one for SQL and other for Snowflake.While making snowflake dataset connection in ADF it throws below error: Error details Error code 9602 Details ERROR [22000] Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name. Activity ID: 5d0a5741-1efc-42b0-a835-045bb9bba1f8

It worked for the first time but later it is giving error. I checked the privileges to my role and that is sufficient. The name of the Database is also correct all in capital letters.

Upvotes: 0

Views: 393

Answers (1)

Michael Golos
Michael Golos

Reputation: 2069

Try setting a default database on the user using the ALTER USER command in Snowflake:

ALTER USER user1 SET DEFAULT_NAMESPACE = database_name

Upvotes: 0

Related Questions