td-diff

Apply Teradata TD_DIFF differencing to time series data within the Unbounded Array Framework.

7|Updated Dec 3, 2025
One-click install
npx skills add https://github.com/teradata-labs/claude-cookbooks --skill td-diff
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: td-diff
Source: https://github.com/teradata-labs/claude-cookbooks/tree/main/skills/analytics/td-diff
Command: npx skills add https://github.com/teradata-labs/claude-cookbooks --skill td-diff

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and resources (resource) components.

What problem does it solve?

This Skill addresses the challenge of analyzing time series data that exhibits trends or non-stationarity, which can hinder accurate forecasting and modeling.

Core Features & Use Cases

  • Time Series Differencing: Applies differencing to remove trends and seasonality, making data stationary.
  • UAF Implementation: Leverages Teradata's Unbounded Array Framework for efficient, scalable processing.
  • Use Case: Analyze sensor data from IoT devices to identify anomalies or predict future behavior by first removing the underlying trend and seasonal patterns.

Quick Start

Analyze time series table: my_database.sensor_data with timestamp column and value columns.

Frequently Asked Questions about td-diff

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I make time series data stationary for forecasting?

Make time series data stationary by applying differencing to remove trends and seasonality. This process eliminates non-stationary patterns, resulting in trend-free data that improves analytical model performance and forecasting accuracy.

What is time series differencing and when should I use it?

Time series differencing is a technique that removes trends and seasonal components from sequential data. Use it when your data exhibits non-stationarity, which hinders accurate forecasting and modeling, to stabilize statistical properties over time.

How do I remove trends from IoT sensor data in Teradata?

Remove trends from IoT sensor data by performing time series differencing using the TD_DIFF function within Teradata's Unbounded Array Framework. This efficiently processes timestamp and value columns to identify anomalies or predict future behavior.

Does the Teradata Unbounded Array Framework support high-dimensional time series differencing?

Yes, the Teradata Unbounded Array Framework supports high-dimensional time series differencing. It leverages scalable processing to handle complex datasets while generating production-ready SQL with comprehensive error handling.

What are the limitations of time series differencing for trend removal?

Time series differencing effectively removes trends and seasonality but may introduce autocorrelation or lose initial data points. If underlying data lacks clear trends or seasonal patterns, differencing might not improve stationarity for analytical modeling.