sql database project failed to build Method not found: Microsoft.SqlServer.TransactSql.ScriptDom.ViewHashDistributionPolicy.get_DistributionColumns()

[ashdhalama]

sql database project failed to build Method not found: Microsoft.SqlServer.TransactSql.ScriptDom.ViewHashDistributionPolicy.get_DistributionColumns()

[kisantia]

@ssreerama fyi

[hettic1]

Same error here and in Visual Studio 2022 it builds successful.
To be precise. I'm using Azure Data Warehouse as my target platform.

stdout: c:\Users.....vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018: The "SqlBuildTask" task failed unexpectedly. [c:\Users\dev_gvanolst\source\repos\Edw.Datawarehouse\Edw.Datawarehouse.sqlproj]
stdout: c:\Users.....vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018: System.MissingMethodException: Method not found: 'System.Collections.Generic.IList`1<Microsoft.SqlServer.TransactSql.ScriptDom.Identifier> Microsoft.SqlServer.TransactSql.ScriptDom.ViewHashDistributionPolicy.get_DistributionColumns()'.

Version: 1.86.0 (user setup)
Commit: 05047486b6df5eb8d44b2ecd70ea3bdf775fd937
Date: 2024-01-31T10:28:19.990Z
Electron: 27.2.3
ElectronBuildId: 26495564
Chromium: 118.0.5993.159
Node.js: 18.17.1
V8: 11.8.172.18-electron.0
OS: Windows_NT x64 10.0.19045