Get-AzureRmDataLakeAnalyticsCatalogItem

Module:
AzureRM.DataLakeAnalytics
Gets a Data Lake Analytics catalog item or types of items.

Syntax

Get-AzureRmDataLakeAnalyticsCatalogItem
   [-Account] <String>
   [-ItemType] <CatalogItemType>
   [[-Path] <CatalogPathInstance>]
   [<CommonParameters>]

Description

The Get-AzureRmDataLakeAnalyticsCatalogItem gets a specified Azure Data Lake Analytics catalog item, or gets catalog items of a specified type.

Examples

Example 1: Get a specified database

PS C:\>Get-AzureRmDataLakeAnalyticsCatalogItem -Account "contosoadla" -ItemType Database -Path "databaseName"

This command gets the specified database.

Example 2: Get tables in a specified database and schema

PS C:\>Get-AzureRmDataLakeAnalyticsDataSource -AccountName "contosoadla" -ItemType Table -Path "databaseName.schemaName"

This command gets a list of tables in the specified database.

Required Parameters

-Account

Specifies the Data Lake Analytics account name.

Type:String
Aliases:AccountName
Position:0
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-ItemType

Specifies the catalog item type of the item(s) being fetched or listed. The acceptable values for this parameter are:

  • Database
  • Schema
  • Assembly
  • Table
  • TableValuedFunction
  • TableStatistics
  • ExternalDataSource
  • View
  • Procedure
  • Secret
  • Credential
  • Types
  • TablePartition
Type:CatalogItemType
Parameter Sets:Database, Schema, Assembly, Table, TablePartition, TableValuedFunction, TableStatistics, ExternalDataSource, View, Procedure, Secret, Credential, Types, Package
Position:1
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Optional Parameters

-Path

Specifies the multi-part path to the item to retrieve, or to the parent item of the items to list. The parts of the path should be separated by a period (.).

Type:CatalogPathInstance
Position:2
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Outputs

CatalogItem

The specified catalog item.

Outputs

List<CatalogItem>

The list of the specified catalog items underneath their corresponding container.