Forum Discussion
Fabric Data Warehouse Cost
- 1 year ago
Hi Flubis ,
Thank you for connecting with the Microsoft Fabric Community.
Fabric does not impose network data ingress fees for mirroring into One Lake. This means that when your Snowflake data is replicated into One Lake, there are no associated mirroring costs.
However, there are compute and cloud query costs on the Snowflake side. These include virtual warehouse compute costs and cloud services compute costs incurred during the data mirroring process.
- When mirroring data from Snowflake to Fabric, compute costs are incurred on the Snowflake side due to data extraction. These costs are influenced by the size of the virtual warehouse and the duration of query execution. Larger warehouses and longer queries result in higher costs. Operations by Snowflake's cloud services, such as managing and optimizing queries, also add to the overall compute costs.
- Additionally, if Fabric frequently queries Snowflake to detect data changes for replication, each of these queries will consume compute resources on the Snowflake side.
To manage and potentially minimize these costs, consider the following:
- Fine-tune data extraction queries to boost performance. This cuts down the runtime of the virtual warehouse, saving costs.
- Plan mirroring operations during off-peak hours or do it less often, depending on how fresh you need your data. This keeps compute costs in check.
- Keep an eye on the virtual warehouse's usage and performance. Snowflake offers tools to analyse performance and spot ways to save costs.
For more information and clarity, please refer to the official Microsoft documentation on Snowflake mirror costs and configuring Snowflake activity mentioned in the links below.
Microsoft Fabric Mirrored Databases From Snowflake - Microsoft Fabric | Microsoft Learn.
Configure Snowflake in a copy activity - Microsoft Fabric | Microsoft Learn.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
Hi Flubis
When people talk about the free portion when using fabric that relates to the data that is being stored, you will not incur any cost. After that, if you are querying data from the Snowflake Mirror, you will incur cost or capacity units, which will be used when queries being run.
What I would recommend doing is to create the snowflake mirror and then run a few queries. Once that is done, go do the metrics app and you can then see how many capacity units is being consumed.