Querying the Sensitive Data in Databases

Function

This API is used to query sensitive data in databases in the asset catalog. You can filter the sensitive data statistics of a database by group label ID and type ID.

Calling Method

For details, see Calling APIs.

URI

GET /v1/{project_id}/metadata/catalog/column-details/database-dim

**Table 1** Path Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Unique project ID.

**Table 2** Query Parameters
Parameter	Mandatory	Type	Description
label_id	No	String	Group label ID, which is used to filter the database dimension of a specific group.
type_id	No	String	Type ID, which is used to filter the database dimension of a specific type.

Request Parameters

None

Response Parameters

Status code: 200

**Table 3** Response body parameters
Parameter	Type	Description
results	Array of DatabaseDim objects	List of column label details by database.

**Table 4** DatabaseDim
Parameter	Type	Description
asset_name	String	Asset name.
count	Integer	Matched items.
db_name	String	Database name.
db_type	String	Database type.
tables	Array of TableDim objects	Table information list.

**Table 5** TableDim
Parameter	Type	Description
columns	Array of ColumnDim objects	Column information list.
count	Integer	Matched items.
table_name	String	Table name.

**Table 6** ColumnDim
Parameter	Type	Description
classification_tags	Array of strings	Classification label list.
column_name	String	Column name.
level_tags	Array of strings	Level label list.

Example Requests

None

Example Responses

None

Status Codes

Status Code	Description
200	Query result.
401	Unauthorized. The user is not logged in or the token is invalid.
403	Unauthorized to access the resource.
404	The specified project does not exist.