Apply td_interval patterns to time columns for time-based SQL filtering.
npx skills add https://github.com/treasure-data/td-skills --skill time-filtering
Please help me install this Agent Skill. Skill: time-filtering Source: https://github.com/treasure-data/td-skills/tree/main/sql-skills/time-filtering Command: npx skills add https://github.com/treasure-data/td-skills --skill time-filtering
This Skill simplifies complex time-based filtering by offering advanced td_interval patterns, offset dates, and debugging helpers to ensure accurate, fast queries over large datasets.
Use the time-filtering skill to generate a td_interval expression that selects the previous 7 days relative to your reference date and verify with td_interval_range.
High-intent search queries and answers about installing and using this skill.
Time filtering with td_interval patterns enables partition pruning, which skips irrelevant data blocks during query execution. By applying td_interval directly to your time column—using absolute, relative, or now-based references—you filter efficiently without transforming the column, keeping queries fast over terabytes of data.
Use td_interval expressions with relative ranges and time-zone-aware offsets to generate accurate start and end dates. The Skill handles timezone alignment and validates windows with td_interval_range, ensuring reproducible results regardless of where your data originates or when your ETL runs.
The td_interval_range debugging helper returns the actual start and end timestamps for your interval expression. Run it first to confirm your window matches expectations—particularly useful for month-to-date or year-to-date ranges—before executing expensive analytics queries.
Yes. td_interval patterns support month-to-date and year-to-date ranges through relative offset syntax. The Skill provides templates for these common reporting windows and ensures alignment with td_scheduled_time so scheduled jobs produce consistent results across runs.
Partition pruning requires the time column to be used directly in the filter without transformation. Functions like date truncation or arithmetic on the column prevent pruning. The Skill guides you to structure filters that keep the column intact, maximizing partition elimination and query speed.
Daily ETL jobs benefit from td_interval with relative ranges and td_scheduled_time alignment, ensuring consistent windows even as dates shift. Ad hoc queries can use absolute ranges. The Skill addresses both patterns and explains when to anchor to scheduled execution time versus query submission time.
treasure-dataOptimize Trino SQL queries using TD-specific time functions for partition pruning.
markus41Automate NABIP AMS data into interactive dashboards and reports.
jeremylongshoreDesign range, list, or hash partitioning strategies and generate SQL scripts.
timequityOptimize data warehouse queries and storage across Snowflake, BigQuery, and Redshift.
