Reading from SQLite with a URI
A local SQLite database has been prepared with the digital format summary the team uses every week. Use Polars' URI-based reader with the ADBC engine, which transfers data in Arrow's columnar format so Polars can use it directly without any per-row Python conversion.
The connection URI is in uri and the SQL query is in query.
Latihan ini merupakan bagian dari kursus
Scaling and Optimizing Data Pipelines with Polars
Instruksi latihan
- Run the query using Polars' URI-based read function.
- Set the database engine to
"adbc".
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
# Read the SQL query result into a Polars DataFrame
result = pl.____(
query=query,
uri=uri,
# Use the ADBC engine
engine="____",
)
print(result)