"Encountered an error while globbing file pattern" error when using BigQuery API w/ Google Sheets

When trying the access a federated source (Google sheets) from BigQuery API, the following error is thrown: [..] "errorResult" : { "location" : "/gdrive/id/<removed_file_id>", "