Snowflake

Get started with the snowflake target!

Connector Details

NameValue
PlatformSnowflake
Auth TypeOAuth/Keypair
DirectionBidirectional
API versionRest API
Testing AccountSnowflake Account
Unified SchemaINFORMATION_SCHEMA

Connector Versions

NameVersionStageDescription
Snowflakev1GASupports Snowflake Accounts

Get your Snowflake credentials

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!

Supported Data

Sample Postman Collection