Cmdlets

Choose a cmdlet from the list on the left or search for a specific cmdlet. Choose a cmdlet from the list or search for a specific cmdlet.
About Help  Providers
 

Get-AzureDataFactoryTable

Get-AzureDataFactoryTable

microsoft.azure.commands.datafactories.dll

Synopsis

Gets information about tables in Data Factory.

Syntax

Get-AzureDataFactoryTable [-ResourceGroupName] [-DataFactoryName] [-Name] [<CommonParameters>]

Get-AzureDataFactoryTable [-DataFactory] [-Name] [<CommonParameters>]

Detailed Description

The Get-AzureDataFactoryTable cmdlet gets information about tables in Azure Data Factory. If you specify the name of a table, this cmdlet gets information about that table. If you do not specify a name, this cmdlet gets information about all the tables in the data factory.

You must be in AzureResourceManager mode to run Azure Data Factory cmdlets. To switch to AzureResourceManager mode, type Switch-AzureMode AzureResourceManager.

Parameters

-DataFactory <PSDataFactory>

Specifies a PSDataFactory object. This cmdlet gets tables that belong to 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>

Specifies the name of a data factory. This cmdlet gets tables that belong to the data factory that this parameter specifies.

Aliases

None

Required?

true

Position

2

Default value

None

Accept pipeline input?

True (ByPropertyName)

Accept wildcard characters?

false

-Name <String>

Specifies the name of the table about which to get information.

Aliases

None

Required?

false

Position

3

Default value

None

Accept pipeline input?

True (ByPropertyName)

Accept wildcard characters?

false

-ResourceGroupName <String>

Specifies the name of an Azure resource group. This cmdlet gets tables that belong to the group that this parameter specifies.

Aliases

None

Required?

true

Position

1

Default value

None

Accept pipeline input?

True (ByPropertyName)

Accept wildcard characters?

false

Input Type


Return Type

System.Collections.Generic.List`1[[Microsoft.WindowsAzure.Commands.Utilities.PSTable, Microsoft.WindowsAzure.Commands.Utilities, Version=0.8.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]] Microsoft.WindowsAzure.Commands.Utilities.PSTable

Notes

None

Examples

Example 1: Get information about all tables

This command gets information about all tables in the data factory named WikiADF.

                    PS C:\> Get-AzureDataFactoryTable -ResourceGroupName "ADF" -DataFactoryName "WikiADF"
                    TableName         : DACuratedWikiData
                    ResourceGroupName : ADF
                    DataFactoryName   : WikiADF
                    Availability      : Microsoft.DataFactories.Availability
                    Location          :
                    Policy            :
                    Structure         : {}
                    Published         : False

                    TableName         : DAWikipediaClickEvents
                    ResourceGroupName : ADF
                    DataFactoryName   : WikiADF
                    Availability      : Microsoft.DataFactories.Availability
                    Location          :
                    Policy            :
                    Structure         : {}
                    Published         : False

                    TableName         : DAWikiAggregatedData
                    ResourceGroupName : ADF
                    DataFactoryName   : WikiADF
                    Availability      : Microsoft.DataFactories.Availability
                    Location          :
                    Policy            :
                    Structure         : {}
                    Published         : False
                

Example 2: Get information about a specific table

This command gets information about the table named DAWikipediaClickEvents in the data factory named WikiADF.

                    PS C:\> Get-AzureDataFactoryTable -ResourceGroupName "ADF" -DataFactoryName "WikiADF" -Name "DAWikipediaClickEvents"
                    TableName         : DAWikipediaClickEvents
                    ResourceGroupName : ADF
                    DataFactoryName   : WikiADF
                    Availability      : Microsoft.DataFactories.Availability
                    Location          : Microsoft.DataFactories.AzureBlobLocation
                    Policy            : Microsoft.DataFactories.Policy
                    Structure         : {}
                    Published         : False
                

Example 3: Get the location for a specific table

This command gets information for the table named DAWikipediaClickEvents in the data factory named WikiADF, and then uses standard dot notation to view the Location associated with that table. Alternatively, assign the output of the Get-AzureDataFactoryTable cmdlet to a variable, and then use dot notation to view the Location property associated with the table object stored in that variable.

                    PS C:\> (Get-AzureDataFactoryTable -ResourceGroupName "ADF" -DataFactoryName "WikiADF" -Name "DAWikipediaClickEvents").Location
                    BlobPath          : wikidatagateway/wikisampledatain/
                    FilenamePrefix    :
                    Format            :
                    LinkedServiceName : LinkedServiceWikipediaClickEvents
                    PartitionBy       : {}
                

New-AzureDataFactoryTable
Remove-AzureDataFactoryTable