Learn R Programming

opalr (version 2.0.0)

opal.table_create: Create a Opal table or view

Description

Create a Opal table if it does not already exist. If a list of table references are provided, the table will be a view. The table/view created will have no dictionary, use opal.table_dictionary_update to apply a dictionary.

Usage

opal.table_create(opal, project, table, type = "Participant", tables = NULL)

Arguments

opal

Opal connection object.

project

Project name where the table is located.

table

Table name to be deleted.

type

Entity type, default is "Participant". Ignored if some table references are provided.

tables

List of the fully qualified table names that are referred by the view.

Examples

Run this code
# NOT RUN {
o <- opal.login('administrator','password', url='https://opal-demo.obiba.org')
# make a raw table
opal.table_create(o, "CNSIM", "CNSIM4")
# make a view
opal.table_create(o, "CNSIM", "CNSIM123", 
                  tables = c("CNSIM.CNSIM1", "CNSIM.CNSIM2", "CNSIM.CNSIM3"))
opal.logout(o)
# }

Run the code above in your browser using DataLab