Announcing the CloudQuery BigQuery Destination Plugin
This tutorial will show you how to sync your cloud resources to a BigQuery database on Google Cloud Platform.
Herman Schaaf • Dec 06, 2022
Hot on the heels of the Snowflake destination plugin, today we are introducing another CloudQuery destination plugin: BigQuery. BigQuery is a cloud-based data warehousing and analytics platform offered by Google Cloud that allows users to store and query large datasets quickly and efficiently. With the CloudQuery BigQuery destination plugin, you can now consolidate your organization's data from across cloud platforms into BigQuery.
CloudQuery brings all your cloud infrastructure configuration data to the same place, consolidating your security and infrastructure data and enabling new insights. If your organization already uses BigQuery for analysis, these in-house datasets can now also be combined with CloudQuery datasets to unlock insights that were previously impossible without several intermediate steps.
Maintaining historical data is a common use case for data warehouses. By using BigQuery as a destination, you can now cost-effectively store all your cloud infrastructure data in a data warehouse for long term storage, analysis and investigation use-cases.
By combining the CloudQuery data in BigQuery with scheduled queries, further business insights and security reports can be derived from the data as part of a completely serverless, cloud-based deployment.
Syncing data to BigQuery can be done as with any other destination plugin, so check out our Quickstart and BigQuery plugin documentation for instructions on how to get started.
Once data is synced you can start querying either with the native BigQuery interface, code or with any of the many BI tools that support BigQuery. Here is the "Hello World" of cloud infrastructure queries, a query that finds all AWS S3 buckets that are permitted to be public:
And yes, the BigQuery destination is not just for GCP data! As the example above demonstrates, data from all major cloud providers can now be synced to BigQuery, allowing a holistic view of your cloud assets.