SQL Query error after connecting to snowflake
shanila
New Altair Community Member
USE WAREHOUSE WAREHOUSENAME
SELECT *
FROM "RAPIDMINER"."PUBLIC"."AUTHORDATASET" Exception: com.rapidminer.core.io.data.DataSetException Message: SQL compilation error: syntax error line 2 at position 0 unexpected 'SELECT'.
Tagged:
0
Answers
-
Hi shanila,
have you already tried to add a semicolon between the queries?USE WAREHOUSE WAREHOUSENAME;
Otherwise it's also possible to set the warehousename either as a jdbc property or via the jdbc url.
SELECT *
FROM "RAPIDMINER"."PUBLIC"."AUTHORDATASET"
Greetings,
Jonas0