Working with databases
Tutorials for building ETL/CDC pipelines for relational databases with advanced SQL support, transactions, and custom queries.
- Get started with databases
- ETL with relational databases
- SQL actions: INSERT, UPDATE, DELETE, MERGE, IFEXIST, CUSTOM
- Advanced SQL with CUSTOM Action
- Transaction management
- Use global variables with database connections
- Automatically create or alter a destination table
- Cannot connect to the database
- ELT with databases
- Foreign key constraint violation when loading or deleting data in database
- Automatically create staging tables from any data source
- Override data types when creating or altering tables
- Override CREATE and ALTER TABLE SQL
- Expose a database object or SQL query as an API endpoint
- Read records from a database and execute a flow for each record
- Execute any SQL outside of regular source-to-destination transformation
- Execute SQL from JavaScript to update status or save rejected records
- Automatic partitioning
- Tips and tricks when working with databases
- Load to multiple targets