How to Use Great Expectations for Data Quality Checks with Airflow

Поділитися
Вставка
  • Опубліковано 5 лис 2024

КОМЕНТАРІ • 25

  • @joaovitoralmeidaaraujobelc6993
    @joaovitoralmeidaaraujobelc6993 5 місяців тому +1

    Very simple video with excellent explanation and not overcomplicating things. Thanks for sharing it!

  • @roopashastri9908
    @roopashastri9908 3 місяці тому +1

    Great explaination!Any thoughts on how we can save the great expectation results in the Database?

    • @thedataguygeorge
      @thedataguygeorge  2 місяці тому

      I would configure the expectation results storage location to be a bucket and then have a pipeline that takes the expectation results and stores them in a database

  • @VarunDeep-x5j
    @VarunDeep-x5j 21 день тому

    Hi - Thanks for sharing this video. When I tried running it, I kept getting errors like "raise gx_exceptions.DataContextError(
    great_expectations.exceptions.exceptions.DataContextError: expectation_suite strawberry_suite not found". During a deep dive into the code, i found there is a condition "self.expectations_store.has_key(key)". I am missing something concerning the store.?

  • @BubbaB2323
    @BubbaB2323 Рік тому +1

    Very useful bud. Thank you.

    • @thedataguygeorge
      @thedataguygeorge  Рік тому +1

      No problem, do it all for you!

    • @BubbaB2323
      @BubbaB2323 Рік тому +1

      @@thedataguygeorge will reach out on the side to talk shop if that's cool, loving your work.

    • @thedataguygeorge
      @thedataguygeorge  Рік тому

      Always cool!

  • @roopashastri9908
    @roopashastri9908 3 місяці тому +1

    On failure of great expectation validation, would this raise alerts?

    • @thedataguygeorge
      @thedataguygeorge  3 місяці тому

      Yes as long as you have Alerts configured for your Airflow DAG

  • @roopashastri9908
    @roopashastri9908 3 місяці тому +1

    Also how can we automate the threshold changes with the changing business needs?

    • @thedataguygeorge
      @thedataguygeorge  2 місяці тому

      You'd want to have another helper pipeline that checks for changing business requirements and then either alerts you or makes adjustments

  • @roopashastri9908
    @roopashastri9908 3 місяці тому

    Also can we include more than one expectation in the expectation file?

  • @LucasGomes-q9t
    @LucasGomes-q9t 3 місяці тому

    On minute 3:57 how could create the default file of great_expectations? I created the json but I got a blank one.

    • @thedataguygeorge
      @thedataguygeorge  2 місяці тому

      You then just fill out that json with all the expectation info you want!

  • @criistiina71
    @criistiina71 3 місяці тому

    May I know if, we can create our own expectations. If I have a expectations who is not in the script that is on the documentation Could I create my own one?For Example, if one column is created from a formula and used a diferent database Could I create a expectation of who makes the math?
    Hi, from Colombia :)

    • @thedataguygeorge
      @thedataguygeorge  2 місяці тому +1

      Definitely can create your own expectations, honestly one of the best features of great expectations!

    • @criistiina71
      @criistiina71 2 місяці тому

      @@thedataguygeorge Do you have a video-tutorial where you’re teaching how to connect GX with Databricks? 😊

  • @karangupta_DE
    @karangupta_DE Рік тому +1

    Hi, do you prefer soda or great expectations?

    • @thedataguygeorge
      @thedataguygeorge  Рік тому +1

      I've only recently started using Soda so I'm not sure if I have enough experience to form a definitive opinion, but I have definitely enjoyed the UX much more so far, SCL is a lot more human readable than great expectation "expectations" imo

  • @maheshbhatm9998
    @maheshbhatm9998 9 місяців тому +1

    Thank You

    • @thedataguygeorge
      @thedataguygeorge  9 місяців тому

      No worries, let me know if there's any other videos you'd like to see!