Use Cases
Working with databases
- Get started with databases
- ETL with relational databases
- Create pipeline to CDC data into relational database
- SQL actions: INSERT, UPDATE, DELETE, MERGE, IFEXIST, CUSTOM
- Transaction management
- Open database connection when needed
Bulk load data into databases
Change replication and data synchronization
- Compare data replication techniques
- Change Data Capture (CDC) from transaction log
- Change Replication using High Watermark (HWM)
- Change Data Tracking (CT)
- Real-time change replication with Kafka and Debezium
- Change replication using full refresh
Working with files
Working with web services
Working with Snowflake
- Get started with Snowflake
- Extract, transform, and load data in Snowflake
- Bulk load files into Snowflake
- Create pipeline to CDC data into Snowflake
- Load files in Snowflake using user-defined COPY INTO command
- ELT with Snowflake
Working with Amazon Redshift
- Get started with Amazon Redshift
- Extract, transform, and load data in Amazon Redshift
- Bulk load files in S3 into Redshift
- Create pipeline to CDC data into Amazon Redshift
- Load files in Redshift using user-defined COPY command
- ELT with Amazon Redshift