Redshift Snap Pack examples

Example Snaps used
Redshift - Bulk Load

Load data from MySQL into Redshift

This example demonstrates how to extract data from a MySQL database and load it into Redshift using the Bulk Load Snap.

Bulk Load with twin inputs

This example shows how to use the Redshift Bulk Load Snap with multiple input streams.

Bulk Load configurations

This example demonstrates various configuration options available in the Redshift Bulk Load Snap.

Load Twitter data into Redshift

This example shows how to extract data from Twitter and load it into Redshift using the Bulk Load Snap.

Bulk Load from file

This example demonstrates how to read data from a file and bulk load it into Redshift.
Redshift - Bulk Upsert

Bulk Upsert operation

This example demonstrates how to perform bulk upsert operations in Redshift, updating existing records and inserting new ones.
Redshift - Delete

Delete all records

This example shows how to delete all records from a Redshift table.

Delete with conditions

This example demonstrates how to delete records from Redshift based on specific conditions.

ETL delete operation

This example shows how to perform delete operations as part of an ETL pipeline.
Redshift - Execute

Execute custom SQL

This example demonstrates how to execute custom SQL statements in Redshift.

Execute stored procedure

This example shows how to call and execute stored procedures in Redshift.
Redshift - Insert

Basic insert operation

This example demonstrates basic insert operations into Redshift tables.

Insert with Mapper

This example shows how to use the Mapper Snap with Redshift Insert to transform and insert data.

Insert with table creation

This example demonstrates how to create a table and insert data into it using the Redshift Insert Snap.
Redshift - Select

Select with WHERE clause

This example shows how to select data from Redshift using WHERE conditions.

Select with pagination

This example demonstrates how to implement pagination when selecting large datasets from Redshift.
Redshift - Update

Conditional update

This example demonstrates how to update Redshift records based on specific conditions.
Redshift - Lookup

Lookup and enrich data

This example shows how to use the Redshift Lookup Snap to enrich data with information from Redshift tables.
Redshift - Unload

Unload data to S3

This example demonstrates how to unload data from Redshift to Amazon S3 using the Redshift Unload Snap.
Redshift - SCD2

Slowly Changing Dimension Type 2

This example demonstrates how to implement Slowly Changing Dimension Type 2 (SCD2) logic in Redshift.