read_sql: Execute SQL SELECT statements from Nuvolos.cloud

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

Execute SQL SELECT statements from Nuvolos.cloud

Description

Function read_sql(sql, dbname, schemaname, parse_dates). Executes SELECT SQL statements 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

read_sql(sql, dbname = NULL, schemaname = NULL, index_col = 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 which the SELECT statement will be executed.
schemaname	The name of the schema from which the SELECT statement will be executed.
index_col	Name of the column to set as index. Default is NULL.

Value

Returns an R dataframe object. When date format columns are in the table, they are returned as Date.

Examples

db <- read_sql("SELECT * FROM table")
db <- read_sql("SELECT * FROM table", dbname = "space_1", schemaname = "test_schema", index_col = "index")

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