Supported SQL statements for data sharing writes on consumers - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the blog post .

Supported SQL statements for data sharing writes on consumers

The following Data Definition Language (DDL) statements are supported for data sharing with writes:

  • ALTER TABLE RENAME TO

  • ALTER TABLE RENAME COLUMN TO

  • ALTER TABLE ADD/DROP COLUMN

  • ALTER SCHEMA RENAME TO

  • { CREATE | DROP } SCHEMA

  • { CREATE | DROP | SHOW } TABLE

  • CREATE TABLE table_name AS

  • BEGIN | START TRANSACTION

  • END | COMMIT | ROLLBACK

  • TRUNCATE

The following Data Manipulation Language (DML) statements are supported for data sharing with writes:

  • SELECT

  • INSERT

  • INSERT INTO SELECT

  • UPDATE

  • DELETE

  • MERGE

  • COPY without COMPUPDATE

The following analyze statements are supported for data sharing with writes:

  • ANALYZE. The consumer runs USER ANALYZE and sends the stats to the producer.

  • Analyze activated by CTAS/COPY running on the consumer. This iIncludes multiplexing for small consumers.

  • Auto-analyze run on the producer after COPY.

The following permission statements are supported for data sharing with writes:

  • { GRANT | REVOKE } privilege_name ON OBJECT_TYPE object_name TO consumer_user

  • SHOW GRANTS. For more information, see SHOW GRANTS.