Forum Discussion

Flubis's avatar
Flubis
Frequent Visitor
1 year ago
Solved

Fabric Data Warehouse Cost

Hello,    I have been searching for the true cost of using a mirrored Snowflake (Fabric Data Warehouse) within the P1 SKU. I have come across many articles stating that it is essentially "free" on ...
  • V-yubandi-msft's avatar
    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.