Dialect to use for Snowflake Database

Question

What is the dialect I need to use to connect with Snowflake database?

I've configured JDBC driver for Snowflake database @ lib folder and restarted Knowage; Leter I attempt to create Datasource for Snowflake; Getting Knowage manual and Snowflakes manual I managed to write connection string viz., something like

jdbc:snowflake://myportal.snowflakecomputing.com/?user=myname&password=myPassword&role=MY_ROLE&warehouse=MY_WAREHOUSE&db=MY_DATABASE&schema=MY_SCHEMA

I don't know is the Dialect I need to select for SnowFlake database; Test connection return success for any dialect I choose; But on creation of dataset It don't fetch preview dataset.

So how to deal this.

Answer 1

I'm sorry but at the moment Snowflake DB is not supported.

You can try to use a different dialect but of course the result is not guaranteed.