-
We first created a
dlt
pipeline that could load data from google analytics 4 into a local duckdb database -
We then developed a streamlit app locally with the duckdb data
-
After we created a pipeline and a streamlit app, we decided to move our process from local to remote for deployment
-
We created a Google Cloud VM instance and set up a postgres database in it
-
We deployed our
dlt
pipeline to load data onto this Postgres database daily using GitHub Actions -
We then finally delpoyed our streamlit app on the VM instance and modified it so that it reads data from the Postgres database inside the VM
dlt-hub / ga4-internal-dashboard-demo Goto Github PK
View Code? Open in Web Editor NEWLicense: Apache License 2.0