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/