9952 explained code solutions for 126 technologies


amazon-redshiftHow can I create and manage Amazon Redshift jobs?


Creating and managing Amazon Redshift jobs is accomplished by using SQL queries and the AWS Management Console.

  1. Create a SQL query to define the job:
CREATE TABLE my_table (
  id INTEGER NOT NULL,
  name VARCHAR(50)
);
  1. Schedule the job using the AWS Management Console:
  • Log in to the AWS Management Console.
  • Select the Amazon Redshift service.
  • Select the “Scheduled Jobs” tab.
  • Click the “Create Job” button.
  • Enter the SQL query in the “Job Definition” field.
  • Enter a schedule for the job.
  • Click the “Create Job” button.
  1. Monitor the job:
  • Log in to the AWS Management Console.
  • Select the Amazon Redshift service.
  • Select the “Scheduled Jobs” tab.
  • Select the job from the list.
  • Click the “Run Now” button to manually run the job.
  • Check the “Job Status” to see the job's progress.

Helpful links

Edit this code on GitHub