- Implemented a safeguard against concurrent connection attempts to Snowflake.
- Added support for User / Password + DUO MFA authentication method.
- Environment variables now sourced from
.envfiles and VS Code'sterminal.integrated.env.<platform>setting. - Resolved Python location detection issue.
- Corrected column definition in
referenced_tablesforINFORMATION_SCHEMAtables:jobs_by_user,jobs_by_project,jobs_by_folder,jobs_by_organization. - Introduced quick actions for resolving dbt dependencies and authentication issues.
- Extended go-to-column functionality to recognize column aliases and locate columns in additional areas within the SELECT statement, as well as in external models.
- Enabled column autocompletion within CTEs.
- Optimized preview load time by skipping model compilation on first open event if project is already compiled.
- Added support for the following Snowflake functions:
grouping,decode,iff,nvl,nvl2,regr_valx. - Resolved an issue where false positives occurred during arithmetic operations with the Snowflake VARIANT type.
- Improved errors handling.
- Introduced a feature to display previews utilizing model configuration values for refs. It can be useful for users who separates dev and prod environments. To use, right-click and select
Use schema from config for refsfrom the context menu in the Preview editor.
- Supported double quoted names for Snowflake.
- Added
CONTAINS_SUBSTRfunction. - Fixed
ModuleNotFoundError: No module named 'dbt.adapters.bigquery'error. - Update ZetaSQL version.
- Fixed compilation issue when using dbt 1.6.0.
- Updated setting description.
- With this release, we have integrated a syntax analyzer for Snowflake projects. This addition will help users to identify errors and use the SQL to ref conversion, go to definition and auto-completion features within Snowflake dbt project. You can disable this feature using the
WizardForDbtCore(TM).enableSnowflakeSyntaxChecksetting if needed.
- Fixed the issue with specific UDFs in BigQuery.
- Improved Snowflake compatibility by returning columns in the correct order.
- Set snowflake-sql type for Snowflake preview, ensuring accurate syntax highlighting.
- Expanded Snowflake support to include additional syntax.
- Enabled support for BigQuery JSON functions.
- Updated the functionality of the "Analyze current project" button (🔄). Clicking it now cancels any ongoing compilation/analysis and initiates a new one.
- Added support for semi-structured data functions in Snowflake.
- Added support for Snowflake cast operator (
::).
- In this release, we've introduced a new setting,
WizardForDbtCore(TM).enableSnowflakeSyntaxCheck, which is turned off by default. When activated, this setting enables syntax checks for Snowflake dbt projects. As a result, any errors within models will be detected and displayed. Please note that this is an experimental feature and may not be entirely reliable. It could potentially yield false positive errors, indicating issues where there are none.
- Enabled JSON functions.
- Resolved an issue where the extension would unexpectedly restart during code editing.
- Fixed an error that occurred while compiling the project for adapters other than BigQuery.
- In this release we override
get_columns_in_relationto work with code and not with BigQuery dataset directly. It should help to decrease false errors you could see when using dbt macros that access information schema.
- Added support for jinja filters in
profiles.yml. - Added support for
_file_namepseudo column in external tables.
- Got rid of the warning asking about accepting incoming network connections.
- Resolved crash issue for linux-arm64 and macOS 11 platforms.
- Resolved crash issue in Visual Studio Code 1.78.0.
- Resolved false errors that occurred when switching between branches.
- Added compatibility with dbt 1.5.0.
- Enhanced OAuth error message for better clarity.
- Resolved "No connection established" error occurring when running on WSL with Ubuntu 20.04.
- Display only a single dbt-related error, if present.
- Added support to install specific versions of dbt-core and dbt adapters.
- Show progress during dbt package installation.
- Resolved the issue with re-authentication when using oAuth BigQuery configuration.
- Removed dbt-rpc support as it is being deprecated soon.
- Fix empty preview issue.
Full Changelog: https://github.com/fivetran/dbt-language-server/compare/v0.21.0...v0.21.2