/****** Object:  Table [dbo].[MainControlTable_215] ******/
            CREATE TABLE [dbo].[MainControlTable_215](
                [Id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
                [SourceObjectSettings] [nvarchar](max) NULL,
                [SourceConnectionSettingsName] [varchar](max) NULL,
                [CopySourceSettings] [nvarchar](max) NULL,
                [SinkObjectSettings] [nvarchar](max) NULL,
                [SinkConnectionSettingsName] [varchar](max) NULL,
                [CopySinkSettings] [nvarchar](max) NULL,
                [CopyActivitySettings] [nvarchar](max) NULL,
                [TopLevelPipelineName] [varchar](max) NULL,
                [TriggerName] [nvarchar](max) NULL,
                [DataLoadingBehaviorSettings] [nvarchar](max) NULL,
                [TaskId] [int] NULL,
                [CopyEnabled] [bit] NULL
        ) 
            DECLARE @MainControlMetadata NVARCHAR(max)  = N'[
    {
        "SourceObjectSettings": {
            "entityName": "upbeat_accounttype"
        },
        "SinkObjectSettings": {
            "table": "upbeat_accounttype",
            "schema": "dbo"
        },
        "CopySinkSettings": {
            "preCopyScript": null,
            "tableOption": "autoCreate",
            "writeBehavior": "upsert",
            "sqlWriterUseTableLock": false,
            "disableMetricsCollection": false,
            "upsertSettings": {
                "useTempDB": false,
                "keys": [
                    "upbeat_accounttypeid"
                ],
                "interimSchemaName": "Staging"
            }
        },
        "CopyActivitySettings": {
            "translator": {
                "type": "TabularTranslator",
                "mappings": [
                    {
                        "source": {
                            "name": "createdby",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "createdby",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "createdbyname",
                            "type": "String"
                        },
                        "sink": {
                            "name": "createdbyname",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "createdbyyominame",
                            "type": "String"
                        },
                        "sink": {
                            "name": "createdbyyominame",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "createdon",
                            "type": "DateTime"
                        },
                        "sink": {
                            "name": "createdon",
                            "type": "DateTime"
                        }
                    },
                    {
                        "source": {
                            "name": "createdonbehalfby",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "createdonbehalfby",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "createdonbehalfbyname",
                            "type": "String"
                        },
                        "sink": {
                            "name": "createdonbehalfbyname",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "createdonbehalfbyyominame",
                            "type": "String"
                        },
                        "sink": {
                            "name": "createdonbehalfbyyominame",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "importsequencenumber",
                            "type": "Int32"
                        },
                        "sink": {
                            "name": "importsequencenumber",
                            "type": "Int32"
                        }
                    },
                    {
                        "source": {
                            "name": "modifiedby",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "modifiedby",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "modifiedbyname",
                            "type": "String"
                        },
                        "sink": {
                            "name": "modifiedbyname",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "modifiedbyyominame",
                            "type": "String"
                        },
                        "sink": {
                            "name": "modifiedbyyominame",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "modifiedon",
                            "type": "DateTime"
                        },
                        "sink": {
                            "name": "modifiedon",
                            "type": "DateTime"
                        }
                    },
                    {
                        "source": {
                            "name": "modifiedonbehalfby",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "modifiedonbehalfby",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "modifiedonbehalfbyname",
                            "type": "String"
                        },
                        "sink": {
                            "name": "modifiedonbehalfbyname",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "modifiedonbehalfbyyominame",
                            "type": "String"
                        },
                        "sink": {
                            "name": "modifiedonbehalfbyyominame",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "overriddencreatedon",
                            "type": "DateTime"
                        },
                        "sink": {
                            "name": "overriddencreatedon",
                            "type": "DateTime"
                        }
                    },
                    {
                        "source": {
                            "name": "ownerid",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "ownerid",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "owneridname",
                            "type": "String"
                        },
                        "sink": {
                            "name": "owneridname",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "owneridtype",
                            "type": "String"
                        },
                        "sink": {
                            "name": "owneridtype",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "owneridyominame",
                            "type": "String"
                        },
                        "sink": {
                            "name": "owneridyominame",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "owningbusinessunit",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "owningbusinessunit",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "owningbusinessunitname",
                            "type": "String"
                        },
                        "sink": {
                            "name": "owningbusinessunitname",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "owningteam",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "owningteam",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "owninguser",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "owninguser",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "statecode",
                            "type": "Int32"
                        },
                        "sink": {
                            "name": "statecode",
                            "type": "Int32"
                        }
                    },
                    {
                        "source": {
                            "name": "statuscode",
                            "type": "Int32"
                        },
                        "sink": {
                            "name": "statuscode",
                            "type": "Int32"
                        }
                    },
                    {
                        "source": {
                            "name": "timezoneruleversionnumber",
                            "type": "Int32"
                        },
                        "sink": {
                            "name": "timezoneruleversionnumber",
                            "type": "Int32"
                        }
                    },
                    {
                        "source": {
                            "name": "upbeat_accountid",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "upbeat_accountid",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "upbeat_accountidname",
                            "type": "String"
                        },
                        "sink": {
                            "name": "upbeat_accountidname",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "upbeat_accountidyominame",
                            "type": "String"
                        },
                        "sink": {
                            "name": "upbeat_accountidyominame",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "upbeat_accounttype",
                            "type": "String"
                        },
                        "sink": {
                            "name": "upbeat_accounttype",
                            "type": "String"
                        }
                    },
                    {
                        "source": {
                            "name": "upbeat_accounttypeid",
                            "type": "Guid"
                        },
                        "sink": {
                            "name": "upbeat_accounttypeid",
                            "type": "Guid"
                        }
                    },
                    {
                        "source": {
                            "name": "utcconversiontimezonecode",
                            "type": "Int32"
                        },
                        "sink": {
                            "name": "utcconversiontimezonecode",
                            "type": "Int32"
                        }
                    },
                    {
                        "source": {
                            "name": "versionnumber",
                            "type": "Int64"
                        },
                        "sink": {
                            "name": "versionnumber",
                            "type": "Int64"
                        }
                    }
                ]
            }
        },
        "TopLevelPipelineName": "DV_215_TopLevel",
        "TriggerName": [
            "Sandbox",
            "Manual"
        ],
        "DataLoadingBehaviorSettings": {
            "dataLoadingBehavior": "DeltaLoad",
            "watermarkColumnName": "modifiedon",
            "watermarkColumnType": "DateTime",
            "watermarkColumnStartValue": "2000-05-20T00:00:00.000Z"
        },
        "TaskId": 0,
        "CopyEnabled": 1
    }
]';
            INSERT INTO [dbo].[MainControlTable_215] (
                [SourceObjectSettings],
                [SourceConnectionSettingsName],
                [CopySourceSettings],
                [SinkObjectSettings],
                [SinkConnectionSettingsName],
                [CopySinkSettings],
                [CopyActivitySettings],
                [TopLevelPipelineName],
                [TriggerName],
                [DataLoadingBehaviorSettings],
                [TaskId],
                [CopyEnabled])
            SELECT * FROM OPENJSON(@MainControlMetadata)
                WITH ([SourceObjectSettings] [nvarchar](max) AS JSON,
                [SourceConnectionSettingsName] [varchar](max),
                [CopySourceSettings] [nvarchar](max) AS JSON,
                [SinkObjectSettings] [nvarchar](max) AS JSON,
                [SinkConnectionSettingsName] [varchar](max),
                [CopySinkSettings] [nvarchar](max) AS JSON,
                [CopyActivitySettings] [nvarchar](max) AS JSON,
                [TopLevelPipelineName] [varchar](max),
                [TriggerName] [nvarchar](max) AS JSON,
                [DataLoadingBehaviorSettings] [nvarchar](max) AS JSON,
                [TaskId] [int],
                [CopyEnabled] [bit])