Add a column to an existing table

Let’s say you have a CRITICAL_ORDERS table with just two columns and you want to add another one.

SELECT *
FROM GLOBAL_SUPERSTORE.PUBLIC.CRITICAL_ORDERS
LIMIT 1;

You can use the following query

SELECT *
FROM GLOBAL_SUPERSTORE.PUBLIC.CRITICAL_ORDERS
LIMIT 1;