ALTER TABLE

ALTER TABLE table_name
    alter_option;

ALTER TABLE table_name
    ADD [ COLUMN ] column_name data_type [ DEFAULT default_expr ];

-- Add a column named "age" to a table named "employees" with a data type of integer
ALTER TABLE employees ADD age int;

ALTER TABLE table_name CONNECTOR WITH (
  'property_name' = 'value',
  ...
);

ALTER TABLE table_name
    DROP [ COLUMN ] [ IF EXISTS ] column_name;

-- Remove a column named "fax" from the "employees" table
ALTER TABLE employees DROP fax;

ALTER TABLE table_name
    ALTER [ COLUMN ] column_name TYPE new_data_type;

-- Change the data type of a struct column to add a new field
ALTER TABLE employees ALTER COLUMN address TYPE STRUCT<street VARCHAR, city VARCHAR, zipcode VARCHAR>;

-- Change the data type of a nested struct column
ALTER TABLE orders ALTER COLUMN customer_info TYPE STRUCT<name VARCHAR, contact STRUCT<email VARCHAR, phone VARCHAR, address VARCHAR>>;

ALTER TABLE table_name
    OWNER TO new_user;

-- Change the owner of the table named "t" to the user "user1"
ALTER TABLE t OWNER TO user1;

ALTER TABLE table_name
    SET SCHEMA schema_name;

-- Move a table named "test_table" into a schema named "test_schema"
ALTER TABLE test_table SET SCHEMA test_schema;

ALTER TABLE table_name
SET PARALLELISM { TO | = } parallelism_number;

ALTER TABLE test_table SET PARALLELISM = 8;

SET streaming_parallelism = 3;

-- Create a table.
CREATE TABLE t(v int);
-- View parrellelism by rw_fragments table.
SELECT fragment_id, parallelism FROM rw_fragments;

------RESULTS
 fragment_id | parallelism
-------------+-------------
           1 |           3
           2 |           3
(2 rows)

-- Set to a fixed number.
ALTER TABLE t SET PARALLELISM = 8;
SELECT fragment_id, parallelism FROM rw_fragments;

------RESULTS
 fragment_id | parallelism
-------------+-------------
           1 |           8
           2 |           8
(2 rows)

-- Set to ADAPTIVE
ALTER TABLE t SET PARALLELISM = adaptive;
SELECT fragment_id, parallelism FROM rw_fragments;

------RESULTS
 fragment_id | parallelism
-------------+-------------
           1 |          12
           2 |          12
(2 rows)

ALTER TABLE name
SWAP WITH target_name;

-- Swap the names of the products table and the inventory table.
ALTER TABLE products
SWAP WITH inventory;

ALTER TABLE table_name
    RENAME TO new_name;

-- Change the name of the table named "table0" to "table1"
ALTER TABLE table0 RENAME TO table1;

ALTER TABLE table_name
    REFRESH SCHEMA;

-- Refresh the schema of the table named "t_user".
ALTER TABLE t_user REFRESH SCHEMA;

ALTER TABLE table_name
    SET SOURCE_RATE_LIMIT { TO | = } { default | rate_limit_number };

ALTER TABLE table_name
    SET BACKFILL_RATE_LIMIT { TO | = } { default | rate_limit_number };