I have a bit of a arduous task each few days whereby my new CSV files (stored locally and on Google Drive) are used for data for my website tables.
The current task involves TRUNCATEing of 15 tables, and then updating each table with the latest CSV by using the IMPORT and “Choose file” option (skipping row 1).

As I’m repeating the exact same task everytime, I was wondering if there was a way to code this using a SQL or trigger to semi-automate the process?
TIA