jhoolachan

Results 5 comments of jhoolachan

dbt run fails with "The specified schema name userid@domain either does not exist or you do not have permission to use it

@swanderz I'm using Azure SQL and my profiles.yml is below: ``` azure-sql-demo: target: dev outputs: dev: type: sqlserver driver: 'ODBC Driver 17 for SQL Server' server: {server} port: 1433 database:...

dbt run fails with "The specified schema name userid@domain either does not exist or you do not have permission to use it

The guide is great; thanks for that! I was able to successfully connect via the CLI auth but I'm still facing the same error. My updated profile.yml is below. ```...

dbt run fails with "The specified schema name userid@domain either does not exist or you do not have permission to use it

1. Nope, neither my userid or company domain are present in the profiles.yml - but those are the credentials I use during authentication 2. dbt debug looks good ``` Running...

dbt run fails with "The specified schema name userid@domain either does not exist or you do not have permission to use it

1. Edited: I can see `master` but have specified a different DB in my profiles.yml 2. I cannot. Per our cloud team, the only login we can use in SSMS...

dbt run fails with "The specified schema name userid@domain either does not exist or you do not have permission to use it

Ah! Running `CREATE SCHEMA new_schema` in SSMS fails with the same error. I forgot that I need to add `CREATE SCHEMA new_schema AUTHORIZATION {DB user}` where {DB user} is the...