Snowflake Dataset with Custom SQL

Question & Answer
,
1

Hi Team,

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

Error -

image
image1912×882 99.2 KB

Snowflake DB Query Output -

image
image1812×953 133 KB

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

2

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