Snowflake

Get started with the snowflake target!

Enable the Snowflake target

Head to your flow, and go to the target options.

19001900

Go ahead and search for the Snowflake target.

19151915

From here, go ahead and select the Snowflake target.

18961896

You should now input your credentials for Snowflake. If you don't know where to get these credentials, you can learn where to find them here.

18871887

Enter the credentials and Save the changes.

19151915

You have now set up your Snowflake target. Now that you have set up a source and a target, your flow is ready to run a job.

Get your Snowflake credentials

For the Snowflake target to work correctly, you need to create a snowflake account from here.

19201920

Enter the credentials or register the account.

19031903

This is your home page. To get started, click the Database button in the top right corner.

19201920

You can now create the new database and to get the required credentials.

19201920

For the account field in hotglue, you can find your Account information in the URL at the top of the page. As you can see in the picture above, it appears directly after app.snowflake.com, and includes your region.

19201920

Next, you should search for Schema in the secondary navigation bar. You will now be able to see your database name (this example is called Target Test). Within Target Test, you can see the Schema being used for target test. Input this as the schema field in hotglue.

19091909

Next, search for warehouse in the secondary navigation bar. You can now see the warehouse you would like to associate. You can find what you need to input right above the table on the right. In this example, the input into hotglue would be COMPUTE_WH.

19091909

Lastly, we will look to grab the file-format from Snowflake. In the secondary navigation bar on the left side, click on the database and navigate to PUBLIC. You should then be able to see what the File Format is for your specific warehouse. Go ahead and input that information into hotglue.

You should now be all set to set up your target Snowflake!


Did this page help you?