Edit on GitHub
Does Fivetran Integrate With any Data Profiling or Validation Tools?link
Questionlink
Does Fivetran integrate with any data profiling or validation tools?
Environmentlink
All transformations
Answerlink
Yes, we recommend using dbt. Using dbt's dbt-expectations package, you can apply tests to your data to assess the following:
- Table shape
- Missing values
- Unique values
- String matching
- Aggregations
- Distributional functions
- Comparing columns
- Column values in a set and/or range
These tests provide a better view of your data and ensure you see the data you expect.