AuditData

Stay organized with collections Save and categorize content based on your preferences.

BigQuery AuditData represents the older AuditData.serviceData log messages.

JSON representation
{
  "jobCompletedEvent": {
    object (JobCompletedEvent)
  },
  "tableDataReadEvents": [
    {
      object (TableDataReadEvent)
    }
  ],

  // Union field request can be only one of the following:
  "tableInsertRequest": {
    object (TableInsertRequest)
  },
  "tableUpdateRequest": {
    object (TableUpdateRequest)
  },
  "datasetListRequest": {
    object (DatasetListRequest)
  },
  "datasetInsertRequest": {
    object (DatasetInsertRequest)
  },
  "datasetUpdateRequest": {
    object (DatasetUpdateRequest)
  },
  "jobInsertRequest": {
    object (JobInsertRequest)
  },
  "jobQueryRequest": {
    object (JobQueryRequest)
  },
  "jobGetQueryResultsRequest": {
    object (JobGetQueryResultsRequest)
  },
  "tableDataListRequest": {
    object (TableDataListRequest)
  },
  "setIamPolicyRequest": {
    object (SetIamPolicyRequest)
  }
  // End of list of possible types for union field request.

  // Union field response can be only one of the following:
  "tableInsertResponse": {
    object (TableInsertResponse)
  },
  "tableUpdateResponse": {
    object (TableUpdateResponse)
  },
  "datasetInsertResponse": {
    object (DatasetInsertResponse)
  },
  "datasetUpdateResponse": {
    object (DatasetUpdateResponse)
  },
  "jobInsertResponse": {
    object (JobInsertResponse)
  },
  "jobQueryResponse": {
    object (JobQueryResponse)
  },
  "jobGetQueryResultsResponse": {
    object (JobGetQueryResultsResponse)
  },
  "jobQueryDoneResponse": {
    object (JobQueryDoneResponse)
  },
  "policyResponse": {
    object (Policy)
  }
  // End of list of possible types for union field response.
}
Fields
jobCompletedEvent

object (JobCompletedEvent)

A job completion event.

tableDataReadEvents[]

object (TableDataReadEvent)

Information about the table access events.

Union field request. Request data for each BigQuery method. request can be only one of the following:
tableInsertRequest

object (TableInsertRequest)

Table insert request.

tableUpdateRequest

object (TableUpdateRequest)

Table update request.

datasetListRequest

object (DatasetListRequest)

Dataset list request.

datasetInsertRequest

object (DatasetInsertRequest)

Dataset insert request.

datasetUpdateRequest

object (DatasetUpdateRequest)

Dataset update request.

jobInsertRequest

object (JobInsertRequest)

Job insert request.

jobQueryRequest

object (JobQueryRequest)

Job query request.

jobGetQueryResultsRequest

object (JobGetQueryResultsRequest)

Job get query results request.

tableDataListRequest

object (TableDataListRequest)

Table data-list request.

setIamPolicyRequest

object (SetIamPolicyRequest)

Iam policy request.

Union field response. Response data for each BigQuery method. response can be only one of the following:
tableInsertResponse

object (TableInsertResponse)

Table insert response.

tableUpdateResponse

object (TableUpdateResponse)

Table update response.

datasetInsertResponse

object (DatasetInsertResponse)

Dataset insert response.

datasetUpdateResponse

object (DatasetUpdateResponse)

Dataset update response.

jobInsertResponse

object (JobInsertResponse)

Job insert response.

jobQueryResponse

object (JobQueryResponse)

Job query response.

jobGetQueryResultsResponse

object (JobGetQueryResultsResponse)

Job get query results response.

jobQueryDoneResponse

object (JobQueryDoneResponse)

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

policyResponse

object (Policy)

Iam Policy.

TableInsertRequest

Table insert request.

JSON representation
{
  "resource": {
    object (Table)
  }
}
Fields
resource

object (Table)

The new table.

Table

Describes a BigQuery table. See the Table 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.

JSON representation
{
  "tableName": {
    object (TableName)
  },
  "info": {
    object (TableInfo)
  },
  "schemaJson": string,
  "view": {
    object (TableViewDefinition)
  },
  "expireTime": string,
  "createTime": string,
  "truncateTime": string,
  "updateTime": string,
  "encryption": {
    object (EncryptionInfo)
  }
}
Fields
tableName

object (TableName)

The name of the table.

info

object (TableInfo)

User-provided metadata for the table.

schemaJson

string

A JSON representation of the table's schema.

view

object (TableViewDefinition)

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

expireTime

string (Timestamp format)

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

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

createTime

string (Timestamp format)

The time the table was created.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

truncateTime

string (Timestamp format)

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

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

updateTime

string (Timestamp format)

The time the table was last modified.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

encryption

object (EncryptionInfo)

The table encryption information. Set when non-default encryption is used.

TableName

The fully-qualified name for a table.

JSON representation
{
  "projectId": string,
  "datasetId": string,
  "tableId": string
}
Fields
projectId

string

The project ID.

datasetId

string

The dataset ID within the project.

tableId

string

The table ID of the table within the dataset.

TableInfo

User-provided metadata for a table.

JSON representation
{
  "friendlyName": string,
  "description": string,
  "labels": {
    string: string,
    ...
  }
}
Fields
friendlyName

string

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

description

string

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

labels

map (key: string, value: string)

Labels provided for the table.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.

TableViewDefinition

Describes a virtual table defined by a SQL query.

JSON representation
{
  "query": string
}
Fields
query

string

SQL query defining the view.

EncryptionInfo

Describes encryption properties for a table or a job

JSON representation
{
  "kmsKeyName": string
}
Fields
kmsKeyName

string

unique identifier for cloud kms key

TableUpdateRequest

Table update request.

JSON representation
{
  "resource": {
    object (Table)
  }
}
Fields
resource

object (Table)

The table to be updated.

DatasetListRequest

Dataset list request.

JSON representation
{
  "listAll": boolean
}
Fields
listAll

boolean

Whether to list all datasets, including hidden ones.

DatasetInsertRequest

Dataset insert request.

JSON representation
{
  "resource": {
    object (Dataset)
  }
}
Fields
resource

object (Dataset)

The dataset to be inserted.

Dataset

BigQuery dataset information. See the Dataset API resource for more details on individual fields.

JSON representation
{
  "datasetName": {
    object (DatasetName)
  },
  "info": {
    object (DatasetInfo)
  },
  "createTime": string,
  "updateTime": string,
  "acl": {
    object (BigQueryAcl)
  },
  "defaultTableExpireDuration": string
}
Fields
datasetName

object (DatasetName)

The name of the dataset.

info

object (DatasetInfo)

User-provided metadata for the dataset.

createTime

string (Timestamp format)

The time the dataset was created.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

updateTime

string (Timestamp format)

The time the dataset was last modified.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

acl

object (BigQueryAcl)

The access control list for the dataset.

defaultTableExpireDuration

string (Duration format)

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.

A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".

DatasetName

The fully-qualified name for a dataset.

JSON representation
{
  "projectId": string,
  "datasetId": string
}
Fields
projectId

string

The project ID.

datasetId

string

The dataset ID within the project.

DatasetInfo

User-provided metadata for a dataset.

JSON representation
{
  "friendlyName": string,
  "description": string,
  "labels": {
    string: string,
    ...
  }
}
Fields
friendlyName

string

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

description

string

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

labels

map (key: string, value: string)

Labels provided for the dataset.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.

BigQueryAcl

An access control list.

JSON representation
{
  "entries": [
    {
      object (BigQueryAcl.Entry)
    }
  ]
}
Fields
entries[]

object (BigQueryAcl.Entry)

Access control entry list.

BigQueryAcl.Entry

Access control entry.

JSON representation
{
  "role": string,
  "groupEmail": string,
  "userEmail": string,
  "domain": string,
  "specialGroup": string,
  "viewName": {
    object (TableName)
  }
}
Fields
role

string

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

groupEmail

string

Grants access to a group identified by an email address.

userEmail

string

Grants access to a user identified by an email address.

domain

string

Grants access to all members of a domain.

specialGroup

string

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

viewName

object (TableName)

Grants access to a BigQuery View.

DatasetUpdateRequest

Dataset update request.

JSON representation
{
  "resource": {
    object (Dataset)
  }
}
Fields
resource

object (Dataset)

The dataset to be updated.

JobInsertRequest

Job insert request.

JSON representation
{
  "resource": {
    object (Job)
  }
}
Fields
resource

object (Job)

Job insert request.

Job

Describes a job.

JSON representation
{
  "jobName": {
    object (JobName)
  },
  "jobConfiguration": {
    object (JobConfiguration)
  },
  "jobStatus": {
    object (JobStatus)
  },
  "jobStatistics": {
    object (JobStatistics)
  }
}
Fields
jobName

object (JobName)

Job name.

jobConfiguration

object (JobConfiguration)

Job configuration.

jobStatus

object (JobStatus)

Job status.

jobStatistics

object (JobStatistics)

Job statistics.

JobName

The fully-qualified name for a job.

JSON representation
{
  "projectId": string,
  "jobId": string,
  "location": string
}
Fields
projectId

string

The project ID.

jobId

string

The job ID within the project.

location

string

The job location.

JobConfiguration

Job configuration information. See the Jobs API resource for more details on individual fields.

JSON representation
{
  "dryRun": boolean,
  "labels": {
    string: string,
    ...
  },

  // Union field configuration can be only one of the following:
  "query": {
    object (JobConfiguration.Query)
  },
  "load": {
    object (JobConfiguration.Load)
  },
  "extract": {
    object (JobConfiguration.Extract)
  },
  "tableCopy": {
    object (JobConfiguration.TableCopy)
  }
  // End of list of possible types for union field configuration.
}
Fields
dryRun

boolean

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

labels

map (key: string, value: string)

Labels provided for the job.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.

Union field configuration. Job configuration information. configuration can be only one of the following:
query

object (JobConfiguration.Query)

Query job information.

load

object (JobConfiguration.Load)

Load job information.

extract

object (JobConfiguration.Extract)

Extract job information.

tableCopy

object (JobConfiguration.TableCopy)

TableCopy job information.

JobConfiguration.Query

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

JSON representation
{
  "query": string,
  "destinationTable": {
    object (TableName)
  },
  "createDisposition": string,
  "writeDisposition": string,
  "defaultDataset": {
    object (DatasetName)
  },
  "tableDefinitions": [
    {
      object (TableDefinition)
    }
  ],
  "queryPriority": string,
  "destinationTableEncryption": {
    object (EncryptionInfo)
  },
  "statementType": string
}
Fields
query

string

The SQL query to run.

destinationTable

object (TableName)

The table where results are written.

createDisposition

string

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

writeDisposition

string

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

defaultDataset

object (DatasetName)

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

tableDefinitions[]

object (TableDefinition)

Describes data sources outside BigQuery, if needed.

queryPriority

string

Describes the priority given to the query: QUERY_INTERACTIVE or QUERY_BATCH.

destinationTableEncryption

object (EncryptionInfo)

Result table encryption information. Set when non-default encryption is used.

statementType

string

Type of the statement (e.g. SELECT, INSERT, CREATE_TABLE, CREATE_MODEL..)

TableDefinition

Describes an external data source used in a query.

JSON representation
{
  "name": string,
  "sourceUris": [
    string
  ]
}
Fields
name

string

Name of the table, used in queries.

sourceUris[]

string

Google Cloud Storage URIs for the data to be imported.

JobConfiguration.Load

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

JSON representation
{
  "sourceUris": [
    string
  ],
  "schemaJson": string,
  "destinationTable": {
    object (TableName)
  },
  "createDisposition": string,
  "writeDisposition": string,
  "destinationTableEncryption": {
    object (EncryptionInfo)
  }
}
Fields
sourceUris[]

string

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

schemaJson

string

The table schema in JSON format representation of a TableSchema.

destinationTable

object (TableName)

The table where the imported data is written.

createDisposition

string

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

writeDisposition

string

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

destinationTableEncryption

object (EncryptionInfo)

Result table encryption information. Set when non-default encryption is used.

JobConfiguration.Extract

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

JSON representation
{
  "destinationUris": [
    string
  ],
  "sourceTable": {
    object (TableName)
  }
}
Fields
destinationUris[]

string

Google Cloud Storage URIs where extracted data should be written.

sourceTable

object (TableName)

The source table.

JobConfiguration.TableCopy

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

JSON representation
{
  "sourceTables": [
    {
      object (TableName)
    }
  ],
  "destinationTable": {
    object (TableName)
  },
  "createDisposition": string,
  "writeDisposition": string,
  "destinationTableEncryption": {
    object (EncryptionInfo)
  }
}
Fields
sourceTables[]

object (TableName)

Source tables.

destinationTable

object (TableName)

Destination table.

createDisposition

string

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

writeDisposition

string

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

destinationTableEncryption

object (EncryptionInfo)

Result table encryption information. Set when non-default encryption is used.

JobStatus

Running state of a job.

JSON representation
{
  "state": string,
  "error": {
    object (Status)
  },
  "additionalErrors": [
    {
      object (Status)
    }
  ]
}
Fields
state

string

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

error

object (Status)

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

additionalErrors[]

object (Status)

Errors encountered during the running of the job. Do not necessarily mean that the job has completed or was unsuccessful.

JobStatistics

Job statistics that may change after a job starts.

JSON representation
{
  "createTime": string,
  "startTime": string,
  "endTime": string,
  "totalProcessedBytes": string,
  "totalBilledBytes": string,
  "billingTier": integer,
  "totalSlotMs": string,
  "reservationUsage": [
    {
      object (JobStatistics.ReservationResourceUsage)
    }
  ],
  "referencedTables": [
    {
      object (TableName)
    }
  ],
  "totalTablesProcessed": integer,
  "referencedViews": [
    {
      object (TableName)
    }
  ],
  "totalViewsProcessed": integer,
  "queryOutputRowCount": string,
  "totalLoadOutputBytes": string
}
Fields