Skip to contents

ADBC FlightSQL Driver

Usage

adbcflightsql()

# S3 method for class 'adbcflightsql_driver_flightsql'
adbc_database_init(driver, ..., uri = NULL)

# S3 method for class 'adbcflightsql_database'
adbc_connection_init(database, ..., adbc.connection.autocommit = NULL)

# S3 method for class 'adbcflightsql_connection'
adbc_statement_init(
  connection,
  ...,
  adbc.ingest.target_table = NULL,
  adbc.ingest.mode = NULL
)

Arguments

driver

The driver to use. This can be one of the following:

  • A non-missing character(1) containing a driver or manifest name, a relative or absolute path to a driver or manifest, or a URI. For a URI, the driver manager uses the URI scheme as the driver name and passes the URI to that driver. A profile:// URI loads a connection profile.

  • NULL, which leaves driver selection to the driver manager. In this case, ... must normally contain uri or profile; the driver is inferred from the URI or loaded from the connection profile.

  • An object that inherits from the adbc_driver class, such as one created by adbc_driver(). This includes drivers provided by R packages, such as adbcsqlite::adbcsqlite().

...

Extra key/value options passed to the driver.

uri

A URI to a database path (e.g., user[:password]@account/database[?param1=value1])

database

An adbc_database.

adbc.connection.autocommit

Use FALSE to disable the default autocommit behaviour.

connection

An adbc_connection

adbc.ingest.target_table

The name of the target table for a bulk insert.

adbc.ingest.mode

Whether to create (the default) or append.

Examples

adbcflightsql()
#> <adbcflightsql_driver_flightsql> List of 4
#>  $ load_flags      : int 15
#>  $ driver_init_func:Class 'adbc_driver_init_func' <externalptr> 
#>  $ .child_count    : int 0
#>  $ version         : int 1001000