Cloud Data Loss Prevention (Cloud DLP) is now a part of Sensitive Data Protection. The API name remains the same: Cloud Data Loss Prevention API (DLP API). For information about the services that make up Sensitive Data Protection, see Sensitive Data Protection overview.
Required. Resource name of the organization or project, for example organizations/433245324/locations/europe or projects/project-id/locations/asia.
Authorization requires the following IAM permission on the specified resource parent:
dlp.columnDataProfiles.list
Query parameters
Parameters
pageToken
string
Page token to continue retrieval.
pageSize
integer
Size of the page. This value can be limited by the server. If zero, server returns a page of max size 100.
orderBy
string
Comma-separated list of fields to order by, followed by asc or desc postfix. This list is case insensitive. The default sorting order is ascending. Redundant space characters are insignificant. Only one order field at a time is allowed.
Examples:
projectId asc
tableId
sensitivityLevel desc
Supported fields are:
projectId: The Google Cloud project ID.
datasetId: The ID of a BigQuery dataset.
tableId: The ID of a BigQuery table.
sensitivityLevel: How sensitive the data in a column is, at most.
dataRiskLevel: How much risk is associated with this data.
profileLastGenerated: When the profile was last updated in epoch seconds.
filter
string
Allows filtering.
Supported syntax:
Filter expressions are made up of one or more restrictions.
Restrictions can be combined by AND or OR logical operators. A sequence of restrictions implicitly uses AND.
A restriction has the form of {field} {operator} {value}.
Supported fields/values:
table_data_profile_name - The name of the related table data profile.
projectId - The Google Cloud project ID. (REQUIRED)
datasetId - The BigQuery dataset ID. (REQUIRED)
tableId - The BigQuery table ID. (REQUIRED)
fieldId - The ID of the BigQuery field.
infoType - The infotype detected in the resource.
sensitivityLevel - HIGH|MEDIUM|LOW
dataRiskLevel: How much risk is associated with this data.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-09 UTC."],[],[],null,["- [HTTP request](#body.HTTP_TEMPLATE)\n- [Path parameters](#body.PATH_PARAMETERS)\n- [Query parameters](#body.QUERY_PARAMETERS)\n- [Request body](#body.request_body)\n- [Response body](#body.response_body)\n- [Authorization scopes](#body.aspect)\n- [Try it!](#try-it)\n\nLists column data profiles for an organization.\n\nHTTP request\n\nChoose a location: \nglobal africa-south1 asia-east1 asia-east2 asia-northeast1 asia-northeast2 asia-northeast3 asia-south1 asia-south2 asia-southeast1 asia-southeast2 australia-southeast1 australia-southeast2 europe-central2 europe-north1 europe-north2 europe-southwest1 europe-west1 europe-west10 europe-west12 europe-west2 europe-west3 europe-west4 europe-west6 europe-west8 europe-west9 me-central1 me-central2 me-west1 northamerica-northeast1 northamerica-northeast2 northamerica-south1 southamerica-east1 southamerica-west1 us-central1 us-east1 us-east4 us-east5 us-south1 us-west1 us-west2 us-west3 us-west4 us eu \n\n\u003cbr /\u003e\n\nThe URLs use [gRPC Transcoding](https://google.aip.dev/127) syntax.\n\nPath parameters\n\n| Parameters ||\n|----------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `parent` | `string` Required. Resource name of the organization or project, for example `organizations/433245324/locations/europe` or `projects/project-id/locations/asia`. Authorization requires the following [IAM](https://cloud.google.com/iam/docs/) permission on the specified resource `parent`: - `dlp.columnDataProfiles.list` |\n\nQuery parameters\n\n| Parameters ||\n|-------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `pageToken` | `string` Page token to continue retrieval. |\n| `pageSize` | `integer` Size of the page. This value can be limited by the server. If zero, server returns a page of max size 100. |\n| `orderBy` | `string` Comma-separated list of fields to order by, followed by `asc` or `desc` postfix. This list is case insensitive. The default sorting order is ascending. Redundant space characters are insignificant. Only one order field at a time is allowed. Examples: - `projectId asc` - `tableId` - `sensitivityLevel desc` Supported fields are: - `projectId`: The Google Cloud project ID. - `datasetId`: The ID of a BigQuery dataset. - `tableId`: The ID of a BigQuery table. - `sensitivityLevel`: How sensitive the data in a column is, at most. - `dataRiskLevel`: How much risk is associated with this data. - `profileLastGenerated`: When the profile was last updated in epoch seconds. |\n| `filter` | `string` Allows filtering. Supported syntax: - Filter expressions are made up of one or more restrictions. - Restrictions can be combined by `AND` or `OR` logical operators. A sequence of restrictions implicitly uses `AND`. - A restriction has the form of `{field} {operator} {value}`. - Supported fields/values: - `table_data_profile_name` - The name of the related table data profile. - `projectId` - The Google Cloud project ID. (REQUIRED) - `datasetId` - The BigQuery dataset ID. (REQUIRED) - `tableId` - The BigQuery table ID. (REQUIRED) - `fieldId` - The ID of the BigQuery field. - `infoType` - The infotype detected in the resource. - `sensitivityLevel` - HIGH\\|MEDIUM\\|LOW - `dataRiskLevel`: How much risk is associated with this data. - `status_code` - an RPC status code as defined in \u003chttps://github.com/googleapis/googleapis/blob/master/google/rpc/code.proto\u003e - The operator must be `=` for projectId, datasetId, and tableId. Other filters also support `!=`. Examples: - projectId = 12345 AND status_code = 1 - projectId = 12345 AND sensitivityLevel = HIGH - projectId = 12345 AND infoType = STREET_ADDRESS The length of this field should be no more than 500 characters. |\n\nRequest body\n\nThe request body must be empty.\n\nResponse body\n\nIf successful, the response body contains an instance of [ListColumnDataProfilesResponse](/sensitive-data-protection/docs/reference/rest/v2/ListColumnDataProfilesResponse).\n\nAuthorization scopes\n\nRequires the following OAuth scope:\n\n- `https://www.googleapis.com/auth/cloud-platform`\n\nFor more information, see the [Authentication Overview](/docs/authentication#authorization-gcp)."]]
