microsoft / microsoft/DacFx

Build error SQL70015: Statement 'CREATE EXTERNAL DATA SOURCE' is not supported for the targeted platform.

Open
#750 4 comments 0 reactions 0 assignees View on GitHub
bug sqldw
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.