Snowflake Data Targets
Overview
DataBlend supports a variety of data targets for creating, modifying, and deleting specific records in Snowflake.
Configuration
Setting | Required/ Optional | Description |
|---|---|---|
Type | Required | Snowflake |
Name | Required | Enter a unique name. |
Query | Required | Select the query that will generate the data for this target. |
Query Mode | Required | Select New unless you have a reason to select Latest or Specific. |
Credential | Required | Select a Database from the drop-down menu. |
Snowflake Data Target Type | Required | DataBlend currently offers a Run Statements option |
Advanced
History Retention
History Retention (Days) allows users to decide how long they want the information from their data targets to be stored. This field is optional.
Timeout (seconds)
The Timeout section allows users to determine if they would like to timeout collections taking longer than a set number of seconds to collect data.
Skip If No Records Found
The “Skip if No Records Found” button is used to eliminate sending information to Data Targets unnecessarily. Simply enable the “Skip if No Records Found” toggle. The use of this toggle is optional.
Agent
The Agent drop-down for users to select any agent they have established. This is optional.
Run As
Run As allows users to select from a drop-down list of users to run the Workflow. This is optional. Please note that Run As is only available to Admin users. If a user is set as the Run As and then demoted to a Member, the user which demoted the Run As user will instead be set as the Run As.
Schedule & Presets
Link to Schedule and Presents
https://datablend.atlassian.net/wiki/spaces/DS1/pages/1416593411