Hello guys, I would be really interesting if you support the schema tests using a json file outside the model yml file, so we can have the model's schemas in another directory.

Hi @Jorge Gomez Moreno, thanks for reaching out. I'm not exactly sure I understand. Could you please elaborate a ibt?

Hello @Elon Gliksberg! for us it could be quite interesting the possibility to have the schemas in a separate json file (instead of inside the yml file where the model is documented) and create inside the YML file something like schema_path = "whatever_schema.json"

Got it, thanks for explaining. The problem is that at the moment dbt doesn't enable dbt packages to read files from the file system aside from dbt configuration files such as the YAMLs. Therefore, we wouldn't be able to read the JSON files that are in your project. However, you might be interested in the

schema_changes

test that does not require you to define the schema. It works by comparing the schema of the table to its previous state when the test was ran. More information can be found here.