Feature description

When using the sql_database source, I want to be able to pass the oracle arraysize to sql alchemy as documented here: https://docs.sqlalchemy.org/en/20/dialects/oracle.html#engine-options-consumed-by-the-sqlalchemy-oracledb-dialect-outside-of-the-driver

Sql alchemy then passes the setting to the underlying driver.

Being able to specify the arraysize is essential when extracting large tables since it can greatly reduce the number of round trips to the database.

Are you a dlt user?

Yes, I run dlt in production.

Use case

No response

Proposed solution

No response

Related issues

No response