Teradata

This is the implementation of the Teradata data handler for MindsDB.

Teradata Vantage Advanced SQL Engine (formerly known as Teradata Database) is a connected multi-cloud data platform offering for enterprise analytics, that enables users to solve complex data challenges from start to scale. It supports huge data warehouse applications and was designed with a patented massively parallel processing (MPP) architecture. [Read more].

Implementation

This handler is implemented using teradatasql, the Python driver for Teradata.

The required arguments to establish a connection are as follows:

• host is the host name or IP address of the Teradata Vantage instance.
• user specifies the user name.
• password specifies the password for the user.
• database sets the database for the connection.

If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the handler’s folder (mindsdb/integrations/handlers/teradata_handler) and run this command: pip install -r requirements.txt.

Usage

You can use the below SQL statements to create a database in Teradata called HR and a table called Employees.

CREATE
DATABASE HR
AS PERMANENT = 60e6, -- 60MB
   SPOOL = 120e6; -- 120MB

CREATE
SET TABLE HR.Employees (
   GlobalID INTEGER,
   FirstName VARCHAR(30),
   LastName VARCHAR(30),
   DateOfBirth DATE FORMAT 'YYYY-MM-DD',
   JoinedDate DATE FORMAT 'YYYY-MM-DD',
   DepartmentCode BYTEINT
)
UNIQUE PRIMARY INDEX ( GlobalID );

INSERT INTO HR.Employees (GlobalID,
                          FirstName,
                          LastName,
                          DateOfBirth,
                          JoinedDate,
                          DepartmentCode)
VALUES (101,
        'Adam',
        'Tworkowski',
        '1980-01-05',
        '2004-08-01',
        01);

In order to make use of this handler and connect to the Teradata database in MindsDB, the following syntax can be used:

CREATE DATABASE teradata_db
WITH
   ENGINE = 'teradata',
   PARAMETERS = {
      "host": "192.168.0.41",
      "user": "dbc",
      "password": "dbc",
      "database": "HR"
   };

The above example assumes usage of Teradata Vantage running on Oracle VirtualBox.

You can use this established connection to query your table as follows:

SELECT *
FROM teradata_db.Employees;

On execution, we get:

+---------+-----------+------------+-------------+------------+----------------+
|GlobalID | FirstName | LastName   | DateOfBirth | JoinedDate | DepartmentCode |
+---------+-----------+------------+-------------+------------+----------------+
|101      | Adam      | Tworkowski | 1980-01-05  | 2004-08-01 | 1              |
+---------+-----------+------------+-------------+------------+----------------+