Posted On: Sep 15, 2021

Amazon Redshift, a fully-managed cloud data warehouse, announces availability of Amazon Redshift RSQL, a command line client for interacting with Amazon Redshift clusters and databases. With Amazon Redshift RSQL, you connect to an Amazon Redshift cluster, describe database objects, query data, and view query results in various output formats.

Amazon Redshift RSQL supports the capabilities of the PostgreSQL psql command line tool with an additional set of Amazon Redshift specific capabilities: You can use Single Sign-On (SSO) authentication using ADFS, PingIdentity, Okta, Azure AD or other SAML/JWT based Identity Providers, as well as use Browser-based SAML Identity Providers with Multi-Factor Authentication (MFA); You can describe properties or attributes of Amazon Redshift objects such as Distribution Keys, Sort Keys, Late Binding Views (LBVs), Materialized Views, External tables in Amazon Glue catalog or Hive Metastore, External tables in Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL-Compatible Edition, Amazon RDS for MySQL (preview) and Amazon Aurora MySQL-Compatible Edition (preview), and tables shared via Amazon Redshift Data Sharing; you can also use enhanced control flow commands such as IF (\ELSEIF, \ELSE, \ENDIF), \GOTO and \LABEL.

With Amazon Redshift RSQL batch mode, which executes a script passed as an input parameter, you can now run scripts which include both SQL and complex business logic. Customers with existing self-managed on-premise data warehouses can use Amazon Redshift RSQL to easily replace existing ETL and automation scripts, such as Teradata BTEQ scripts, instead of manually re-implementing them in a procedural language. 

Amazon Redshift RSQL is available for Linux, Windows, and macOS X operating systems.

To get started and learn more about Amazon Redshift RSQL visit our documentation.