The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

SQL Query error after connecting to snowflake

shanilashanila Member Posts: 6 Contributor II
in Help 
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-RapidMiner, Member Posts: 303 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.