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 by companies like...
Easy integration
Connect to your BigQuery database with Google Service Account credentials, the GCP project id and the name of a GCS bucket, to start building APIs right away.
SQL based
Use an SQL query to get the data you need from BigQuery and then run SQL queries on that data in Tinybird.
TTLs and Roll-ups
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 \
--gcp-project-id $PROJECT_ID \
--gcs-bucket $BUCKET_NAME \
--google-application-credentials $GOOGLE_APPLICATION_CREDENTIALS \
datasource append $DESTINATION_DATA_SOURCE \
--connector bigquery \
--sql "select * from $PROJECT_DATASET_TABLE"
** 🐔 starting export process from bigquery
** 🥚 starting import process
** 🐥 done
** Total rows in taxi: 232341
** Data appended to data source 'taxi' successfully!
** Data pushed to taxi
NODE avg_triptime_endpoint
SQL >
SELECT
toDayOfMonth(pickup_datetime) as day,
avg (dateDiff('minute', pickup_datetime, dropoff_datetime)) as avg_trip_time_minutes
FROM tripdata
{% if defined(start_date) and defined(end_date) %}
WHERE pickup_dt BETWEEN {{Date(start_date)}} AND {{Date(end_date)}}
{% end %}
GROUP BY day
$ tb push endpoints/avg_triptime.pipe
** Processing endpoints/avg_triptime.pipe
** Building dependencies
** Running avg_triptime
** => Test endpoint at https://api.tinybird.co/v0/pipes/avg_triptime.json
** 'avg_triptime' created
** Not pushing fixtures
Automate ingestion of data from your Google BigQuery database.
Filter, clean or enrich your data using Pipes, a new way of chaining SQL queries designed to ease development and maintenance.
Share access securely to your data in a click and get full OpenAPI and Postman documentation for your 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
