The problem I’m having
I dont see a way to connect to SQL Server from dbt CLoud (only Fabric etc) - I can see articles on how to do it with dbt Core locally but not running dbt cloud.
We currently have a bespoke data warehouse that uses SQL Server and we’d like to avoid making the jump to a lakehouse type product at the moment but would like the features that dbt Cloud offer. Is this possible whilst we stick with with Azure SQL Server?