Teradata Vantage™ is the connected multi-cloud data platform for enterprise analytics that unifies everything — data lakes, data warehouses, analytics, and new data sources and types. Latest version 17.10 is currently supported.
To create a simple Teradata transformation, follow these steps:
CREATE TABLE "transformationTable" (
"id" INT NOT NULL,
"name" VARCHAR(10) NOT NULL
);
INSERT INTO "transformationTable" ("id", "name") VALUES (1, 'john');
INSERT INTO "transformationTable" ("id", "name") VALUES (2, 'doe');
You can organize the script into blocks.
Teradata organizes tables in databases. Each bucket in Keboola is represented by a separated database, which usually follow this naming pattern: <stackPrefix>_<projectID>-<bucketID>
stackPrefix
- depends on keboola stack which you use
SAPI
on https://connection.keboola.com/KEBOOLA
everywhere elseprojectID
- ID of your project, which you can find in URLbucketID
- you can find this string ID in detail of your bucket (field ID, not name). This value is in form where .
is replaced by _
Example:
Bucket with ID in.c-bucketOutOfTransformation
in project 9435
on connection.keboola.com
is represented by database SAPI_9435-in_c-bucketOutOfTransformation