deephaven.dbc

• adbc
  • read_cursor()
• odbc

The dbc package includes the modules and functions for using external databases with Deephaven.

read_sql(conn, query, driver='connectorx')

Executes the provided SQL query via a supported driver and returns a Deephaven table.

Parameters:

• conn (Any) – must either be a connection string for the given driver or a Turbodbc/ADBC DBAPI Connection object; when it is a Connection object, the driver argument will be ignored.

• query (str) – SQL query statement

• driver (Literal['odbc', 'adbc', 'connectorx']) – (str): the driver to use, supported drivers are “odbc”, “adbc”, “connectorx”, default is “connectorx”

Return type:

Table

Returns:

a new Table

Raises:

DHError –