Contents

Cancel

Recommended Articles

  1. unify-apps

    Indexing

    Unify AI

    Transform raw content into searchable knowledge through AI-powered indexing and vector embeddings

  2. unify-apps

    JobNimbus

    Unify Integrations

    Integrate your application with JobNimbus to manage leads, track jobs, and streamline your workflow processes efficiently

  3. unify-apps

    IMAP

    Unify Integrations

    Integrate your app with IMAP to enable seamless email synchronization, real-time access, and enhanced communication workflows.

  4. unify-apps

    Preview Your Work

    Unify Automations

    Effortlessly review & monitor your automation’s performance

  5. unify-apps

    QuickBooks

    Unify Integrations

    Integrate your app with QuickBooks to streamline accounting, automate invoicing, and manage finances effortlessly

  6. unify-apps

    FTP/FTPS

    Unify Integrations

    Connect your app with FTP/FTPS to automate secure file transfers and streamline data exchange across systems.

  7. unify-apps

    Filters

    Unify Applications

    Enable users to refine, search, and sort data effortlessly across dashboards and datasets

  8. unify-apps

    Insided

    Unify Integrations

    Integrate your app with Insided to enhance customer engagement, streamline community management, and drive self-service support.

  9. unify-apps

    Facebook Ads

    Unify Integrations

    Connect your app with Facebook Ads to automate campaign management, optimize ad performance, and track marketing success.

  10. unify-apps

    Gainsight

    Unify Integrations

    Integrate your app with Gainsight to enhance customer success, automate engagement workflows, and drive retention

  11. unify-apps

    Livestorm

    Unify Integrations

    Integrate your app with Livestorm to streamline webinar hosting, automate event management, and enhance audience engagement.

  12. unify-apps

    Snowflake

    Unify Automations

    Connect to Snowflake for fast, scalable cloud data warehousing and analytics

  13. unify-apps

    Cognito Forms

    Unify Integrations

    Integrate your app with Cognito Forms to create custom forms, automate data collection, and streamline workflows

  14. unify-apps

    Button

    Unify Applications

    Create interactive elements with ease using buttons

  15. unify-apps

    BambooHR

    Unify Automations

    Integrate your app with BambooHR to streamline HR management, automate employee data processing, and enhance onboarding workflows

  16. unify-apps

    Build your first automation

    Unify Automations

    Learn how to build your automation step by step

  17. unify-apps

    User Management

    Unify Applications

    Efficiently manage user roles and permissions

  18. unify-apps

    Microsoft Teams

    Unify Automations

    Connect your app with Microsoft Teams to enhance communication, automate workflows, and foster collaboration across your organization

#
Unify Automations
Logo
Snowflake

Snowflake

Logo

3 mins READ

Integrating your application with Snowflake transforms your data warehousing and analytics capabilities, offering a cloud-native platform for scalable, flexible, and high-performance data processing.

Connecting your application to a Snowflake account allows you to interact with Snowflake's data warehousing capabilities directly from your application.

Authentication

Before you begin, make sure you have the following information:

Connection Name: Select a descriptive name for your Snowflake connection. This identifier will help you recognize the connection within your application or integration settings. For example, you might choose something like "MyAppSnowflakeDataWarehouse"

Account Identifier: This is your unique Snowflake account locator. To find this, click on "admin" in the Snowflake interface, then click on "your accounts." Hover over the "locator" field, and you'll see the Account Identifier displayed as something like abc12345.region.snowflakecomputing.com.

Image
Image

Client ID and Secret: Fetch the Client ID and Secret for your Snowflake account basis this documentation.

Image
Image

Warehouse Name: It is the compute resource that executes SQL queries. To view your warehouses, go to the left sidebar and click "Admin" then click "Warehouses". Here, you'll see a list of warehouse names and their details.

Image
Image

Database Name: It is another crucial piece of information. This is the container for your schemas and tables. To view your databases, go to the left sidebar and click "Data" then click "Databases". You'll see a list of all available databases.

Image
Image

Schema Name: To view schemas, first select a database, then click "Schemas" within that database. You'll see a list of all schemas in the selected database.

Image
Image

Actions

Action

Description

Delete rows

Deletes rows in a table using Snowflake

Execute SQL

Executes SQL in Snowflake

Insert a row

Inserts a row in a table in Snowflake

Replicate batch rows

Replicates a batch of rows to a table in Snowflake

Select rows

Selects rows from a table in Snowflake