Changelog

Changed

• Added support for removing a group of connections from the explorer, as well as removing a single connection from a group in the explorer.
• Switched to a universal build. Binary packages will be downloaded as needed instead of being included in the extension.
• Added cloud providers to the connection picker.

Fixed

• Postgres databases in some cases were not displaying results.

Changed

• Added support for materialized views (Postgres and BigQuery). #214
• Added cmd/ctrl+r to refresh the results (if enabled). #250
• BigQuery: Added support for editing functions, ADC authentication. #159

Fixed

• Fixed a bug when the file system could not be read. #218
• Show correct icons when opening views and materialized views.

Changed

• Updated SQLite driver.
• Results can now render hundreds of megabytes of data.

Fixed

• MySQL/MariaDB connections were not using the connection timeout setting.
• MySQL/MariaDB connections would not show the correct error message when the connection failed.
• MySQL/MariaDB connections show better SQL errors.

Changed

• Added BigQuery support (in Beta). #159
• Added cmd/ctrl+s to save all changes in the grid. #215
• Added the connection color to tab icons where applicable. #72

Fixed

• Result saving was being incorrectly enabled if a single change was made, and then another change made which resulted in the original value. #210
• Undo/Redo keyboard shortcuts when multiple result tabs were visible in the DBCode panel where applying to all result tabs.

Changed

• Added Azure cloud provider, supports Azure SQL, Azure Postgres and Azure MySQL via Microsoft Entra ID authentication.
• Added support for Microsoft Entra authentication to Azure SQL connections.

Changed

• Added a new command to the database context menu to execute SQL files on a database. #162
• Reduced logo size in activity bar.

Fixed

• Fixed error with hovering a procedure name in the editor that does not have parameters. #184
• Postgres: Added the pseudo types to introspection. #163
• Postgres: Added support for composite types. #164

Changed

• Added Entity Relationship Diagram option to the context menu of individual tables, filters the initial display to that table and it’s related tables. #134

Fixed

• Revised URL handling for file paths on auto discovery. #152 #156
• ERD was not loading when a column type was not matched to a type from the schema. #153

Fixed

• Snowflake now supports Key Pair Auth #113
• CoPilot will now quote identifiers in case sensitive dialects #154

Changed

• Snowflake supports full introspection, and procedures are now supported.

Fixed

• Handle urls that cannot be parsed in autodisovery and manual discovery. #152

Changed

• Updated Snowflake connections to support SSO, Warehouse, and Secondary Roles. #113
• Updated Redshift to the new introspection model. #146

Changed

• Updated MySQL/MariaDB to new introspection model. #145 #132 #122

Fixed

• MySQL/Maria null dates (0000-00-00) were causing a results not to render. #137
• Notebook results windows were incorrectly sized. #144

• Added preview support for IBM DB2
• Added a completion item to include all fields in a table when typing table.*

Fixed

• Result columns are now resized sooner to avoid the flash of resizing on initial loading.
• Result columns can now be dragged as wide as needed.

Changed

• Added support for MotherDuck. #136

Fixed

• Fixed Snowflake schema to default to public.

Changed

• Added support for MySQL 5.7.
• Added a filter option to connections to filter schemas and databases in the explorer.