add more default rule types

[thinhha]

We should be able to implement all of dbt's schema tests as CUSTOM_SQL_STATEMENT. There may be other rules we can implement from https://docs.greatexpectations.io/en/latest/reference/glossary_of_expectations.html#dataset.

We should consider how to allow rules that reference multiple tables using references to tables (with overrides). The current alternative is to parameterize the table names.

It it make sense we may want to implement the rule directly in https://github.com/GoogleCloudPlatform/cloud-data-quality/blob/main/clouddq/classes/rule_type.py

[thinhha]

more default rule types we can add:
https://github.com/calogica/dbt-expectations

[bogo96]

hi, i wonder if you have plan to supporting dbt-expectations? Such as using dbt-expectations rules inside configs/rules.
If not, can i make issue with details and go for it?

[thinhha]

Hi @bogo96 please go ahead! I suggest adding integrations tests like below however I'm happy to collaborate with you on this :)
https://github.com/GoogleCloudPlatform/cloud-data-quality/blob/main/tests/integration/test_advanced_dq_rules.py