Konnectify
Submit a Ticket

Snowflake

Recent Searches

No recent searches

    Popular Articles

      Articles

      View all

        Topics

        View all

          Tickets

          View all
            no results

            Sorry! nothing found for

            Snowflake + Konnectify

            Snowflake Integration with Konnectify

            Sync enterprise data seamlessly by automating Snowflake database rows and tables with your business applications.

            Rows Tables 2 Triggers 8 Actions

            What is Snowflake?

            Snowflake is a cloud-based data platform that enables organizations to store, analyze, and query massive datasets with exceptional speed and scalability. By connecting Snowflake to Konnectify, you can bridge the gap between your core business applications and your centralized data warehouse, automating data pipeline ingestion and syncing operational records in real time.

            New to Snowflake?

            Set up your enterprise data cloud and configure your databases, schemas, and virtual warehouses.

            Visit Snowflake website →

            New to Konnectify?

            Create your workspace to start building automated workflows between Snowflake and your business tools.

            Sign up for Konnectify →

            What you can automate

            • Stream newly added database rows directly to CRMs or messaging tools.
            • Automatically log sales transactions and ERP records into Snowflake tables.
            • Instantly update existing database records based on external application events.
            • Run custom SELECT queries to retrieve targeted segments of warehouse data.
            • Programmatically create and alter database tables as your schemas evolve.
            • Sync deleted records across platforms to maintain data warehouse integrity.

            API & Authentication

            Secure OAuth 2.0 Authentication

            Snowflake uses a custom OAuth 2.0 authorization flow to establish a secure connection. This ensures Konnectify can securely read, write, and update data within your warehouse without ever seeing or storing your Snowflake password.

            To authorize the connection, you must provide your Client ID and Client Secret generated from a custom Snowflake OAuth security integration, along with your Account Identifier, target Warehouse, Database, Schema, and optional Role.

             Active Virtual Warehouse Required

            Konnectify requires an active Snowflake virtual warehouse to execute queries and retrieve metadata. Ensure the authorized OAuth role has USAGE permissions on your designated warehouse, database, and schema to prevent connection timeouts or query failures.

            For comprehensive details on creating security integrations and managing roles, refer to the official Snowflake Documentation.

            How to Connect

            Prerequisites before you begin:
            • A Snowflake account with permissions to run CREATE SECURITY INTEGRATION.
            • Your Snowflake Account Identifier (formatted as orgname-accountname).
            • The names of your active Virtual Warehouse, Database, and Schema.
            1

            Add Snowflake to a Workflow

            1. Log in to your Konnectify dashboard and create a new workflow.
            2. Search for Snowflake in the application library and select it as either a Trigger or Action.
            2

            Authorize via OAuth 2.0

            1. In Snowflake, configure your redirect URI to: https://app.us.konnectifyapp.co/ipaas/api/oauth/callback.
            2. Enter your generated Client ID and Client Secret into the Konnectify connection window.
            3. Provide your Account Identifier, Warehouse, Database, and Schema. Click Authorize to log in and approve the connection.
            3

            Configure the Trigger or Action

            1. Select the specific Snowflake table you want to monitor or modify.
            2. Map the incoming fields from your source application directly to your Snowflake table columns.
             Schema Matching

            Ensure the data types mapped from external applications match your Snowflake column definitions (e.g., VARCHAR, TIMESTAMP, NUMBER) to avoid SQL execution errors.

            4

            Test the Workflow

            1. Click Test inside the workflow builder to run a dry-run execution.
            2. Verify that data is correctly retrieved from or written to your active Snowflake table.
            5

            Activate the Workflow

            1. Toggle your integration to Active.
            2. Konnectify will now run your Snowflake automation automatically in the background.

            Triggers 2

            Triggers monitor your Snowflake tables for changes and instantly pass that data to other applications in your workflow.

             Rows 2 triggers ▾ 
            New Row Or Updated Row

            Polls the selected Snowflake table for rows whose timestamp is within the UTC since/till interval.

            New Row Custom Query Poll

            Polls Snowflake with a custom SELECT query and returns the next page of rows.

            Actions 8

            Actions allow your workflows to write, update, query, or delete records and tables in Snowflake when events occur in other apps.

             Rows 4 actions ▾ 
            Create Row

            Creates one row in the selected Snowflake table using the table's live column metadata.

            Update Row

            Updates one row in the selected table. The connector validates that the selected key/value matches exactly one row before updating.

            Find Row By Unique Key

            Returns the first row matching the selected key column and value.

            Delete Row

            Deletes one row after first verifying that the selected key/value matches exactly one row in the selected table.

             Tables 4 actions ▾ 
            Create Table

            Creates a Snowflake table either by executing a complete CREATE TABLE query or by creating a table from a SELECT query.

            Update Table

            Updates the structure or properties of a selected Snowflake table using either a complete ALTER TABLE query or an ALTER clause.

            Find Table

            Finds a Snowflake table using either its table name or Snowflake-generated table ID and returns the table metadata and columns.

            Delete Table

            Drops the selected Snowflake table after reading its metadata for the output payload.

            Popular Automations

            Log New CRM Contacts to Snowflake

            Keep your central data warehouse updated by automatically creating a new row in your contacts table whenever a lead is created in your CRM.

            New Contact Trigger → Create Row

            Sync Payment Transactions to Snowflake

            Automatically append payment and invoice data to your financial tables the moment a successful transaction occurs in your payment gateway.

            New Payment Trigger → Create Row

            Update Warehouse Records on Deal Changes

            Ensure pipeline analytics are accurate by updating the matching deal row in Snowflake when a sales opportunity is closed-won.

            Deal Updated Trigger → Update Row

            Alert Teams of New Database Insights

            Trigger instant Slack or Teams notifications whenever a new data record meets your polling criteria in Snowflake.

            New Row Or Updated Row → Send Message Action

            FAQ

             What authentication does Snowflake use? ▾ 
            Snowflake utilizes secure OAuth 2.0 authentication. You must configure a custom OAuth security integration in Snowflake and input the generated Client ID, Client Secret, and Account Identifier into Konnectify to establish the link.
             Which Snowflake editions are supported? ▾ 
            This integration supports Snowflake Standard, Enterprise, and Business Critical editions. Please ensure that your database user role has the required privileges to read, write, or alter schemas in your selected database.
             How do the row triggers work? ▾ 
            The Snowflake triggers use a polling mechanism. At scheduled intervals, Konnectify queries your specified table for rows with a timestamp that falls within your configured interval, fetching new or updated records to initiate your workflows.
             How do I prevent duplicate rows in Snowflake? ▾ 
            To avoid duplicates, you can use the "Find Row By Unique Key" action in your workflow first. If a matching row is found, you can route your workflow to update that row using the "Update Row" action; otherwise, you can safely trigger the "Create Row" action.
             Does Konnectify support custom SQL SELECT queries? ▾ 
            Yes. The "New Row Custom Query Poll" trigger allows you to write a custom SELECT query to extract specific datasets, filter columns, or perform joins before returning rows to your workflow.
             Can I connect multiple Snowflake databases? ▾ 
            Yes. You can create multiple Snowflake connections in your Konnectify workspace, each targeting a different database, schema, or virtual warehouse as required by your business segments.
             What is the "Account Identifier" and where do I find it? ▾ 
            The Account Identifier is the unique name Snowflake assigns to your account. It is used in your Snowflake web interface URL, typically structured as <orgname>-<accountname> before the .snowflakecomputing.com domain.

            Ready to automate your Snowflake data workflows?

            Connect Snowflake to your operational tools and start syncing critical business data in minutes.

             Get started free → 

            Was this article helpful?

            That’s Great!

            Thank you for your feedback

            Sorry! We couldn't be helpful

            Thank you for your feedback

            Let us know how can we improve this article!

            Select at least one of the reasons
            CAPTCHA verification is required.

            Feedback sent

            We appreciate your effort and will try to fix the article

            Preview
            0 of 0