top | item 36188491

(no title)

westonOG | 2 years ago

How does this work when you need to test your script against multiple databases and multiple schemas? Is this for an enterprise size application?

discuss

order

quickthrower2|2 years ago

I am interested in your use case where you have a situation with multiple databases, possible with different schemas, where you want to run the same sql on all of them. Maybe some kind of data lake? I have not come across this. But admittedly I have not worked in enterprise (I take to mean thousands of employees)

westonOG|2 years ago

In enterprise environments this is pretty common. I've worked at places with over 100 developers and 30 testers. So you have a situation with hundreds if not thousands of databases and then multiple schemas in each database. So imagine trying to manually validate if your script will work on all those databases and against all those schemas. How difficult of a task that is.