[SQL] Output numbers with comma separation in snowflake result set

I'm working with SQL queries in Snowflake. I'm able to work in the browser (chrome), or on SQLWorkbenchJ. I'm comfortable with both, but prefer the browser.

I'm working with moderately large numbers, up into the hundreds of billions (10^8), so it would be really helpful if I could make the program print my numbers with comma separation for the thousands (e.g. 12,345,678,901.00 vs. 12345678901.00).

I've looked into the documentation on format models here https://docs.snowflake.com/en/sql-reference/sql-format-models.html but I can't see an option to output in the style I'm looking for.

Even besides that, I would really prefer to implement this as a configuration to the interface itself rather than code I apply to my queries.

Continue reading...