I would like to run a basic query at 8am everyday, preferably using the Jetbrains Datagrip IDE.
The query is irrelevant, but here it is for illustrative purposes:
select month,count(*) as distinct_month
into table.table
from table2.table
What are the steps required to schedule this job. For what it's worth, I'm query against an AWS Redshift database. Thank you.