delayed_sql: Define a SQL query function to be executed within a task...

View source: R/manual_layer_delayed.R

delayed_sqlR Documentation

Define a SQL query function to be executed within a task graph

Description

Define a SQL query function to be executed within a task graph

Usage

delayed_sql(query, name = NULL, namespace = NULL)

Arguments

query

SQL query string – see vignette for examples

name

A display name for the query

namespace

If supplied, the TileDB-Cloud namespace to charge the query to. If omitted, a namespace can be applied at your top-level call to compute. If omitted there as well, your logged-in account's default namespace will be used.

Value

A task-graph node object on which you can later call compute. The return value from compute() will be the query result as a dataframe. Note that results will be strings, so numerical results will need to be explicitly cast as such.

See Also

Other manual-layer functions: array_info(), compute_sequentially(), compute(), delayed_args<-(), delayed_args(), delayed_array_udf(), delayed_generic_udf(), delayed(), deregister_array(), deregister_group(), deregister_udf(), execute_array_udf(), execute_generic_udf(), execute_multi_array_udf(), execute_sql_query(), get_udf_info(), group_info(), list_arrays(), list_groups(), login(), register_array(), register_udf(), update_udf_info(), user_profile()


TileDB-Inc/TileDB-Cloud-R documentation built on July 18, 2024, 3:33 p.m.