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.

Diese Übung ist Teil des Kurses

<Kurs>Scaling and Optimizing Data Pipelines with Polars</Kurs>

Kurs ansehen

Übungsanweisungen

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

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

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

Code bearbeiten und ausführen