Power BI Connector for Azure Data Catalog

Build 24.0.9062

Objects

Get list datasource properties.

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 Objects WHERE Tags <> 'sales';

    SELECT * FROM Objects WHERE Name = 'sales' AND HasTags = true;

    SELECT * FROM Objects WHERE CONTAINS(Tags, 'sales') AND CONTAINS(Tags, 'customer');

Columns

Name Type Description
Id String Id of an Object.
Type String Type of an Object.
EffectiveRights String Rights a particular annotation has.
Name String Name of an Object.
ObjectType String Type of object. Eg. table, etc.
SourceType String Source type. Eg. Jdbc, Odbc, etc.
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.
LastRegisteredByObjectId String Object Id of a user.
LastRegisteredByUpn String User Principal Name of a user.
Roles String Roles of Database.
RoleMembers String Members whom roles was assigned.
Timestamp Datetime Created time of an Object.
AccessInstructionsId String Id of access instructions.
AccessInstructionsType String Type of access instructions.
AccessInstructionsEffectiveRights String Rights a particular annotation has.
AccessInstructionsMimeType String Mime type of a documentation.
AccessInstructionsContent String Content of a documentation.
AccessInstructionsFromSourceSystem Boolean Indicates whether data of an item is derived from a source system or authored by a user.
AccessInstructionsRoles String Roles of an object.
AccessInstructionsRoleMembers String Members whom roles was assigned.
AccessInstructionsTimestamp Datetime Created time of an object.
FriendlyName String Check items where the search term appears in the data source friendly name.
Experts String Check items where the data source expert matches the search term.
Description String Description of objects.
Tags String Tags available for objects.
HasTags Boolean Check items that have a tag.
HasPreviews Boolean Check items that contain a 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 String Date and time when the metadata was registered.

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