​
🚀 New Features

  • Support Branching for Oracle.
  • Add project switcher in SQL Editor.
  • Add two SQL Review rules:
    • Disallow mixing DDL and DML statements.
    • Disallow mixing different types (UPDATE, INSERT, DELETE) of DML statements on the same table.

​
🔔 Notable Changes

  • Remove Data Access Control from Workspace Settings.
    • The option to query and export at the workspace level is no longer available. Instead, make allUsers a project member with the Querier role for the same functionality.
    • The feature to prevent copying data from the SQL Editor has been moved to the environment page.
  • Update the visibility of SQL Editor Worksheets to Private, Project Read and Project Write.

​
🎄 Enhancements

  • Display failed Oracle statement line numbers.
  • Improve Snowflake syntax error messages.
  • Collect all PostgreSQL slow logs if pg_stat_statements view exists.
  • Enhance Oracle compatibility.

​
🐞 Bug Fixes

  • Correct time display for slow query logs.

​
📰 Fresh Off the Press

  • ❄️ Snowflake offers scalable compute and storage resources, with a SQL-based interface for data manipulation and analysis. Yet, when it comes to CI/CD practices, especially compared to its querying functionalities in SnowSight, various deficiencies emerge. Read more about Snowflake CI/CD Best Practices.

  • 💥 Once upon a time, a developer named John was modifying the name column in a large table and Bob, the DBA reviewed. As soon as the migration was deployed, alarms blared throughout the office. Then whose fault was it?

  • ⚙️ GitOps is a modern approach to manage infrastructure that emphasizes automation, collaboration, and continuous delivery. In this post, we are reviewing several open-source GitOps tools.