How do I adjust TTL on IR?

Christopher Teljstedt 21 Reputation points
2021-02-25T08:05:01.39+00:00

I currently I run a lot of Data flow jobs, and it seems that there is no time-to-live (TTL) between jobs in Azure Synapse. I would like to cut a couple of minutes in cold boot time.

When trying to create a new Integration Runtime there is no setting for TTL although Documentation says it should be there.

Debug mode actually works faster running sequentially on the debug cluster which is on for 60 minutes than running data flows in parallel with an regular trigger and Auto resolve integration runtime needs to start from scratch for every data flow.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,578 questions
{count} votes

Accepted answer
  1. Saurabh Sharma 23,776 Reputation points Microsoft Employee
    2021-02-26T00:31:36.637+00:00

    @Christopher Teljstedt Thanks for using Microsoft Q&A !!
    Unfortunately TTL feature is not available for Azure Synapse Analytics and it is meant for Azure Data Factory Only. Please refer to the documentation to get data integration differences of ADF and Synapse Analytics.
    I will internally share this feedback with the products team however, I also suggest you to please provide this as a feedback at Synapse Analytics Uservoice so that community can upvote and products team can work on including this feature in future releases of Synapse Analytics.

    Thanks you.
    Saurabh

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.


0 additional answers

Sort by: Most helpful