Google BigQuery
Turn your data in BigQuery into actionable API Endpoints
Write SQL queries on your data held in Google BigQuery and directly expose the results, or queries on those results, as API endpoints. Easy to maintain. Always up-to-date. Fast as can be.
Trusted in production by engineers at...
Easy integration
Connect to your BigQuery database with a handful of clicks. Select which tables to sync and set the schedule.
SQL based
Use an SQL query to get the data you need from BigQuery and then run SQL queries on that data in Tinybird.
Automatic APIs
All your Data APIs in one place, automatically documented and scaled. Consistent results for your Data/Dev Teams.
Secure
Use Auth tokens to control access to API endpoints. Implement access policies as you need. Support for row-level security.
Build in minutes, not weeks
Ingest, query and build APIs for your data at scale in a matter of minutes. Forget about ETLs, performance and complex security rules.
$ tb connection create bigquery
** Log into your Google Cloud Platform Console as a project editor and go to https://console.cloud.google.com/iam-admin/iam
** Grant access to this principal: service-email@tinybird-cdk-production.iam.gserviceaccount.com
** Assign it the role "BigQuery Data Viewer" Ready? (y, N) [N]: y
** Connection bigquery created successfully!
DESCRIPTION >
Gets the top product orders last 5 minutes
SQL >
SELECT
bigquery.dimension_id,
bigquery.dimension_name,
count(events.action)
FROM
events
JOIN
bigquery USING (product_id)
WHERE
events.type = 'purchase'
AND
events.timestamp >= now() - INTERVAL 5 minute
$ tb push endpoints/orders.pipe
** Processing endpoints/orders.pipe
** Building dependencies
** Running orders
** 'orders' created
** => Test endpoint at
https://api.tinybird.co/v0/pipes/orders.json
Quickly and securely automate ingestion of data from your Google BigQuery data warehouse.
Filter, clean or enrich your data using Pipes, a new way of chaining SQL queries designed to ease development and maintenance.
Instantly publish low-latency, high-concurrency, and secure APIs, with full OpenAPI and Postman documentation.
Tinybird and Google Cloud, better together
Send Google Cloud data to Tinybird, query and shape it using SQL, publish it as APIs.
We accelerate your data, no matter where it is.
Connect data from Relational Databases, Data Warehouses and Data Streams.
Amazon Redshift
Amazon S3
Google BigQuery
Apache Kafka
PostgreSQL
MySQL
Snowflake
Build fast data products, faster.
