td-spectral-density

Estimate power spectral density for time series using Teradata's TD_SPECTRAL_DENSITY function and UAF.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps analyze the frequency content of time series data, enabling deeper insights into patterns and anomalies within signals.

Core Features & Use Cases

  • Power Spectral Density Estimation: Utilizes Teradata's Unbounded Array Framework (UAF) to calculate PSD.
  • Frequency Content Analysis: Identifies dominant frequencies and their power in time series data.
  • Use Case: Analyze sensor data from IoT devices to detect cyclical patterns or anomalies in machine vibrations.

Quick Start

Analyze the spectral density of the 'sensor_data' table using the 'timestamp' and 'value' columns.

Frequently Asked Questions about td-spectral-density

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

FAQPage Schema
How do I perform power spectral density estimation on time series data in Teradata?

To perform power spectral density estimation in Teradata, you can use the TD_SPECTRAL_DENSITY function via the Unbounded Array Framework (UAF). It analyzes frequency content and signal characteristics directly within Teradata Vantage.

Does TD_SPECTRAL_DENSITY require specific licensing or environment setup?

TD_SPECTRAL_DENSITY requires Teradata Vantage with the Unbounded Array Framework (UAF) enabled. You must also have the appropriate licensing to access UAF and execute spectral density analysis on your time series data.

What is power spectral density analysis used for in IoT or financial time series?

Power spectral density analysis identifies dominant frequencies and noise patterns in time series data. In IoT sensor data or financial time series, it detects cyclical patterns, machine vibration anomalies, and underlying signal characteristics.

Can I analyze frequency content and noise patterns using Teradata UAF?

You can analyze frequency content and noise patterns using Teradata UAF by applying the TD_SPECTRAL_DENSITY function. It processes the time series data to extract dominant frequencies and evaluate signal characteristics.

What's the best way to detect cyclical patterns or anomalies in machine vibration sensor data?

The best way to detect cyclical patterns or anomalies in machine vibration sensor data is by estimating the power spectral density. This frequency analysis isolates dominant vibration frequencies to identify deviations from expected operational baselines.