SQL Query error after connecting to snowflake

shanilashanila MemberPosts:6Contributor I
inHelp 
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, MemberPosts:245RM 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 InorRegisterto comment.