Load data feed into Azure data lake and analyze
we are trying to load Adobe Data Feed into Azure Storage Blob and do some initial data analysis. I tried with AWS, altough it's quite slow, S3 + Athena works for this, but I'd like to know if there is any alternative way to do the same analysis in Microsoft Azure before building a data warehouse. Azure is required...
1. Does anyone have any suggestion? for data analysis on Azure storage Blob, or if other Azure service is preferred
2. Next step, we will build a data warehouse with ETL. We also like to know the best practice.
Some information: I'm using daily delivery raw Adobe Data Feed data to Azure Storage Blob. Everyday, a new zip or tar.gz (contains a .tsv) file is added. For 30 days, I will have 30 files.
W
Thanks,
Martin
