Changelog

Add support for json mode in column usage modal in schema tab of table detail page

• Add tabs to differentiate between unused tables and used tables in insight page.
• Add tabs to differentiate between unused columns and used columns in schema tab of table detail page.

• Add support for rollup materialized views. Create materialized views for queries sharing same source table and similar patterns to improve query performance through rollup optimization. Currently support only single-table rollup MVs.

• Make it possible to filter queries by cost and execution time before import

• Add support for filter based materialized views. Now we could create materialized views for queries sharing one or more exactly same filters and rewrite these queries to improve the performance by using filter based materialized views. Currently, the rewritten queries are for reference only due to tech limitations and we are constantly improving the accuracy of this feature.
• Show columns usages in the schema table of table detail page.

• Add sql preview feature to query list table component.
• Refine the UX of the pagination component.
• Make table columns configurable for query list table component.

• Add 'Tables Using Select *' column to query history list page.
• Show CTE definitions with Format.
• Make it possible to set storage type via the UI.

• Add general keyword search feature to query list table.

• Add 'GROUP BY' and 'ORDER BY' column usage support.
• Add 'Has Select *' column in query history list.

• Add sql line numbers to the query history table
• Add sql comparison feature
• Add CTE definition feature