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
Activity
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.
