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.

Deze oefening maakt deel uit van de cursus

Scaling and Optimizing Data Pipelines with Polars

Bekijk cursus

Oefeninstructies

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

Interactieve oefening met praktijkervaring

Probeer deze oefening door deze voorbeeldcode aan te vullen.

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

Code bewerken en uitvoeren