Learn R Programming
brickster (version 0.2.12)

dbConnect,DatabricksDriver-method: Connect to Databricks SQL Warehouse

Description

Connect to Databricks SQL Warehouse

Usage

# S4 method for DatabricksDriver
dbConnect(
  drv,
  warehouse_id = NULL,
  http_path = NULL,
  catalog = NULL,
  schema = NULL,
  staging_volume = NULL,
  max_active_connections = 30,
  fetch_timeout = 300,
  token = db_token(),
  host = db_host(),
  ...
)

Value

A DatabricksConnection object

Arguments

drv

A DatabricksDriver object

warehouse_id

Optional ID of the SQL warehouse to connect to

http_path

Optional HTTP path for the SQL warehouse; if provided, the warehouse ID is extracted from this path

catalog

Optional catalog name to use as default

schema

Optional schema name to use as default

staging_volume

Optional volume path for large dataset staging

max_active_connections

Maximum number of concurrent download connections when fetching query results (default: 30)

fetch_timeout

Timeout in seconds for downloading each result chunk (default: 300)

token

Authentication token (defaults to db_token())

host

Databricks workspace host (defaults to db_host())

...

Additional arguments (ignored)

Details

Provide either warehouse_id or http_path. When http_path is supplied, the warehouse ID is extracted from the /warehouses/<id> segment.