flipside

    Try Quests to earn cryptoTry Quests to earn crypto
    Share

    Flipside Cheat Sheet - Format Number in Table

    Turning ugly default number in table into beautiful formatted and sortable number Based on SnowflakeSQL docs. Read more here: https://docs.snowflake.com/en/sql-reference/sql-format-models If you have any questions, please reach me on X at 0xTraevon

    Loading...

    📌 Volume --> Volume with separator:

      TO_VARCHAR(volume, 'FM999,999,999,999')

    📌 Volume --> Volume with separator and $ sign:

       TO_VARCHAR(volume, '$999,999,999,999')

    📌 Volume --> Volume with compact short:

         CASE
     WHEN volume >= 1000000000 THEN '$' || ROUND(TO_VARIANT(volume / 1000000000),4) || ' B'
     WHEN volume >= 1000000 THEN '$' || ROUND(TO_VARIANT(volume / 1000000),4) || ' M'
     WHEN volume >= 1000 THEN '$' || ROUND(TO_VARIANT(volume / 1000),4) || ' K'
     ELSE TO_VARIANT(volume)
     END AS formatted_volume