Like downloading a text or csv file from a website, load data from it to your table, a bunch of queries to validate data or remove invalid data.
Is it possible to call SQL scripts from a JAVA program? Or can this be done through batch or Python which I’m unfamiliar with.
Novice user here. What’s the usual process like? Can it be done in one press of a button?