Skip to main content

No project description provided

Project description

LakeApi 2 SQL

This is a simple library that does a HTTP Request to an Endpoint from the Lake API and inserts the data via bulk insert into MS SQL Server. In Theory you could also get the data from some other HTTP Endpoint which returns an Arrow Stream and is authenticated using Basic Auth.

The main goal is to be very fast in this one task. It does not guarantee atomicity at sql server level, therefore you will usually want to use a global temp table as target.

It's meant to be used from Python, the Logic is written in Rust.

Features

  • You can specify Authentication=ActiveDirectoryMSI|ActiveDirectoryDefault|ActiveDirectoryInteractive in the connection string similar to .Net/ODBC SQL Driver. This requires the azure-identity package to be installed

Roadmap

There is still a lot todo:

  • Allow reading from pyarrow instead of HTTP
  • Allow passing more flexible HTTP Authentication options
  • Add option to read from database and write to a flat file
  • Document
  • Test

Alternatives

This would not have been possible without the excellent arrow-odbc-py library. Use it whenever SQL Server is not the only possible target, or you need to read from a database or you just need something better ;)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

lakeapi2sql-0.6.0.tar.gz (28.6 kB view hashes)

Uploaded Source

Built Distributions

lakeapi2sql-0.6.0-cp310-abi3-win_amd64.whl (3.1 MB view hashes)

Uploaded CPython 3.10+ Windows x86-64

lakeapi2sql-0.6.0-cp310-abi3-win32.whl (2.9 MB view hashes)

Uploaded CPython 3.10+ Windows x86

lakeapi2sql-0.6.0-cp310-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (6.0 MB view hashes)

Uploaded CPython 3.10+ manylinux: glibc 2.17+ x86-64

lakeapi2sql-0.6.0-cp310-abi3-manylinux_2_17_s390x.manylinux2014_s390x.whl (6.4 MB view hashes)

Uploaded CPython 3.10+ manylinux: glibc 2.17+ s390x

lakeapi2sql-0.6.0-cp310-abi3-manylinux_2_17_ppc64le.manylinux2014_ppc64le.whl (6.5 MB view hashes)

Uploaded CPython 3.10+ manylinux: glibc 2.17+ ppc64le

lakeapi2sql-0.6.0-cp310-abi3-manylinux_2_17_i686.manylinux2014_i686.whl (6.3 MB view hashes)

Uploaded CPython 3.10+ manylinux: glibc 2.17+ i686

lakeapi2sql-0.6.0-cp310-abi3-manylinux_2_17_armv7l.manylinux2014_armv7l.whl (5.8 MB view hashes)

Uploaded CPython 3.10+ manylinux: glibc 2.17+ ARMv7l

lakeapi2sql-0.6.0-cp310-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (5.8 MB view hashes)

Uploaded CPython 3.10+ manylinux: glibc 2.17+ ARM64

lakeapi2sql-0.6.0-cp310-abi3-macosx_11_0_arm64.whl (3.2 MB view hashes)

Uploaded CPython 3.10+ macOS 11.0+ ARM64

lakeapi2sql-0.6.0-cp310-abi3-macosx_10_7_x86_64.whl (3.5 MB view hashes)

Uploaded CPython 3.10+ macOS 10.7+ x86-64

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page