How to connect to Snowflake from Denodo

Applies to: Denodo 7.0
Last modified on: 13 Mar 2019
Tags: Cloud JDBC data sources Snowflake

Download original document

You can translate the document:

Goal

This document describes how to access Snowflake from the Denodo Platform.

Content

Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS), which uses cloud-based hardware and software.

Starting from version 6.0, Denodo includes a connector for Snowflake. Therefore, Denodo is going to use the supported JDBC adapter “Snowflake” for accessing Snowflake as a data source.

Connecting to Snowflake from Denodo

  • From the Virtual DataPort Administration tool, create a new JDBC data source by selecting “File > New > Data source > JDBC”. This will open the wizard to create a connection to a data source with a JDBC driver.

  • To create a connection, fill all the required fields:
  • Name: ds_snowflake
  • Database adapter: Snowflake
  • Database URI: use a connection string in the form of: jdbc:snowflake://host/?db=database&schema=schema&warehouse=warehouse

For example : jdbc:snowflake://host/?db=SAMPLE_DB&schema=SAMP&warehouse=VDP_WH

  • Username: Enter the username to connect to Snowflake
  • Password: Enter the appropriate password.

  • Once the details are filled, click on “Test Connection” and if the connection is successful, click on “Save”.

  • Once the data source is created, create base views for that particular source. In order to do that click on the "Create Base View" option.

  • This will then display a tree with the schemas of the database. Click on any schema to inspect its tables and their fields.  To search a view or a schema, type its name in the “search” box located at the top of the dialog. The list will only show the elements whose name contains the text you entered.  

  • To incorporate some of the tables into the Denodo virtual schema, you have to check the box near the tables or views you want to import and then click “Create selected”.

  • When the importing process is finished, the new views are displayed.

  • Now, the base views are ready for the execution and to be combined with the rest of the sources.

References

Virtual DataPort Administration Guide: JDBC Sources

Virtual DataPort Administration Guide: Supported JDBC Data Sources

Snowflake JDBC connectivity Guide: Snowflake JDBC Driver

How To Video: Denodo and Snowflake

Snowflake Data Warehouse

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training