Experts
Get list of experts of databases, tables, and objects.
Table Specific Information
Select
The add-in 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 add-in.
- 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 Experts WHERE ObjectType = 'table' AND CONTAINS(Experts, 'support')
SELECT * FROM Experts WHERE Tags = 'orders' OR Name = 'orders' AND ObjectType = 'table';
Columns
| Name | Type | Description |
| Id | String | Id of an expert. |
| Type | String | Type of expert. |
| EffectiveRights | String | Rights a particular annotation has. |
| FromSourceSystem | Boolean | Indicates whether data of an item is derived from a source system or authored by a user. |
| Key | String | Key of an expert. |
| ExpertObjectId | String | Object Id of an expert. |
| ExpertUPN | String | User Principal Name of an expert. |
| Roles | String | Roles of an expert. |
| RoleMembers | String | Members whom roles was assigned. |
| Timestamp | Datetime | Created time of experts. |
| Name | String | Name of a table, database, object. |
| ObjectType | String | Type of object. Eg. table, etc. |
| SourceType | String | Source type. Eg. Jdbc, Odbc, etc. |
| 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 an expert. |
| Tags | String | Tags available for experts. |
| 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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| LastRegisteredTime | Date | Date and time when the metadata was registered. |