- 最新
- 最多得票
- 最多評論
Is there a way to run a stored procedure on a schedule?
Not within Redshift itself.
You need to configure an external system, such as an EC2 instance, to regularly connect to and issue your SQL on the Redshift instance.
This is usually done with a crontab and something like a Python script.
A stored procedure can be called programmatically; it's just an SQL statement, like any other. If your queries run correctly without needing the functionality of a procedure, there's no particular need to make a procedure. Just issue your SQL from Python.
May I know if you were able to setup your SQL scripts/ stored proc run on a schedule?
I have a similar scenario and looking for options to achieve it.
Thanks,
Patravik
AWS Glue provides time based scheduling of jobs. You could use a small Python script to connect to Redshift and call the Stored Procedure.
• Time-Based Schedules:https://docs.aws.amazon.com/glue/latest/dg/monitor-data-warehouse-schedule.html
• Adding Python Shell Jobs: https://docs.aws.amazon.com/glue/latest/dg/add-job-python.html
You can also schedule events with Amazon EventBridge. Redshift is not currently an EventBridge target however you can invoke a Lamba function which calls the Redshift Stored Procedure.
• Tutorial: https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/RunLambdaSchedule.html
Thanks for the response. I created a sample stored proc through Redshift query editor but do not seem to find where to access it from. Is there a place where I can see the list of stored procs created?
I also responded to your post on that here: https://forums.aws.amazon.com/thread.jspa?threadID=310998&tstart=0
相關內容
- 已提問 6 個月前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前