Snowflake Dataset with Custom SQL

Hi Team,

I have tried creating dataset for snowflake DB with Custom SQL. Will creating I am getting below error.

Error -

Snowflake DB Query Output -

Please note, I have executed sql manually on snowflake DB it is working as expected. Is there anything missing.

Let me know if you need any further input from my end.

@ErikG @Kristin

Hi @anshul1243,
do you have multible warehouses in snowflake?

Because on the SF screenshot it is “Compute_WH” maybe you have defined a different one in the QS datasource?

grafik

BR