Comments (3)
We would probably need to directly query those tables since DuckDB has no support for reading from relational databases other than Postgres and Sqlite.
Polars has support for more databases, but no query pushdown, meaning it's not usable for us.
If we directly query the source we cannot use it in the sql endpoint, or at least not mix it.
from lakeapi.
At a later point we probably want to go for ADBC instead of ODBC and use ADBC driver for ms sql server (which does not exist, yet).
from lakeapi.
For now, probably arrow-odbc is the best option we have to get an arrow dataset
from lakeapi.
Related Issues (20)
- Multi parameter fails with more than 1000 parameters HOT 1
- Sorting with Null is always first (for desc and asc ordering)
- Too many items in a combi parameter leads to recursion error
- Migrate away from pypika HOT 6
- Enforce schema in Post request
- Bug with latest Polars Version HOT 1
- Ditch support for Polars HOT 1
- Input should be a valid string
- Switch to cashew HOT 1
- Caching as table options HOT 1
- Enable ODBC connection pooling
- Write more tests for caching HOT 1
- New Project Setup / "Plugin" Architecture
- Caching doesn't hit anymore HOT 1
- Option to use duckdb database as "file_type" HOT 1
- polars write_json to serialize HOT 1
- Get rid of caching (for the last time). We should not handle it here HOT 1
- Add support for Azure (abfss)
- Ditch DuckDB Support HOT 1
- Switch Config to Pydantic
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from lakeapi.