BigQuery Integration and Synchronization
Google BigQuery data
can be integrated and synchronized codeless with various other data sources
using the Layer2 Cloud Connector via CData provider. Please
take a look here
for supported target systems and applications like SQL databases, Microsoft
Office 365, SharePoint, Exchange, Dynamics and others.
Querying massive datasets can be time consuming and expensive without the right
hardware and infrastructure. Google BigQuery solves this problem by enabling
super-fast, SQL-like queries against append-only tables, using the processing
power of Google's infrastructure.
Fig.: Google BigQuery sample table to sync with local or other cloud-based data sets using the Layer2 Cloud Connector.
To connect to a Google BigQuery table the source entity must be configured as
follows in the Layer2 Cloud Connector Connection Manager: