Snowflake Connection with SQL query

[Anonymous]

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

[DataInsights]

@Anonymous,

Custom SQL requires that you populate the Database field:

[Anonymous]

When I typed in this box "LIGHCAST"."UK""POSTING_SKILLS" it gives me the same error.

[DataInsights]

Enter only the database name LIGHTCAST.

[Anonymous]

Thank you fro your answer, now it gives this error

[DataInsights · Accepted solution]

Try removing the semicolon at the end of the SQL. Also, try removing the quotes from the database, schema, and table names.

[Dann]

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.

[Anonymous]

Thank you so much, it works!