Skip to content

Tag: validation

What is the value of schema tests in dbt?

When would you want to use a dbt schema tests (unique, not_null, accepted_values, & relationships) when you could instead use SQL schema constraints? For example, here are some SQL schema constraints that could replace each of the dbt schema tests: unique: UNIQUE constraint not_null: NOT NULL constraint accepted_values: FOREIGN KEY constraint to a lookup table relationships: FOREIGN KEY constraint to

ORA-01861: the value does not match the format string

I have this External Table: I created this function to return the week number of the year If I only run the function it tells me that everything has been compiled. But when i run the SELECT it gives me the following error: [I enter the dates like this: ‘2020/01/01’ but sql-developer on the control query shows them to me