Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Snowflake Database Parameter Ignored

Has anyone noticed when explicitly specifiying a Snowflake database, it is ignored? It appears my default database is always used.

jeffshieldsdev_0-1638294999613.png

 

Status: Accepted

Have submited this issue internal to confrim(ICM: 275332274), would update here as soon as possible if there is any progress about it.

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Accepted

Have submited this issue internal to confrim(ICM: 275332274), would update here as soon as possible if there is any progress about it.

 

Best Regards,
Community Support Team _ Yingjie Li

jeffshieldsdev
Solution Sage

I just reviewed the documentation again, and this requirement is called out:

"SQL Statement ... In this version of native database query functionality, you need to use fully qualified table names in the format Database.Schema.Table, for example SELECT * FROM DEMO_DB.PUBLIC.DEMO_TABLE."