Head to your flow, and go to the target options.
Go ahead and search for the Snowflake target.
From here, go ahead and select the Snowflake target.
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.
Enter the credentials and Save the changes.
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.
For the Snowflake target to work correctly, you need to create a snowflake account from here.
Enter the credentials or register the account.
This is your home page. To get started, click the Database button in the top right corner.
You can now create the new database and to get the required credentials.
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.
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.
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.
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!
Updated 3 months ago