Tips for Working with databases
Uncommon scenarios for database connectors, including metadata, upserts, and image storage.
- Using a value returned by SQL query as a parameter
- Insert auto-generated column value when working with databases
- Insert images from files into a database table
- Using MERGE (UPSERT) when working with databases
- Handle table and column names with spaces and special characters when working with databases
- Read data from one dataset and load it into multiple database tables