Hello, I was trying to load my data to GoodData from Snowflake - created the connection, the model, but when trying to set the Automatic Data Distribution, I am getting following error:
2020-07-20T16:00:40.109+0200 [ERROR]: Fail to load projects "[puceqi1sg2z2cxcxsxs2k6brq5vn5uh3]". Reason: Unable to unload:
PreparedStatementCallback; SQL [COPY INTO @STAGE__20200720__8pwvUFfC/out_customer__20200720__j7O2j5sS__ FROM (SELECT "a__country" AS "a__country","cp__customerid" AS "cp__customerid" FROM "out_customer") FILE_FORMAT=(type=CSV NULL_IF=('') FIELD_OPTIONALLY_ENCLOSED_BY='"' compression='GZIP') OVERWRITE=true HEADER=true MAX_FILE_SIZE=100000000]; No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
; nested exception is net.snowflake.client.jdbc.SnowflakeSQLException: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
:
No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
Can someone help me understand what I can do to make it work? Where can I put the ‘use warehouse’ command? I do have my warehouse selected in the connection and in the Snowflake console it is marked as “started”.
Thank you.
Best answer by Boris
View original