- Más nuevo
- Más votos
- Más comentarios
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
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace un año