Now in Preview: Google BigQuery Data Source

Connect BigQuery to Propel to easily power a variety of customer-facing analytics use cases

Photo: Propel

BigQuery Logo

We’re delighted to announce that the Google BigQuery Data Source preview is now available. Google BigQuery Data Source makes it simple to connect your BigQuery warehouse to Propel’s powerful data cloud in order to power insights and usage dashboards, analytics APIs, and more for your customers.

Why we’re launching BigQuery Data Source

Google BigQuery is a popular data warehouse solution. It is used as the last step in ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes where data relating to your business is moved into BigQuery for analysis. BigQuery excels at ad-hoc queries on large datasets; however, it is less well suited to repeating high-performance queries in customer-facing use cases such as powering frequently accessed web-based dashboards and analytics APIs. BigQuery Data Source lets Propel connect to your Google BigQuery warehouse and operationalize your data to make it ready for customer-facing analytics use cases.

Why use BigQuery Data Source

If you use Google BigQuery as your data warehouse, then you can make datasets available to power a variety of customer analytics use cases. For example, if you are ingesting events from your application related to customer usage, you can construct a BigQuery dataset that will contain tables that store that usage data for your customers. By connecting Propel’s BigQuery DataSource to that dataset, you can use the tables constructed to make fast, cost-effective usage dashboards available to your customers.

How does it work?
A diagram showing how Google BigQuery integrates with Propel

Once you supply appropriate GCP credentials and a project ID, the Google BigQuery Data Source automatically establishes a secure connection to Google BigQuery. Propel will show the tables organized inside the dataset you specify. Once the Data Source is created, a Data Pool will maintain a cached table version of the dataset data, allowing for ultra-fast performance when querying the Metrics you define. Propel handles synchronization automatically as new data is added to the BigQuery table.  Click here to learn more about Propel key concepts like Data Pools and Metrics. All functionality can be automated through GraphQL APIs or managed through the Propel web console.

How can I try it?

Google BigQuery Data Source is available today in preview. If you are an existing customer and would like to get access, please contact us. If you’d like to learn more about Propel, we’d love to speak with you; click here to book a demo today.

Related Content

Abstract background


Introducing Propellers: Easily select the optimal cost and query speed for each Customer-Facing Analytics use case

Propellers equip developers with an easy way to select the optimal cost and query speed for each customer-facing analytics use case.

Propel Data's now supports Snowflake warehouse, meaning developers can build data apps on top of GraphQL APIs powered by their Snowflake data, as illustrated by this single snowflake on a dark blue background consistent with Propel's brand colors.


How to build in-product analytics with Snowflake and GraphQL

Propel Data is excited to announce support for Snowflake. Developers are now able to build on top of GraphQL APIs powered by Snowflake data.