Snowflake icon

Snowflake Integration

Cloud data platform for warehousing, analytics, and data sharing. Connect Snowflake to AI agents and downstream tools whenever important data changes. When Get a Statement fires, follow with Cancel a Statement or Make an API Call so connected systems stay up to date.
3-day trialCancel anytimeUp to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Supported triggers and actions for Snowflake integration

Triggers can detect changes in Snowflake and run actions that can create, search or modify data inside Snowflake automatically [3] — exactly how you set them.

  • Snowflake icon
    Get a StatementReturns the status and results of a submitted SQL statement.
  • Snowflake icon
    Cancel a StatementCancels a running SQL statement.
  • Snowflake icon
    Make an API CallPerforms an arbitrary authorized API call.
  • Snowflake icon
    Submit a StatementSubmits a SQL statement and returns its handle.

How to integrate Snowflake in automation workflow?

3 simple steps to make your Snowflake connected with other apps in automation workflows on WEXTL. Up to 10 minutes integration set up.

How Snowflake connects and integrates with WEXTL

Save and approve your credentials once — WEXTL® stores authorization information encrypted and reuses the authentication whenever Snowflake app is called in workflows. That allows your database automations to run without your attention, per defined schedule [7]. Explore documentation [6] for a detailed list of fields that Snowflake supports.

The following table illustrates what fields Snowflake integration require during authorization flow inside our workflow builder [4].

Demonstration of Snowflake connection step inside WEXTL Workflow Builder [4].

FieldTypeHelp
Account IdentifierRequired
text

The host label only, such as myorg-myaccount. No https:// and no .snowflakecomputing.com. For an account locator, leave the region off.

Client IDRequired
text

The client id of your OAuth integration.

Client SecretRequired
password

The client secret. It is sent in the token form, not as a header.

Role
text

Leave blank to use the user's default role. If set, the name must match SHOW ROLES, including case. One role. A name that needs session:role-encoded: is not encoded here; leave Role blank and set the integration's default.

Connect Snowflake to popular apps on WEXTL

Enter a name of the other app you want to sync with Snowflake below. Click on selected app to explore integration options with Snowflake. If the app you search for is not available in WEXTL yet, you can use HTTP node [10] instead to integrate it directly.

Example automation with Snowflake integration

Select Get a Statement action from Snowflake - this will be a starting point in your automation. Whenever event happens in Snowflake, workflow will start [7] from Get a Statement node.

Search for Cancel a Statement, connect it as the next step of integration sequence. You can use filters between Get a Statement and Cancel a Statement, so only important data pass from Get a Statement to the next step. WEXTL gives you full control over the process of Snowflake automation. All parts of workflow are visible on the canvas [4].

Snowflake on WEXTL has 4 modules for crafting database automations. Explore Snowflake documentation for more.

Snowflake
Get a Statement
Google Firestore
Performs action
OR
Google Firestore
Triggers
Snowflake
Cancel a Statement

Demonstration of how visual Snowflake automation [6] looks in WEXTL.

Frequently asked questions

Common questions about automating Snowflake in your workflows.

Try Snowflake on WEXTL®

Claim your 3-day trial to build Snowflake integrations and access every WEXTL® feature.

Cancel anytime.

References

List of sources used to gather information about the Snowflake integration.

  1. Snowflake integration source code, module specs and credentials implementation.
  2. Internal Snowflake integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official Snowflake vendor API documentation — used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
  4. WEXTL® Visual Workflow Builder, anonymized data from our technical support team.
  5. WEXTL® Apps Library
  6. WEXTL® Snowflake App Documentation
  7. WEXTL® Workflow Scheduler
  8. WEXTL® HTTP node documentation