No project description provided
Project description
ODBC 2 Deltalake
This is a package that supports reading from ODBC and writing to a scd2 DeltaTable. The delta table will always have the following "system" cols:
- __timestamp : The Date of the Load
- __is_deleted : True for a deletion of a record
- __is_full_load : True if it was a full load, meaning an implicit deletion of not delivered records
Currently, this package is focused very much on Microsoft SQL Server. But it should not be too hard to add support for other DB Systems.
This packages handles delta's based on MS-SQL's "timestamp"/"rowversion" DataType or based on Temporal Tables. Other methods will be added later on. It does detect updates to records that happened differently, eg if a restore happened in the source.
Usage
It's as simple as this:
from odbc2deltalake import write_db_to_delta
await write_db_to_delta(
your_onnection_string,
(your_db_schema, your_table_name),
Path("YOUR_TARGET_PATH")
)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
odbc2deltalake-0.3.0.tar.gz
(15.9 kB
view hashes)
Built Distribution
Close
Hashes for odbc2deltalake-0.3.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d611da5d40112e57f23ce50986a857e1955a335cfdcf9f46b0bf0a445011cda9 |
|
MD5 | f93d796853d58fc799e93874dfdc76c0 |
|
BLAKE2b-256 | 732ce1e252bdd697784e21261f3b8ff135a9f2e15a471320b619345991a7d3e5 |