Schedule a job with DataGrip
Hi there,
I am using DataGrip postgreSQL against an Amazon Redshift database.
I was looking to schedule a job to run each morning at 8am. The job is running a very basic SQL script. What is the easiest/most seamless way to accomplish this? Can you point me to any instructions? Thank you kindly.
For what it's worth, the query is below:
select month,count(*) as distinct_month
into table.table
from table2.table请先登录再写评论。
Hi,
Unfortunately, DataGrip does not support scheduled tasks.
You can try to find some useful information here https://www.quora.com/Are-there-any-scheduling-tools-available-for-AWS-redshift
I am planning to do the same but I am using the DataGrip as the client for our SnowFlake Data Warehouse. Is there a way to schedule a job to run a saved SQL script? What is the easiest/most seamless way to accomplish this? Can you point me to any instructions? Thank you!