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.
Este exercicio faz parte do curso
Scaling and Optimizing Data Pipelines with Polars
Instruções do exercicio
- Run the query using Polars' URI-based read function.
- Set the database engine to
"adbc".
exercicio interativo prático
Tente este exercicio completando este código de exemplo.
# Read the SQL query result into a Polars DataFrame
result = pl.____(
query=query,
uri=uri,
# Use the ADBC engine
engine="____",
)
print(result)