You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.
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