Skip to contents

Materialize a view into a memory table

Source: R/sx_views.R
sx_create_table.Rd

Forces computation of a lazy view or dataframe and stores the result as a materialized table in SedonaDB memory (Apache Arrow MemTable).

This is useful for caching intermediate results to speed up subsequent queries.

Usage

sx_create_table(x, name = NULL, overwrite = TRUE, verbosity = NULL)

Arguments

x

A sedonadb_dataframe, sf object, or view name (character) in SedonaDB to materialize.. Can be a view name (character) or sedonadb_dataframe.

name

Character. The name to register the table as. If NULL (default), a unique name is generated.

overwrite

Logical. If TRUE, overwrites any existing view with the same name. Default is FALSE.

verbosity

Character or NULL. Controls message output for this function call.

  • "quiet": Suppress all informational messages.

  • "info": Show standard progress and status messages.

  • "debug": Show additional diagnostic messages for troubleshooting.

If NULL (the default), uses the global sx.verbosity option. See sx_options() for persistent configuration.

Value

A sedonadb_dataframe pointing to the materialized table (invisibly).

Examples

if (FALSE) { # \dontrun{
# 1. Define a lazy operation
lazy_df <- sx_buffer("input_view", 10)

# 2. Materialize it into memory as 'buffered_table'
sx_create_table(lazy_df, "buffered_table")
} # }