Release 2.0.100

  • Add a new tab in table action center to show most commonly used filter conditions that are not included in the query stats but can be deduced from queries.
  • Show table related views in table insight page.
  • Show table related views in the source table section of query history page.
  • Show progress of ongoing import jobs in settings page.

Release 2.0.98

  • Add 'Suggestion' column to query/table insight page linking to action center of query/table detail page.
  • Allow to use special characters to do keyword search.
  • Render time related data such as 'CPU Time', 'Total Execution Time' in a more user friendly way.

Release 2.0.97

  • Enable users to highlight views in the sql editor of query history detail page.
  • Implement action center in table detail page:
    • Use a table to show most commonly used filter conditions so users could generate materialized views for them to speed up queries and reduce the cost.
    • Use a table to show most commonly used json column fields so users could generate materialized views for them to speed up queries and reduce the cost.
  • Refine the query action center by highlighting sqls of suggestions.
  • Enabled users to view unparsed queries(Unparsed quereis include queries that are excluded by the filter sql of an import and queries that we fail to parse during an import).
  • Handle failed imports in a more elegant manner:
    • Show Failure status properly in import job list.
    • Enable users to restart a failed import.

Release 2.0.96

  • Enable users to highlight high cost tables in the sql editor of query history detail page:
    • High cost table would be marked in orange color.
    • The editor would auto scroll so the high cost table is at the middle of the view port.
  • Enable users to view query history detail of queries that have not been imported from the preview table of the import flow.
  • Highlight attribute field at the action center of query history detail page as JSON.
  • Change layout of numeric fields in all tables to right aligned

Release 2.0.95

  • Show scan cost in query detail page.
  • Add action center to query detail page, which can show some useful suggestion to optimize query, like creating mv for high scan cost table, remove duplicates for explosion join and so on.
  • Revamp the import flow to make it more intuitive.

Release 2.0.94

  • Add unit to bytes.
  • Display row count in a more friendly way.
  • Add scan cost to insight page.
  • Add an explanation section about fields that can be used to filter queries before import.
  • Add a checkebox in simple mode of import modal to enable users to exclude queries whose signatures have been imported in this month already.
  • Use consistent UX to display covered queries in materialized view detail page.

Release 2.0.93

  • Allow users to specify a name for an import.
  • Allow users to add a description to an import.
  • Enable users to write SQL directly to filter queries for an import.
  • Enhance the logic for generating similar filter groups.
  • Optimize the performance of the query list component.

Release 2.0.92

  • Refined the algorithm for forming Similar Filter Groups.
  • Added JSON mode support to Similar Filter Groups.
  • Added JSON mode support for "JOIN" column usage in the table detail page.
  • Added JSON mode support for "GROUP BY" column usage in the table detail page.
  • Added JSON mode support for "ORDER BY" column usage in the table detail page.

Release 2.0.91

  • Add JSON mode to the "Where" column usages in the Schema tab of the Table Detail page.
  • Enable sorting by column and unused column in the Insight page.

Release 2.0.90

  • Turn on json mode by default
  • Add column level to the column usage modal
  • Do not do dedup in leaf node levels
  • Enable the user to go directly to query detail page by clicking the leaf node
  • Refine the table headers in schema tab of table detail page