How to write to a database – tutorial transcript
To write to a dataset using Database Export Block:
Step 1. Drag and drop the DB Export Block from the Block Library or right-click on the Main Canvas and select “Add Export Block” and then “DB Export”.
Step 2. Connect the DB Export Block to a block that contains the data that you would like to export.
Step 3. Click on the DB Export Block to access its settings and press on the “Select Database table” button.
Step 4. Select database type.
Step 5. Connect to the database using your credentials.
Step 6. Provide a name for a new table or select an existing table in the database (choose if you want to append or overwrite the data) and click finish.
Step 7. Press the “Run with outputs” button to write to the database.
- DB Export Block settings
- Database tables
Transcript – How to write to a database
Tutorial – Connecting to an SQL database
Tutorial – How to edit an SQL query
You can download a free trial of Analytics Canvas to follow along with the video.