Snowflake Reader

This document outlines the functionality of the Snowflake Reader node, which enables executing SELECT queries on Snowflake databases and using the results in automated workflows.

​

Node Configuration

• Query: SQL SELECT statement to execute

  • Must be a valid SELECT query
  • Can be dynamically provided from previous nodes
  • View Snowflake SQL reference

• Column Names: Specify which columns from your query results to expose as outputs

  • Each column becomes a separate output that can connect to other nodes
  • Output is in List format

​

Authentication

1. Navigate to Credentials page
2. Add Snowflake credentials:
   • Account Identifier URL (e.g., org-account.region.snowflakecomputing.com)
     • Required for connecting to your Snowflake instance
     • How to find your account identifier
   • Username
   • Password

​

Example Workflows

​

1. Sales Performance Alerts

Snowflake Reader (sales metrics) → Combine Text → Slack Message Sender

• Snowflake Reader fetches daily sales metrics including revenue, targets, and regional performance
• Combine Text formats the data into a structured alert message:
  • Highlights underperforming regions and revenue gaps
  • Shows month-over-month comparisons
  • Includes relevant sales manager contacts
• Slack messages are automatically routed to:
  • Regional sales channels for local performance
  • Executive channel for company-wide metrics
  • Custom channels based on alert severity

​

2. Inventory Management

Snowflake Reader (inventory levels) → Gmail Sender → Airtable Writer

• Snowflake Reader monitors:
  • Current stock levels across warehouses
  • Historical consumption rates
  • Supplier details and lead times
• Gmail Sender automates:
  • Purchase order emails to suppliers
  • Order confirmation requests
  • Delivery timeline updates
• Airtable Writer maintains:
  • Complete order history
  • Supplier response times
  • Reorder patterns for analysis

​

3. Customer Engagement Automation

Snowflake Reader (customer data) → Ask AI → SendGrid Email Sender

• Snowflake Reader collects:
  • Purchase history and frequency
  • Product category preferences
  • Customer interaction data
• Ask AI processes this data to:
  • Generate personalized product recommendations
  • Create customized email content
  • Optimize sending times
• SendGrid Email Sender delivers:
  • Targeted promotional campaigns
  • Personalized follow-up messages
  • Product recommendation emails

​

4. Data Quality Monitoring

Snowflake Reader (data quality metrics) → Jira Issue Creator → Slack Message Sender

• Snowflake Reader checks for:
  • Missing or null values
  • Data format inconsistencies
  • Anomalous patterns
• Jira Issue Creator automatically:
  • Opens tickets for detected issues
  • Assigns to appropriate team members
  • Sets priority based on impact
• Slack notifications include:
  • Issue summary and severity
  • Direct link to Jira ticket
  • Required action items

​

Common Use Cases

1. Data-Driven Alerts

   • Performance monitoring
   • Threshold-based notifications
   • SLA tracking
   • Error detection

2. Automated Reporting

   • Regular business reports
   • KPI dashboards
   • Compliance reporting
   • Team performance metrics

3. Process Automation

   • Customer communications
   • Supply chain management
   • Resource allocation
   • Quality control

4. Data Integration

   • Sync data to other platforms
   • Update external systems
   • Consolidate information
   • Cross-platform analytics

​

In Summary

The Snowflake Reader node allows seamless integration of Snowflake databases into automated workflows by executing SELECT queries and exposing query results as outputs for further processing. Ideal for data-driven alerts, reporting, and process automation.