big_query_exports

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

Overview

Name	big_query_exports
Type	Resource
Id	google.securitycenter.big_query_exports

Fields

Name	Datatype	Description
name	string	The relative resource name of this export. See: https://cloud.google.com/apis/design/resource_names#relative_resource_name. Example format: "organizations/{organization_id}/bigQueryExports/{export_id}" Example format: "folders/{folder_id}/bigQueryExports/{export_id}" Example format: "projects/{project_id}/bigQueryExports/{export_id}" This field is provided in responses, and is ignored when provided in create requests.
description	string	The description of the export (max of 1024 characters).
createTime	string	Output only. The time at which the BigQuery export was created. This field is set by the server and will be ignored if provided on export on creation.
dataset	string	The dataset to write findings' updates to. Its format is "projects/[project_id]/datasets/[bigquery_dataset_id]". BigQuery Dataset unique ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_).
filter	string	Expression that defines the filter to apply across create/update events of findings. The expression is a list of zero or more restrictions combined via logical operators AND and OR. Parentheses are supported, and OR has higher precedence than AND. Restrictions have the form and may have a - character in front of them to indicate negation. The fields map to those defined in the corresponding resource. The supported operators are: = for all value types. >, <, >=, <= for integer values. :, meaning substring matching, for strings. The supported value types are: string literals in quotes. integer literals without quotes. boolean literals true and false without quotes.
mostRecentEditor	string	Output only. Email address of the user who last edited the BigQuery export. This field is set by the server and will be ignored if provided on export creation or update.
principal	string	Output only. The service account that needs permission to create table and upload data to the BigQuery dataset.
updateTime	string	Output only. The most recent time at which the BigQuery export was updated. This field is set by the server and will be ignored if provided on export creation or update.

Methods

Name	Accessible by	Required Params	Description
folders_big_query_exports_get	SELECT	bigQueryExportsId, foldersId	Gets a BigQuery export.
folders_big_query_exports_list	SELECT	foldersId	Lists BigQuery exports. Note that when requesting BigQuery exports at a given level all exports under that level are also returned e.g. if requesting BigQuery exports under a folder, then all BigQuery exports immediately under the folder plus the ones created under the projects within the folder are returned.
organizations_big_query_exports_get	SELECT	bigQueryExportsId, organizationsId	Gets a BigQuery export.
organizations_big_query_exports_list	SELECT	organizationsId	Lists BigQuery exports. Note that when requesting BigQuery exports at a given level all exports under that level are also returned e.g. if requesting BigQuery exports under a folder, then all BigQuery exports immediately under the folder plus the ones created under the projects within the folder are returned.
projects_big_query_exports_get	SELECT	bigQueryExportsId, projectsId	Gets a BigQuery export.
projects_big_query_exports_list	SELECT	projectsId	Lists BigQuery exports. Note that when requesting BigQuery exports at a given level all exports under that level are also returned e.g. if requesting BigQuery exports under a folder, then all BigQuery exports immediately under the folder plus the ones created under the projects within the folder are returned.
folders_big_query_exports_create	INSERT	foldersId	Creates a BigQuery export.
organizations_big_query_exports_create	INSERT	organizationsId	Creates a BigQuery export.
projects_big_query_exports_create	INSERT	projectsId	Creates a BigQuery export.
folders_big_query_exports_delete	DELETE	bigQueryExportsId, foldersId	Deletes an existing BigQuery export.
organizations_big_query_exports_delete	DELETE	bigQueryExportsId, organizationsId	Deletes an existing BigQuery export.
projects_big_query_exports_delete	DELETE	bigQueryExportsId, projectsId	Deletes an existing BigQuery export.
folders_big_query_exports_patch	UPDATE	bigQueryExportsId, foldersId	Updates a BigQuery export.
organizations_big_query_exports_patch	UPDATE	bigQueryExportsId, organizationsId	Updates a BigQuery export.
projects_big_query_exports_patch	UPDATE	bigQueryExportsId, projectsId	Updates a BigQuery export.

SELECT examples

Lists BigQuery exports. Note that when requesting BigQuery exports at a given level all exports under that level are also returned e.g. if requesting BigQuery exports under a folder, then all BigQuery exports immediately under the folder plus the ones created under the projects within the folder are returned.

SELECT
name,
description,
createTime,
dataset,
filter,
mostRecentEditor,
principal,
updateTime
FROM google.securitycenter.big_query_exports
WHERE foldersId = '{{ foldersId }}';

INSERT example

Use the following StackQL query and manifest file to create a new big_query_exports resource.

All Properties

/*+ create */
INSERT INTO google.securitycenter.big_query_exports (
foldersId,
name,
description,
filter,
dataset
)
SELECT 
'{{ foldersId }}',
'{{ name }}',
'{{ description }}',
'{{ filter }}',
'{{ dataset }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: description
      value: string
    - name: filter
      value: string
    - name: dataset
      value: string
    - name: createTime
      value: string
    - name: updateTime
      value: string
    - name: mostRecentEditor
      value: string
    - name: principal
      value: string

UPDATE example

Updates a big_query_exports resource.

/*+ update */
UPDATE google.securitycenter.big_query_exports
SET 
name = '{{ name }}',
description = '{{ description }}',
filter = '{{ filter }}',
dataset = '{{ dataset }}'
WHERE 
bigQueryExportsId = '{{ bigQueryExportsId }}'
AND foldersId = '{{ foldersId }}';

DELETE example

Deletes the specified big_query_exports resource.

/*+ delete */
DELETE FROM google.securitycenter.big_query_exports
WHERE bigQueryExportsId = '{{ bigQueryExportsId }}'
AND foldersId = '{{ foldersId }}';