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


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"


  • Tableau Desktop
  • Teradata
  • Initial SQL statement


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


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?