SQL Query error after connecting to snowflake

shanila
shanila New Altair Community Member
edited November 5 in Community Q&A
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:

Answers

  • jwpfau
    jwpfau New Altair Community Member
    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