I use the information given to create a table schema for each of the six CSV files. Specifying data types, primary keys, foreign keys, and other constraints. Then importing each CSV file into the ...

First we create tables in duckdb using the CSV files in the folder. Once we have the tables, we can run any SQL query on them using duckdb engine. Once we are done with the changes, we can save the ...

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.