dbt test command generates sql code with schema 'dbo'

Help
1

I run a command dbt test and gets error because I don’t have access to dbo schema.

 Database Error in test ... (models/sources.yml)
  ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The specified schema name "dbo" either does not exist or you do not have permission to use it. (2760) (SQLExecDirectW)')

Generated code (from here …/target/run/models/sources.yml/test.sql) contains dbo schema for a temporary view

    EXEC('create view 
      dbo.testview_3707
     as  .....

There is the only ‘dbt’ schema In my profiles.yml and all models are correctly created there.

How to change the dbo schema to dbt?

2

Solved
They wrote dbo in a template, Changed it to {{target.schema}}, it works

image
image913×477 35.5 KB

3

This is unclear , how do i actually change the test views Schema?

4

Did you manage to solve this error ?

5

I solved it by changing the file ......site-packages/dbt/include/fabric/macros/materializations/tests/helpers.sql

I replaced dbo.testview_{{ range(1300, 19000) | random }}to {{target.schema}}.testview_{{ range(1300, 19000) | random }}