tabsdata.OracleSource

class OracleSource(
uri: str,
query: str | List[str],
credentials: UserPasswordCredentials | None = None,
initial_values: dict | None = None,
)

Bases: SourcePlugin

Oracle-based data inputs.

__init__(
uri: str,
query: str | List[str],
credentials: UserPasswordCredentials | None = None,
initial_values: dict | None = None,
)

Initializes the OracleSource with the given URI and query, and optionally connection credentials and initial values for the parameters in the SQL queries.

Parameters:
  • uri – The URI of the database where the data is located

  • query – The SQL query(s) to execute. If multiple queries are provided, they must be provided as a list, and they will be mapped to the function inputs in the same order as they are defined.

  • credentials – The credentials required to access the Oracle database. Must be a UserPasswordCredentials object.

  • initial_values – The initial values for the parameters in the SQL queries.

Raises:

InputConfigurationError

Methods

__init__(uri, query[, credentials, ...])

Initializes the OracleSource with the given URI and query, and optionally connection credentials and initial values for the parameters in the SQL queries.

chunk(working_dir)

Trigger the import of the data.

stream(working_dir)

Attributes

credentials

The credentials required to access Oracle.

initial_values

The initial values for the parameters in the SQL queries.

query

The SQL query(s) to execute.

uri

The URI of the database where the data is located.