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

Name	Datatype	Description
name	string	The name of the profile.
configSnapshot	object	Snapshot of the configurations used to generate the profile.
createTime	string	The time at which the table was created.
dataRiskLevel	object	Score is a summary of all elements in the data profile. A higher number means more risk.
dataSourceType	object	Message used to identify the type of resource being profiled.
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.
encryptionStatus	string	How the table is encrypted.
expirationTime	string	Optional. The time when this table expires.
failedColumnCount	string	The number of columns skipped in the table because of an error.
fullResource	string	The resource name of the resource profiled. https://cloud.google.com/apis/design/resource_names#full_resource_name
lastModifiedTime	string	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	The last time the profile was generated.
profileStatus	object	Success or errors for the profile generation.
projectDataProfile	string	The resource name of the project data profile for this table.
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	Number of rows in the table when the profile was generated. This will not be populated for BigLake tables.
scannedColumnCount	string	The number of columns profiled in the table.
sensitivityScore	object	Score is calculated from of all elements in the data profile. A higher level means the data is more sensitive.
state	string	State of a profile.
tableId	string	If the resource is BigQuery, the BigQuery table ID.
tableSizeBytes	string	The size of the table when the profile was generated.

Methods

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

SELECT examples

Lists table data profiles for an organization.

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

DELETE example

Deletes the specified table_data_profiles resource.

/*+ delete */
DELETE FROM google.dlp.table_data_profiles
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND tableDataProfilesId = '{{ tableDataProfilesId }}';