Custom SQL Data Asset

GX Core Support
1

I am trying to run some expectations on a table - these expectations reference more than one table (example - table a column a only has values that exist in table b column b) is there a way to do this natively within great expectations.

Moreover I would like to create custom data assests using SQL joins is there a way to do this?

2

Hello! You can use a join in UnexpectedRowsExpectation and it will work as long as the joined table is accessible using the credentials known by the Data Asset. More info here