KNOWLEDGE BASE

Error "Data definition not valid unless solitary" When Connecting to Teradata and Using Initial SQL query


Published: 04 Jan 2018
Last Modified Date: 24 Apr 2018

Issue

When connecting to Teradata data source when using an initial SQL query in "Query Banding and Initial SQL" in the connection window, the following error might occur if there are extra spaces into the Initial SQL statements: 

"Data definition not valid unless solitary"

Environment

  • Tableau Desktop
  • Teradata
  • Initial SQL statement

Resolution

Option 1

Upgrade to Tableau Desktop 2018.1. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

Review the Initial SQL statement and remove trailing spaces before all crlf (carriage return - line feed) outside brackets

Cause

This behavior is related to a known issue (ID: 725088) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?