Forum Discussion

JuanMahecha's avatar
JuanMahecha
Copper Contributor
Jun 25, 2025

Cost-effective alternatives to control table for processed files in Azure Synapse

Hello, good morning.In Azure Synapse Analytics, I want to have a control table for the files that have already been processed by the bronze or silver layers. For this, I wanted to create a dedicated pool, but I see that at the minimum performance level it charges 1.51 USD per hour (as I show in the image), so I wanted to know what other more economical alternatives I have, since I will need to do inserts and updates to this control table and with a serverless option this is not possible.

 

azure synapse analytics
data
sql

2 Replies

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Jun 28, 2025

    One of the options would be Azure SQL (Basic Tier), it offers Full T-SQL support, easy integration, supports updates/inserts.

     

     

    • JuanMahecha's avatar
      JuanMahecha
      Copper Contributor
      Jul 07, 2025

      Thank you for responding, I previously tried this option but I felt that it was charging a bit high, I had it set to deactivate after 15 minutes, and the cost while it was activated for those 15 minutes before turning off was 0.60 euros, which I don't know if that's normal.

Resources