White Space is Added to Custom SQL Queries

KNOWLEDGE BASE

White Space is Added to Custom SQL Queries

Published: 23 Aug 2017
Last Modified Date: 17 Aug 2020

Issue

When using a custom SQL query and changing the data type of a field to Date or Date & Time, then Tableau Desktop inserts carriage returns to the beginning and ending of the custom SQL query.

Environment

Tableau Desktop 10.3.0-10.3.3
Custom SQL queries

Resolution

Option 1

Convert fields to the date data type in the custom SQL query rather than in the Tableau Desktop interface.

Option 2

Upgrade to Tableau Desktop 10.2.5, 10.3.3, 10.3.4 or 10.4.1 or later and only convert fields to the date data type on live connection before extracting the connection. For more information, see Upgrading Tableau Desktop in Tableau Help.