Build error SQL70015: Statement 'CREATE EXTERNAL DATA SOURCE' is not supported for the targeted platform.
- Dominant language
- C#
- Stars
- 460
- Forks
- 29
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 7
Description
When trying to build a Sql Database project with an External Data Source that targets a Fabric Data Warehouse:
```
CREATE EXTERNAL DATA SOURCE [dls] WITH (LOCATION = N'abfss://dls@foo.dfs.core.windows.net/')
GO
```
I get this error:
```
Build error SQL70015: Statement 'CREATE EXTERNAL DATA SOURCE' is not supported for the targeted platform.
```
However, when I run the script manually with SSMS it succeeds
it is unclear to me what version of dacfx is being used however
```
SystemDacpacsLocation="\\.vscode\\extensions\\ms-mssql.sql-database-projects-vscode-1.5.6\\BuildDirectory"
```
Note: the file version of the dacfx dll file in the above folder appears to be **170.2.70.1**
- SqlPackage or DacFx Version: 170.1.61.1
- .NET Framework (Windows-only) or .NET Core:
- Environment (local platform and source/target platforms):
(DacFx/SqlPackage/SSMS/Azure Data Studio)
Contributor guide
Research direction
Start by reproducing the build in the SQL Database Projects VS Code extension 1.5.6 using the shown CREATE EXTERNAL DATA SOURCE statement against a Fabric Data Warehouse. Compare the reported DacFx versions 170.1.61.1 and 170.2.70.1, and verify whether the build accepts the statement or clearly reports the supported platform behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, vscode
- Domain
- build-system, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100