CODEWITHSUNDEEP
sqluser-interfaceselectwhitespacesnowflake-cloud-data-platform
Vincent_Adultman
Vincent_Adultman

Reputation: 108

Snowflake automatically condenses multiple spaces located consecutively in the middle of a string when displaying results

If I run

SELECT ('ABC      DEF')

I get the following output in the Results pane:

'ABC DEF'

Note: The spaces are being condensed only for the purpose of displaying the record. It keeps all of the spaces but for some reason the browser only shows a single space.

Is there any way to alter the display so that all of the spaces show up? I have columns where records are identical except for the number of consecutive spaces in the middle and they look exactly the same when I select them. Thanks!

EDIT: In case it's relevant, I'm viewing the Snowflake UI in Google Chrome.

Upvotes: 0

Views: 1883

Answers (1)

Mike Walton
Mike Walton

Reputation: 7339

The Snowflake UI is HTML at the end of the day, so HTML naturally condenses spaces. Not a lot you can do with the current Snowflake UI, but if you switch over to the Preview App (Snowsight) that is current in Public Preview, it handles the display of spaces better. It isn't the fully functional UI that the Snowflake UI is, but it will continue to get better as Snowflake rolls out new features.

Upvotes: 2

Related Questions