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.
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. |