How can I automate checking my sql database’s data before inserting new data?
I have an API request to a database which gets triggered every morning at 9am. The api returns a json file which has data for 6 of my sql database tables. I transform the data into the correct format and do some cleaning before inputting the data into the sql database.