Federated sources support inc googlesheets

[MarkEdmondson1234]

https://cloud.google.com/blog/big-data/2016/05/bigquery-integrates-with-google-drive

[Phippsy]

Hi @MarkEdmondson1234 - just checking, I'm guessing federated source access isn't possible at the moment?
I tried enabling all the scopes for drive, cloud platform & bigquery then listing them in googleAuthR.scopes.selected, per this article but can't get it working - I get an error:

Request Status Code: 403
Error : JSON fetch error: Access Denied: BigQuery BigQuery: Permission denied while globbing file pattern.

Not a big deal, just curious. Thanks as always!

[MarkEdmondson1234]

No, not yet. It would require modifying this function to accept an externalDataConfiguration object as specced here.