Supported SQL commands

The following SQL commands and functionalities are supported with lakehouse database/tables. For more information, see:

• CREATE DATABASE
• CREATE SCHEMA
• CREATE TABLE
• DESCRIBE
• SELECT QUERIES
• CTAS
• DROP SCHEMA
• TRUNCATE
• DELETE
• UPDATE
• Backup and restore is only supported for the login and reference information, not the data itself.
• AWS S3, IBM COS, minIO data sources are available as storage options or a data lake database.
• Time travel on Iceberg tables

The following functionalities are not supported:

• Creation of lakehouse native objects (for example materialized views and sequences) in schemas other than NETEZZA_SCHEMA
• Queries which update the contents of tables (Insert, Merge)
• Accessing data lake tables that were created by using LZ4 compression format
• Multi-table transactions
• timestamptz and UUID data types