TDCH template - Create Teradata Table processor and Reserved Word column names

Description

Teradata has Reserved words such as 'title' which fail when ingesting data into teradata in the "Create Teradata Table" processor.

The SQL Syntax should quote the field names so it passes and creates/inserts the data

Environment

None

Activity

Show:
Jagrut Sharma
May 10, 2018, 9:02 PM

Using quotes around name (.e.g "title" instead of title) will allow the table to be created with the reserved word as column name.

For querying such a column, the select query also has to quote it.
select title from mytable; // will not work
select "title" from mytable; // will work

This will also allow column names with spaces in them. e.g. "my title".
select "my title" from mytable; // will work

I am inclined to not support these kind of column names for Teradata tables, since it may cause downstream issues. Best to avoid them altogether at feed creation time.

Done

Assignee

Jagrut Sharma

Reporter

Scott Reisdorf

Labels

None

Reviewer

None

Story point estimate

None

Time tracking

0m

Time remaining

0m

Sprint

None

Fix versions

Affects versions

Priority

Medium