SQL Query error after connecting to snowflake

shanila

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'.

jwpfau

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