top of page

Snowflake Connector - Catalog, Transform, Query, Visualize

The Snowflake connector allows data to be cataloged, queried, transformed and to create tables in Snowflake Data Cloud. This can be used to quickly and easily join data between different systems like Snowflake and Hive, or between different Snowflake instances.


The Snowflake connector is available for all Promethium editions, including Free, Professional and Enterprise.


If you don't have a Promethium account, get your free account now

Jump to the how to video.


Connect Snowflake

Connecting to Snowflake is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select Snowflake and enter the information for your Snowflake.

Image of Snowflake connection in Promethium
Snowflake Connection

Snowflake connection details can be case sensitive. Ensure that data is entered with the correct case for your Snowflake.

Field

Description

Data Source Name

Give the Snowflake connection a unique name for easy identification.

Description

Optional. A meaningful description for this connection.

Data Source Topic

Optional. Categorize the Snowflake connection. For example, Marketing.

Snowflake Account Name

Enter the account name for your Snowflake account.

User Name

​Enter the username associated with your Snowflake account.

Password

Enter the password associated with your Snowflake account.

Warehouse

Enter the warehouse containing the data you want to retrieve.

Database Name

Enter the database containing the data you want to retrieve.


What Happens Next - Finish Snowflake Connection

Click the Connect button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your Snowflake, then make the data easily searchable and usable.


Click Data Explorer from the menu and begin exploring the data in your Snowflake Data Cloud.

Screenshot of Snowflake data in Promethium
Snowflake Data Catalog Promethium

FAQs

Is my data moved or copied out of Snowflake?

No. Your data stays in Snowflake and isn't moved to Promethium.


What options are available for publishing datasets?

Datasets can be published as a view, as a table in Snowflake or as a dbt model.


Is this a Production-level connector?

Yes. The Snowflake connector is designed for all-sized Datasets.


Watch how to video


51 views

Recent Posts

See All
bottom of page