PostgreSQL and Snowflake integrations and automations

Do everything in one place

Customize your PostgreSQL and Snowflake integration with the following triggers and actions.

Triggers

When this happens…

PostgreSQL

New row
New row in a table in PostgreSQL
New rows Batch
New batch of rows in a table in PostgreSQL
New/updated row
New/updated row in a table in PostgreSQL
New/updated rows Batch
New/updated batch of rows in a table in PostgreSQL

Any other trigger you can think up

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

Actions

Do this…

PostgreSQL

Delete rows Batch
Delete rows in a table in PostgreSQL
Export query result
Export query result as a CSV file in PostgreSQL
Insert row
Insert row in a table in PostgreSQL
Run custom SQL Batch
Run custom SQL in PostgreSQL
Run long query using custom SQL
Run long query using custom SQL in PostgreSQL
Select rows Batch
Select rows in a table in PostgreSQL
Select rows using custom SQL Batch
Select rows using custom SQL in PostgreSQL
Get table schema
Get table schema for PostgreSQL
Update rows
Update rows in a table in PostgreSQL
Upsert rows Batch
Upsert batch of rows in a table in PostgreSQL

Any other action you can think up

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

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

Let’s start automating

Schedule a Demo