Snowflake Processor
Snowflake is a cloud-based data warehouse system. The user can use Snowflake as a processor in Gathr for ELT pipelines.
| Field | Description |
|---|---|
| Connection Name | The user will be required to mention the connection name for creating connection. |
| Warehouse Name | Specify the warehouse name. |
| Schema Name | Mention the schema name. |
| Query Type | The user can select the type of query that he wants to write. i.e either Static query or Dynamic query. Static query contains normal SQL query while as in dynamic query the user can use an existing dataset columns using @ as shown in the image above. |
| Query | The user will be required to specify the static value/dynamic value, which ever he selects in the query type. A static query will run once to update the query, while the dynamic type will update the query at run time. |
If you have any feedback on Gathr documentation, please email us!