Does Fivetran Integrate With any Data Profiling or Validation Tools?

Question

Does Fivetran integrate with any data profiling or validation tools?

Environment

All transformations

Answer

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.