DEV Community

adrian
adrian

Posted on

1

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.

Local for personal use

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.

Cloud for serving to company

Code and video included.

Read about it here!

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay