EXTERNAL DATA SOURCE should be created before views and procedures

[asos-martinsmith]

• SqlPackage or DacFx Version:
• .NET Framework (Windows-only) or .NET Core:
• Environment (local platform and source/target platforms):

Unsure - using publish in latest version of VS 2022

VisualStudio.17.Release/17.8.4+34408.163
SQL Server Data Tools 17.8.120.1

Steps to Reproduce:

1. Have the project contain an external data source - for example

CREATE EXTERNAL DATA SOURCE [MyExternalDataSource]
    WITH (
    LOCATION = N'https://MyBlobaccountname.blob.core.windows.net',
    CREDENTIAL = [ManagedIdentityCredential]
    );

2. Have a view or stored procedure reference that data source in OPENROWSET

SELECT PARQUET_DATA.SKU_ID
FROM OPENROWSET(
BULK 'mypath_*.parquet',
DATA_SOURCE = 'MyExternalDataSource',
FORMAT = 'PARQUET')
WITH (Foo bigint)
PARQUET_DATA

3. Publish the project to a Synapse Serverless database that has neither of these objects.

The Publish script creates the external data source at the end but the deployment has already failed before that point as it tries to create the proc/view that references the non existent data source and the SQL Serverless throws an error about that.

Probably the placement of the data source creation should always happen before the procedures and views are created (as they can be dependent on the data source but the reverse isn't possible)

Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio)