sodadata
Test referential integrity
Is your feature request related to a problem? Please describe. I would like to be able to run "relationship tests". A relationship test is a test that involves 2 tables. The main use case is for running referential integrity tests.
Modern DWH, such as Redshift and Snowflake, does not enforce constraints, so having the ability to check if a value in column of one table exists in a column on another table would be of great help!
I do not have a solution in mind, but we could take inspiration from dbt_utils package.
@AlessandroLollo I'll narrow this issue down to 1 use case: referential integrity. If you have other use cases in mind, feel free to create separate issue(s) for that.
