Adding a new entity

Adding a new entity

DECLARE @RC int
DECLARE @DataSourceId int
DECLARE @WorkspaceGuid uniqueidentifier
DECLARE @SourceSchema nvarchar(100)
DECLARE @SourceName nvarchar(200)
DECLARE @TargetSchema nvarchar(100)
DECLARE @TargetName nvarchar(200)
DECLARE @SourceCustomSelect nvarchar(4000)
DECLARE @FileName nvarchar(200)
DECLARE @FilePath nvarchar(100)
DECLARE @FileType nvarchar(20)
DECLARE @IsIncremental bit
DECLARE @IsIncrementalColumn nvarchar(50)
DECLARE @CustomNotebookName varchar(200)
DECLARE @PrimaryKeys nvarchar(200)

-- TODO: Set parameter values here.

EXECUTE @RC = [integration].[sp_UpsertLandingzoneBronzeSilver] 
   @DataSourceId
  ,@WorkspaceGuid
  ,@SourceSchema
  ,@SourceName
  ,@TargetSchema
  ,@TargetName
  ,@SourceCustomSelect
  ,@FileName
  ,@FilePath
  ,@FileType
  ,@IsIncremental
  ,@IsIncrementalColumn
  ,@CustomNotebookName
  ,@PrimaryKeys
GO

Example of adding a xlxs file

DECLARE @RC int
DECLARE @DataSourceId int
DECLARE @WorkspaceGuid uniqueidentifier
DECLARE @SourceSchema nvarchar(100)
DECLARE @SourceName nvarchar(200)
DECLARE @SourceCustomSelect nvarchar(4000)
DECLARE @FileName nvarchar(200)
DECLARE @FilePath nvarchar(100)
DECLARE @FileType nvarchar(20)
DECLARE @IsIncremental bit
DECLARE @IsIncrementalColumn nvarchar(50)
DECLARE @CustomNotebookName varchar(200)
DECLARE @PrimaryKeys nvarchar(200)

-- TODO: Set parameter values here.

EXECUTE @RC = [integration].[sp_UpsertLandingzoneBronzeSilver] 
   13                                           --Datasource id
  ,'40e27fdc-775a-4ee2-84d5-48893c92d7cc'       --WorkspaceGuid of the DataWorkspace
  ,'demo'                                       --Folder of the sourcefile
  ,'SalesOrders.xlsx'                           --Name of the File
  ,'demo'                                       --Tableschema
  ,'SalesOrders'                                --TableName
  ,''                                           --Custom select
  ,'SalesOrders'                                --Name of the File
  ,'FMD'                                        --Folder of the destination
  ,'xlsx'                                       --SourceFileType
  ,0                                            --Incremental
  ,''                                           --Incremental Column
  ,''                                           --Name of the CustomNotebook                    
  ,'SalesOrderLine'                                        --PrimaryKeys
GO

More to come in future releases!