Hi, i tried the constraints option like that :
the film_id has no nulls but it didn't abort
also the rating data has "PG" in the data and still it run successful
---------------------------------------
source: sakila_duck
target: sakila_db
defaults:
object: 'stg.{stream_table}'
mode: full-refresh
streams:
main.film:
columns:
rating: string | value in ('PG', 'PG-13', 'R', 'NC-17')
film_id: int | value is null
env:
SLING_THREADS: 1
SLING_ON_CONSTRAINT_FAILURE: abort