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.

This exercise is part of the course

Scaling and Optimizing Data Pipelines with Polars

View Course

Exercise instructions

Run the query using Polars' URI-based read function.
Set the database engine to "adbc".

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Read the SQL query result into a Polars DataFrame
result = pl.____(
    query=query,
    uri=uri,
    # Use the ADBC engine
    engine="____",
)
print(result)

Edit and Run Code