Altering Logical Schema

Data Warehouse supports table modification via the standard ALTER TABLE command.

The underlying columnar storage enables adding columns very quickly, even for very large tables.

New columns are not automatically propagated to associated views, even if a view is created with the wildcard (*). To add new columns to a view, recreate the view using the CREATE OR REPLACE VIEW command.

Limitations:

  • Maximum table columns: 1600 columns
  • You cannot add columns to a temporary table