deephaven.dbc.odbc

This module supports ingesting data from external relational databases into Deephaven via the Python DB-API 2.0 (PEP 249) and the Open Database Connectivity (ODBC) interfaces by using the Turbodbc module.

Turbodbc is DB-API 2.0 compliant, provides access to relational databases via the ODBC interface and more importantly it has optimized, built-in Apache Arrow support when fetching ODBC result sets. This enables Deephaven to achieve maximum efficiency when ingesting relational data.

read_cursor(cursor)[source]

Converts the result set of the provided cursor into a Deephaven table.

Parameters:

cursor (turbodbc.cursor.Cursor) – a Turbodbc cursor. Prior to it being passed in, its execute() method must be called to run a query operation that produces a result set

Return type:

Table

Returns:

a new Table

Raises:

DHError, TypeError