appsmithorg / appsmithorg/appsmith

[Feature] BigQuery Datasource

Open
#3,129 21 comments 28 reactions 0 assignees View on GitHub
Community Reported Enhancement Integrations Product New Datasource Query & JS Pod Query Widgets & IDE Pod
Dominant language
TypeScript
Stars
40.9k
Forks
4.8k
Avg merge
1d 22h
Merged PRs (30d)
45

Description

## Summary

Support BigQuery as a datasource

## Motivation

A typical data pipeline is to replicate Firestore document inserts and updates in realtime to BigQuery using the [Firestore Export to BigQuery extension](https://firebase.google.com/products/extensions/firestore-bigquery-export). This then enables richer SQL queries against the data then would otherwise be possible directly through the Firestore API and this brings the Firebase data experience closer to a typical RDBMS.

![Firestore BigQuery Data Pipeline](https://user-images.githubusercontent.com/1079943/108625129-075a8080-7441-11eb-97ea-6b620e0aac07.jpg)

## Additional Context

[Google BigQuery API](https://cloud.google.com/bigquery/docs/reference/libraries)

Front logo [Front conversations](https://app.frontapp.com/open/top_9gjgs)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.