I have a GCP bucket with hundreds of csv files in the format [filename]-YYYYMMDD-[suffix].csv I want to fetch just the last 3 days' files each day to merge into BigQuery

Matillion ETL
1

Wildcards and variables in the URI for the Google Cloud Loader don't seem to appear valid. How would you approach this?

 

We are running Matillion on GCP, target is BigQuery.