Repo: https://qtraxweb.visualstudio.com/Data%20and%20BI%20Solutions/_git/Data-Solutions-DataFactory

Tables that track runs:
    [Integrations].[dbo].[360ExtractRun] - Main pipeline stores here

    [Integrations].[dbo].[360ExtractPipelineRun] - Individual dataset pipelines store here

    [Integrations].[dbo].[360ExtractVersion] - Keeps track of current version for pipelines

    [Integrations].[dbo].[360ExtractParameter] - Begin date parameters start here if dataset is too large and we need to limit


Azure Data Factories: 

    Dev: https://portal.azure.com/#@premiumretail.com/resource/subscriptions/6996ac10-1567-4a0f-a83c-8510f4121183/resourceGroups/d-data-and-bi-solutions-RG/providers/Microsoft.DataFactory/factories/d-prs-data-solutions-datafactory/overview

    Test: https://portal.azure.com/#@premiumretail.com/resource/subscriptions/6996ac10-1567-4a0f-a83c-8510f4121183/resourceGroups/t-data-and-bi-solutions-RG/providers/Microsoft.DataFactory/factories/t-prs-data-solutions-datafactory/overview

    Prod: https://portal.azure.com/#@premiumretail.com/resource/subscriptions/0d5c99c9-7ba8-4fc6-910f-f706a8019e91/resourceGroups/p-data-and-bi-solutions-RG/providers/Microsoft.DataFactory/factories/p-prs-data-solutions-datafactory/overview


2 patterns are followed for the pipelines: 1 with a parameter and 1 without. Make sure to lookup which ones have parameters so you know which ones to clone.


If you need to debug a pipeline, I use the below query to get my parameters;

SELECT LOWER(newid()), format(GETUTCDATE(), 'yyyyMMddHHmmss')