dlp_jobs

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

Overview

Name	`dlp_jobs`
Type	Resource
Id	`google.dlp.dlp_jobs`

Fields

The following fields are returned by SELECT queries:

projects_locations_dlp_jobs_get
organizations_locations_dlp_jobs_list
projects_dlp_jobs_get
projects_locations_dlp_jobs_list
projects_dlp_jobs_list

Name	Datatype	Description
`name`	`string`	Output only. The server-assigned name.
`actionDetails`	`array`	Output only. Events that should occur after the job has completed.
`createTime`	`string (google-datetime)`	Output only. Time when the job was created.
`endTime`	`string (google-datetime)`	Output only. Time when the job finished.
`errors`	`array`	Output only. A stream of errors encountered running the job.
`inspectDetails`	`object`	Results from inspecting a data source. (id: GooglePrivacyDlpV2InspectDataSourceDetails)
`jobTriggerName`	`string`	Output only. If created by a job trigger, the resource name of the trigger that instantiated the job.
`lastModified`	`string (google-datetime)`	Output only. Time when the job was last modified by the system.
`riskDetails`	`object`	Results from analyzing risk of a data source. (id: GooglePrivacyDlpV2AnalyzeDataSourceRiskDetails)
`startTime`	`string (google-datetime)`	Output only. Time when the job started.
`state`	`string`	Output only. State of a job. (JOB_STATE_UNSPECIFIED, PENDING, RUNNING, DONE, CANCELED, FAILED, ACTIVE)
`type`	`string`	The type of job. (DLP_JOB_TYPE_UNSPECIFIED, INSPECT_JOB, RISK_ANALYSIS_JOB)

Name	Datatype	Description
`name`	`string`	Output only. The server-assigned name.
`actionDetails`	`array`	Output only. Events that should occur after the job has completed.
`createTime`	`string (google-datetime)`	Output only. Time when the job was created.
`endTime`	`string (google-datetime)`	Output only. Time when the job finished.
`errors`	`array`	Output only. A stream of errors encountered running the job.
`inspectDetails`	`object`	Results from inspecting a data source. (id: GooglePrivacyDlpV2InspectDataSourceDetails)
`jobTriggerName`	`string`	Output only. If created by a job trigger, the resource name of the trigger that instantiated the job.
`lastModified`	`string (google-datetime)`	Output only. Time when the job was last modified by the system.
`riskDetails`	`object`	Results from analyzing risk of a data source. (id: GooglePrivacyDlpV2AnalyzeDataSourceRiskDetails)
`startTime`	`string (google-datetime)`	Output only. Time when the job started.
`state`	`string`	Output only. State of a job. (JOB_STATE_UNSPECIFIED, PENDING, RUNNING, DONE, CANCELED, FAILED, ACTIVE)
`type`	`string`	The type of job. (DLP_JOB_TYPE_UNSPECIFIED, INSPECT_JOB, RISK_ANALYSIS_JOB)

Name	Datatype	Description
`name`	`string`	Output only. The server-assigned name.
`actionDetails`	`array`	Output only. Events that should occur after the job has completed.
`createTime`	`string (google-datetime)`	Output only. Time when the job was created.
`endTime`	`string (google-datetime)`	Output only. Time when the job finished.
`errors`	`array`	Output only. A stream of errors encountered running the job.
`inspectDetails`	`object`	Results from inspecting a data source. (id: GooglePrivacyDlpV2InspectDataSourceDetails)
`jobTriggerName`	`string`	Output only. If created by a job trigger, the resource name of the trigger that instantiated the job.
`lastModified`	`string (google-datetime)`	Output only. Time when the job was last modified by the system.
`riskDetails`	`object`	Results from analyzing risk of a data source. (id: GooglePrivacyDlpV2AnalyzeDataSourceRiskDetails)
`startTime`	`string (google-datetime)`	Output only. Time when the job started.
`state`	`string`	Output only. State of a job. (JOB_STATE_UNSPECIFIED, PENDING, RUNNING, DONE, CANCELED, FAILED, ACTIVE)
`type`	`string`	The type of job. (DLP_JOB_TYPE_UNSPECIFIED, INSPECT_JOB, RISK_ANALYSIS_JOB)

Name	Datatype	Description
`name`	`string`	Output only. The server-assigned name.
`actionDetails`	`array`	Output only. Events that should occur after the job has completed.
`createTime`	`string (google-datetime)`	Output only. Time when the job was created.
`endTime`	`string (google-datetime)`	Output only. Time when the job finished.
`errors`	`array`	Output only. A stream of errors encountered running the job.
`inspectDetails`	`object`	Results from inspecting a data source. (id: GooglePrivacyDlpV2InspectDataSourceDetails)
`jobTriggerName`	`string`	Output only. If created by a job trigger, the resource name of the trigger that instantiated the job.
`lastModified`	`string (google-datetime)`	Output only. Time when the job was last modified by the system.
`riskDetails`	`object`	Results from analyzing risk of a data source. (id: GooglePrivacyDlpV2AnalyzeDataSourceRiskDetails)
`startTime`	`string (google-datetime)`	Output only. Time when the job started.
`state`	`string`	Output only. State of a job. (JOB_STATE_UNSPECIFIED, PENDING, RUNNING, DONE, CANCELED, FAILED, ACTIVE)
`type`	`string`	The type of job. (DLP_JOB_TYPE_UNSPECIFIED, INSPECT_JOB, RISK_ANALYSIS_JOB)

Name	Datatype	Description
`name`	`string`	Output only. The server-assigned name.
`actionDetails`	`array`	Output only. Events that should occur after the job has completed.
`createTime`	`string (google-datetime)`	Output only. Time when the job was created.
`endTime`	`string (google-datetime)`	Output only. Time when the job finished.
`errors`	`array`	Output only. A stream of errors encountered running the job.
`inspectDetails`	`object`	Results from inspecting a data source. (id: GooglePrivacyDlpV2InspectDataSourceDetails)
`jobTriggerName`	`string`	Output only. If created by a job trigger, the resource name of the trigger that instantiated the job.
`lastModified`	`string (google-datetime)`	Output only. Time when the job was last modified by the system.
`riskDetails`	`object`	Results from analyzing risk of a data source. (id: GooglePrivacyDlpV2AnalyzeDataSourceRiskDetails)
`startTime`	`string (google-datetime)`	Output only. Time when the job started.
`state`	`string`	Output only. State of a job. (JOB_STATE_UNSPECIFIED, PENDING, RUNNING, DONE, CANCELED, FAILED, ACTIVE)
`type`	`string`	The type of job. (DLP_JOB_TYPE_UNSPECIFIED, INSPECT_JOB, RISK_ANALYSIS_JOB)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
`projects_locations_dlp_jobs_get`	`select`	`projectsId`, `locationsId`, `dlpJobsId`		Gets the latest state of a long-running DlpJob. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`organizations_locations_dlp_jobs_list`	`select`	`organizationsId`, `locationsId`	`filter`, `locationId`, `orderBy`, `pageSize`, `pageToken`, `type`	Lists DlpJobs that match the specified filter in the request. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`projects_dlp_jobs_get`	`select`	`projectsId`, `dlpJobsId`		Gets the latest state of a long-running DlpJob. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`projects_locations_dlp_jobs_list`	`select`	`projectsId`, `locationsId`	`filter`, `locationId`, `orderBy`, `pageSize`, `pageToken`, `type`	Lists DlpJobs that match the specified filter in the request. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`projects_dlp_jobs_list`	`select`	`projectsId`	`filter`, `locationId`, `orderBy`, `pageSize`, `pageToken`, `type`	Lists DlpJobs that match the specified filter in the request. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`projects_locations_dlp_jobs_create`	`insert`	`projectsId`, `locationsId`		Creates a new job to inspect storage or calculate risk metrics. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more. When no InfoTypes or CustomInfoTypes are specified in inspect jobs, the system will automatically choose what detectors to run. By default this may be all types, but may change over time as detectors are updated.
`projects_dlp_jobs_create`	`insert`	`projectsId`		Creates a new job to inspect storage or calculate risk metrics. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more. When no InfoTypes or CustomInfoTypes are specified in inspect jobs, the system will automatically choose what detectors to run. By default this may be all types, but may change over time as detectors are updated.
`projects_locations_dlp_jobs_delete`	`delete`	`projectsId`, `locationsId`, `dlpJobsId`		Deletes a long-running DlpJob. This method indicates that the client is no longer interested in the DlpJob result. The job will be canceled if possible. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`projects_dlp_jobs_delete`	`delete`	`projectsId`, `dlpJobsId`		Deletes a long-running DlpJob. This method indicates that the client is no longer interested in the DlpJob result. The job will be canceled if possible. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`projects_dlp_jobs_cancel`	`exec`	`projectsId`, `dlpJobsId`		Starts asynchronous cancellation on a long-running DlpJob. The server makes a best effort to cancel the DlpJob, but success is not guaranteed. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`projects_locations_dlp_jobs_cancel`	`exec`	`projectsId`, `locationsId`, `dlpJobsId`		Starts asynchronous cancellation on a long-running DlpJob. The server makes a best effort to cancel the DlpJob, but success is not guaranteed. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.
`projects_locations_dlp_jobs_finish`	`exec`	`projectsId`, `locationsId`, `dlpJobsId`		Finish a running hybrid DlpJob. Triggers the finalization steps and running of any enabled actions that have not yet run.
`projects_locations_dlp_jobs_hybrid_inspect`	`exec`	`projectsId`, `locationsId`, `dlpJobsId`		Inspect hybrid content and store findings to a job. To review the findings, inspect the job. Inspection will occur asynchronously.

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
`dlpJobsId`	`string`
`locationsId`	`string`
`organizationsId`	`string`
`projectsId`	`string`
`filter`	`string`
`locationId`	`string`
`orderBy`	`string`
`pageSize`	`integer (int32)`
`pageToken`	`string`
`type`	`string`

`SELECT` examples

projects_locations_dlp_jobs_get
organizations_locations_dlp_jobs_list
projects_dlp_jobs_get
projects_locations_dlp_jobs_list
projects_dlp_jobs_list

Gets the latest state of a long-running DlpJob. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.

SELECT
name,
actionDetails,
createTime,
endTime,
errors,
inspectDetails,
jobTriggerName,
lastModified,
riskDetails,
startTime,
state,
type
FROM google.dlp.dlp_jobs
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND dlpJobsId = '{{ dlpJobsId }}' -- required
;

Lists DlpJobs that match the specified filter in the request. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.

SELECT
name,
actionDetails,
createTime,
endTime,
errors,
inspectDetails,
jobTriggerName,
lastModified,
riskDetails,
startTime,
state,
type
FROM google.dlp.dlp_jobs
WHERE organizationsId = '{{ organizationsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND locationId = '{{ locationId }}'
AND orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND type = '{{ type }}'
;

SELECT
name,
actionDetails,
createTime,
endTime,
errors,
inspectDetails,
jobTriggerName,
lastModified,
riskDetails,
startTime,
state,
type
FROM google.dlp.dlp_jobs
WHERE projectsId = '{{ projectsId }}' -- required
AND dlpJobsId = '{{ dlpJobsId }}' -- required
;

SELECT
name,
actionDetails,
createTime,
endTime,
errors,
inspectDetails,
jobTriggerName,
lastModified,
riskDetails,
startTime,
state,
type
FROM google.dlp.dlp_jobs
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND locationId = '{{ locationId }}'
AND orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND type = '{{ type }}'
;

SELECT
name,
actionDetails,
createTime,
endTime,
errors,
inspectDetails,
jobTriggerName,
lastModified,
riskDetails,
startTime,
state,
type
FROM google.dlp.dlp_jobs
WHERE projectsId = '{{ projectsId }}' -- required
AND filter = '{{ filter }}'
AND locationId = '{{ locationId }}'
AND orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND type = '{{ type }}'
;

`INSERT` examples

projects_locations_dlp_jobs_create
projects_dlp_jobs_create
Manifest

Creates a new job to inspect storage or calculate risk metrics. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more. When no InfoTypes or CustomInfoTypes are specified in inspect jobs, the system will automatically choose what detectors to run. By default this may be all types, but may change over time as detectors are updated.

INSERT INTO google.dlp.dlp_jobs (
data__inspectJob,
data__jobId,
data__locationId,
data__riskJob,
projectsId,
locationsId
)
SELECT 
'{{ inspectJob }}',
'{{ jobId }}',
'{{ locationId }}',
'{{ riskJob }}',
'{{ projectsId }}',
'{{ locationsId }}'
RETURNING
name,
actionDetails,
createTime,
endTime,
errors,
inspectDetails,
jobTriggerName,
lastModified,
riskDetails,
startTime,
state,
type
;

INSERT INTO google.dlp.dlp_jobs (
data__inspectJob,
data__jobId,
data__locationId,
data__riskJob,
projectsId
)
SELECT 
'{{ inspectJob }}',
'{{ jobId }}',
'{{ locationId }}',
'{{ riskJob }}',
'{{ projectsId }}'
RETURNING
name,
actionDetails,
createTime,
endTime,
errors,
inspectDetails,
jobTriggerName,
lastModified,
riskDetails,
startTime,
state,
type
;

# Description fields are for documentation purposes
- name: dlp_jobs
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the dlp_jobs resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the dlp_jobs resource.
  - name: inspectJob
    description: |
      An inspection job scans a storage repository for InfoTypes.
    value:
      actions:
        - deidentify:
            cloudStorageOutput: "{{ cloudStorageOutput }}"
            fileTypesToTransform:
              - "{{ fileTypesToTransform }}"
            transformationConfig:
              deidentifyTemplate: "{{ deidentifyTemplate }}"
              imageRedactTemplate: "{{ imageRedactTemplate }}"
              structuredDeidentifyTemplate: "{{ structuredDeidentifyTemplate }}"
            transformationDetailsStorageConfig:
              table:
                datasetId: "{{ datasetId }}"
                projectId: "{{ projectId }}"
                tableId: "{{ tableId }}"
          jobNotificationEmails: "{{ jobNotificationEmails }}"
          pubSub:
            topic: "{{ topic }}"
          publishFindingsToCloudDataCatalog: "{{ publishFindingsToCloudDataCatalog }}"
          publishFindingsToDataplexCatalog: "{{ publishFindingsToDataplexCatalog }}"
          publishSummaryToCscc: "{{ publishSummaryToCscc }}"
          publishToStackdriver: "{{ publishToStackdriver }}"
          saveFindings:
            outputConfig:
              outputSchema: "{{ outputSchema }}"
              storagePath:
                path: "{{ path }}"
              table:
                datasetId: "{{ datasetId }}"
                projectId: "{{ projectId }}"
                tableId: "{{ tableId }}"
      inspectConfig:
        contentOptions:
          - "{{ contentOptions }}"
        customInfoTypes:
          - detectionRules: "{{ detectionRules }}"
            dictionary:
              cloudStoragePath:
                path: "{{ path }}"
              wordList:
                words: "{{ words }}"
            exclusionType: "{{ exclusionType }}"
            fileLabelInfoType:
              googleDriveLabel:
                labelFieldsToMatch: "{{ labelFieldsToMatch }}"
                labelId: "{{ labelId }}"
              sensitivityLabel:
                guid: "{{ guid }}"
            infoType:
              name: "{{ name }}"
              sensitivityScore:
                score: "{{ score }}"
              version: "{{ version }}"
            likelihood: "{{ likelihood }}"
            metadataKeyValueExpression:
              keyRegex: "{{ keyRegex }}"
              valueRegex: "{{ valueRegex }}"
            regex:
              groupIndexes:
                - {{ groupIndexes }}
              pattern: "{{ pattern }}"
            sensitivityScore:
              score: "{{ score }}"
            storedType:
              createTime: "{{ createTime }}"
              name: "{{ name }}"
            surrogateType: "{{ surrogateType }}"
        excludeInfoTypes: {{ excludeInfoTypes }}
        includeQuote: {{ includeQuote }}
        infoTypes:
          - name: "{{ name }}"
            sensitivityScore:
              score: "{{ score }}"
            version: "{{ version }}"
        limits:
          maxFindingsPerInfoType:
            - infoType:
                name: "{{ name }}"
                sensitivityScore: "{{ sensitivityScore }}"
                version: "{{ version }}"
              maxFindings: {{ maxFindings }}
          maxFindingsPerItem: {{ maxFindingsPerItem }}
          maxFindingsPerRequest: {{ maxFindingsPerRequest }}
        minLikelihood: "{{ minLikelihood }}"
        minLikelihoodPerInfoType:
          - infoType:
              name: "{{ name }}"
              sensitivityScore:
                score: "{{ score }}"
              version: "{{ version }}"
            minLikelihood: "{{ minLikelihood }}"
        ruleSet:
          - infoTypes: "{{ infoTypes }}"
            rules: "{{ rules }}"
      inspectTemplateName: "{{ inspectTemplateName }}"
      storageConfig:
        bigQueryOptions:
          excludedFields:
            - name: "{{ name }}"
          identifyingFields:
            - name: "{{ name }}"
          includedFields:
            - name: "{{ name }}"
          rowsLimit: "{{ rowsLimit }}"
          rowsLimitPercent: {{ rowsLimitPercent }}
          sampleMethod: "{{ sampleMethod }}"
          tableReference:
            datasetId: "{{ datasetId }}"
            projectId: "{{ projectId }}"
            tableId: "{{ tableId }}"
        cloudStorageOptions:
          bytesLimitPerFile: "{{ bytesLimitPerFile }}"
          bytesLimitPerFilePercent: {{ bytesLimitPerFilePercent }}
          fileSet:
            regexFileSet:
              bucketName: "{{ bucketName }}"
              excludeRegex: "{{ excludeRegex }}"
              includeRegex: "{{ includeRegex }}"
            url: "{{ url }}"
          fileTypes:
            - "{{ fileTypes }}"
          filesLimitPercent: {{ filesLimitPercent }}
          sampleMethod: "{{ sampleMethod }}"
        datastoreOptions:
          kind:
            name: "{{ name }}"
          partitionId:
            namespaceId: "{{ namespaceId }}"
            projectId: "{{ projectId }}"
        hybridOptions:
          description: "{{ description }}"
          labels: "{{ labels }}"
          requiredFindingLabelKeys:
            - "{{ requiredFindingLabelKeys }}"
          tableOptions:
            identifyingFields:
              - name: "{{ name }}"
        timespanConfig:
          enableAutoPopulationOfTimespanConfig: {{ enableAutoPopulationOfTimespanConfig }}
          endTime: "{{ endTime }}"
          startTime: "{{ startTime }}"
          timestampField:
            name: "{{ name }}"
  - name: jobId
    value: "{{ jobId }}"
    description: |
      The job id can contain uppercase and lowercase letters, numbers, and hyphens; that is, it must match the regular expression: `[a-zA-Zd-_]+`. The maximum length is 100 characters. Can be empty to allow the system to generate one.
  - name: locationId
    value: "{{ locationId }}"
    description: |
      Deprecated. This field has no effect.
  - name: riskJob
    description: |
      A risk analysis job calculates re-identification risk metrics for a BigQuery table.
    value:
      actions:
        - deidentify:
            cloudStorageOutput: "{{ cloudStorageOutput }}"
            fileTypesToTransform:
              - "{{ fileTypesToTransform }}"
            transformationConfig:
              deidentifyTemplate: "{{ deidentifyTemplate }}"
              imageRedactTemplate: "{{ imageRedactTemplate }}"
              structuredDeidentifyTemplate: "{{ structuredDeidentifyTemplate }}"
            transformationDetailsStorageConfig:
              table:
                datasetId: "{{ datasetId }}"
                projectId: "{{ projectId }}"
                tableId: "{{ tableId }}"
          jobNotificationEmails: "{{ jobNotificationEmails }}"
          pubSub:
            topic: "{{ topic }}"
          publishFindingsToCloudDataCatalog: "{{ publishFindingsToCloudDataCatalog }}"
          publishFindingsToDataplexCatalog: "{{ publishFindingsToDataplexCatalog }}"
          publishSummaryToCscc: "{{ publishSummaryToCscc }}"
          publishToStackdriver: "{{ publishToStackdriver }}"
          saveFindings:
            outputConfig:
              outputSchema: "{{ outputSchema }}"
              storagePath:
                path: "{{ path }}"
              table:
                datasetId: "{{ datasetId }}"
                projectId: "{{ projectId }}"
                tableId: "{{ tableId }}"
      privacyMetric:
        categoricalStatsConfig:
          field:
            name: "{{ name }}"
        deltaPresenceEstimationConfig:
          auxiliaryTables:
            - quasiIds: "{{ quasiIds }}"
              relativeFrequency:
                name: "{{ name }}"
              table:
                datasetId: "{{ datasetId }}"
                projectId: "{{ projectId }}"
                tableId: "{{ tableId }}"
          quasiIds:
            - customTag: "{{ customTag }}"
              field:
                name: "{{ name }}"
              inferred: "{{ inferred }}"
              infoType:
                name: "{{ name }}"
                sensitivityScore: "{{ sensitivityScore }}"
                version: "{{ version }}"
          regionCode: "{{ regionCode }}"
        kAnonymityConfig:
          entityId:
            field:
              name: "{{ name }}"
          quasiIds:
            - name: "{{ name }}"
        kMapEstimationConfig:
          auxiliaryTables:
            - quasiIds: "{{ quasiIds }}"
              relativeFrequency:
                name: "{{ name }}"
              table:
                datasetId: "{{ datasetId }}"
                projectId: "{{ projectId }}"
                tableId: "{{ tableId }}"
          quasiIds:
            - customTag: "{{ customTag }}"
              field:
                name: "{{ name }}"
              inferred: "{{ inferred }}"
              infoType:
                name: "{{ name }}"
                sensitivityScore: "{{ sensitivityScore }}"
                version: "{{ version }}"
          regionCode: "{{ regionCode }}"
        lDiversityConfig:
          quasiIds:
            - name: "{{ name }}"
          sensitiveAttribute:
            name: "{{ name }}"
        numericalStatsConfig:
          field:
            name: "{{ name }}"
      sourceTable:
        datasetId: "{{ datasetId }}"
        projectId: "{{ projectId }}"
        tableId: "{{ tableId }}"

`DELETE` examples

projects_locations_dlp_jobs_delete
projects_dlp_jobs_delete

Deletes a long-running DlpJob. This method indicates that the client is no longer interested in the DlpJob result. The job will be canceled if possible. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.

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

DELETE FROM google.dlp.dlp_jobs
WHERE projectsId = '{{ projectsId }}' --required
AND dlpJobsId = '{{ dlpJobsId }}' --required
;

Lifecycle Methods

projects_dlp_jobs_cancel
projects_locations_dlp_jobs_cancel
projects_locations_dlp_jobs_finish
projects_locations_dlp_jobs_hybrid_inspect

Starts asynchronous cancellation on a long-running DlpJob. The server makes a best effort to cancel the DlpJob, but success is not guaranteed. See https://docs.cloud.google.com/sensitive-data-protection/docs/inspecting-storage and https://docs.cloud.google.com/sensitive-data-protection/docs/compute-risk-analysis to learn more.

EXEC google.dlp.dlp_jobs.projects_dlp_jobs_cancel 
@projectsId='{{ projectsId }}' --required, 
@dlpJobsId='{{ dlpJobsId }}' --required
;

EXEC google.dlp.dlp_jobs.projects_locations_dlp_jobs_cancel 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@dlpJobsId='{{ dlpJobsId }}' --required
;

Finish a running hybrid DlpJob. Triggers the finalization steps and running of any enabled actions that have not yet run.

EXEC google.dlp.dlp_jobs.projects_locations_dlp_jobs_finish 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@dlpJobsId='{{ dlpJobsId }}' --required
;

Inspect hybrid content and store findings to a job. To review the findings, inspect the job. Inspection will occur asynchronously.

EXEC google.dlp.dlp_jobs.projects_locations_dlp_jobs_hybrid_inspect 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@dlpJobsId='{{ dlpJobsId }}' --required 
@@json=
'{
"hybridItem": "{{ hybridItem }}"
}'
;

Overview​

Fields​

Methods​

Parameters​

SELECT examples​

INSERT examples​

DELETE examples​

Lifecycle Methods​