New-AzureDataFactoryTable

New-AzureDataFactoryTable

Creates a table in the specified Azure data factory.

Syntax

Parameter Set: ByFactoryName
New-AzureDataFactoryTable [-ResourceGroupName] <String> [-DataFactoryName] <String> [[-Name] <String> ] [-File] <String> [-Force] [-Profile <AzureProfile> ] [ <CommonParameters>]

Parameter Set: ByFactoryObject
New-AzureDataFactoryTable [-DataFactory] <PSDataFactory> [[-Name] <String> ] [-File] <String> [-Force] [-Profile <AzureProfile> ] [ <CommonParameters>]

Detailed Description

Creates a table in the specified Azure data factory. If a table with the same name already exists, you will be asked to confirm whether to overwrite the existing table unless you use the -force flag.

Here is the sequence of operations you perform:

1) Create a data factory.

2) Create linked services.

3) Create tables.

4) Create a pipeline.

See Data Factory – Naming Rules topic on MSDN Library for naming rules for Data Factory artifacts.

Parameters

-DataFactory<PSDataFactory>

Specifies a object. This cmdlet creates a table in the data factory that this parameter specifies.

Aliases	none
Required?	true
Position?	1
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-DataFactoryName<String>

Name of the data factory.

Aliases	none
Required?	true
Position?	2
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-File<String>

Path including the name of the JSON file that contains the description of the table.

Aliases	none
Required?	true
Position?	4
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-Force

Indicates that this cmdlet replaces an existing table without prompting you for confirmation.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-Name<String>

Name of the table.

Aliases	none
Required?	false
Position?	3
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-Profile<AzureProfile>

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-ResourceGroupName<String>

Name of the resource group.

Aliases	none
Required?	true
Position?	1
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see  about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216).

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

• Microsoft.WindowsAzure.Commands.Utilities.PSTable

Examples

-------------------------- EXAMPLE 1 --------------------------

Creates a table 'DA_WikipediaClickEvents' in the Azure data factory 'WikiADF' based on information in the DAWikipediaClickEvents.json file.

PS C:\> New-AzureDataFactoryTable -ResourceGroupName ADF -Name DAWikipediaClickEvents -DataFactoryName wikiADF -File c:\\samples\\WikiSample\\DA_WikipediaClickEvents.json

-------------------------- EXAMPLE 2 --------------------------

Creates a table 'DA_WikipediaClickEvents' in the Azure data factory 'WikiADF' based on information in the DAWikipediaClickEvents.json file and assigns the output to a variable named $table.

PS C:\> $table = New-AzureDataFactoryTable -ResourceGroupName ADF -Name DAWikipediaClickEvents -DataFactoryName wikiADF -File c:\\samples\\WikiSample\\DA_WikipediaClickEvents.json

-------------------------- EXAMPLE 3 --------------------------

Returns details about the Availability property of the table you created in the previous step.

PS C:\> $table.Availability

-------------------------- EXAMPLE 4 --------------------------

Returns details about the Location property of the table you created earlier.

PS C:\> $table.Location

-------------------------- EXAMPLE 5 --------------------------

Returns validation rules for the table.

PS C:\> $table.Policy.Validation | format-list