Integrating google analytics to snowflake

(Nir Yalin) #1

I would like to create a standard dashboard of data from Google analytics on my company’s Website and Blog. In order to create the dashboard i need to extract the data from GA to our Snowflake DB. Does anyone a schema of GA that will help me figuring out what data to extract and how to model it?


(Izzy) #2

My 2 cents: We’ve got a pre-built google analytics block by Firebase, and a GA360 one made by Google. and respectively.

Those should at the very least give you an idea of the right direction, and might be almost plug and play!