SQL Query error after connecting to snowflake

shanilashanila Member Posts: 6 Contributor I
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'.

Answers

  • jwpfaujwpfau Employee, Member Posts: 274 RM Engineering
    Hi shanila,

    have you already tried to add a semicolon between the queries?
    USE WAREHOUSE WAREHOUSENAME;
    SELECT *
    FROM "RAPIDMINER"."PUBLIC"."AUTHORDATASET"
    Otherwise it's also possible to set the warehousename either as a jdbc property or via the jdbc url.

    Greetings,
    Jonas
Sign In or Register to comment.