Moving data warehouse… what’s your experience?

Tools
1

What data warehouse platforms have you moved between?

For example, we recently moved from MS SQL Server to Redshift in a 500+ person company.

2

We’re moving to Microsoft Fabric but staying within the Microsoft ecosystem. We have a managed instance, but it’s pretty expensive.

3

Vale said:
We’re moving to Microsoft Fabric but staying within the Microsoft ecosystem. We have a managed instance, but it’s pretty expensive.

I just learned about Fabric! Do they still use SQL Server as the data warehouse in Fabric?

4

@Emory
Yes, SQL Server is still in use under Fabric.

5

Moving to Redshift sounds like a good move, especially if you’re dealing with large datasets. Have you noticed any performance improvements yet, or are you still transitioning? Also, curious about the size of your datasets and typical usage.

6

@Penn
Latency is a bit higher on smaller queries, but it can definitely handle larger datasets. We’ve got dimension tables in the 100,000s range, and some even over 100 million rows. Our fact tables are huge, too. We’re an e-commerce business with about a billion orders over the years. We also handle billions of clickstream data points, but we rarely query that directly.