SYMPTOM
If a user builds a table which contains a column with spaces in the name, and then builds a View off this table. When adding the View to a project using Warehouse Catalog the following error message will be shown:
Sample Code/Error
Syntax error: expected something between the word 'xxx' and 'is' keyword
CAUSE
The View is behaving as designed from the database. The original table contained double quotes around the column in the create statement, however they were not retained when creating the warehouse table view. .
ACTION
Alter the Warehouse Catalog read settings to enclose the ColumnName variable when reading in a VIEW with columns defined containing spaces as shown below:
Sql
'"ColumnName"' COL_NAME,
Note: The specified syntax is based on Teradata databases. Contact the Database Administrator for specific SQL syntax.
