Google BigQuery allows you to create external datasets that store data in Amazon S3 regions (like aws-us-east-1) or Azure Storage regions (like azure-useast2). The server supports these datasets with two major limitations:

1. Google BigQuery treats external tables as read-only. You cannot execute INSERT, UPDATE or DELETE queries on them. They are also incompatible with DestinationTable because Google BigQuery cannot create destination tables in an external dataset.
2. Google BigQuery does not support the Storage API for external datasets. You must disable the UseStorageAPI option in order to query them. This limits the read throughput of the server, so if you are executing large queries CData recommends that you copy your data into Google BigQuery for the best performance.