0

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.

Divya Pardeshi
  • 11
  • 1
  • If you call "show databases" in a Snowflake Worksheet, does the name of the database also appear in all capitals? – aek Oct 13 '22 at 11:45

1 Answers1

0

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

ALTER USER user1 SET DEFAULT_NAMESPACE = database_name
Michael Golos
  • 1,814
  • 1
  • 6
  • 16