Check whether a Opal table exists (and is visible). Optionally check whether the table is a raw table or a view.
opal.table_exists(opal, project, table, view = NA)Opal connection object.
Project name where the table is located.
Table name.
Logical to perform an additional check whether the table is a view (TRUE) or a raw table (FALSE). If NULL or NA, the table can be indifferently a view or a raw table. Default is NA.
Other table functions:
opal.resource_view_create(),
opal.resource_view_reconnect(),
opal.table_create(),
opal.table_delete(),
opal.table_dictionary_get(),
opal.table_dictionary_update(),
opal.table_export(),
opal.table_get(),
opal.table_import(),
opal.table_perm_add(),
opal.table_perm_delete(),
opal.table_perm(),
opal.table_save(),
opal.table_truncate(),
opal.table_view_create(),
opal.table_view_update()
if (FALSE) {
o <- opal.login('administrator','password', url='https://opal-demo.obiba.org')
# check table exists
opal.table_exists(o, "CNSIM", "CNSIM1")
# check table exists AND is a NOT a view
opal.table_exists(o, "CNSIM", "CNSIM1", view = FALSE)
# check table exists AND is a view
opal.table_exists(o, "CNSIM", "CNSIM1", view = TRUE)
opal.logout(o)
}