Referência do conector do Google Workspace

info

Beta

Esse recurso está em Beta. Para usá-lo, um administrador do workspace deve ativar o Lakeflow Connect for Google Workspace na página Pré-visualizações . Consulte Gerenciar prévias do Databricks.

Esta página contém informações de referência para o conector gerenciado do Google Workspace, incluindo tabelas de origem e esquemas de tabela de destino compatíveis.

Tabelas de origem compatíveis

O conector do Google Workspace oferece suporte às seguintes tabelas de origem, todas sob o esquema de origem default. Cada tabela usa lw_id como sua key primária, é sincronizada incrementalmente e usa time como o campo de cursor.

nota

As tabelas gmail e drive contêm a atividade de auditoria do Admin SDK Reports para esses aplicativos, e não o conteúdo deles. Para ingerir conteúdos de caixa postal do Gmail ou arquivos do Google Drive, use o conector do Gmail ou o conector do Google Drive dedicados.

Tabela de origem	Descrição
`gmail`	Atividade de auditoria do Gmail.
`saml`	Atividade de auditoria SAML.
`token`	Atividade de auditoria de tokens OAuth.
`calendar`	Atividade de auditoria do Google Calendar.
`chat`	Atividade de auditoria do Google Chat.
`rules`	Atividade de auditoria de regras.
`meet`	Atividade de auditoria do Google Meet.
`chrome`	Atividade de auditoria do Chrome.
`context_aware_access`	Atividade de auditoria de acesso com reconhecimento de contexto.
`access_transparency`	Atividade de auditoria do Access Transparency.
`mobile`	Atividade de auditoria de dispositivo móvel.
`user_accounts`	Atividade de auditoria de account de usuário.
`gcp`	Atividade de auditoria do Google Cloud Platform.
`data_studio`	Atividade de auditoria do Looker Studio.
`classroom`	Atividade de auditoria do Google Classroom.
`keep`	Atividade de auditoria do Google Keep.
`meet_hardware`	Atividade de auditoria de hardware do Google Meet.
`admin`	Atividade de auditoria de administrador.
`ldap`	Atividade de auditoria do Secure LDAP.
`profile`	Perfil de atividade de auditoria.
`access_evaluation`	Atividade de auditoria de avaliação de acesso.
`assignments`	Atividade de auditoria de atribuições.
`contacts`	Atividade de auditoria de contatos.
`cloud_search`	Atividade de auditoria do Google Cloud Search.
`data_migration`	Atividade de auditoria de migração de dados.
`directory_sync`	Atividade de auditoria do Directory Sync.
`graduation`	Atividade de auditoria de graduação.
`vault`	Atividade de auditoria do Google Vault.
`gemini_in_workspace_apps`	Atividade de auditoria do Gemini nos aplicativos do Google Workspace.
`tasks`	Atividade de auditoria do Google Tasks.
`takeout`	Atividade de auditoria do Google Takeout.
`drive`	Atividade de auditoria do Google Drive.
`login`	Atividade de auditoria de login.
`groups`	Atividade de auditoria de Grupos do Google.
`groups_enterprise`	Atividade de auditoria do Google Groups Enterprise.

Tabela de origem	Descrição
`gmail`	Atividade de auditoria do Gmail.
`saml`	Atividade de auditoria SAML.
`token`	Atividade de auditoria de tokens OAuth.
`calendar`	Atividade de auditoria do Google Calendar.
`chat`	Atividade de auditoria do Google Chat.
`rules`	Atividade de auditoria de regras.
`meet`	Atividade de auditoria do Google Meet.
`chrome`	Atividade de auditoria do Chrome.
`context_aware_access`	Atividade de auditoria de acesso com reconhecimento de contexto.
`access_transparency`	Atividade de auditoria do Access Transparency.
`mobile`	Atividade de auditoria de dispositivo móvel.
`user_accounts`	Atividade de auditoria de account de usuário.
`gcp`	Atividade de auditoria do Google Cloud Platform.
`data_studio`	Atividade de auditoria do Looker Studio.
`classroom`	Atividade de auditoria do Google Classroom.
`keep`	Atividade de auditoria do Google Keep.
`meet_hardware`	Atividade de auditoria de hardware do Google Meet.
`admin`	Atividade de auditoria de administrador.
`ldap`	Atividade de auditoria do Secure LDAP.
`profile`	Perfil de atividade de auditoria.
`access_evaluation`	Atividade de auditoria de avaliação de acesso.
`assignments`	Atividade de auditoria de atribuições.
`contacts`	Atividade de auditoria de contatos.
`cloud_search`	Atividade de auditoria do Google Cloud Search.
`data_migration`	Atividade de auditoria de migração de dados.
`directory_sync`	Atividade de auditoria do Directory Sync.
`graduation`	Atividade de auditoria de graduação.
`vault`	Atividade de auditoria do Google Vault.
`gemini_in_workspace_apps`	Atividade de auditoria do Gemini nos aplicativos do Google Workspace.
`tasks`	Atividade de auditoria do Google Tasks.
`takeout`	Atividade de auditoria do Google Takeout.
`drive`	Atividade de auditoria do Google Drive.
`login`	Atividade de auditoria de login.
`groups`	Atividade de auditoria de Grupos do Google.
`groups_enterprise`	Atividade de auditoria do Google Groups Enterprise.

Todas as tabelas de destino usam liquid clustering na coluna time.

Esquemas de tabelas de destino

As seções a seguir descrevem o esquema de cada tabela de destino para a qual o conector do Google Workspace grava.

Cada linha é um registro de atividade da API Reports. Uma atividade pode conter vários eventos, que o conector armazena no array events em vez de dividi-los em linhas separadas. Para obter uma linha por evento, use explode(events).

`gmail`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`saml`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`token`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`calendar`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`chat`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`rules`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`meet`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`chrome`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`context_aware_access`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`access_transparency`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`mobile`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`user_accounts`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`gcp`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`data_studio`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`classroom`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`keep`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`meet_hardware`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`admin`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`ldap`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`profile`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`access_evaluation`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`assignments`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`contacts`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`cloud_search`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`data_migration`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`directory_sync`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`graduation`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`vault`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`gemini_in_workspace_apps`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`tasks`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`takeout`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`drive`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`login`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`groups`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

`groups_enterprise`

key primária : lw_id
Campo de cursor : time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`kind`	`STRING`
`etag`	`STRING`
`id`	`STRUCT<time: STRING, uniqueQualifier: STRING, applicationName: STRING, customerId: STRING>`
`actor`	`STRUCT<profileId: STRING, email: STRING, callerType: STRING, key: STRING, applicationInfo: STRUCT<oauthClientId: STRING, applicationName: STRING, impersonation: BOOLEAN>>`
`ownerDomain`	`STRING`
`ipAddress`	`STRING`
`isAgenticAction`	`BOOLEAN`
`networkInfo`	`STRUCT<ipAsn: ARRAY<INT>, regionCode: STRING, subdivisionCode: STRING>`
`events`	`ARRAY<STRUCT<type: STRING, name: STRING, status: STRING, resourceIds: ARRAY<STRING>, parameters: ARRAY<STRUCT<name: STRING, value: STRING, intValue: STRING, boolValue: BOOLEAN, multiValue: ARRAY<STRING>, multiIntValue: ARRAY<STRING>, multiBoolValue: ARRAY<BOOLEAN>, messageValue: VARIANT, multiMessageValue: VARIANT>>>>`
`userDeviceInfo`	`VARIANT`
`resourceDetails`	`VARIANT`

nota

Esta tabela não oferece suporte ao SCD tipo 2 porque possui colunas VARIANT.

Permissões do OAuth obrigatórias

O cliente OAuth deve conceder o seguinte escopo. Consulte a referência da API do Admin SDK Reports.

Permissão	Obrigatório para
`https://www.googleapis.com/auth/admin.reports.audit.readonly`	Todas as tabelas

Permissões de account do Google Workspace necessárias

A account do Google Workspace usada para ingestão deve ter as seguintes permissões.

Permissão	Obrigatório para
Privilégio de relatórios	Todas as tabelas
Privilégio Google Vault Access All Logs	`vault` tabela

Tabelas de origem compatíveis​

Esquemas de tabelas de destino​

gmail​

saml​

token​

calendar​

chat​

rules​

meet​

chrome​

context_aware_access​

access_transparency​

mobile​

user_accounts​

gcp​

data_studio​

classroom​

keep​

meet_hardware​

admin​

ldap​

profile​

access_evaluation​

assignments​

contacts​

cloud_search​

data_migration​

directory_sync​

graduation​

vault​

gemini_in_workspace_apps​

tasks​

takeout​

drive​

login​

groups​

groups_enterprise​

Permissões do OAuth obrigatórias​

Permissões de account do Google Workspace necessárias​

Tabelas de origem compatíveis

Esquemas de tabelas de destino

`gmail`

`saml`

`token`

`calendar`

`chat`

`rules`

`meet`

`chrome`

`context_aware_access`

`access_transparency`

`mobile`

`user_accounts`

`gcp`

`data_studio`

`classroom`

`keep`

`meet_hardware`

`admin`

`ldap`

`profile`

`access_evaluation`

`assignments`

`contacts`

`cloud_search`

`data_migration`

`directory_sync`

`graduation`

`vault`

`gemini_in_workspace_apps`

`tasks`

`takeout`

`drive`

`login`

`groups`

`groups_enterprise`

Permissões do OAuth obrigatórias

Permissões de account do Google Workspace necessárias