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
- Automatically create staging tables from any data source
- Expose a database object or SQL query as an API endpoint
- Read records from a database and execute the flow for each record
- Execute any SQL outside of regular source-to-destination transformation
- Execute SQL from JavaScript
- Tips and tricks when working with databases