Hi. I have a service principal that is set as member in my fabric workspace wherein I have fabric warehouses. In dbt cloud I have set up a connection to fabric using the SQL connection string to the workspace, port 1433, the service principal client id/secret + tenant id. I have an environment variable for the warehouse name and the variable is used under "database" in the fabric connection.
{{env_var('DBT_ENV_DBNAME')}}
This setup has worked for several months but I recently had connection issues when changing to "set to latest version" on dbt cloud.
I then tried with the same service principal but a new client secret to see if that was the issue, but I am getting "something went wrong" when trying a new connection. I am not getting it to work when reverting to 1.7 now however.
Note that the original SP secret is valid for 9 more months and I have also tried with a new secret.
I cannot see the logs since there is no log in the log window
Hi. I have a service principal that is set as member in my fabric workspace wherein I have fabric warehouses. In dbt cloud I have set up a connection to fabric using the SQL connection string to the workspace, port 1433, the service principal client id/secret + tenant id. I have an environment variable for the warehouse name and the variable is used under "database" in the fabric connection.
{{env_var('DBT_ENV_DBNAME')}}
This setup has worked for several months but I recently had connection issues when changing to "set to latest version" on dbt cloud. I then tried with the same service principal but a new client secret to see if that was the issue, but I am getting "something went wrong" when trying a new connection. I am not getting it to work when reverting to 1.7 now however.
Note that the original SP secret is valid for 9 more months and I have also tried with a new secret. I cannot see the logs since there is no log in the log window
Edit:
This was unrelated to the SP. Closing the ticket.