PsDataFactory is a PowerShell module to generate DataFactory pipelines and datasets.
Creates a Copy activity for an Azure Data Factory pipeline.
New-AdfCopyActivity [-Name] <String> [-Source] <PSObject> [-SourceType] <Object>
[[-AdditionalSourceColumns] <Object>] [[-SourceQueryTimeout] <Object>] [-Sink] <PSObject> [-SinkType] <Object>
[[-SinkWriteBehavior] <Object>] [-SqlWriterUseTableLock] [[-Timeout] <Object>] [[-DependsOn] <Object>]
[[-Translator] <Object>] [[-SinkStagingSettings] <Object>] [-ProgressAction <ActionPreference>]
[<CommonParameters>]
Creates a Copy activity with the selected source and sink types, dataset references, and optional source, sink, staging, timeout, dependency, and translation settings. For an Azure Databricks Delta Lake source and Delimited Text sink, staging settings are required.
New-AdfCopyActivity -Name 'CopyOrders' -Source $source -SourceType AzureSqlSource -Sink $sink -SinkType AzureSqlSink
Creates a Copy activity from an Azure SQL source to an Azure SQL sink.
The activity name.
Type: String
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The source dataset reference.
Type: PSObject
Parameter Sets: (All)
Aliases:
Required: True
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The Copy activity source type.
Type: Object
Parameter Sets: (All)
Aliases:
Required: True
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Optional additional source columns.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: 4
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Optional timeout for the source query.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: 5
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The sink dataset reference.
Type: PSObject
Parameter Sets: (All)
Aliases:
Required: True
Position: 6
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The Copy activity sink type.
Type: Object
Parameter Sets: (All)
Aliases:
Required: True
Position: 7
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Optional sink store settings that define how data is written.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: 8
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
When specified, enables the SQL writer table lock setting.
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
The activity timeout. Defaults to 12 hours.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: 9
Default value: 0.12:00:00
Accept pipeline input: False
Accept wildcard characters: False
The activity dependencies. Defaults to an empty array.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: 10
Default value: @()
Accept pipeline input: False
Accept wildcard characters: False
Optional column translator configuration.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: 11
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Optional staging settings for the sink.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: 12
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
https://abbgrade.github.io/PsDataFactory/docs/New-AdfCopyActivity.html