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 a destination table
- ELT with databases
Change replication and data synchronization
- Comparing data replication techniques
- Change Data Capture (CDC)
- 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 files
Working with web services
Working with emails
Working with social networks
Working with Salesforce
Working with Marketo
Connecting to Google services
Working with Google Analytics
Working with Google AdWords
Working with Google Sheets
Working with Snowflake
- Getting started with Snowflake
- Loading data in Snowflake
- ELT with Snowflake
- Snowflake flow examples
- Using wildcard filenames in Snowflake COPY INTO command
- Working with Snowflake as with a relational database