dlt.destinations.impl.sqlalchemy.configuration

SqlalchemyCredentials Objects

@configspec(init=False)
class SqlalchemyCredentials(ConnectionStringCredentials)

View source on GitHub

engine_kwargs

Additional keyword arguments passed to sqlalchemy.create_engine

engine_args

DEPRECATED: use engine_kwargs instead

is_memory_database

@staticmethod
def is_memory_database(database: Optional[str],
                       query: Optional[Dict[str, Any]] = None) -> bool

View source on GitHub

Detect if the given database/query represent an in-memory SQLite database.

Handles the following forms:

• Classic: :memory:
• URI: file:<name>?mode=memory&cache=shared&uri=true

NOTE: empty/None database is NOT considered in-memory here because dlt's configuration system resolves it to a default file path.

SqlalchemyClientConfiguration Objects

@configspec
class SqlalchemyClientConfiguration(WithLocalFiles,
                                    DestinationClientDwhConfiguration)

View source on GitHub

destination_type

type: ignore

credentials

SQLAlchemy connection string

create_unique_indexes

Whether UNIQUE constrains should be created

create_primary_keys

Whether PRIMARY KEY constrains should be created

engine_kwargs

Additional keyword arguments passed to sqlalchemy.create_engine

engine_args

DEPRECATED: use engine_kwargs instead