Snowflake Nodes

Snowflake is a cloud-native data warehouse platform. MaestroHub provides seamless integration for running SQL queries, executing statements, and loading data into your Snowflake warehouse using connector nodes.

Configuration Quick Reference

Field	What you choose	Details
Parameters	Connection, Function, Function Parameters, Timeout Override	Select the connection profile, function, configure function parameters with expression support, and optionally override timeout.
Settings	Description, Timeout (seconds), Retry on Timeout, Retry on Fail, On Error	Node description, maximum execution time, retry behavior on timeout or failure, and error handling strategy. All execution settings default to pipeline-level values.

Snowflake Query Node

Snowflake Query Node

Execute SQL queries against your Snowflake data warehouse with full parameter binding.

Supported Function Types:

Function Name	Purpose	Common Use Cases
Execute Query	Run parameterized SQL SELECT against Snowflake	Analytics dashboards, ETL reads, cross-schema joins, data quality checks

Snowflake Execute Node

Snowflake Execute Node

Execute DML/DDL statements against your Snowflake data warehouse.

Supported Function Types:

Function Name	Purpose	Common Use Cases
Execute Statement	Run INSERT, UPDATE, DELETE, CREATE, ALTER, DROP statements	Data modifications, schema changes, cleanup operations

Snowflake Write Node

Snowflake Write Node

Bulk-load data into a Snowflake table with automatic schema detection.

Supported Function Types:

Function Name	Purpose	Common Use Cases
Write Data	Insert rows into a table with auto-detection and batching	Pipeline data loading, ETL writes, sensor data ingestion