How does the skill handle relative date ranges?

It provides patterns for CURRENT_DATE, DATE_TRUNC for period boundaries, and INTERVAL for relative math, allowing for dynamic filters like 'last month'.

When should I use FILTER (WHERE ...) versus CASE WHEN?

Use 'FILTER (WHERE ...)' inside metric SQL aggregations for cleaner, standard SQL; use 'CASE WHEN' within attribute SQL definitions for per-row conditional logic.

Can this skill filter data after it has been aggregated?

Yes, it supports filtering on aggregated metric values (equivalent to a SQL HAVING clause) using the filters parameter in a structured query.

Does it support type casting for mismatched fields?

Yes, the skill emphasizes explicit type casting (e.g., field::DATE or field::VARCHAR) to prevent silent type coercion errors during comparisons.

What syntax does this skill use for string matching?

It utilizes standard SQL operators like '=', 'IN', and 'ILIKE' for case-insensitive pattern matching, as well as a specialized 'SEARCH' function for Snowflake full-text search.

Data Filtering & Expressions

Name: Data Filtering & Expressions
Author: honeydew-ai

byhoneydew-ai

0•

Data Science & ML

Applies precise data filtering and conditional logic across Honeydew perspectives, metrics, and attributes using standardized SQL syntax.

This skill provides Claude with the specialized knowledge required to restrict and refine data results within the Honeydew AI ecosystem. It covers multiple filtering contexts—including row-level perspective filters, during-aggregation metric filters, and per-row attribute expressions—ensuring that data queries are both accurate and performant. By mastering complex date handling, full-text search syntax, and explicit type casting, this skill enables Claude to generate sophisticated data analysis queries that follow industry best practices for Snowflake and other SQL-based environments.

Key Features

010 GitHub stars

02Explicit type casting to prevent silent query coercion errors

03Context-aware filtering for perspectives, metrics, and attributes

04Advanced string matching using ILIKE and full-text SEARCH functionality

05Comprehensive date handling with truncation and interval logic

06Post-aggregation filtering for metric values (HAVING clause equivalent)

Use Cases

01Calculating metrics based on conditional logic using FILTER (WHERE ...)

02Developing relative date filters for rolling time-period analysis

03Filtering sales reports to specific regions or active status codes

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add honeydew-ai/honeydew-ai-coding-agents-plugins filtering

For use in Claude.ai and ChatGPT

Key Features

010 GitHub stars

02Explicit type casting to prevent silent query coercion errors

03Context-aware filtering for perspectives, metrics, and attributes

04Advanced string matching using ILIKE and full-text SEARCH functionality

05Comprehensive date handling with truncation and interval logic

06Post-aggregation filtering for metric values (HAVING clause equivalent)

Use Cases

01Calculating metrics based on conditional logic using FILTER (WHERE ...)

02Developing relative date filters for rolling time-period analysis

03Filtering sales reports to specific regions or active status codes

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add honeydew-ai/honeydew-ai-coding-agents-plugins filtering

For use in Claude.ai and ChatGPT