Snowflake Connector
Before we explore the Snowflake connector – One of the many application connectors provided by Boomi, we should know what it is.
What is Snowflake?
Snowflake is a modern cloud-based data computing platform that helps data storage, organize, process, and provide analytic solutions that are faster and easier to use.
Coming back to Snowflake Connector, as already mentioned, it’s an application connector provided by Boomi to connect to and exchange data from the Snowflake platform. Using this connector, you can directly connect with the Snowflake platform, browse the interfaces in real-time, and exchange Snowflake data with any cloud or on-premises platform.
Like every other connector in Boomi, Snowflake Connector also requires the Snowflake Connection and Snowflake Operation components to connect to the Snowflake platform.
Snowflake Connection:
Stores the essential details required for establishing the Boomi-Snowflake connectivity.
Name: One can set the desired name for the connection in this field.
Connection URL: Stores the URL for the Snowflake Platform.
User: Stores the username of the Snowflake account used to log into the Snowflake platform.
Password: Stores the password of the Snowflake account used to log onto the Snowflake platform.
Private Key String: Stores the User’s private key.
Passphrase: Stores the passphrase for the private key.
Warehouse Name: Stores the warehouse name.
Database Name: Stores the database name where the target data is stored.
Schema name: Stores the name of the schema.
Role: Stores the user role.
S3 Access Key ID: Every AWS account has an Access Key that provides unrestricted access to all the resources available in the Amazon S3 account.
S3 Secret Key: Once the Access Key gets created, AWS lets you view and download the corresponding Secret Key that provides unrestricted access to all the resources available in the Amazon S3 account.
Date Time Format: Select the desired date time format from the dropdown menu.
Date Format: Select the desired date format from the given dropdown menu.
Time Format: Select the desired time format from the given dropdown menu.
Snowflake Operation:
Defines the action that needs to be performed on a specific Snowflake object using the Snowflake Connection.
- Name: One can set the desired operation name in this field.
- Object: The Snowflake Object against which you want to perform the said action.
- Request Profile: Defines the schema/structure of the request sent to the Snowflake
- Response Profile: Defines the schema/structure of the response received by the Snowflake
- Tracking Direction: This enables you to choose whether to track the input or output document and display the same in process reporting.
- Return Application Error Response: If selected processing continues and passes the error response to the next component processed as the connection output, otherwise stops the processing and reports an error in process reporting.
Cover Photo by Aaron Burden on Unsplash
