< Back

Test-AzureRmDataLakeAnalyticsCatalogItem

Tue Jan 29, 2019 9:44 pm

NAME Test-AzureRmDataLakeAnalyticsCatalogItem



SYNOPSIS

Checks for the existence of a catalog item.





SYNTAX

Test-AzureRmDataLakeAnalyticsCatalogItem [-Account] <String> [-ItemType] {Database | Schema | Assembly | Table | TablePartition |

TableValuedFunction | TableStatistics | ExternalDataSource | View | Procedure | Secret | Credential | Types | Package} [-Path]

<CatalogPathInstance> [-DefaultProfile <IAzureContextContainer>] [<CommonParameters>]





DESCRIPTION

The Test-AzureRmDataLakeAnalyticsCatalogItem cmdlet checks for the existence of an Azure Data Lake Analytics catalog item.





PARAMETERS

-Account <String>

Specifies the Data Lake Analytics account name.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-DefaultProfile <IAzureContextContainer>

The credentials, account, tenant, and subscription used for communication with azure



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-ItemType <CatalogItemType>

Specifies the catalog item type of the item to check. The acceptable values for this parameter are:



- Database



- Schema



- Assembly



- Table



- TablePartition



- TableValuedFunction



- TableStatistics



- ExternalDataSource



- View



- Procedure



- Secret



- Credential



- Types



Required? true

Position? 1

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-Path <CatalogPathInstance>

Specifies the path to the item to fetch, or the path to the parent item of the items to list.



Required? true

Position? 2

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

This cmdlet does not accept any input.





OUTPUTS

bool

True or false indicating if the specified catalog item exists or not.





NOTES









Example 1: Test whether a catalog item exists



PS C:\\>Test-AzureRmDataLakeAnalyticsCatalogItem -Account "ContosoAdlAccount" -ItemType Schema -Path "databaseName.schemaName"



This command tests whether a specified Schema item exists.







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... atalogitem

Get-AzureRmDataLakeAnalyticsCatalogItem