Querying DuckDB into Polars

The team also has a local DuckDB analytical store. A connection is already open, and a physical_format_summary table is loaded for you. DuckDB has its own integration with Polars: query the table and convert the result to a Polars DataFrame in one step.

polars is loaded as pl, and the DuckDB connection is in db.

Cet exercice fait partie du cours

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

Voir le cours

Instructions de l’exercice

Run the SQL query on the DuckDB connection.
Convert the DuckDB result to a Polars DataFrame.

Exercice interactif pratique

Essayez cet exercice en complétant ce code d’exemple.

# Run the query and convert the result to a Polars DataFrame
result = db.____(
    """
    SELECT *
    FROM physical_format_summary
    ORDER BY total_checkouts DESC
    """
).____()
print(result)

Modifier et exécuter le code