Hey everyone !
So I am wondering what’s the best way to ingest forecast data into Looker which is csv/xls format? I am totally in the dark here.
Should it one of these 2 formats :
Or
Is it something completely different?
Hi Abhi,
The ingestion would need to be into the warehouse, rather than into Looker.
I would recommend keeping the data at the most granular level, and create any aggregations in Looker.
In your case, I would recommend creating multiple rows, and only one column which contains the forecast amount.
Hope this helps!
Best,