Connect to Snowflake

Snowflake connectivity is bundled with Omniscope -  you will be able to connect to Snowflake as seen here:

Key-pair authentication

The example above uses a password. If your Snowflake account prevents this, and you are unable to use a LEGACY_SERVICE user account type, you should configure key-pair authentication.

Follow the Snowflake docs on Key-pair authentication.  You will need to generate and store securely an unencrypted private key. You'll need to add the public key to the user in Snowflake using an ALTER USER statement. It is recommended that you use a user of type SERVICE for this, too. 

You'll also need to be sure that you are using a recent Snowflake JDBC driver. Omniscope comes bundled with this unless you are using an older version.

In this example we're using a private key file on the Omniscope server. This should be outside of the sharing folder, perhaps in a special folder designated for private keys created using Project Resource Access in Admin.

Note the use of private_key_file rather than password, for authentication. The value is the full path on the Omniscope server to the private key created following the Snowflake documentation.

Also see further documentation on these parameters.

Older instructions for Omniscope 2023 (JDBC driver configuration)

To make older versions of Omniscope able to connect to a Snowflake database it is first necessary to upload the jdbc driver in the admin app. This is a necessary step the first time Omniscope needs to connect to a Snowflake database, or when the Snowflake jdbc driver itself needs to be updated.

If the jdbc driver is not configured, Omniscope will be unable to connect to Snowflake, and it will show an error like in the in the image below.

To configure the jdbc driver for Snowflake navigate to the Admin app, then open the 'Database Drivers' section:

Next, scroll to the Snowflake section, and follow the download link:

In the new tab, scroll to the very bottom and follow the link associated to the latest version of the jdbc driver (3.9.2 at the time of writing ).

In the new tab you need to select the file called snowflake-jdbc-<version>.jar 

where <version> is the latest version of the jdbc driver. In the scenario below, the file needed is snowflake-jdbc-3.9.2.jar.

Important: Make sure to download the correct file here (i.e., the one with a jar extension, and not a -javadoc, -sources, -tests suffix) otherwise Omniscope will not be able to connect.  

To upload the jdbc driver to Omniscope go back to the 'Database Drivers' section of the Admin app, scroll to the top of the page, select 'Snowflake' in the 'Database' dropdown, and chose the file downloaded earlier.

Finally click 'Upload' to upload the driver:

After the jdbc driver has been uploaded, Omniscope will be able to use it to connect to Snowflake: