White Space is Added to Custom SQL Queries

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


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.


  • Tableau Desktop 10.3.0-10.3.3
  • Custom SQL queries


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.



This behavior is related to known issues (IDs: 659319 and 686741) that has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?