Forum Discussion

bminehart's avatar
bminehart
ETL
12-10-2024

long text fields with carriage returns, tabs, and spaces

Live data model connected to Snowflake. We have some long text columns containing carriage returns and tabs. If we display these values in a table or pivot table in Sisense, the text is missing the c...
dashboards & reporting
DRay's avatar
DRay
Admin
12-13-2024

Hi bminehart,

Are you able to extract that text from Snowflake with the formatting intact using another tool? I'm trying to figure out if this is a Sisense or Snowflake limitation.

  • bminehart's avatar
    bminehart
    ETL
    12-16-2024

    Hi DRay -- we've queried Snowflake directly to see what the data look like, and Snowflake is retaining the desired carriage returns/tabs/spaces. It seems to be a problem at the presentation/dashboard layer.

    • DRay's avatar
      DRay
      Admin
      12-17-2024

      Thank you, that's interesting. I'm not able to find any resources that discuss this, so if you like I can work on finding a technical resource to work with you directly on this. Would you like me to get the ball rolling on that?

      • bminehart's avatar
        bminehart
        ETL
        12-19-2024

        Yup, please do.