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

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.

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.