bk99.de entertain the web since 1997

Analysing more than 50,000 Hub data sets with DuckDB

Summary

The article uses Parquet metadata and DuckDB to evaluate many Hub data sets directly with SQL. Large data sets do not have to be loaded completely onto your own machine for this. DuckDB can query Parquet files directly over HTTP.

Ideas

  • Columnar formats allow analysis close to the metadata instead of complete downloads.
  • SQL makes data inventories accessible for reproducible quality checks.

Insights

  • Data access becomes scalable when formats, metadata and query patterns are designed together.

Facts

  • The Hub provides automatically generated Parquet versions for numerous data sets.

Critique

  • Automatically converted Parquet files inherit the quality and licence problems of their source data.

Recommendations

  • Start with metadata and sample queries before you take over a large data set completely.

References

Read the original article on Hugging Face

Search the Web Archive