Databases
Get list of databases.
Table Specific Information
Select
The driver 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 driver.
- 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 Databases WHERE HasDocumentation=false AND HasDescription = false AND HasTags = true;
SELECT * FROM Databases WHERE Timestamp > '2019-09-19T04:39:54.0083651Z'
SELECT * FROM Databases WHERE Tags = 'sales' OR Name = 'FactProductInventory'
Columns
| Name | Type | Description |
| Id | String | Id of a database. |
| Type | String | Type of database. |
| EffectiveRights | String | Rights a particular annotation has. |
| Roles | String | Roles of a database. |
| RoleMembers | String | Members whom roles was assigned. |
| Timestamp | Datetime | Created time of database. |
| Name | String | Name of a property. |
| ObjectType | String | Type of object. Eg. table, etc. |
| SourceType | String | Source type. Eg. Jdbc, Odbc, etc. |
| DslAddressDatabase | String | DSL address of a database. |
| 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 last registered user. |
| LastRegisteredByUpn | String | Upn of last registered user. |
| AccessInstructionsId | String | Id of an access instructions. |
| AccessInstructionsType | String | Type of an access instructions. |
| AccessInstructionsEffectiveRights | String | Effective rights of a particular access instructions. |
| AccessInstructionsMimeType | String | Mime type of access instructions. |
| AccessInstructionsContent | String | Content of an 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 Database. |
| AccessInstructionsRoleMembers | String | Members whom roles was assigned. |
| AccessInstructionsTimestamp | Datetime | Created time of access instructions. |
| DocumentationType | String | Type of documentation. |
| DocumentationId | String | Id of a documentation. |
| DocumentationEffectiveRights | String | Rights a particular documentation has. |
| DocumentationMimeType | String | Mime type 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 a documentation. |
| DocumentationRoleMembers | String | Members whom roles was assigned. |
| DocumentationTimestamp | Datetime | Created time of other:mirror= |
| 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 friendly name has. |
| FriendlyNameFromSourceSystem | Boolean | Indicates whether data of an item is derived from a source system or authored by a user. |
| FriendlyNameRoles | String | Roles of friendly name. |
| FriendlyNameRoleMembers | String | Members whom roles was assigned. |
| FriendlyNameTimestamp | Datetime | Created time of friendly name. |
| Experts | String | Check items where the data source expert matches the search term. |
| Description | String | Description of databases. |
| Tags | String | Tags available in databases. |
| Facets | String | A comma separated field names to facet the results on. |
| View | String | Name of the view the client wants to see. |
| 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. |
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. |