Skip to content

Instantly share code, notes, and snippets.

@do-me

do-me/load_data.sql

Created January 28, 2026 13:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save do-me/eba96368897a03ed5dd629fc43ee263b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save do-me/eba96368897a03ed5dd629fc43ee263b to your computer and use it in GitHub Desktop.
Download ZIP
Simple DuckUI query with duckdb wasm to HF with filters
Raw
load_data.sql
SELECT
*
FROM 'hf://datasets/do-me/EUR-LEX/**/*.parquet'
WHERE
-- 1. Date filter (highly efficient for narrowing down files/rows)
CAST(date AS DATE) >= '2026-01-21'
-- 2. Your specific keywords (case-insensitive)
--AND regexp_matches(text, '(?i)copernicus|earth observation')
ORDER BY date DESC
LIMIT 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment