-
- Before we connect with snowflake let’s understand what is snowflake :- While data is a core asset for modern enterprises, technology’s ability to scale has created a surge of big data. Managing and storing that data has become a critical function for modern business operations. Choosing a data platform that can handle massive volumes of big data, high speeds, and reliability — not to mention the ease of use, is top of mind. Most enterprises are already using a cloud data platform, but many are evaluating whether a data migration might be needed in order to stay competitive. One of the most popular data platforms is Snowflake,which operates as a cloud data warehouse and is heralded for its ability to support multi-cloud infrastructure environments. Snowflake is a data warehouse built on top of the Amazon Web Services or Microsoft Azure cloud infrastructure, and allows storage and compute to scale independently.
- Now let’s see how we can connect with snowflake in Helical Insigth for this you need to have active snowflake account.
- In order to connect with Helical Insight you must know about your hostid,user,role,warehouse and Database
- You can copy your account URL this will be user HOST
![Helical Insight connection with snowflake](https://www.helicalinsight.com/wp-content/uploads/2021/03/image001-18.png)
- Use this to find you account SELECT CURRENT_ACCOUNT();
- After this find out what is role for this user,warehouse and Database which you want to connect.
- Now go to the Data source in helical Insight and click on add drive and add Snowflake Driver here you can find the Driver https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/
- Enter the URL. for ex: jdbc:snowflake://<snowflake_host>/?warehouse=<warehouse_name>&db=<test>&schema=PUBLIC&tracing=ALL
- Then Provide your username and password with Data source Name and click on test connection now you are able to connect snowflake with Helical Insight
![Helical Insight connection with snowflake](https://www.helicalinsight.com/wp-content/uploads/2021/03/image003-17.png)
Congrats you have connected with snowflake.
Thank You,
Abhishek
Helical Insight