Now in Preview: Google BigQuery Data Source

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

BigQuery Logo

Photo: Propel

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 posts

Introducing Webhook Data Pools - Build customer-facing analytics from JSON events

This is some text inside of a div block.

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5
Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

  1. Item 1
  2. Item 2
  3. Item 3

Unordered list

  • Item A
  • Item B
  • Item C

Text link

Bold text

Emphasis

Superscript

Subscript

In Preview Today: Snowflake Dynamic Table Support

This is some text inside of a div block.

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5
Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

  1. Item 1
  2. Item 2
  3. Item 3

Unordered list

  • Item A
  • Item B
  • Item C

Text link

Bold text

Emphasis

Superscript

Subscript

Now in preview: Updates and deletes support for Snowflake

This is some text inside of a div block.

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5
Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

  1. Item 1
  2. Item 2
  3. Item 3

Unordered list

  • Item A
  • Item B
  • Item C

Text link

Bold text

Emphasis

Superscript

Subscript

Start shipping today

Deliver the analytics your customers have been asking for.