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?
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.