Power BI Connector for Azure Data Catalog

Build 24.0.9062

Tables

Get list of tables in the data asset.

Table Specific Information

Select

The 本製品 will use the Azure Data Catalog API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • Name supports the '=, !=, <>, CONTAINS' operators.
  • Timestamp supports the '=, <, <=, >, >=, CONTAINS' operators.
  • LastRegisteredTime supports the '=, CONTAINS' operators.
  • ObjectType supports the '=' operator.
  • SourceType supports the '=' operator.
  • FriendlyName supports the '=, CONTAINS' operators.
  • Experts supports the '=, CONTAINS' operators.
  • Description supports the '=, CONTAINS' operators.
  • Tags supports the '=, !=, <>, CONTAINS' operators.
  • HasTags supports the '=' operator.
  • HasPreviews supports the '=' operator.
  • HasDocumentation supports the '=' operator.
  • HasTableDataProfiles supports the '=' operator.
  • HasColumnsDataProfiles supports the '=' operator.
  • HasDescription supports the '=' operator.
  • View supports the '=' operator.
  • Facets supports the '=' operator.
For example:
    SELECT * FROM Tables WHERE Tags = 'sales' OR Name = 'FactProductInventory';

    SELECT * FROM Tables WHERE Tags != 'FactProductInventory' AND NOT Tags = 'sales';

    SELECT * FROM Tables WHERE NOT Tags = 'FactProductInventory';

Columns

Name Type Description
Id String Id of a table.
Type String Type of table.
EffectiveRights String Rights a particular annotation has.
Roles String Roles of a table.
RoleMembers String Members to whom the role was assigned.
Timestamp Datetime Created time of table.
ItemId String Item Id of the table or view.
Name String Name of a table.
ContainerId String Id of a container.
ObjectType String Type of object. Eg. table, etc.
SourceType String Source type. Eg. Jdbc, Odbc, etc.
DslAddressDatabase String Name of the database.
DslAddressObject String Object of a table.
DslAddressOptionsDriver String Name of the driver.
DslAddressOptionsPort String Port number.
DslAddressOptionsServer String IP address of the server.
DslAuthentication String Type of authentication used.
DslProtocol String Describes a protocol used to communicate with the data source.
FromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
LastRegisteredByFirstName String First name of the registered user.
LastRegisteredByLastName String Last name of the registered user.
LastRegisteredByObjectId String Object Id of a user.
LastRegisteredByUpn String User Principal Name of a user.
AccessInstructionsId String Id of access instructions.
AccessInstructionsType String Type of access instructions.
AccessInstructionsEffectiveRights String Rights a particular annotation has.
AccessInstructionsMimeType String Mime type of access instructions.
AccessInstructionsContent String Content described in access instructions.
AccessInstructionsFromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
AccessInstructionsRoles String Roles of table.
AccessInstructionsRoleMembers String Members to whom the role was assigned.
AccessInstructionsTimestamp Datetime Created time of table.
SchemaId String Id of a schema.
SchemaType String Type of schema.
SchemaEffectiveRights String Rights a particular annotation has.
SchemaFromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
SchemaRoles String Roles of an schema for table.
SchemaRoleMembers String Members whom roles was assigned.
SchemaTimestamp Datetime Created time of an schema for table.
DocumentationId String Id of a documentation.
DocumentationType String Type of documentation.
DocumentationEffectiveRights String Rights a particular documentation has.
DocumentationMimeType String Mime type of a documentation.
DocumentationContent String Content of a documentation.
DocumentationFromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
DocumentationRoles String Roles of an documentation for table.
DocumentationRoleMembers String Members whom roles was assigned.
DocumentationTimestamp Datetime Created time of an documentation for table.
FriendlyName String Name of a friendly name.
FriendlyNameId String Id of a friendly name.
FriendlyNameType String Type of friendly name.
FriendlyNameEffectiveRights String Rights a particular annotation has.
FriendlyNameFromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
FriendlyNameRoles String Roles of an friendly name for table.
FriendlyNameRoleMembers String Members whom roles was assigned.
FriendlyNameTimestamp Datetime Created time of an friendly name for table.
Experts String Check items where the data source expert matches the search term.
Description String Description of table.
Tags String Tags available in tables.
HasTags Boolean Check items that have a tag.
HasPreviews Boolean Check items that contain preview.
HasDocumentation Boolean Check items that contain documentation.
HasTableDataProfiles Boolean Check items that have a table profile.
HasColumnsDataProfiles Boolean Check items that have a columns data profile.
HasDescription Boolean Check items that have a description.
View String Name of the view the client wants to see.
Facets String A comma separated field names to facet the results on.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
LastRegisteredTime Date Date and time when the metadata was registered.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062