Use Cases
Working with databases
- Getting started with databases
- Migrating data from one database to another
- SQL actions: INSERT,UPDATE,DELETE,MERGE,IFEXIST
- Transaction management
- Automatically create or alter a destination table
- ELT with databases
Change replication and data synchronization
- Comparing data replication techniques
- Change Data Capture (CDC) from transaction log
- Real-time change replication with Kafka and Debezium
- Change Replication using High Watermark (HWM)
- Using a fully-qualified field name for high watermark field
- Calculating high watermark field value
Working with web services
Working with Snowflake
- Getting started with Snowflake
- Extract, transform and load data in Snowflake
- ELT with Snowflake
- Directly load files in Snowflake
- Using wildcard filenames in Snowflake COPY INTO command
- Working with Snowflake as a relational database