Hi,
I am trying to connect Apache Drill to query Snowflake cloud data
warehouse. I was able to successfully create a snowflake storage plugin in
Drill web UI from my windows 10 machine with JSON structure as below. But I
am not able to either explore the tables in the schema in the explorer nor
query the tables. I am using Snowflake JDBC driver from their site:
https://docs.snowflake.net/manuals/user-guide/jdbc-configure.html#examples
What am I doing wrong? Thanks in advance for your help.
{
"type": "jdbc",
"driver": "net.snowflake.client.jdbc.SnowflakeDriver",
"url": "jdbc:snowflake://accountname.snowflakecomputing.com/?
warehouse=wh&db=test_db&schema=test_schema",
"username": "user",
"password": "pwd",
"caseInsensitiveTableNames": false,
"enabled": true
}
Thanks and Regards,
Jeganathan Velu
