数据库
数据库管理与查询
trino
treasure-data
TD Trino SQL with TD-specific functions (td_interval, td_time_range, td_time_string, td_sessionize). Use for time-based filtering, partition pruning, and TD query patterns.
schema-auto-tagger
treasure-data
Automated schema tagging and resource classification for Treasure Data. Detects new tables/columns, analyzes metadata patterns, and suggests appropriate policy tags with confidence scoring. Reduces manual tagging effort by 80% while maintaining compliance standards (GDPR, CCPA, HIPAA, SOX).
time-filtering
treasure-data
Advanced td_interval patterns including offset dates (-1d/2025-10-01, -7d/-1d, 0M/now), td_interval_range for debugging, td_time_string for display formatting, and partition pruning optimization.
trino-to-hive-migration
treasure-data
Convert Trino queries to Hive when memory errors occur. Covers syntax differences (td_time_string→TD_TIME_FORMAT, REGEXP_LIKE→RLIKE, ARRAY_AGG→COLLECT_LIST) and engine selection.
pytd
treasure-data
Expert assistance for using pytd (Python SDK) to query and import data with Treasure Data. Use this skill when users need help with Python-based data analysis, querying Presto/Hive, importing pandas DataFrames, bulk data uploads, or integrating TD with Python analytical workflows.
identity
treasure-data
Query identity change logs to explore profile creation and merging
parent-segment
treasure-data
Manages CDP parent segments using tdx ps commands with YAML configs. Covers master tables, attributes, behaviors, tdx ps validate for join validation, tdx ps preview for data preview, and schedule configuration (daily/hourly/cron). Use when creating customer master tables, validating join match rates, or troubleshooting parent segment workflows.
aps-doc-hist-union
treasure-data
Expert documentation generation for hist-union workflows. Documents historical and incremental table combination strategies, schema validation, time-based partitioning, and backfill processes. Use when documenting hist-union layers.
segment
treasure-data
Manages CDP child segments using tdx sg commands with YAML rule configs. Covers filtering with operators (Equal, In, Greater, TimeWithinPast, Contain), folder organization, and activations for Salesforce/Google Ads exports. Use when creating audience segments, validating with tdx sg push --dry-run, or listing fields with tdx sg fields.
rt-journey-monitor
treasure-data
Monitor RT journeys - track activation success, debug failures, query activation logs, and optimize performance
digdag
treasure-data
Treasure Workflow (digdag) for TD. Covers .dig syntax, session variables (session_date, session_date_compact), td> operator, _parallel/_retry/_error directives, and tdx wf commands.
connector-config
treasure-data
Writes connector_config for segment/journey activations using tdx connection schema <type> to discover available fields. Use when configuring activations - always run schema command first to see connector-specific fields.
rt-config
treasure-data
Configure RT 2.0 (Real-Time Personalization) for parent segments including event tables, key events, RT attributes, and ID stitching using tdx ps rt commands or API
agent-prompt
treasure-data
Write effective system prompts for TD AI agents. Covers role definition, constraint specification, output formatting, tool usage instructions, and prompt structure patterns.
rt-config-id-stitching
treasure-data
Configure RT 2.0 ID stitching - merge real-time profiles across different identifiers using stitching keys and primary keys
trino-optimizer
treasure-data
TD Trino performance optimization including CTAS (5x faster), UDP bucketing for ID lookups, magic comments for join distribution, REGEXP_LIKE vs LIKE, and approx functions.
hive
treasure-data
TD Hive SQL with TD-specific functions and Hive-only features (lateral view, explode, MAPJOIN hint). Use when Trino memory errors occur or for Hive-specific syntax.
parent-segment-analysis
treasure-data
Query and analyze CDP parent segment database data. Use tdx ps desc -o to get output database schema, then query customers and behavior tables. Use when exploring parent segment data, building reports, or analyzing customer attributes and behaviors.
rt-config-events
treasure-data
Configure RT 2.0 event tables and key events - define which streaming events to track and filter for real-time processing
dbt
treasure-data
dbt with TD Trino. Covers profiles.yml setup (method:none, user:TD_API_KEY), required override macros (no CREATE VIEW), TD_INTERVAL in models, and TD Workflow deployment.
aps-doc-ingestion
treasure-data
Expert documentation generation for ingestion layers. Automatically detects connector types (REST API, Database, File, Streaming), documents authentication patterns, rate limiting strategies, and incremental load patterns. Use when documenting data source ingestion workflows.
aps-doc-golden
treasure-data
Expert documentation generation for golden layers. Detects SCD types, documents business rules, metric definitions, aggregation logic, and data quality scoring. Use when documenting golden layer tables.
aps-doc-core
treasure-data
Core documentation generation patterns and framework for Treasure Data pipeline layers. Provides shared templates, quality validation, testing framework, and Confluence integration used by all layer-specific documentation skills.
activations
treasure-data
Query activation logs to check for errors and view volume