execute: Execute any SQL statement from Nuvolos.cloud

In nuvolos-cloud/r-connector: R connector to Nuvolos

Execute any SQL statement from Nuvolos.cloud

Description

Function execute(sql, dbname, schemaname). Executes any SQL statement in the connected Nuvolos schema. On Nuvolos the database and schema are by default the ones the user is working in, from local machine they need to be specified.

Usage

execute(sql, dbname = NULL, schemaname = NULL)

Arguments

sql	SQL statement to be executed. Note that quoting the tables is needed only if the table name is case sensitive (it contains both upper and lowercase letters or special chars).
dbname	The name of the database from/in which the statement will be executed.
schemaname	The name of the schema from/in which the statement will be executed.

Value

Returns the result of python's execute method.

Examples

execute("DROP TABLE table")
execute("DROP TABLE table", dbname = "space_1", schemaname = "test_schema")

nuvolos-cloud/r-connector documentation built on March 29, 2025, 3:22 p.m.