❓ // Flipside & Snowflake Tutorials

    Struggling to write handle the nuance of writing Snowflake queries? Don't worry. Here is my guidebook of all the notes I have needed in the time of writing queries on Flipside.

    Loading...

    Getting unexpected characters in a row output?

    You can simply replace characters by following Snowflake syntax with:

    REPLACE(str, chr(index), '')
    

    SQL uses unicode definition for characters.

    You can find the index-key on the list above or alternatively write a Snowflake query like this one 👉

    You can generate example outputs of given character indexes with:

    SELECT
      column1,
      CHR(column1)
    FROM
      (
        VALUES
          (83),
          (33),
          (169),
          (8364),
          (0),
          (null)
      );
    

    Want to use a custom theme on your dashboard?

    You can control the styling of your dashboard with a simple <style> tag.

    .wmde-markdown[data-color-mode*=dark] .wmde-markdown-var, .wmde-markdown[data-color-mode*=dark] .wmde-markdown { 
    --color-canvas-default: #0A0012;
    }
    
    .dark .dark\:bg-gray-90, .dark .dark\:bg-\[\#1A1919\] { 
    background: #0A0012;
    }
    
    .wmde-markdown pre { 
    background: #000;
    }
    
    div[data-projection-id="1"] {
    background-image: radial-gradient(circle at center center, #212121 16%,  rgb(10, 0, 18) 17%) !important;
    }
    
    Custom Dashboard Themes
    Replacing Unicode Characters