I am using IntelliJ and its database plugin to export data from a table on one database to a table on another database.
The tool works brilliantly, but I need to perform this task repeatedly.
Is there a way I can automate this so that it runs according some some schedule, of say, once a day?
I'm happy to code this up in Python, but I don't want to have to re-invent the tool.
There is no such functionality as database jobs which could be run by the schedule in DataGrip itself. But there is a Macros functionality which you can try: when you record repetitive procedures you do frequently to automate it and then execute them easily (from the Menu or via the shortcut).