Once you have completed the installation process for the template's respective endpoints, you can configure the export settings for Snowflake and import settings for the selected application.
Note that all of your flows are disabled when first installed. After configuring the flows, you may enable them in your Flows dashboard or in Flow Builder with the Off/On toggle button. then run or schedule each flow.
Snowflake – HubSpot Reverse ETL
The business process application template automates syncing updated HubSpot company and contact updates from the Snowflake database to HubSpot. This template consists of two flows, Snowflake to HubSpot company update and Snowflake to HubSpot contact update.
Configure Export (Snowflake):
The aim here is to retrieve updates from Snowflake and send them to the appropriate endpoint application. Given the template, we can import updated HubSpot company details or updated HubSpot contact details with the supplied two flows.
This SQL query field indicates the Snowflake fields you want to extract and filters the data based on the insert time to retrieve records from the update time. Any amount of records can be returned by structuring the query. The export type is set to Delta, allowing you to extract data that has recently been modified.
Configure Import (HubSpot): We are fetching the company details and updating the relevant details in HubSpot. Provide the required fields in the Settings, API version, API name, Operation, identification of existing records, and the field.
Here, you can see the pre-packaged out-of-the-box mappings. These can be any fields, columns from the Snowflake table to map to the HubSpot. These mappings are customizable according to your requirements.
Snowflake – NetSuite Reverse ETL
The business process application template automates syncing updated NetSuite company and contact updates from the Snowflake database to NetSuite. This template consists of two flows, Snowflake to NetSuite contact update and Snowflake to NetSuite customer update.
Configure Export (Snowflake):
The aim here is to retrieve updates from Snowflake and send them to the appropriate endpoint application. Given the template, we can import updated NetSuite contact details or updated NetSuite customer details with the supplied two flows.
This SQL query field helps you to specify what fields from Snowflake you want to extract, and it filters the data, based on the insert time to get the records from the update time. The query can be structured to return any number of records. The export type is set to Delta, which allows you to extract data that has been updated recently.
Configure Import (NetSuite): We are fetching the company details and updating the relevant details in NetSuite. Provide the required fields in the settings, Record Type, Operation (Update), define the primary key to find the existing record from Snowflake.
The pre-packaged out-of-the-box mappings are displayed here. Any fields or columns from the Snowflake table can be mapped to NetSuite. These mappings can be customized to meet your specific needs.
Snowflake – Salesforce Reverse ETL
The business process application template automates syncing updated Salesforce account and contact updates from the Snowflake database to Salesforce. This template consists of two flows, Snowflake to Salesforce account update and Snowflake to Salesforce contact update.
Configure Export (Snowflake):
The aim here is to retrieve updates from Snowflake and send them to the appropriate endpoint application. Given the template, we can import updated Salesforce account details or updated Salesforce contact details with the supplied two flows.
This SQL query field helps you to specify what fields from Snowflake you want to extract, and it filters the data, based on the insert time to get the records from the update time. The query can be structured to return any number of records. The export type is set to Delta, which allows you to extract data that has been updated recently.
Configure Import (Salesforce): We are fetching the company details and updating the relevant details in Salesforce. Provide the required fields in the settings, Record Type, Operation (Update), define the primary key to find the existing record from Snowflake.
Here, you can see the pre-packaged out-of-the-box mappings. These can be any fields, columns from the Snowflake table to map to the Salesforce. These mappings are customizable according to your requirements.
Snowflake – Zendesk Reverse ETL
The business process application template automates syncing updated Zendesk organizations and user updates from the Snowflake database to Zendesk. This template consists of two flows, Snowflake to Zendesk organization update and Snowflake to Zendesk user update.
Configure Export (Snowflake):
The aim here is to retrieve updates from Snowflake and send them to the appropriate endpoint application. Given the template, we can import updated Zendesk account details or updated Zendesk contact details with the supplied two flows.
This SQL query field helps you to specify as to what fields from Snowflake you want to extract, and it filters the data, based on the insert time to get the records from the update time. The query can be structured to return any number of records. The export type is set to Delta, which allows you to extract data that has been updated recently.
Configure Import (Zendesk): We are fetching the company details and updating the relevant details in Zendesk. Provide the required fields in the Settings, API version, API name, Operation, identification of existing records, and the field.
Here, you can see the pre-packaged out-of-the-box mappings. These can be any fields, columns from the Snowflake table to map to the Zendesk. These mappings are customizable according to your requirements.
Comments
Please sign in to leave a comment.