Snowflake

What is the Snowflake Connection?

The Snowflake connection connects your Snowflake data warehouse to Duvo, enabling your assignments to query and analyze your enterprise data on your behalf. This is a user-configured connection—you'll need to provide your Snowflake connection details (username, database, schema, warehouse, and role) before your assignments can use it.

What Can It Do?

The Snowflake connection provides actions that allow your assignments to:

• Execute read queries: Run SQL queries to retrieve data from your data warehouse

• Get connection info: Verify connection details and database information

• List tables: Discover available tables within your schema

Why This Matters

Snowflake serves as the central data warehouse for many organizations, storing critical business data, analytics, and insights. The Snowflake connection allows your assignments to access this data directly—running queries to inform decisions, pulling metrics for reports, and leveraging your enterprise data without manual database access or CSV exports.

When to Use It

Use the Snowflake connection when your assignment needs to:

• Pull business metrics: Retrieve sales data, customer analytics, or performance indicators

• Generate data-driven reports: Query warehouse data to populate reports or documents

• Validate information: Check current data values before making business decisions

• Enrich workflows: Combine warehouse data with other systems for comprehensive automation

• Monitor thresholds: Query metrics to trigger actions when certain conditions are met

How It Works

After connecting your Snowflake credentials, your assignments can execute SQL queries against your data warehouse using the specified database, schema, warehouse, and role. When you include Snowflake actions in your assignment's SOP, it will query data just as you would—running SELECT statements to retrieve the information needed for workflow decisions.

Key Benefits

Enterprise data access: Connect assignments directly to your central data warehouse

Real-time insights: Query current data rather than relying on static exports

Secure access: Uses role-based permissions and encrypted logins

SQL flexibility: Execute any read query to get exactly the data you need

Data-driven automation: Make intelligent workflow decisions based on actual warehouse data

The Snowflake connection is essential for data-driven workflows—enabling your assignments to leverage enterprise analytics and business intelligence for informed, automated decision-making.