[Snowflake] Column sorting in left Panel

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!

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
1 Like

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