SaaSActive

Amazon Redshift

Cloud data warehouse service supporting standard and extended SQL functions.

Open source page ↗

Product features

Product features

AWS CLI

Command line tools to manage Redshift from Windows, Mac, and Linux.

AWS SDK support

Supported by AWS SDKs for Java, .NET, PHP, Python, Ruby, and Node.js.

Data types

Data types supported by Amazon Redshift SQL.

Date and time functions

Functions for date and time values.

JSON functions

Functions for working with JSON data.

Machine learning functions

Functions supporting machine learning workloads.

Amazon Redshift management API

HTTP/HTTPS GET or POST requests with an Action parameter.

Math functions

Mathematical functions.

Operators

Operators usable in Amazon Redshift SQL.

Provisioned clusters

Manually manage clusters composed of one or more compute nodes.

Query editor v2

Load data and start querying in the Amazon Redshift query editor v2.

Redshift Serverless

Access and analyze data without provisioning a data warehouse; capacity scales automatically.

Redshift SQL

Syntax for Redshift SQL commands and functions.

Loading data from Amazon S3

Load data into Redshift from Amazon S3.

Amazon Redshift Serverless

Access and analyze data without configuring a provisioned data warehouse.

Spatial functions

Functions for spatial data.

SQL commands

Create and manage database objects.

SQL functions

Functions available within the Amazon Redshift SQL environment.

String functions

Functions for string manipulation.

System administration functions

Functions for system administration.

System information functions

Functions returning system information.