About Snowflake and the Snowflake ODBC driver
Snowflake is a cloud data platform that focuses on data warehousing, analytics and data lakes.
As Snowflake is gaining popularity, many of our customers and prospects are reporting a gap in the market for a stable and reliable solution for ODBC connectivity to Snowflake. The Progress DataDirect Snowflake ODBC driver will allow you to connect to your Snowflake data warehouse from any BI and/or ETL tool which supports standard ODBC connectivity.
The driver will support all the CRUD operations supported by Snowflake. The driver is ODBC Standard 3.8 compliant and utilizes the SQL Engine capabilities of Snowflake for query execution.
You can download the User's Guide and other relevant documentation for this driver along with the installer package from the URLs listed in the Download Information sections below.
The documentation will talk in detail about the minimum requirements, steps to configure the driver, and connection options supported by the driver. The readme file contains the release highlights and some of the functionality that is not part of this preview release.
Features which are not part of the preview (but may be considered for GA)
Minimum requirements for Setup:
AccountName – Specifies the full name of your account and region where it is hosted.
DatabaseName – Specifies the name of a Snowflake database.
Schema – Specifies the default schema to use for a database once connected or an empty string. The specified schema should be an existing schema for which the default role has privileges. Alternatively USE SCHEMA command to change or update the Schema.
Warehouse – Specifies the virtual warehouse to use once connected, or an empty string. The specified warehouse should be an existing warehouse for which the default role has privileges.
UserID – Snowflake UserID
Password – Password for the specified user connecting to Snowflake
Sample Connection string "Driver=Datadirect 8.0 Snowflake Preview Driver; AccountName=progress_software.us-east1;LogonID=<UserID>;Password<PWD><DatabaseName=<SnowflakeDBname>;Schema=<SnowflakeSchema>;Warehouse=<Snowflakewarehouse>"
Snowflake User's Guide: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=0SSHQVOUTMPDL
I think it would be helpful to have documentation on where to find the Account Name within the Snowflake console and how it is formatted. I had to look up the docs for Snowflake's JDBC driver. Maybe a screen shot or something similar to the Account Name by Region table docs.snowflake.net/.../jdbc-configure.html
From what I have found, if your URL to Snowflake is:
the username would be:
I too was briefly stumped by this field, though I admit I didn't read the documentation - I just assumed that it was the same as the SERVER keyword in the Snowflake-supplied ODBC driver, where you supply the full URL. when I saw the error (which showed problems connecting to company.us-east-1.snowflakecomputing.com.snowflakecomputing.com) I realized to drop the .snowflakecomputing.com part.
I have noted the feedback and will be updating the Document with more detailed information for ACCOUNT NAME.
My client is testing the new driver and while the connection to Snowflake presentation layer (production) is working fine. The connection to staging layer (sandbox) is causing problems. Either no preview of the data is available at all or the data starts to load but fails after a few (thousand) records. One difference between the two layers is that the staging layer uses S3 in the back-end which the presentation layer doesn't. Not sure if the error goes back to S3 or to the sandbox environment (staging layer) or the combination of both. Any know limitations with staging layer (Snowflake sandbox environment) and/ore S3?
We are not aware of any limitations with Snowflake running in Production vs Sandbox Environment. Is it possible to get access to your Snowflake Sandbox account and run tests on it.
Also let us know if it is possible to get on a call with your client and understand the issue better?