GCP – Loading complex CSV files into BigQuery using Google Sheets
Building an ELT pipeline using Google Sheets as an intermediary BigQuery offers the ability to quickly import a CSV file, both from the web user interface and from the command line: Limitations of autodetect and import This works for your plain-vanilla CSV files, but can fail on complex CSV files. As an example of a […]