Input Connector Nodes
      Back to home
      1. Home
      2. 5: Workflow Toolkit
      3. Input Connector Nodes

      Snowflake Connector

      The Snowflake connector node in Rayven.io provides a powerful way to automate SQL queries, manage stored procedures, and integrate Snowflake data into your workflows

      The Snowflake connector node in Rayven.io enables seamless integration with your Snowflake data warehouse. This connector allows you to automate SQL queries, run multiple SQL statements, and manage stored procedures directly from Rayven.io workflows. With Snowflake’s powerful data platform and Rayven’s workflow automation, you can streamline data operations and integrate Snowflake data with other systems effortlessly.

      Setting up the Snowflake Connector in Rayven.io

      1. Create a Snowflake Account and Generate API Keys:

        • Sign up or log in to your Snowflake account at Snowflake.
        • Navigate to Account Settings and generate the SQL API key needed for authentication.

      2. Add Snowflake Credentials in Rayven.io:

        • In Rayven.io, navigate to Settings > Credentials.
        • Add your Snowflake account URL, API key, and other credentials to establish a secure connection between Snowflake and Rayven.io.

      Available Snowflake Operations in Rayven.io

      Below are the pre-configured endpoints available for the Snowflake connector in Rayven.io workflows.

      SQL API Endpoints

      • Endpoint: Snowflake SQL API
      • Description: Execute SQL queries directly against your Snowflake instance and retrieve results.
      • Usage: Use this node to run ad-hoc queries and extract data into your workflow.

      Multiple SQL Statements in a Single Request

      • Endpoint: Multiple SQL Statements
      • Description: Submit multiple SQL queries in a single request, improving efficiency by reducing the number of API calls.
      • Usage: Use this node to run complex workflows that involve multiple sequential queries.

      Stored Procedures

      • Endpoint: Stored Procedures
      • Description: Execute stored procedures in Snowflake to manage data and perform advanced operations.
      • Usage: Use this node to automate database procedures, such as inserting records or performing data transformations.

      Using the Snowflake Connector in Rayven.io Workflows

      1. Create a New Workflow:

        • Navigate to Workflows in Rayven.io and click Create Workflow.

      2. Add Snowflake Nodes:

        • Drag and drop the required Snowflake Input Nodes (SQL API or Stored Procedure) into your workflow.

      3. Configure the Nodes:

        • For SQL API nodes, provide the SQL query you want to execute.
        • For multiple SQL statements, enter each query as part of a single request.
        • For stored procedure nodes, specify the procedure name and any required parameters.

      4. Incorporate Triggers and Business Logic:

        • Use trigger nodes to initiate workflows based on Snowflake query results (e.g., send an alert if query output meets specific conditions).
        • Apply logic nodes to further process the query results within Rayven.io.

      5. Push Data to Dashboards or External Systems:

        • Use visualization nodes to display Snowflake data on dashboards.
        • Use output nodes to send the processed data to other systems if needed.

      Example Use Case: Automated Data Sync for Reporting

      Scenario: A business wants to extract data from Snowflake and display it on Rayven dashboards for real-time reporting.

      1. Workflow Setup:

        • Use the SQL API Node to run a query that extracts sales data from Snowflake.
        • Configure a trigger node to run the query periodically (e.g., every hour).
        • Use a dashboard node to display the queried data in a real-time report.

      2. Optimization:

        • Use Multiple SQL Statements to run batch queries and reduce API calls.
        • Automate stored procedures to clean and transform data before sending it to Rayven.

      HTTP Node for Custom API Calls

      If you need to use additional endpoints or operations not pre-configured, you can utilize the HTTP Node in Rayven.io to connect to any Snowflake API endpoint directly.

      Steps:

      1. Add an HTTP Node to your workflow.
      2. Select Authentication > Predefined Credential Type and choose Snowflake.
      3. Provide the API endpoint, headers, and payload required for the custom operation.

      Refer to the Snowflake API Documentation for further details on available operations.

      Conclusion

      The Snowflake connector node in Rayven.io provides a powerful way to automate SQL queries, manage stored procedures, and integrate Snowflake data into your workflows. Whether you're building real-time reports or automating data transformations, this connector ensures seamless data flow between Snowflake and other systems.

      For more advanced operations, explore the Snowflake API Documentation at:

      If you need assistance with setup or have additional requirements, contact our support team for help.