package google.cloud.bigquery.logging.v1

Get desktop application:
View/edit binary Protocol Buffers messages

BigQuery request and response messages for audit log. Note: `Table.schema` has been deprecated in favor of `Table.schemaJson`. `Table.schema` may continue to be present in your logs during this transition.

• oneof request

  Request data for each BigQuery method.

  • TableInsertRequest table_insert_request = 1

    Table insert request.

  • TableUpdateRequest table_update_request = 16

    Table update request.

  • DatasetListRequest dataset_list_request = 2

    Dataset list request.

  • DatasetInsertRequest dataset_insert_request = 3

    Dataset insert request.

  • DatasetUpdateRequest dataset_update_request = 4

    Dataset update request.

  • JobInsertRequest job_insert_request = 5

    Job insert request.

  • JobQueryRequest job_query_request = 6

    Job query request.

  • JobGetQueryResultsRequest job_get_query_results_request = 7

    Job get query results request.

  • TableDataListRequest table_data_list_request = 8

    Table data-list request.

• oneof response

  Response data for each BigQuery method.

  • TableInsertResponse table_insert_response = 9

    Table insert response.

  • TableUpdateResponse table_update_response = 10

    Table update response.

  • DatasetInsertResponse dataset_insert_response = 11

    Dataset insert response.

  • DatasetUpdateResponse dataset_update_response = 12

    Dataset update response.

  • JobInsertResponse job_insert_response = 18

    Job insert response.

  • JobQueryResponse job_query_response = 13

    Job query response.

  • JobGetQueryResultsResponse job_get_query_results_response = 14

    Job get query results response.

  • JobQueryDoneResponse job_query_done_response = 15

    Deprecated: Job query-done response. Use this information for usage analysis.

• optional JobCompletedEvent job_completed_event = 17

  A job completion event.

An access control list.

Used in: Dataset

• repeated BigQueryAcl.Entry entries = 1

  Access control entry list.

Access control entry.

Used in: BigQueryAcl

• string role = 1

  The granted role, which can be `READER`, `WRITER`, or `OWNER`.

• string group_email = 2

  Grants access to a group identified by an email address.

• string user_email = 3

  Grants access to a user identified by an email address.

• string domain = 4

  Grants access to all members of a domain.

• string special_group = 5

  Grants access to special groups. Valid groups are `PROJECT_OWNERS`, `PROJECT_READERS`, `PROJECT_WRITERS` and `ALL_AUTHENTICATED_USERS`.

• optional TableName view_name = 6

  Grants access to a BigQuery View.

BigQuery dataset information. See the [Dataset](/bigquery/docs/reference/v2/datasets) API resource for more details on individual fields.

Used in: DatasetInsertRequest, DatasetInsertResponse, DatasetUpdateRequest, DatasetUpdateResponse

• optional DatasetName dataset_name = 1

  The name of the dataset.

• optional DatasetInfo info = 2

  User-provided metadata for the dataset.

• optional protobuf.Timestamp create_time = 4

  The time the dataset was created.

• optional protobuf.Timestamp update_time = 5

  The time the dataset was last modified.

• optional BigQueryAcl acl = 6

  The access control list for the dataset.

• optional protobuf.Duration default_table_expire_duration = 8

  If this field is present, each table that does not specify an expiration time is assigned an expiration time by adding this duration to the table's `createTime`. If this field is empty, there is no default table expiration time.

User-provided metadata for a dataset.

Used in: Dataset

• string friendly_name = 1

  A short name for the dataset, such as`"Analytics Data 2011"`.

• string description = 2

  A long description, perhaps several paragraphs, describing the dataset contents in detail.

Dataset insert request.

Used in: AuditData

• optional Dataset resource = 1

  The dataset to be inserted.

Dataset insert response.

Used in: AuditData

• optional Dataset resource = 1

  Final state of the inserted dataset.

Dataset list request.

Used in: AuditData

• bool list_all = 1

  Whether to list all datasets, including hidden ones.

The fully-qualified name for a dataset.

Used in: Dataset, JobConfiguration.Query, JobQueryRequest

• string project_id = 1

  The project ID.

• string dataset_id = 2

  The dataset ID within the project.

Dataset update request.

Used in: AuditData

• optional Dataset resource = 1

  The dataset to be updated.

Dataset update response.

Used in: AuditData

• optional Dataset resource = 1

  Final state of the updated dataset.

Describes a job.

Used in: JobCompletedEvent, JobGetQueryResultsResponse, JobInsertRequest, JobInsertResponse, JobQueryDoneResponse, JobQueryResponse

• optional JobName job_name = 1

  Job name.

• optional JobConfiguration job_configuration = 2

  Job configuration.

• optional JobStatus job_status = 3

  Job status.

• optional JobStatistics job_statistics = 4

  Job statistics.

Query job completed event.

Used in: AuditData

• string event_name = 1

  Name of the event.

• optional Job job = 2

  Job information.

Job configuration information. See the [Jobs](/bigquery/docs/reference/v2/jobs) API resource for more details on individual fields.

Used in: Job

• oneof configuration

  Job configuration information.

  • JobConfiguration.Query query = 5

    Query job information.

  • JobConfiguration.Load load = 6

    Load job information.

  • JobConfiguration.Extract extract = 7

    Extract job information.

  • JobConfiguration.TableCopy table_copy = 8

    TableCopy job information.

• bool dry_run = 9

  If true, don't actually run the job. Just check that it would run.

Describes an extract job, which exports data to an external source via the export pipeline.

Used in: JobConfiguration

• repeated string destination_uris = 1

  Google Cloud Storage URIs where extracted data should be written.

• optional TableName source_table = 2

  The source table.

Describes a load job, which loads data from an external source via the import pipeline.

Used in: JobConfiguration

• repeated string source_uris = 1

  URIs for the data to be imported. Only Google Cloud Storage URIs are supported.

• string schema_json = 6

  The table schema in JSON format representation of a TableSchema.

• optional TableName destination_table = 3

  The table where the imported data is written.

• string create_disposition = 4

  Describes when a job is allowed to create a table: `CREATE_IF_NEEDED`, `CREATE_NEVER`.

• string write_disposition = 5

  Describes how writes affect existing tables: `WRITE_TRUNCATE`, `WRITE_APPEND`, `WRITE_EMPTY`.

Describes a query job, which executes a SQL-like query.

Used in: JobConfiguration

• string query = 1

  The SQL query to run.

• optional TableName destination_table = 2

  The table where results are written.

• string create_disposition = 3

  Describes when a job is allowed to create a table: `CREATE_IF_NEEDED`, `CREATE_NEVER`.

• string write_disposition = 4

  Describes how writes affect existing tables: `WRITE_TRUNCATE`, `WRITE_APPEND`, `WRITE_EMPTY`.

• optional DatasetName default_dataset = 5

  If a table name is specified without a dataset in a query, this dataset will be added to table name.

• repeated TableDefinition table_definitions = 6

  Describes data sources outside BigQuery, if needed.

Describes a copy job, which copies an existing table to another table.

Used in: JobConfiguration

• repeated TableName source_tables = 1

  Source tables.

• optional TableName destination_table = 2

  Destination table.

• string create_disposition = 3

  Describes when a job is allowed to create a table: `CREATE_IF_NEEDED`, `CREATE_NEVER`.

• string write_disposition = 4

  Describes how writes affect existing tables: `WRITE_TRUNCATE`, `WRITE_APPEND`, `WRITE_EMPTY`.

Job getQueryResults request.

Used in: AuditData

• uint32 max_results = 1

  Maximum number of results to return.

• uint64 start_row = 2

  Zero-based row number at which to start.

Job getQueryResults response.

Used in: AuditData

• uint64 total_results = 1

  Total number of results in query results.

• optional Job job = 2

  The job that was created to run the query. It completed if `job.status.state` is `DONE`. It failed if `job.status.errorResult` is also present.

Job insert request.

Used in: AuditData

• optional Job resource = 1

  Job insert request.

Job insert response.

Used in: AuditData

• optional Job resource = 1

  Job insert response.

The fully-qualified name for a job.

Used in: Job

• string project_id = 1

  The project ID.

• string job_id = 2

  The job ID within the project.

Job getQueryDone response.

Used in: AuditData

• optional Job job = 1

  The job and status information. The job completed if `job.status.state` is `DONE`.

Job query request.

Used in: AuditData

• string query = 1

  The query.

• uint32 max_results = 2

  The maximum number of results.

• optional DatasetName default_dataset = 3

  The default dataset for tables that do not have a dataset specified.

• string project_id = 4

  Project that the query should be charged to.

• bool dry_run = 5

  If true, don't actually run the job. Just check that it would run.

Job query response.

Used in: AuditData

• uint64 total_results = 1

  The total number of rows in the full query result set.

• optional Job job = 2

  Information about the queried job.

Job statistics that may change after a job starts.

Used in: Job

• optional protobuf.Timestamp create_time = 1

  Time when the job was created.

• optional protobuf.Timestamp start_time = 2

  Time when the job started.

• optional protobuf.Timestamp end_time = 3

  Time when the job ended.

• int64 total_processed_bytes = 4

  Total bytes processed for a job.

• int64 total_billed_bytes = 5

  Processed bytes, adjusted by the job's CPU usage.

• int32 billing_tier = 7

  The tier assigned by CPU-based billing.

Running state of a job.

Used in: Job

• string state = 1

  State of a job: `PENDING`, `RUNNING`, or `DONE`.

• optional rpc.Status error = 2

  If the job did not complete successfully, this field describes why.

Describes a BigQuery table. See the [Table](/bigquery/docs/reference/v2/tables) API resource for more details on individual fields. Note: `Table.schema` has been deprecated in favor of `Table.schemaJson`. `Table.schema` may continue to be present in your logs during this transition.

Used in: TableInsertRequest, TableInsertResponse, TableUpdateRequest, TableUpdateResponse

• optional TableName table_name = 1

  The name of the table.

• optional TableInfo info = 2

  User-provided metadata for the table.

• string schema_json = 8

  A JSON representation of the table's schema.

• optional TableViewDefinition view = 4

  If present, this is a virtual table defined by a SQL query.

• optional protobuf.Timestamp expire_time = 5

  The expiration date for the table, after which the table is deleted and the storage reclaimed. If not present, the table persists indefinitely.

• optional protobuf.Timestamp create_time = 6

  The time the table was created.

• optional protobuf.Timestamp truncate_time = 7

  The time the table was last truncated by an operation with a `writeDisposition` of `WRITE_TRUNCATE`.

Table data-list request.

Used in: AuditData

• uint64 start_row = 1

  Starting row offset.

• uint32 max_results = 2

  Maximum number of results to return.

Describes an external data source used in a query.

Used in: JobConfiguration.Query

• string name = 1

  Name of the table, used in queries.

• repeated string source_uris = 2

  Google Cloud Storage URIs for the data to be imported.

User-provided metadata for a table.

Used in: Table

• string friendly_name = 1

  A short name for the table, such as`"Analytics Data - Jan 2011"`.

• string description = 2

  A long description, perhaps several paragraphs, describing the table contents in detail.

Table insert request.

Used in: AuditData

• optional Table resource = 1

  The new table.

Table insert response.

Used in: AuditData

• optional Table resource = 1

  Final state of the inserted table.

The fully-qualified name for a table.

Used in: BigQueryAcl.Entry, JobConfiguration.Extract, JobConfiguration.Load, JobConfiguration.Query, JobConfiguration.TableCopy, Table

• string project_id = 1

  The project ID.

• string dataset_id = 2

  The dataset ID within the project.

• string table_id = 3

  The table ID of the table within the dataset.

Table update request.

Used in: AuditData

• optional Table resource = 1

  The table to be updated.

Table update response.

Used in: AuditData

• optional Table resource = 1

  Final state of the updated table.

Describes a virtual table defined by a SQL query.

Used in: Table

• string query = 1

  SQL query defining the view.