anvil_import: Import data tables into AnVIL

In UW-GAC/AnvilDataModels: Utilities for AnVIL data models

Import data tables into AnVIL

Description

Import data tables into AnVIL

Usage

anvil_import_table(
  table,
  table_name,
  model = NULL,
  overwrite = FALSE,
  namespace = avworkspace_namespace(),
  name = avworkspace_name()
)

anvil_import_set(
  table,
  table_name,
  overwrite = FALSE,
  namespace = avworkspace_namespace(),
  name = avworkspace_name()
)

create_set_all(table, table_name)

unnest_set_table(set_table)

anvil_import_tables(
  tables,
  model = NULL,
  overwrite = FALSE,
  namespace = avworkspace_namespace(),
  name = avworkspace_name(),
  timeout = 3600
)

Arguments

table	Data table to import (tibble or data.frame)
table_name	Name of data table in model
model	dm object describing data model
overwrite	Logical for whether to overwrite data for existing rows
namespace	AnVIL workspace namespace
name	AnVIL workspace name
set_table	set table returned by avtable
tables	Named list of tables to import
timeout	Number of seconds to wait for import to complete before timing out

Details

anvil_import_table imports a data table to an AnVIL workspace.

anvil_import_set imports a set table to an AnVIL workspace. The reference table must already exist in the workspace.

anvil_import_tables imports a named list of tables, calling anvil_import_table or anvil_import_set as appropriate. Set tables are assumed to end with "_set".

create_set_all creates a set table containing all entities in the reference table.

unnest_set_table takes a set table returned by avtable and formats it so it can be imported back into AnVIL with avtable_import_set

Value

create_set_all returns a tibble with one set, 'all', containing all entities in table.

unnest_set_table returns a tibble with a set table in long form

UW-GAC/AnvilDataModels documentation built on Nov. 3, 2024, 7:33 p.m.