I use SQL most of the time to clean up the data, transform it, and then push it into the database. We extract data from apps and from websites using a lot of applications. We do that using Python. We used Outlook before to pull data from, the source and then log into Snowflake.
The Nomo, select form, and so on are the most valuable features. We do a lot of stuff with CDL, and a CTE. We do this to structure SQL in such a way that is a bit reasonable and easy to read.
Downtime issues should be improved.
I have been using SQL Power Data Quality for four years.
There is some downtime, but most of the time the solution is stable.
It is a scalable solution. Presently, five to twenty workers are working on the solution.
I previously used Alteryx.
The initial setup was seamless.
It is a very good solution and I recommend it. I rate the overall solution an eight out of ten.