Connecting to Snowflake

Snowflake is an analytic data warehouse that uses an SQL database, in a SaaS offering, and enables you to load, integrate, analyze and securely share their data and consume shared data. 

You can easily upload datasets from Snowflake tables to the Explorium platform. Explorium leverages SQLAlchemy as a connector to export data from Snowflake, into the Explorium platform. 

Snowflake is a storage system that is used to store all of your data and analyze it. One can think of it as an infinite hard disk that Explorium uses for storage.

There are three options to connect to Snowflake:

• Create a new project
• Edit an existing project connection
• Export data from the Export >Run recipe button

Connecting to Snowflake when Creating a New Project

1. Click Enrich. The Enrich page is displayed.
2. Click . The Create a new project window is displayed.
   
3. Type in a new project name. The project name needs to be unique.
4. Select a use case from the drop-down. 
5. Click Create project. The Upload a dataset window appears.
   
6. Select Snowflake.
   
7. All the fields are Mandatory. Enter the connection name.
8. Type in the Account Name.
9. Type in the Username.
10. Type in the Password.
11. Type in the DB Name.
12. Type in the Schema Name.
13. Type in the Warehouse.
14. Type in the Role.
15. Click Test Connection to make sure the connection is successful. A message is displayed informing you if the connection was successfully created or not. If the test connection failed, then you are unable to create a connection. 
    Before creating a new connection, a Test Connection must be run. If the test failed, or a parameter was changed, the Create button will be disabled, and you need to create a new connection.
    
    
16. After the test connection has succeeded, click Create in order to create the connection, and to start working with it.

Connecting to Snowflake when Editing a Dataset

1. Click Enrich. The Enrich page is displayed.
2. Create or search for a project.
3. Click .
   
4. The Change data and edit dataset window appears.
   
5. Click Continue. The Upload a dataset window appears.
   
6. Select Snowflake. 
7. All the fields are Mandatory. Select the connection name.
8. Type in the Account Name.
9. Type in the Username.
10. Type in the Password.
11. Type in the DB Name.
12. Type in the Schema Name.
13. Type in the Warehouse.
14. Type in the Role.
15. Click Test Connection to make sure the connection is successful. A message is displayed informing you if the connection was successfully created or not. If the test connection failed, then you are unable to create a connection.
16. After the test connection has succeeded, click Create in order to create the connection, and to start working with it.

Exporting Data

1. Click Enrich. The Enrich page is displayed. 
2. Create, search or edit a project.
3. Click the Export >Run Recipe.
   
4. The Schedule Recipe Run window is displayed.
   
5. Select the input connection (optional).
6. Select the output connection.