time-filtering
OfficialMaster time filtering with td_interval patterns.
Data & Analytics#sql#data analytics#td_interval_range#partition pruning#Treasure Data#time filtering#td_interval
Authortreasure-data
Version1.0.0
Installs0
System Documentation
What problem does it solve?
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.
Core Features & Use Cases
- Advanced td_interval patterns: Offset dates, relative ranges, and now-based ranges for precise time slicing.
- td_interval_range debugging: Quick checks to validate start/end for time windows.
- Partition pruning guidance: Best practices to optimize queries and prune partitions.
- Use Case: A daily ETL job needs to fetch the last 7 days of events across multiple time zones; this Skill streamlines building the right interval expressions and validates them.
Quick Start
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.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: time-filtering Download link: https://github.com/treasure-data/td-skills/archive/main.zip#time-filtering Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.