There have been many occasions where I need to replicate a SQL query that a Data Analyst has used for a report in an external system using the same tables that I can access using the Databricks connector.

However, replicating this query and translating it into a Data Designer is extremely time consuming and doesn’t always produce the same results due to limited functionality in formula field and case statement functions.

Can we just open up a SQL query builder feature in Gainsight for the Databricks and/or Snowflake connectors?