Referência do conector do Asana

info

Beta

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

O conector gerenciado do Asana no Lakeflow Connect oferece suporte a 24 tabelas de origem no esquema default. Todas as tabelas usam refresh completa, portanto, cada atualização de pipeline ingere novamente cada registro.

Tabelas de origem suportadas

O conector Asana oferece suporte às seguintes tabelas de origem, todas no esquema de origem default:

Tabela de origem	Chave primária	Descrição	Modo de sincronização	Campo do cursor
workspaces	gid	Workspaces e organizações aos quais o usuário autorizador pertence.	Refresh completo apenas
users	workspace_gid, gid	Usuários em cada Workspace, incluindo endereços de email e fotos de perfil.	Refresh completo apenas
teams	workspace_gid, gid	Equipes em cada organização, incluindo suas descrições e configurações de acesso.	Refresh completo apenas
team_memberships	team_gid, gid	Associações de usuários em cada equipe.	Refresh completo apenas
projects	team_gid, gid	Projetos em cada equipe, incluindo status, datas, proprietários e membros.	Refresh completo apenas
sections	project_gid, gid	Seções em cada projeto.	Refresh completo apenas
tasks	section_gid, gid	Tarefas em cada seção do projeto, incluindo responsáveis, datas, associações e valores de campo personalizados.	Refresh completo apenas
stories	section_gid, task_gid, gid	Históricos de cada tarefa, incluindo comentários e atividades, como alterações de campo.	Refresh completo apenas
tags	workspace_gid, gid	Tags em cada workspace.	Refresh completo apenas
custom_fields	workspace_gid, gid	Definições de campo personalizadas em cada workspace.	Refresh completo apenas
task_attachments	section_gid, task_gid, gid	Anexos em cada tarefa.	Refresh completo apenas
portfolios	workspace_gid, gid	Portfólios que o usuário autorizador possui em cada workspace.	Refresh completo apenas
portfolio_memberships	portfolio_gid, gid	Associações de usuários em cada portfólio que o usuário autorizador possui.	Refresh completo apenas
portfolio_items	portfolio_gid, gid	Itens em cada portfólio que o usuário autorizador possui.	Refresh completo apenas
project_memberships	project_gid, gid	Associações de usuários e equipes em cada projeto.	Refresh completo apenas
custom_field_settings	project_gid, gid	Campos personalizados associados a cada projeto.	Refresh completo apenas
project_status_updates	project_gid, gid	Atualizações de status sobre cada projeto.	Refresh completo apenas
portfolio_status_updates	portfolio_gid, gid	Atualizações de status em cada portfólio de propriedade do usuário que autoriza.	Refresh completo apenas
goal_status_updates	goal_gid, gid	Atualizações de status de cada objetivo.	Refresh completo apenas
workspace_memberships	workspace_gid, gid	Associações de usuários em cada workspace.	Refresh completo apenas
goals	workspace_gid, gid	Metas em cada workspace.	Refresh completo apenas
goal_relationships	goal_gid, gid	Relações entre cada objetivo e os projetos, portfólios ou objetivos que o apoiam.	Refresh completo apenas
time_tracking_entries	section_gid, task_gid, gid	Entradas de acompanhamento de tempo em cada tarefa.	Refresh completo apenas
project_attachments	project_gid, gid	Anexos em cada projeto.	Refresh completo apenas

Tabela de origem	Chave primária	Descrição	Modo de sincronização	Campo do cursor
workspaces	gid	Workspaces e organizações aos quais o usuário autorizador pertence.	Refresh completo apenas
users	workspace_gid, gid	Usuários em cada Workspace, incluindo endereços de email e fotos de perfil.	Refresh completo apenas
teams	workspace_gid, gid	Equipes em cada organização, incluindo suas descrições e configurações de acesso.	Refresh completo apenas
team_memberships	team_gid, gid	Associações de usuários em cada equipe.	Refresh completo apenas
projects	team_gid, gid	Projetos em cada equipe, incluindo status, datas, proprietários e membros.	Refresh completo apenas
sections	project_gid, gid	Seções em cada projeto.	Refresh completo apenas
tasks	section_gid, gid	Tarefas em cada seção do projeto, incluindo responsáveis, datas, associações e valores de campo personalizados.	Refresh completo apenas
stories	section_gid, task_gid, gid	Históricos de cada tarefa, incluindo comentários e atividades, como alterações de campo.	Refresh completo apenas
tags	workspace_gid, gid	Tags em cada workspace.	Refresh completo apenas
custom_fields	workspace_gid, gid	Definições de campo personalizadas em cada workspace.	Refresh completo apenas
task_attachments	section_gid, task_gid, gid	Anexos em cada tarefa.	Refresh completo apenas
portfolios	workspace_gid, gid	Portfólios que o usuário autorizador possui em cada workspace.	Refresh completo apenas
portfolio_memberships	portfolio_gid, gid	Associações de usuários em cada portfólio que o usuário autorizador possui.	Refresh completo apenas
portfolio_items	portfolio_gid, gid	Itens em cada portfólio que o usuário autorizador possui.	Refresh completo apenas
project_memberships	project_gid, gid	Associações de usuários e equipes em cada projeto.	Refresh completo apenas
custom_field_settings	project_gid, gid	Campos personalizados associados a cada projeto.	Refresh completo apenas
project_status_updates	project_gid, gid	Atualizações de status sobre cada projeto.	Refresh completo apenas
portfolio_status_updates	portfolio_gid, gid	Atualizações de status em cada portfólio de propriedade do usuário que autoriza.	Refresh completo apenas
goal_status_updates	goal_gid, gid	Atualizações de status de cada objetivo.	Refresh completo apenas
workspace_memberships	workspace_gid, gid	Associações de usuários em cada workspace.	Refresh completo apenas
goals	workspace_gid, gid	Metas em cada workspace.	Refresh completo apenas
goal_relationships	goal_gid, gid	Relações entre cada objetivo e os projetos, portfólios ou objetivos que o apoiam.	Refresh completo apenas
time_tracking_entries	section_gid, task_gid, gid	Entradas de acompanhamento de tempo em cada tarefa.	Refresh completo apenas
project_attachments	project_gid, gid	Anexos em cada projeto.	Refresh completo apenas

Opções do conector

O conector Asana não tem opções de configuração adicionais além das configurações de pipeline disponíveis para todos os conectores gerenciados. Consulte Ingerir dados do Asana.

Esquemas de tabelas de destino

workspaces

Primary key: gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
email_domains	ARRAY<STRING>
is_organization	BOOLEAN

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
email_domains	ARRAY<STRING>
is_organization	BOOLEAN

users

key primária: workspace_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
custom_fields	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
email	STRING
photo	STRUCT<image_21x21: STRING, image_27x27: STRING, image_36x36: STRING, image_60x60: STRING, image_128x128: STRING, image_1024x1024: STRING>
workspaces	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
workspace_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
custom_fields	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
email	STRING
photo	STRUCT<image_21x21: STRING, image_27x27: STRING, image_36x36: STRING, image_60x60: STRING, image_128x128: STRING, image_1024x1024: STRING>
workspaces	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
workspace_gid	STRING

teams

key primária: workspace_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
custom_field_settings	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
description	STRING
edit_team_name_or_description_access_level	STRING
edit_team_visibility_or_trash_team_access_level	STRING
endorsed	BOOLEAN
guest_invite_management_access_level	STRING
html_description	STRING
join_request_management_access_level	STRING
member_invite_management_access_level	STRING
organization	STRUCT<gid: STRING, resource_type: STRING>
permalink_url	STRING
team_content_management_access_level	STRING
team_member_removal_access_level	STRING
visibility	STRING
workspace_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
custom_field_settings	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
description	STRING
edit_team_name_or_description_access_level	STRING
edit_team_visibility_or_trash_team_access_level	STRING
endorsed	BOOLEAN
guest_invite_management_access_level	STRING
html_description	STRING
join_request_management_access_level	STRING
member_invite_management_access_level	STRING
organization	STRUCT<gid: STRING, resource_type: STRING>
permalink_url	STRING
team_content_management_access_level	STRING
team_member_removal_access_level	STRING
visibility	STRING
workspace_gid	STRING

team_memberships

key primária: team_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
is_admin	BOOLEAN
is_guest	BOOLEAN
is_limited_access	BOOLEAN
team	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
user	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
team_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
is_admin	BOOLEAN
is_guest	BOOLEAN
is_limited_access	BOOLEAN
team	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
user	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
team_gid	STRING

projects

key primária: team_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
archived	BOOLEAN
color	STRING
completed	BOOLEAN
completed_at	TIMESTAMP
completed_by	STRUCT<gid: STRING, resource_type: STRING>
created_at	TIMESTAMP
created_from_template	STRUCT<gid: STRING, resource_type: STRING>
current_status	STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>
current_status_update	STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type	STRUCT<gid: STRING, resource_type: STRING>
default_access_level	STRING
default_view	STRING
is_template	BOOLEAN
due_date	DATE
due_on	DATE
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
html_notes	STRING
icon	STRING
members	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
minimum_access_level_for_customization	STRING
minimum_access_level_for_sharing	STRING
modified_at	TIMESTAMP
notes	STRING
owner	STRUCT<gid: STRING, resource_type: STRING>
permalink_url	STRING
privacy_setting	STRING
project_brief	STRUCT<gid: STRING, resource_type: STRING>
public	BOOLEAN
resource_subtype	STRING
start_on	DATE
team	STRUCT<gid: STRING, resource_type: STRING>
workspace	STRUCT<gid: STRING, resource_type: STRING>
team_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
archived	BOOLEAN
color	STRING
completed	BOOLEAN
completed_at	TIMESTAMP
completed_by	STRUCT<gid: STRING, resource_type: STRING>
created_at	TIMESTAMP
created_from_template	STRUCT<gid: STRING, resource_type: STRING>
current_status	STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>
current_status_update	STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type	STRUCT<gid: STRING, resource_type: STRING>
default_access_level	STRING
default_view	STRING
is_template	BOOLEAN
due_date	DATE
due_on	DATE
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
html_notes	STRING
icon	STRING
members	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
minimum_access_level_for_customization	STRING
minimum_access_level_for_sharing	STRING
modified_at	TIMESTAMP
notes	STRING
owner	STRUCT<gid: STRING, resource_type: STRING>
permalink_url	STRING
privacy_setting	STRING
project_brief	STRUCT<gid: STRING, resource_type: STRING>
public	BOOLEAN
resource_subtype	STRING
start_on	DATE
team	STRUCT<gid: STRING, resource_type: STRING>
workspace	STRUCT<gid: STRING, resource_type: STRING>
team_gid	STRING

sections

key primária: project_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
created_at	TIMESTAMP
project	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
projects	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
project_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
created_at	TIMESTAMP
project	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
projects	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
project_gid	STRING

tasks

key primária: section_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
actual_time_minutes	DOUBLE
approval_status	STRING
assigned_by	STRUCT<gid: STRING, resource_type: STRING>
assignee	STRUCT<gid: STRING, resource_type: STRING>
assignee_section	STRUCT<gid: STRING, resource_type: STRING>
assignee_status	STRING
completed	BOOLEAN
completed_at	TIMESTAMP
completed_by	STRUCT<gid: STRING, resource_type: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING>
custom_fields	VARIANT
custom_type	STRUCT<gid: STRING, resource_type: STRING>
custom_type_status_option	STRUCT<gid: STRING, resource_type: STRING>
dependencies	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
dependents	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
due_at	TIMESTAMP
due_on	DATE
effective_memberships	VARIANT
external	STRUCT<gid: STRING, data: STRING>
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_notes	STRING
is_rendered_as_separator	BOOLEAN
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
memberships	VARIANT
modified_at	TIMESTAMP
notes	STRING
num_hearts	BIGINT
num_likes	BIGINT
num_subtasks	BIGINT
parent	STRUCT<gid: STRING, resource_type: STRING>
permalink_url	STRING
projects	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
resource_subtype	STRING
start_at	TIMESTAMP
start_on	DATE
tags	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
workspace	STRUCT<gid: STRING, resource_type: STRING>
project_gid	STRING
section_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
actual_time_minutes	DOUBLE
approval_status	STRING
assigned_by	STRUCT<gid: STRING, resource_type: STRING>
assignee	STRUCT<gid: STRING, resource_type: STRING>
assignee_section	STRUCT<gid: STRING, resource_type: STRING>
assignee_status	STRING
completed	BOOLEAN
completed_at	TIMESTAMP
completed_by	STRUCT<gid: STRING, resource_type: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING>
custom_fields	VARIANT
custom_type	STRUCT<gid: STRING, resource_type: STRING>
custom_type_status_option	STRUCT<gid: STRING, resource_type: STRING>
dependencies	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
dependents	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
due_at	TIMESTAMP
due_on	DATE
effective_memberships	VARIANT
external	STRUCT<gid: STRING, data: STRING>
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_notes	STRING
is_rendered_as_separator	BOOLEAN
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
memberships	VARIANT
modified_at	TIMESTAMP
notes	STRING
num_hearts	BIGINT
num_likes	BIGINT
num_subtasks	BIGINT
parent	STRUCT<gid: STRING, resource_type: STRING>
permalink_url	STRING
projects	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
resource_subtype	STRING
start_at	TIMESTAMP
start_on	DATE
tags	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
workspace	STRUCT<gid: STRING, resource_type: STRING>
project_gid	STRING
section_gid	STRING

stories

Primary key: section_gid, task_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
assignee	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
custom_field	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
dependency	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
duplicate_of	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
duplicated_from	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
follower	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text	STRING
is_editable	BOOLEAN
is_edited	BOOLEAN
is_pinned	BOOLEAN
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
new_approval_status	STRING
new_date_value	VARIANT
new_dates	VARIANT
new_enum_value	VARIANT
new_multi_enum_values	VARIANT
new_name	STRING
new_number_value	BIGINT
new_people_value	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
new_resource_subtype	STRING
new_section	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
new_text_value	STRING
num_hearts	BIGINT
num_likes	BIGINT
old_approval_status	STRING
old_date_value	VARIANT
old_dates	VARIANT
old_enum_value	VARIANT
old_multi_enum_values	VARIANT
old_name	STRING
old_number_value	BIGINT
old_people_value	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
old_resource_subtype	STRING
old_section	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
old_text_value	STRING
previews	VARIANT
project	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
reaction_summary	ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype	STRING
source	STRING
sticker_name	STRING
story	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
tag	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
target	STRUCT<gid: STRING, resource_type: STRING>
task	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
text	STRING
type	STRING
section_gid	STRING
task_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
assignee	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
custom_field	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
dependency	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
duplicate_of	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
duplicated_from	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
follower	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text	STRING
is_editable	BOOLEAN
is_edited	BOOLEAN
is_pinned	BOOLEAN
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
new_approval_status	STRING
new_date_value	VARIANT
new_dates	VARIANT
new_enum_value	VARIANT
new_multi_enum_values	VARIANT
new_name	STRING
new_number_value	BIGINT
new_people_value	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
new_resource_subtype	STRING
new_section	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
new_text_value	STRING
num_hearts	BIGINT
num_likes	BIGINT
old_approval_status	STRING
old_date_value	VARIANT
old_dates	VARIANT
old_enum_value	VARIANT
old_multi_enum_values	VARIANT
old_name	STRING
old_number_value	BIGINT
old_people_value	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
old_resource_subtype	STRING
old_section	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
old_text_value	STRING
previews	VARIANT
project	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
reaction_summary	ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype	STRING
source	STRING
sticker_name	STRING
story	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
tag	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
target	STRUCT<gid: STRING, resource_type: STRING>
task	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
text	STRING
type	STRING
section_gid	STRING
task_gid	STRING

tags

key primária: workspace_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
color	STRING
created_at	TIMESTAMP
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
notes	STRING
permalink_url	STRING
workspace	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
workspace_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
color	STRING
created_at	TIMESTAMP
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
notes	STRING
permalink_url	STRING
workspace	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
workspace_gid	STRING

custom_fields

key primária: workspace_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
asana_created_field	STRING
created_by	STRUCT<gid: STRING, resource_type: STRING>
currency_code	STRING
custom_label	STRING
custom_label_position	STRING
date_value	STRUCT<date: STRING, date_time: STRING>
default_access_level	STRING
description	STRING
display_value	STRING
enabled	BOOLEAN
enum_options	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>
enum_value	STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>
format	STRING
has_notifications_enabled	BOOLEAN
html_text_value	STRING
id_prefix	STRING
input_restrictions	ARRAY<STRING>
is_formula_field	BOOLEAN
is_global_to_workspace	BOOLEAN
is_value_read_only	BOOLEAN
multi_enum_values	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>
number_value	DOUBLE
people_value	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
precision	BIGINT
privacy_setting	STRING
reference_value	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
representation_type	STRING
resource_subtype	STRING
text_value	STRING
type	STRING
workspace_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
asana_created_field	STRING
created_by	STRUCT<gid: STRING, resource_type: STRING>
currency_code	STRING
custom_label	STRING
custom_label_position	STRING
date_value	STRUCT<date: STRING, date_time: STRING>
default_access_level	STRING
description	STRING
display_value	STRING
enabled	BOOLEAN
enum_options	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>
enum_value	STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>
format	STRING
has_notifications_enabled	BOOLEAN
html_text_value	STRING
id_prefix	STRING
input_restrictions	ARRAY<STRING>
is_formula_field	BOOLEAN
is_global_to_workspace	BOOLEAN
is_value_read_only	BOOLEAN
multi_enum_values	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>
number_value	DOUBLE
people_value	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
precision	BIGINT
privacy_setting	STRING
reference_value	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
representation_type	STRING
resource_subtype	STRING
text_value	STRING
type	STRING
workspace_gid	STRING

task_attachments

Primary key: section_gid, task_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
connected_to_app	BOOLEAN
created_at	TIMESTAMP
download_url	STRING
host	STRING
parent	STRUCT<gid: STRING, resource_type: STRING>
permanent_url	STRING
resource_subtype	STRING
size	BIGINT
view_url	STRING
section_gid	STRING
task_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
connected_to_app	BOOLEAN
created_at	TIMESTAMP
download_url	STRING
host	STRING
parent	STRUCT<gid: STRING, resource_type: STRING>
permanent_url	STRING
resource_subtype	STRING
size	BIGINT
view_url	STRING
section_gid	STRING
task_gid	STRING

portfolios

key primária: workspace_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
archived	BOOLEAN
color	STRING
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
current_status_update	STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type	STRUCT<gid: STRING, resource_type: STRING>
default_access_level	STRING
due_on	DATE
members	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
owner	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
permalink_url	STRING
privacy_setting	STRING
project_templates	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
public	BOOLEAN
resource_subtype	STRING
start_on	DATE
workspace	STRUCT<gid: STRING, resource_type: STRING>
workspace_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
archived	BOOLEAN
color	STRING
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
current_status_update	STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type	STRUCT<gid: STRING, resource_type: STRING>
default_access_level	STRING
due_on	DATE
members	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
owner	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
permalink_url	STRING
privacy_setting	STRING
project_templates	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
public	BOOLEAN
resource_subtype	STRING
start_on	DATE
workspace	STRUCT<gid: STRING, resource_type: STRING>
workspace_gid	STRING

portfolio_memberships

key primária: portfolio_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
access_level	STRING
member	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
parent	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
portfolio_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
access_level	STRING
member	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
parent	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
portfolio_gid	STRING

portfolio_items

key primária: portfolio_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
archived	BOOLEAN
color	STRING
completed	BOOLEAN
completed_at	TIMESTAMP
completed_by	STRUCT<gid: STRING, resource_type: STRING>
created_at	TIMESTAMP
created_from_template	STRUCT<gid: STRING, resource_type: STRING>
current_status	STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>
current_status_update	STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type	STRUCT<gid: STRING, resource_type: STRING>
default_access_level	STRING
default_view	STRING
is_template	BOOLEAN
due_date	DATE
due_on	DATE
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
html_notes	STRING
icon	STRING
members	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
minimum_access_level_for_customization	STRING
minimum_access_level_for_sharing	STRING
modified_at	TIMESTAMP
notes	STRING
owner	STRUCT<gid: STRING, resource_type: STRING>
permalink_url	STRING
privacy_setting	STRING
project_brief	STRUCT<gid: STRING, resource_type: STRING>
public	BOOLEAN
resource_subtype	STRING
start_on	DATE
team	STRUCT<gid: STRING, resource_type: STRING>
workspace	STRUCT<gid: STRING, resource_type: STRING>
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
project_templates	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
portfolio_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
archived	BOOLEAN
color	STRING
completed	BOOLEAN
completed_at	TIMESTAMP
completed_by	STRUCT<gid: STRING, resource_type: STRING>
created_at	TIMESTAMP
created_from_template	STRUCT<gid: STRING, resource_type: STRING>
current_status	STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>
current_status_update	STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings	ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type	STRUCT<gid: STRING, resource_type: STRING>
default_access_level	STRING
default_view	STRING
is_template	BOOLEAN
due_date	DATE
due_on	DATE
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
html_notes	STRING
icon	STRING
members	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
minimum_access_level_for_customization	STRING
minimum_access_level_for_sharing	STRING
modified_at	TIMESTAMP
notes	STRING
owner	STRUCT<gid: STRING, resource_type: STRING>
permalink_url	STRING
privacy_setting	STRING
project_brief	STRUCT<gid: STRING, resource_type: STRING>
public	BOOLEAN
resource_subtype	STRING
start_on	DATE
team	STRUCT<gid: STRING, resource_type: STRING>
workspace	STRUCT<gid: STRING, resource_type: STRING>
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
project_templates	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
portfolio_gid	STRING

project_memberships

key primária: project_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
access_level	STRING
write_access	STRING
member	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
parent	STRUCT<gid: STRING, resource_type: STRING>
project_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
access_level	STRING
write_access	STRING
member	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
parent	STRUCT<gid: STRING, resource_type: STRING>
project_gid	STRING

custom_field_settings

key primária: project_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
custom_field	VARIANT
is_important	BOOLEAN
parent	STRUCT<gid: STRING, resource_type: STRING>
project	STRUCT<gid: STRING, resource_type: STRING>
project_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
custom_field	VARIANT
is_important	BOOLEAN
parent	STRUCT<gid: STRING, resource_type: STRING>
project	STRUCT<gid: STRING, resource_type: STRING>
project_gid	STRING

project_status_updates

key primária: project_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
author	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text	STRING
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at	TIMESTAMP
num_hearts	BIGINT
num_likes	BIGINT
parent	STRUCT<gid: STRING, resource_type: STRING>
reaction_summary	ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype	STRING
status_type	STRING
text	STRING
title	STRING
project_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
author	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text	STRING
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at	TIMESTAMP
num_hearts	BIGINT
num_likes	BIGINT
parent	STRUCT<gid: STRING, resource_type: STRING>
reaction_summary	ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype	STRING
status_type	STRING
text	STRING
title	STRING
project_gid	STRING

portfolio_status_updates

key primária: portfolio_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
author	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text	STRING
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at	TIMESTAMP
num_hearts	BIGINT
num_likes	BIGINT
parent	STRUCT<gid: STRING, resource_type: STRING>
reaction_summary	ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype	STRING
status_type	STRING
text	STRING
title	STRING
portfolio_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
author	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text	STRING
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at	TIMESTAMP
num_hearts	BIGINT
num_likes	BIGINT
parent	STRUCT<gid: STRING, resource_type: STRING>
reaction_summary	ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype	STRING
status_type	STRING
text	STRING
title	STRING
portfolio_gid	STRING

goal_status_updates

key primária: goal_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
author	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text	STRING
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at	TIMESTAMP
num_hearts	BIGINT
num_likes	BIGINT
parent	STRUCT<gid: STRING, resource_type: STRING>
reaction_summary	ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype	STRING
status_type	STRING
text	STRING
title	STRING
goal_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
author	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted	BOOLEAN
hearts	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text	STRING
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at	TIMESTAMP
num_hearts	BIGINT
num_likes	BIGINT
parent	STRUCT<gid: STRING, resource_type: STRING>
reaction_summary	ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype	STRING
status_type	STRING
text	STRING
title	STRING
goal_gid	STRING

workspace_memberships

key primária: workspace_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
created_at	TIMESTAMP
is_active	BOOLEAN
is_admin	BOOLEAN
is_guest	BOOLEAN
is_view_only	BOOLEAN
user	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
user_task_list	STRUCT<gid: STRING, resource_type: STRING>
vacation_dates	STRUCT<start_on: STRING, end_on: STRING>
workspace	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
workspace_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
created_at	TIMESTAMP
is_active	BOOLEAN
is_admin	BOOLEAN
is_guest	BOOLEAN
is_view_only	BOOLEAN
user	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
user_task_list	STRUCT<gid: STRING, resource_type: STRING>
vacation_dates	STRUCT<start_on: STRING, end_on: STRING>
workspace	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
workspace_gid	STRING

goals

key primária: workspace_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
owner	STRUCT<gid: STRING, resource_type: STRING>
team	STRUCT<gid: STRING, resource_type: STRING>
workspace	STRUCT<gid: STRING, resource_type: STRING>
html_notes	STRING
notes	STRING
due_on	DATE
start_on	DATE
status	STRING
metric	STRUCT<gid: STRING, resource_subtype: STRING, precision: BIGINT, unit: STRING, currency_code: STRING, initial_number_value: DOUBLE, target_number_value: DOUBLE, current_number_value: DOUBLE, current_display_value: STRING, progress_source: STRING, is_custom_weight: BOOLEAN, can_manage: BOOLEAN>
time_period	STRUCT<gid: STRING, resource_type: STRING>
is_workspace_level	BOOLEAN
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
num_likes	BIGINT
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
current_status_update	STRUCT<gid: STRING, resource_type: STRING>
created_by	STRUCT<gid: STRING, resource_type: STRING>
workspace_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
owner	STRUCT<gid: STRING, resource_type: STRING>
team	STRUCT<gid: STRING, resource_type: STRING>
workspace	STRUCT<gid: STRING, resource_type: STRING>
html_notes	STRING
notes	STRING
due_on	DATE
start_on	DATE
status	STRING
metric	STRUCT<gid: STRING, resource_subtype: STRING, precision: BIGINT, unit: STRING, currency_code: STRING, initial_number_value: DOUBLE, target_number_value: DOUBLE, current_number_value: DOUBLE, current_display_value: STRING, progress_source: STRING, is_custom_weight: BOOLEAN, can_manage: BOOLEAN>
time_period	STRUCT<gid: STRING, resource_type: STRING>
is_workspace_level	BOOLEAN
liked	BOOLEAN
likes	ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
num_likes	BIGINT
followers	ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
current_status_update	STRUCT<gid: STRING, resource_type: STRING>
created_by	STRUCT<gid: STRING, resource_type: STRING>
workspace_gid	STRING

goal_relationships

key primária: goal_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
resource_subtype	STRING
supporting_resource	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
supported_goal	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
contribution_weight	DOUBLE
goal_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
resource_subtype	STRING
supporting_resource	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
supported_goal	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
contribution_weight	DOUBLE
goal_gid	STRING

time_tracking_entries

Primary key: section_gid, task_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
duration_minutes	BIGINT
entered_on	DATE
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
section_gid	STRING
task_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
duration_minutes	BIGINT
entered_on	DATE
created_by	STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at	TIMESTAMP
section_gid	STRING
task_gid	STRING

project_attachments

key primária: project_gid, gid

Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
connected_to_app	BOOLEAN
created_at	TIMESTAMP
download_url	STRING
host	STRING
parent	STRUCT<gid: STRING, resource_type: STRING>
permanent_url	STRING
resource_subtype	STRING
size	BIGINT
view_url	STRING
project_gid	STRING

campo	Tipo de dados
gid	STRING
resource_type	STRING
name	STRING
connected_to_app	BOOLEAN
created_at	TIMESTAMP
download_url	STRING
host	STRING
parent	STRUCT<gid: STRING, resource_type: STRING>
permanent_url	STRING
resource_subtype	STRING
size	BIGINT
view_url	STRING
project_gid	STRING