Boost your CICD automation for Synapse SQL Serverless by taking advantage of SSDT and SqlPackage CLI

RuiCunha What is the best avenue for reporting feedback on this?

One issue I've found is that it creates the objects in the wrong order.

The publish script creates external data sources after views and procedures. But they can reference that data source and then the deployment fails as it does not exist.

I did also find another issue that when using a view as below 

CREATE VIEW dbo.MyView
AS
SELECT *
FROM OPENROWSET(
PROVIDER = 'CosmosDB',
CONNECTION = '...',
OBJECT = '...',
CREDENTIAL = 'CosmosDbCredential'
)
WITH (
col1 VARCHAR(15) COLLATE Latin1_General_100_BIN2_UTF8 '$.col1.string',
col2 bigint '$.col2'
) as rows

That I was getting an issue referencing the columns from my dbo.MyView despite it working fine in SQL Serverless itself.

But this was easy to fix by replacing the * with the explicit column names as SSDT doesn't seem to work it out from the WITH clause