Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to work around and find the solution how to bring relevant data to pbi from Snowflake DB.
I have a connection to Snowflake DB, but it is huge and I can't load it all, to reduce size I need to use SQL query to inner join two tables and filter it.
When I connect to Snowflake I add SQL in this box:
However it gives me this error:
Is there a way I can have dynamic connection to Snowflake Database with SQL query?
TIA
Solved! Go to Solution.
Try removing the semicolon at the end of the SQL. Also, try removing the quotes from the database, schema, and table names.
Proud to be a Super User!
@Anonymous,
Custom SQL requires that you populate the Database field:
Proud to be a Super User!
When I typed in this box "LIGHCAST"."UK""POSTING_SKILLS" it gives me the same error.
Enter only the database name LIGHTCAST.
Proud to be a Super User!
Thank you fro your answer, now it gives this error
Try removing the semicolon at the end of the SQL. Also, try removing the quotes from the database, schema, and table names.
Proud to be a Super User!
I'm having this same issue, but I didn't have the table names in "" and no semicolon in my sql. I've noticed that if a hard code the connection into the query editor I have no issue pulling in my data - but this is a bit of a faff. I've tested with a very simple sql expression:
select count(*) from [warehouse].[schema].[table] but literally any sql in the UI will cause this error for me.
Like I say, I have a viable workaround but would like to know what's causing this issue in case I need to trouble shoot again in the future.
Thank you so much, it works!