Amazon Redshift + Salesforce

Delete rows in Amazon Redshift when updated records are detected in Salesforce

Ensure your Amazon Redshift data is up-to-date by removing unnecessary information whenever a record gets updated in Salesforce. This workflow deletes rows in Amazon Redshift based on your updated Salesforce records, keeping your databases consistent and organized. Maintain data integrity across platforms with ease and efficiency.

When this happens...
Updated Record
Triggers when any record of the specified Salesforce object (ie. Contact, Lead, Opportunity, etc.) is updated.
TriggerPolling
automatically do this!
Delete Rows
Deletes row(s) in an existing table in Redshift.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

New Case Attachment
Triggers when a new Attachment is added to a case.
Trigger
Polling
Try It
- History ObjectRequired
Trigger
Polling
Try It
New Lead
Triggers when a new Lead is created.
Trigger
Polling
Try It
- Salesforce ObjectsRequired
Trigger
Polling
Try It
- Salesforce ObjectRequired
Trigger
Polling
Try It

- Salesforce ObjectRequired
- RecordRequired
- FileRequired
- VisibilityRequired
Action
Write
- LeadRequired
- AccountRequired
- Opportunity
- Create new opportunity?
- Converted StatusRequired
Action
Write

- Parent ObjectRequired
- Use Assignment Rules
Action
Write
- Note TitleRequired
- Note ContentRequired
- Salesforce Object
Action
Write
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Use Assignment Rules
- Allow Duplicates
Action
Write
- Warning
- Salesforce ObjectRequired
- Record IDRequired
Action
Write
- Contact to UpdateRequired
Action
Write
- Salesforce ObjectRequired
- Record to UpdateRequired
- Use Assignment Rules
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Salesforce ObjectRequired
- Search ValueRequired
- Second Field to Search By
- Second Search Value
- Search Operator
Action
Search
- Salesforce ObjectRequired
Action
Search
- Salesforce ObjectRequired
- Record IDRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE ClauseRequired
- Sort by
- Sort Order
- Maximum Number of Records
- Use Assignment Rules
- Allow Duplicates
Action
Search or write
- TableRequired
- Returned ColumnsRequired
- Updated Date ColumnRequired
- Primary Key
Trigger
Polling
Try It
- TableRequired
- ColumnRequired
- OperatorRequired
- ValueRequired
Action
Write
- QueryRequired
Action
Search

New Contact
Triggers when a new Contact is created.
Trigger
Polling
Try It
- Salesforce ObjectRequired
- Record (Optional)
Trigger
Polling
Try It
New Outbound Message
Triggers when a new outbound message is received in Salesforce.
Trigger
Instant
Try It
- Disclaimer
- Salesforce ObjectRequired
Trigger
Polling
Try It
- CampaignRequired
- ContactRequired
Action
Write
- CampaignRequired
- LeadRequired
Action
Write
- FileRequired
- Salesforce ObjectRequired
- Description
- Attachment visibility
Action
Write
Create Contact
Creates a new contact.
Action
Write
- FileRequired
- Title
- Description
- Salesforce Object
Action
Write
- Note TitleRequired
- Note
- Salesforce ObjectRequired
- Note Visibility
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Use Assignment Rules
- Allow Duplicates
Action
Write
- ToRequired
- CC
- BCC
- SubjectRequired
- Email FormatRequired
- Sender TypeRequired
Action
Write
- Lead to UpdateRequired
- Use Assignment Rules
Action
Write
- Salesforce ObjectRequired
- Record to UpdateRequired
- Use Assignment Rules
Action
Write
- Parent ObjectRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE clauseRequired
Action
Search
- Salesforce ObjectRequired
- SOQL WHERE ClauseRequired
- Sort by
- Sort Order
- Maximum Number of Records
Action
Search
- Salesforce ObjectRequired
- Search ValueRequired
- Second Field to Search By
- Second Search Value
- Search Operator
- Use Assignment Rules
- Allow Duplicates
Action
Search or write
- QueryRequired
Trigger
Polling
Try It
- TableRequired
- Insert Into ColumnsRequired
Action
Write
- TableRequired
- Update ColumnsRequired
- Where ColumnRequired
- OperatorRequired
- Value
Action
Write
- TableRequired
- Returned ColumnsRequired
- Where ColumnRequired
- OperatorRequired
- Value
- Row Limit
Action
Search

About Amazon Redshift

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.

Related categories

About Salesforce

Salesforce is a leading enterprise customer relationship manager (CRM) application.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Related Zap Templates

Create Salesforce records each time new rows are added in Amazon Redshift

Create rows in Amazon Redshift when new records are added in Salesforce

Amazon Redshift + Salesforce

Delete rows in Amazon Redshift when updated records are detected in Salesforce

New Case Attachment

New Field History Tracking Event

New Lead

New Record

Updated Record

Add File to Record

Convert Lead to Contact

Create Child Records (with line item support)

Create Enhanced Note

Create Lead

Create Record

Delete Record

Update Contact

Update Record

API Request (Beta)

Find Record

Find Records

Get Record Attachments

Find or Create Record by Query

Updated Row

Delete Rows

Query Database

New Contact

New or Updated File on Record

New Outbound Message

Updated Field on Record

Add Contact to Campaign

Add Lead to Campaign

Create Attachment

Create Contact

Create File

Create Note

Create Record (UTC)

Send Email

Update Lead

Update Record (UTC)

Find Child Records

Find Records by Query

Find Record by Query

Find or Create Record

New Row

Create Rows

Update Rows

Find Rows

About Amazon Redshift

Related categories

About Salesforce

Related categories

Similar apps

Zapier Interfaces

Related Zap Templates

Related Zap Templates