Amazon Redshift Serverless

learn Amazon Redshift Serverless

Amazon Redshift Serverless makes it convenient for you to run and scale analytics without having to provision and manage data warehouse clusters. Amazon Redshift automatically provisions and scales data warehouse capacity to deliver fast performance for demanding and unpredictable workloads. You pay only for the capacity that you use.


  • Namespace - collection of database objects and users. The storage-related namespace groups together schemas, tables, users, or AWS Key Management Service keys for encrypting data.
  • Workgroup - a collection of compute resources. The compute-related workgroup groups together compute resources like RPUs, VPC subnet groups, and security groups.
    • Other resources that are grouped under workgroups include access and usage limits.


psql -h -d sample_data_dev -p 5439 -U uadmin

# create user
CREATE USER user01 with password 'Password01' createdb connection limit 30;

# redshift serverless costs per day in USD
  trunc(start_time) "Day",
  sum(compute_seconds)/60/60 * 0.375
from sys_serverless_usage
group by trunc(start_time)
order by 1

# login as `user01`
psql -h -d sample_data_dev -p 5439 -U user01

# list databases

# use database
\c sample_data_dev

# run query
select * from tpcds.customer limit 10;


Serverless Dashboard



Workgroup Limits

Data backup


Recovery point