How To Insert Data into Redshift Table

Sometimes you may need to insert data into Redshift table. In this article, we will look at how to insert data into redshift table. You can use it to insert multiple rows and even insert into identity column.


How To Insert Data into Redshift Table

Here are the steps to insert data into Redshift table. Let us say we have the following table in redshift employees(id, first_name, last_name)

postgres-# create table employees(id int,
   first_name varchar(10),
   last_name varchar(10));

Here is the syntax to insert data into redshift table

insert into table_name(column_list)
values(value_list1),
(value_list2),
...

In the above query, you need to specify table name, comma-separated list of columns, and comma-separated list of values for each row that you want to insert. Although mentioning column list after table name is optional, it is recommended to avoid errors due to mismatch in number of columns and column names.

Also read : How to Alter column from NULL to NOT NULL

Here is the SQL query to insert one row into employees table.

postgres-# insert into employees(id, first_name, last_name)
           values(1, 'John','Doe');
postgres-# select * from employees;
 id | first_name | last_name
----+------------+-----------
  1 | John       | Doe

Also read : How to Calculate Running Total in Redshift


Insert Multiple Rows in Redshift

If you want to enter multiple rows, you just need to provide multiple set of values, enclosed in round brackets ‘( )’. Here is an example to insert multiple rows in redshift.

postgres-# insert into employees(id, first_name, last_name)
           values(2, 'Jim','Doe'),
                 (3, 'Tim','Doe');

postgres-# select * from employees;
 id | first_name | last_name
----+------------+-----------
  1 | John       | Doe
  2 | Jim        | Doe
  3 | Tim        | Doe

Also read : How to Calculate Moving Average in Redshift

Need a reporting tool for Redshift? Ubiq makes it easy to visualize data in minutes, and monitor in real-time dashboards. Try it Today!

mm

About Ubiq

Ubiq is a dashboard & reporting platform that makes it easy to get insights from data. Build dashboards, charts & reports for your business in minutes. Try it for free today!