[Snowflake] Column sorting in left Panel

m0mo · January 6, 2022, 12:51pm

Issue Summary

Hi, we recently switched from Redshift to Snowflake and it turns out that in the schema/table explorer the columns are shown completely unordered. With Redshift we were used that it would provide the same column ordering as defined in the table. It this something we can fix our own? e.g. by adjusting the meta data fetching query ourselves?

Any hint is greatly appreciated, thank you!
Stephan

Technical details:

Redash Version: 8.0.0+b32245 (a16f551e) (we know it is outdated, but we will switch to SuperSet soon and just need to remain a stable environment until the switch can happen)
Browser/OS: Chrome
How did you install Redash: via docker on EC2

jesse · January 19, 2022, 8:38pm

Yes you can edit the schema fetching code for the Redshift query runner. It probably needs an ORDER BY clause to accomplish your need.

github.com

getredash/redash/blob/e28e4227bf11b0688dc9646579647455fade419f/redash/query_runner/pg.py#L374-L404

    
      
          # Use svv_columns to include internal & external (Spectrum) tables and views data for Redshift
          # https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_COLUMNS.html
          # Use HAS_SCHEMA_PRIVILEGE(), SVV_EXTERNAL_SCHEMAS and HAS_TABLE_PRIVILEGE() to filter
          # out tables the current user cannot access.
          # https://docs.aws.amazon.com/redshift/latest/dg/r_HAS_SCHEMA_PRIVILEGE.html
          # https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_EXTERNAL_SCHEMAS.html
          # https://docs.aws.amazon.com/redshift/latest/dg/r_HAS_TABLE_PRIVILEGE.html
          query = """
          WITH tables AS (
              SELECT DISTINCT table_name,
                              table_schema,
                              column_name,
                              ordinal_position AS pos
              FROM svv_columns
              WHERE table_schema NOT IN ('pg_internal','pg_catalog','information_schema')
              AND table_schema NOT LIKE 'pg_temp_%'
          )
          SELECT table_name, table_schema, column_name
          FROM tables
          WHERE

This file has been truncated. show original