Supported Statements - Kinetica Docs

The following statement types are allowed within a SQL procedure:

SELECT
INSERT (inserting from data file not supported)
UPDATE
DELETE
CHECK PERMISSION
<CREATE | DROP | SHOW CREATE> SCHEMA
<CREATE | TRUNCATE | DROP | SHOW CREATE> TABLE
CREATE TABLE ... AS
<CREATE [MATERIALIZED] | REFRESH | DROP | SHOW CREATE> VIEW
DESCRIBE
EXECUTE FUNCTION
EXECUTE PROCEDURE
REFRESH MATERIALIZED VIEW
SHOW PROCEDURE
SHOW SECURITY [FOR <USER | ROLE>]
SHOW RESOURCE GROUP

Any unqualified table/view references made within the SQL procedure will be assumed to exist in the creator’s default schema at the time of creation. Those references will be set upon creation and never re-evaluated afterwards, regardless of the execution type of the SQL procedure, who executes it, or what EXECUTE AS option is specified.