Teradata

This documentation describes the integration of MindsDB with Teradata, the complete cloud analytics and data platform for Trusted AI. The integration allows MindsDB to access data from Teradata and enhance Teradata with AI capabilities.

​

Prerequisites

Before proceeding, ensure the following prerequisites are met:

1. Install MindsDB locally via Docker or Docker Desktop.
2. To connect Teradata to MindsDB, install the required dependencies following this instruction.

​

Connection

Establish a connection to Teradata from MindsDB by executing the following SQL command and providing its handler name as an engine.

CREATE DATABASE teradata_datasource
WITH
   ENGINE = 'teradata',
   PARAMETERS = {
      "host": "192.168.0.41",
      "user": "demo_user",
      "password": "demo_password",
      "database": "example_db"
   };

Required connection parameters include the following:

• host: The hostname, IP address, or URL of the Teradata server.
• user: The username for the Teradata database.
• password: The password for the Teradata database.

Optional connection parameters include the following:

• database: The name of the Teradata database to connect to. Defaults is the user’s default database.

​

Usage

Retrieve data from a specified table by providing the integration, database and table names:

SELECT *
FROM teradata_datasource.database_name.table_name
LIMIT 10;

Run Teradata SQL queries directly on the connected Teradata database:

SELECT * FROM teradata_datasource (

   --Native Query Goes Here
   SELECT emp_id, emp_name, job_duration AS tsp
   FROM employee
   EXPAND ON job_duration AS tsp BY INTERVAL '1' YEAR
      FOR PERIOD(DATE '2006-01-01', DATE '2008-01-01');

);

​

Troubleshooting