Snowflake and Workato Data Tables integrations and automations

Do everything in one place

Customize your Snowflake and Workato Data Tables integration with the following triggers and actions.

Triggers

When this happens…

Snowflake
  • New row
    New row in a table in Snowflake
  • New rows Batch
    New batch of rows in a table in Snowflake
  • Scheduled query Batch
    Scheduled query using custom SQL in Snowflake
  • New/updated row
    New/updated row in a table in Snowflake
  • New/updated rows Batch
    New/updated batch of rows in a table in Snowflake

    • Any other trigger you can think up

Workato Data Tables
  • New record Real-time
    New record in a data table
  • New/updated record Real-time
    New/updated record in a data table

    • Any other trigger you can think up

Actions

Do this…

Snowflake
  • Bulk load data to table from stage Bulk
    Bulk load data to table from stage in Snowflake
  • Delete rows Batch
    Delete rows in a table in Snowflake
  • Export query result
    Export query result as a CSV file in Snowflake
  • Insert row
    Insert row in a table in Snowflake
  • Merge rows
    Merge rows from source table to target table in Snowflake
  • Replicate schema
    Replicate table schema in Snowflake
  • Run custom SQL Batch
    Run custom SQL in Snowflake
  • Run long query using custom SQL
    Run long query using custom SQL in Snowflake
  • Select rows Batch
    Select rows in a table in Snowflake
  • Select rows using custom SQL Batch
    Select rows using custom SQL in Snowflake
  • Replicate rows Batch
    Replicate batch of rows to table in Snowflake
  • Update rows
    Update rows in a table in Snowflake
  • Upload file to internal stage
    Upload file to internal stage in Snowflake
  • Upsert rows Batch
    Upsert batch of rows in a table in Snowflake

    • Any other action you can think up

Workato Data Tables
  • Create record
    Create a new record in a data table
  • Delete record
    Delete a record from a data table
  • Search records Batch
    Search records in a data table matching specified criteria
  • Remove values from a record
    Remove field values from a record in a data table
  • Truncate table Batch
    Truncate a data table
  • Update record
    Update a record in a data table
  • Upsert record
    Upsert record in a data table

    • Any other action you can think up

The wonders of Workato

Easily set up as many intelligent automations you need.
  • 1000s of ready-to-use templates
  • Accelerate work with intelligent automation
  • Do it yourself, faster
  • Build bots. Put them to work

Market leaders run on Workato

  • monday
  • box
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo