I have a SSDT project that deploys to Azure SQL DB. Recently I added an external table. This required an external data source as follows:
CREATE EXTERNAL DATA SOURCE [data_warehouse] WITH ( TYPE = RDBMS, LOCATION = N'mydb.database.windows.net', DATABASE_NAME = N'MainDW', CREDENTIAL = [dw_reader] );
When I import this into my .sqlproj, it complains the credential isn't there, and then when I add that it complains the master key isn't there. The problems is I don't want to store those secrets in the SSDT project. How do I store dummys, or defaults that can be overridden and retrieved from the azure keyvault or other method of storing secrets in Azure Decops?