Is there an easier way to query a dataset via duckdb?

Beginners
2

Yes,
I can use wildcards:

duckdb -c "
SELECT
    CODICE_NATURA_INTERVENTO,
    NATURA_INTERVENTO,
    COUNT(*) AS conteggio
FROM 'hf://datasets/aborruso/open_cup_complessivo/opencup.parquet/data_*.parquet'
GROUP BY
    CODICE_NATURA_INTERVENTO,
    NATURA_INTERVENTO
ORDER BY
    conteggio DESC;
"
1 Like