Thanks to this project, you will link your the data from your HomeAssistant to BigQuery
- a GCP account
- Home assistant and its PubSub plugin
Deploy this project as a Google Cloud Function in your GCP Project. This function is triggered by the event pushed by home assistant. It needs 3 environment variables :
- GCP_PROJECTID
- BIGQUERY_DATASET
- BIGQUERY_TABLE
A complete tutorial (in french) is available at https://blog.bodul.fr/2021/10/17/home-assistant-vers-pubsub-vers-bigquery-vers-datastudio/