Has anyone used Great Expectations, how does it compare to other testing frameworks?

Let’s see what the community has to say. Am curious too what people are using.

Great Expectations is quite focused on working in Jupyter notebooks. If you need some resources about alternatives to running GE in a Jupyter notebook, check out: • Kevin's tutorial on Pandera - + code • My take on GE: blog

And how about Soda https://www.soda.io? It is new since last year (I think). Never used it, but I have been hearing a lot from it lately…

Is there anyway to do a "cascade" drop with to_sql("replace")?

With Pandas? What do you mean by cascade drop?

@Royzac I'd say Pandas

to_sql("replace")

is a convenience method if you need to get things into a DB table quickly. But if you already have a table design with foreign keys, you shouldn't use it - you can always use append to load to a temporary table and then execute a MERGE query.