-
Notifications
You must be signed in to change notification settings - Fork 26
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Dbt test not testing on custom schema #180
Comments
@dbtFabricator , are you seeing tests that use views failing? This might not be the solution you are looking for, please test and let me know. Thanks for providing the repro. I will repro this and see if I can make this easy in the future releases. |
Hi again, it seems like it. I re-ran dbt test on keep at latest which I assume is v.1.8.6, correct me if Im wrong. See attachment for example at row 7040->7079. Generic test
Singular test
|
@dbtFabricator , Yes because Fabric does not support different types of CTE, adapter currently wraps ephermal with a view but this does not work 100% at this time. Once nested CTE support is available, I will update the adapter to support the scenarios you are testing. For now, please stand-by. I will not close the issue yet. |
@prdpsvs - we just started receiving the same errors on our tests. We were on the adapter version 1.8.7 and had no issues at all with dbt core. We are working on moving to dbt cloud, which seems to be on a newer version of the adapter (1.8.8) and the same tests are failing now. ('42000', '[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The specified schema name "tests_schema" either does not exist or you do not have permission to use it. (2760) (SQLExecDirectW)') Any thoughts? |
After upgrading to 1.8, i.e. latest version on dbt cloud, the tests seem to have stopped running correctly on my schema when I run on my production environment. This worked as intended in 1.7. It works fine on 1.8 in the dev environment.
Some tests seem to pass correctly and some don't, I haven't been able to find a pattern.
Note:
I am using https://docs.getdbt.com/docs/build/custom-schemas, under macros/generate_schema_name.sql, however it seems to apply the tests on the generated schemas so not sure if it is related at all.
Some examples of tests in my models.yml file:
debug (34).log
console_output (16).log
The text was updated successfully, but these errors were encountered: