René Bremer
May 22, 2024

--

Yes, that is certainly possible. However, the csv files I use are 30GB and this is also the space that is needed in Azure SQL. Without optimization (e.g. omit large description column I use), this would mean that you also need a significant cache size in Azure Redis and that is costly. If you take the standard SKU of 56GB, that would be 1500 euros per month, see https://azure.microsoft.com/en-us/pricing/details/cache/. In comparison, the Azure SQL 125 DTU standard SKU I used, is 150 euros per month.

--

--

René Bremer
René Bremer

Written by René Bremer

Data Solution Architect - sharing hands-on insights via this blog. Opinions here are mine.

No responses yet