From local to cloud with a flip of a switch - Load Ga4->DuckDB (MDS in a box) or go to the cloud in MotherDuck

In this article, our working student Rahul is showing us how simple it is to pull Google Analytics 4 data with dlt and put the data in DuckDB.

He uses dbt to transform and visualises the data with Metabase.

Finally, good things should be shared, so he plays with the idea of going outside of the Box and onto the cloud so he is able to serve the results of the work to stakeholders.

Code and video included.

Read about it here!