Import CSVs from GCS

[SKairinos]

Import GCS from the GCS bucket into BQ by scheduling data transfer queries in BQ.

• Using GoogleSQL’s LOAD DATA statement, we’ll batch-load all CSVs from the root of a dedicated GCS bucket.
• Using Cloud Storage transfer, we’ll create a recurring-transfer schedule.
• To delete all CSV files after they’ve been imported in BQ, we’ll enable the Delete source files after transfer setting for the recurring-transfer schedule.

[cfl-bot]

@SKairinos, you haven't interacted with this issue in the last 3 weeks. I will unassign you from this issue but you're welcome to assign yourself again if you'd like to continue working on this issue.

[cfl-bot]

@ocadotechnology/cfl-core-team, please write a description for this issue.