table_data_profiles

Creates, updates, deletes, gets or lists a table_data_profiles resource.

Overview

Name	table_data_profiles
Type	Resource
Id	google.dlp.table_data_profiles

Fields

The following fields are returned by SELECT queries:

projects_locations_table_data_profiles_get

Successful response

Name	Datatype	Description
name	string	The name of the profile.
configSnapshot	object	The snapshot of the configurations used to generate the profile. (id: GooglePrivacyDlpV2DataProfileConfigSnapshot)
createTime	string (google-datetime)	The time at which the table was created.
dataRiskLevel	object	The data risk level of this table. (id: GooglePrivacyDlpV2DataRiskLevel)
dataSourceType	object	The resource type that was profiled. (id: GooglePrivacyDlpV2DataSourceType)
datasetId	string	If the resource is BigQuery, the dataset ID.
datasetLocation	string	If supported, the location where the dataset's data is stored. See https://cloud.google.com/bigquery/docs/locations for supported locations.
datasetProjectId	string	The Google Cloud project ID that owns the resource.
domains	array	Domains associated with the profile.
encryptionStatus	string	How the table is encrypted.
expirationTime	string (google-datetime)	Optional. The time when this table expires.
failedColumnCount	string (int64)	The number of columns skipped in the table because of an error.
fullResource	string	The Cloud Asset Inventory resource that was profiled in order to generate this TableDataProfile. https://cloud.google.com/apis/design/resource_names#full_resource_name
lastModifiedTime	string (google-datetime)	The time when this table was last modified
otherInfoTypes	array	Other infoTypes found in this table's data.
predictedInfoTypes	array	The infoTypes predicted from this table's data.
profileLastGenerated	string (google-datetime)	The last time the profile was generated.
profileStatus	object	Success or error status from the most recent profile generation attempt. May be empty if the profile is still being generated. (id: GooglePrivacyDlpV2ProfileStatus)
projectDataProfile	string	The resource name of the project data profile for this table.
relatedResources	array	Resources related to this profile.
resourceLabels	object	The labels applied to the resource at the time the profile was generated.
resourceVisibility	string	How broadly a resource has been shared.
rowCount	string (int64)	Number of rows in the table when the profile was generated. This will not be populated for BigLake tables.
sampleFindingsTable	object	The BigQuery table to which the sample findings are written. (id: GooglePrivacyDlpV2BigQueryTable)
scannedColumnCount	string (int64)	The number of columns profiled in the table.
sensitivityScore	object	The sensitivity score of this table. (id: GooglePrivacyDlpV2SensitivityScore)
state	string	State of a profile. This will always be set to DONE when the table data profile is written to another service like BigQuery or Pub/Sub.
tableId	string	The table ID.
tableSizeBytes	string (int64)	The size of the table when the profile was generated.
tags	array	The tags attached to the table, including any tags attached during profiling. Because tags are attached to Cloud SQL instances rather than Cloud SQL tables, this field is empty for Cloud SQL table profiles.

organizations_locations_table_data_profiles_get

Successful response

Name	Datatype	Description
name	string	The name of the profile.
configSnapshot	object	The snapshot of the configurations used to generate the profile. (id: GooglePrivacyDlpV2DataProfileConfigSnapshot)
createTime	string (google-datetime)	The time at which the table was created.
dataRiskLevel	object	The data risk level of this table. (id: GooglePrivacyDlpV2DataRiskLevel)
dataSourceType	object	The resource type that was profiled. (id: GooglePrivacyDlpV2DataSourceType)
datasetId	string	If the resource is BigQuery, the dataset ID.
datasetLocation	string	If supported, the location where the dataset's data is stored. See https://cloud.google.com/bigquery/docs/locations for supported locations.
datasetProjectId	string	The Google Cloud project ID that owns the resource.
domains	array	Domains associated with the profile.
encryptionStatus	string	How the table is encrypted.
expirationTime	string (google-datetime)	Optional. The time when this table expires.
failedColumnCount	string (int64)	The number of columns skipped in the table because of an error.
fullResource	string	The Cloud Asset Inventory resource that was profiled in order to generate this TableDataProfile. https://cloud.google.com/apis/design/resource_names#full_resource_name
lastModifiedTime	string (google-datetime)	The time when this table was last modified
otherInfoTypes	array	Other infoTypes found in this table's data.
predictedInfoTypes	array	The infoTypes predicted from this table's data.
profileLastGenerated	string (google-datetime)	The last time the profile was generated.
profileStatus	object	Success or error status from the most recent profile generation attempt. May be empty if the profile is still being generated. (id: GooglePrivacyDlpV2ProfileStatus)
projectDataProfile	string	The resource name of the project data profile for this table.
relatedResources	array	Resources related to this profile.
resourceLabels	object	The labels applied to the resource at the time the profile was generated.
resourceVisibility	string	How broadly a resource has been shared.
rowCount	string (int64)	Number of rows in the table when the profile was generated. This will not be populated for BigLake tables.
sampleFindingsTable	object	The BigQuery table to which the sample findings are written. (id: GooglePrivacyDlpV2BigQueryTable)
scannedColumnCount	string (int64)	The number of columns profiled in the table.
sensitivityScore	object	The sensitivity score of this table. (id: GooglePrivacyDlpV2SensitivityScore)
state	string	State of a profile. This will always be set to DONE when the table data profile is written to another service like BigQuery or Pub/Sub.
tableId	string	The table ID.
tableSizeBytes	string (int64)	The size of the table when the profile was generated.
tags	array	The tags attached to the table, including any tags attached during profiling. Because tags are attached to Cloud SQL instances rather than Cloud SQL tables, this field is empty for Cloud SQL table profiles.

projects_locations_table_data_profiles_list

Successful response

Name	Datatype	Description
name	string	The name of the profile.
configSnapshot	object	The snapshot of the configurations used to generate the profile. (id: GooglePrivacyDlpV2DataProfileConfigSnapshot)
createTime	string (google-datetime)	The time at which the table was created.
dataRiskLevel	object	The data risk level of this table. (id: GooglePrivacyDlpV2DataRiskLevel)
dataSourceType	object	The resource type that was profiled. (id: GooglePrivacyDlpV2DataSourceType)
datasetId	string	If the resource is BigQuery, the dataset ID.
datasetLocation	string	If supported, the location where the dataset's data is stored. See https://cloud.google.com/bigquery/docs/locations for supported locations.
datasetProjectId	string	The Google Cloud project ID that owns the resource.
domains	array	Domains associated with the profile.
encryptionStatus	string	How the table is encrypted.
expirationTime	string (google-datetime)	Optional. The time when this table expires.
failedColumnCount	string (int64)	The number of columns skipped in the table because of an error.
fullResource	string	The Cloud Asset Inventory resource that was profiled in order to generate this TableDataProfile. https://cloud.google.com/apis/design/resource_names#full_resource_name
lastModifiedTime	string (google-datetime)	The time when this table was last modified
otherInfoTypes	array	Other infoTypes found in this table's data.
predictedInfoTypes	array	The infoTypes predicted from this table's data.
profileLastGenerated	string (google-datetime)	The last time the profile was generated.
profileStatus	object	Success or error status from the most recent profile generation attempt. May be empty if the profile is still being generated. (id: GooglePrivacyDlpV2ProfileStatus)
projectDataProfile	string	The resource name of the project data profile for this table.
relatedResources	array	Resources related to this profile.
resourceLabels	object	The labels applied to the resource at the time the profile was generated.
resourceVisibility	string	How broadly a resource has been shared.
rowCount	string (int64)	Number of rows in the table when the profile was generated. This will not be populated for BigLake tables.
sampleFindingsTable	object	The BigQuery table to which the sample findings are written. (id: GooglePrivacyDlpV2BigQueryTable)
scannedColumnCount	string (int64)	The number of columns profiled in the table.
sensitivityScore	object	The sensitivity score of this table. (id: GooglePrivacyDlpV2SensitivityScore)
state	string	State of a profile. This will always be set to DONE when the table data profile is written to another service like BigQuery or Pub/Sub.
tableId	string	The table ID.
tableSizeBytes	string (int64)	The size of the table when the profile was generated.
tags	array	The tags attached to the table, including any tags attached during profiling. Because tags are attached to Cloud SQL instances rather than Cloud SQL tables, this field is empty for Cloud SQL table profiles.

organizations_locations_table_data_profiles_list

Successful response

Name	Datatype	Description
name	string	The name of the profile.
configSnapshot	object	The snapshot of the configurations used to generate the profile. (id: GooglePrivacyDlpV2DataProfileConfigSnapshot)
createTime	string (google-datetime)	The time at which the table was created.
dataRiskLevel	object	The data risk level of this table. (id: GooglePrivacyDlpV2DataRiskLevel)
dataSourceType	object	The resource type that was profiled. (id: GooglePrivacyDlpV2DataSourceType)
datasetId	string	If the resource is BigQuery, the dataset ID.
datasetLocation	string	If supported, the location where the dataset's data is stored. See https://cloud.google.com/bigquery/docs/locations for supported locations.
datasetProjectId	string	The Google Cloud project ID that owns the resource.
domains	array	Domains associated with the profile.
encryptionStatus	string	How the table is encrypted.
expirationTime	string (google-datetime)	Optional. The time when this table expires.
failedColumnCount	string (int64)	The number of columns skipped in the table because of an error.
fullResource	string	The Cloud Asset Inventory resource that was profiled in order to generate this TableDataProfile. https://cloud.google.com/apis/design/resource_names#full_resource_name
lastModifiedTime	string (google-datetime)	The time when this table was last modified
otherInfoTypes	array	Other infoTypes found in this table's data.
predictedInfoTypes	array	The infoTypes predicted from this table's data.
profileLastGenerated	string (google-datetime)	The last time the profile was generated.
profileStatus	object	Success or error status from the most recent profile generation attempt. May be empty if the profile is still being generated. (id: GooglePrivacyDlpV2ProfileStatus)
projectDataProfile	string	The resource name of the project data profile for this table.
relatedResources	array	Resources related to this profile.
resourceLabels	object	The labels applied to the resource at the time the profile was generated.
resourceVisibility	string	How broadly a resource has been shared.
rowCount	string (int64)	Number of rows in the table when the profile was generated. This will not be populated for BigLake tables.
sampleFindingsTable	object	The BigQuery table to which the sample findings are written. (id: GooglePrivacyDlpV2BigQueryTable)
scannedColumnCount	string (int64)	The number of columns profiled in the table.
sensitivityScore	object	The sensitivity score of this table. (id: GooglePrivacyDlpV2SensitivityScore)
state	string	State of a profile. This will always be set to DONE when the table data profile is written to another service like BigQuery or Pub/Sub.
tableId	string	The table ID.
tableSizeBytes	string (int64)	The size of the table when the profile was generated.
tags	array	The tags attached to the table, including any tags attached during profiling. Because tags are attached to Cloud SQL instances rather than Cloud SQL tables, this field is empty for Cloud SQL table profiles.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
projects_locations_table_data_profiles_get	select	projectsId, locationsId, tableDataProfilesId		Gets a table data profile.
organizations_locations_table_data_profiles_get	select	organizationsId, locationsId, tableDataProfilesId		Gets a table data profile.
projects_locations_table_data_profiles_list	select	projectsId, locationsId	pageToken, pageSize, orderBy, filter	Lists table data profiles for an organization.
organizations_locations_table_data_profiles_list	select	organizationsId, locationsId	pageToken, pageSize, orderBy, filter	Lists table data profiles for an organization.
projects_locations_table_data_profiles_delete	delete	projectsId, locationsId, tableDataProfilesId		Delete a TableDataProfile. Will not prevent the profile from being regenerated if the table is still included in a discovery configuration.
organizations_locations_table_data_profiles_delete	delete	organizationsId, locationsId, tableDataProfilesId		Delete a TableDataProfile. Will not prevent the profile from being regenerated if the table is still included in a discovery configuration.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
locationsId	string
organizationsId	string
projectsId	string
tableDataProfilesId	string
filter	string
orderBy	string
pageSize	integer (int32)
pageToken	string

SELECT examples

projects_locations_table_data_profiles_get

Gets a table data profile.

SELECT
name,
configSnapshot,
createTime,
dataRiskLevel,
dataSourceType,
datasetId,
datasetLocation,
datasetProjectId,
domains,
encryptionStatus,
expirationTime,
failedColumnCount,
fullResource,
lastModifiedTime,
otherInfoTypes,
predictedInfoTypes,
profileLastGenerated,
profileStatus,
projectDataProfile,
relatedResources,
resourceLabels,
resourceVisibility,
rowCount,
sampleFindingsTable,
scannedColumnCount,
sensitivityScore,
state,
tableId,
tableSizeBytes,
tags
FROM google.dlp.table_data_profiles
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND tableDataProfilesId = '{{ tableDataProfilesId }}' -- required;

organizations_locations_table_data_profiles_get

Gets a table data profile.

SELECT
name,
configSnapshot,
createTime,
dataRiskLevel,
dataSourceType,
datasetId,
datasetLocation,
datasetProjectId,
domains,
encryptionStatus,
expirationTime,
failedColumnCount,
fullResource,
lastModifiedTime,
otherInfoTypes,
predictedInfoTypes,
profileLastGenerated,
profileStatus,
projectDataProfile,
relatedResources,
resourceLabels,
resourceVisibility,
rowCount,
sampleFindingsTable,
scannedColumnCount,
sensitivityScore,
state,
tableId,
tableSizeBytes,
tags
FROM google.dlp.table_data_profiles
WHERE organizationsId = '{{ organizationsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND tableDataProfilesId = '{{ tableDataProfilesId }}' -- required;

projects_locations_table_data_profiles_list

Lists table data profiles for an organization.

SELECT
name,
configSnapshot,
createTime,
dataRiskLevel,
dataSourceType,
datasetId,
datasetLocation,
datasetProjectId,
domains,
encryptionStatus,
expirationTime,
failedColumnCount,
fullResource,
lastModifiedTime,
otherInfoTypes,
predictedInfoTypes,
profileLastGenerated,
profileStatus,
projectDataProfile,
relatedResources,
resourceLabels,
resourceVisibility,
rowCount,
sampleFindingsTable,
scannedColumnCount,
sensitivityScore,
state,
tableId,
tableSizeBytes,
tags
FROM google.dlp.table_data_profiles
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageToken = '{{ pageToken }}'
AND pageSize = '{{ pageSize }}'
AND orderBy = '{{ orderBy }}'
AND filter = '{{ filter }}';

organizations_locations_table_data_profiles_list

Lists table data profiles for an organization.

SELECT
name,
configSnapshot,
createTime,
dataRiskLevel,
dataSourceType,
datasetId,
datasetLocation,
datasetProjectId,
domains,
encryptionStatus,
expirationTime,
failedColumnCount,
fullResource,
lastModifiedTime,
otherInfoTypes,
predictedInfoTypes,
profileLastGenerated,
profileStatus,
projectDataProfile,
relatedResources,
resourceLabels,
resourceVisibility,
rowCount,
sampleFindingsTable,
scannedColumnCount,
sensitivityScore,
state,
tableId,
tableSizeBytes,
tags
FROM google.dlp.table_data_profiles
WHERE organizationsId = '{{ organizationsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageToken = '{{ pageToken }}'
AND pageSize = '{{ pageSize }}'
AND orderBy = '{{ orderBy }}'
AND filter = '{{ filter }}';

DELETE examples

projects_locations_table_data_profiles_delete

Delete a TableDataProfile. Will not prevent the profile from being regenerated if the table is still included in a discovery configuration.

DELETE FROM google.dlp.table_data_profiles
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND tableDataProfilesId = '{{ tableDataProfilesId }}' --required;

organizations_locations_table_data_profiles_delete

Delete a TableDataProfile. Will not prevent the profile from being regenerated if the table is still included in a discovery configuration.

DELETE FROM google.dlp.table_data_profiles
WHERE organizationsId = '{{ organizationsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND tableDataProfilesId = '{{ tableDataProfilesId }}' --required;