A SQL statement. Example: SELECT * FROM "public"."users" WHERE "firstname" = 'Lars';  Make sure the query returns an "id" field, and is sorted by created time descending (or use a descending sort on an autoincremented ID field). 

Specify a column that contains an updated date (or another value that changes on every row update). Zapier uses this to know when the row is updated.

Specify which column contains the primary key. Zapier uses this to determine if we have already seen a specific row. If nothing is provided, Zapier will hash all the data in the row, which may cause unforeseen behavior.

A SQL statement. Example: SELECT * FROM "public"."users" WHERE "firstname" = 'Lars'; 

Define the columns you wish to insert into.

Select the column you want to match against.

Used to define the operator to match against the value. Example: If you want to delete all rows where the column "name" is "Test", you would select "name" as the column and "=" as the operator and "Test" as the value.

Used to define the value to match against the operator. Example: If you want to delete all rows where the column "name" is "Test", you would select "name" as the column and "=" as the operator and "Test" as the value.

Amazon Redshift is a fast, scalable data warehouse that makes it simple and cost-effective to analyze all your data across your data warehouse and data lake.

Zapier Automation Platform

PRODUCTS

CAPABILITIES

By use case

By app

By team

By company size

How Zapier Zaps

How Zapier Uses AI

By team

Learn more

Get help

Zapier quick-start guide

Developer resources

Amazon Redshift Integrations

Amazon Redshift Help & Support

How to get started with Amazon Redshift on Zapier

About Amazon Redshift

Related categories