td-dfft

Perform Discrete Fourier Transform on time-series data using Teradata's TD_DFFT function.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the process of performing Discrete Fourier Transforms (DFT) on time-series data, enabling frequency domain analysis for signal processing and pattern detection.

Core Features & Use Cases

  • Automated Preprocessing: Handles data cleaning, centering, and formatting for DFT.
  • Frequency Domain Analysis: Identifies dominant frequencies, analyzes power spectrum, and interprets results.
  • Use Case: Analyze sensor data to detect cyclical patterns or diagnose issues in machinery by identifying the underlying frequencies present in the signal.

Quick Start

Use the td-dfft skill to analyze the time series data in the table my_database.my_sensor_data with the timestamp column as reading_time and the value column as sensor_value.

Frequently Asked Questions about td-dfft

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

FAQPage Schema
How do I perform a Discrete Fourier Transform on time-series data in Teradata Vantage?

To perform a Discrete Fourier Transform on time-series data in Teradata Vantage, use the TD_DFFT function, which automates data cleaning, centering, and formatting to produce frequency domain analysis and identify dominant periodic components.

What is frequency domain analysis used for in sensor data and signal processing?

Frequency domain analysis is used in sensor data and signal processing to identify dominant frequencies, analyze the power spectrum, and detect cyclical patterns to diagnose issues in machinery by revealing the underlying periodic components present in the signal.

Do I need Teradata ClearScape Analytics to run DFT on time-series data?

Yes, you need Teradata Vantage with ClearScape Analytics and appropriate database permissions to run DFT on time-series data, as the TD_DFFT function relies on this environment to perform the required signal processing and frequency analysis.

How do I analyze the power spectrum of a time series using SQL?

To analyze the power spectrum of a time series using SQL, apply the TD_DFFT function to your timestamp and value columns, which handles the necessary data centering and formatting to interpret the dominant frequencies within your dataset.

What is the best way to detect cyclical patterns in machinery sensor data?

The best way to detect cyclical patterns in machinery sensor data is to apply a Discrete Fourier Transform, which identifies the underlying periodic frequencies present in the signal to diagnose machinery issues.