column_data_profiles

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

Overview

Name	column_data_profiles
Type	Resource
Id	google.dlp.column_data_profiles

Fields

Name	Datatype	Description
name	string	The name of the profile.
column	string	The name of the column.
columnInfoType	object	The infoType details for this column.
columnType	string	The data type of a given column.
dataRiskLevel	object	Score is a summary of all elements in the data profile. A higher number means more risk.
datasetId	string	The BigQuery dataset ID.
datasetLocation	string	The BigQuery 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 profiled resource.
estimatedNullPercentage	string	Approximate percentage of entries being null in the column.
estimatedUniquenessScore	string	Approximate uniqueness of the column.
freeTextScore	number	The likelihood that this column contains free-form text. A value close to 1 may indicate the column is likely to contain free-form or natural language text. Range in 0-1.
otherMatches	array	Other types found within this column. List will be unordered.
policyState	string	Indicates if a policy tag has been applied to the column.
profileLastGenerated	string	The last time the profile was generated.
profileStatus	object	Success or errors for the profile generation.
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.
tableDataProfile	string	The resource name of the table data profile.
tableFullResource	string	The resource name of the resource this column is within.
tableId	string	The BigQuery table ID.

Methods

Name	Accessible by	Required Params	Description
organizations_locations_column_data_profiles_get	SELECT	columnDataProfilesId, locationsId, organizationsId	Gets a column data profile.
organizations_locations_column_data_profiles_list	SELECT	locationsId, organizationsId	Lists column data profiles for an organization.
projects_locations_column_data_profiles_get	SELECT	columnDataProfilesId, locationsId, projectsId	Gets a column data profile.
projects_locations_column_data_profiles_list	SELECT	locationsId, projectsId	Lists column data profiles for an organization.

SELECT examples

Lists column data profiles for an organization.

SELECT
name,
column,
columnInfoType,
columnType,
dataRiskLevel,
datasetId,
datasetLocation,
datasetProjectId,
estimatedNullPercentage,
estimatedUniquenessScore,
freeTextScore,
otherMatches,
policyState,
profileLastGenerated,
profileStatus,
sensitivityScore,
state,
tableDataProfile,
tableFullResource,
tableId
FROM google.dlp.column_data_profiles
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';