SQL commands

Create/Alter/Drop Objects

CREATE	ALTER	DROP
`CREATE CLUSTER`	`ALTER CLUSTER`	`DROP CLUSTER`
`CREATE CLUSTER REPLICA`		`DROP CLUSTER REPLICA`
`CREATE CONNECTION`	`ALTER CONNECTION`	`DROP CONNECTION`
`CREATE DATABASE`		`DROP DATABASE`
`CREATE INDEX`	`ALTER INDEX`	`DROP INDEX`
`CREATE MATERIALIZED VIEW`	`ALTER MATERIALIZED VIEW`	`DROP MATERIALIZED VIEW`
`CREATE NETWORK POLICY`	`ALTER NETWORK POLICY`	`DROP NETWORK POLICY`
`CREATE ROLE`	`ALTER ROLE`	`DROP ROLE` `DROP USER`
`CREATE SCHEMA`		`DROP SCHEMA`
`CREATE SECRET`	`ALTER SECRET`	`DROP SECRET`
`CREATE SINK`	`ALTER SINK`	`DROP SINK`
`CREATE SOURCE`	`ALTER SOURCE`	`DROP SOURCE`
`CREATE TABLE`	`ALTER TABLE`	`DROP TABLE`
`CREATE TYPE`		`DROP TYPE`
`CREATE VIEW`		`DROP VIEW`

Create/Read/Update/Delete Data

The following commands perform CRUD operations on materialized views, views, sources, and tables:

Select/Subscribe	`SELECT` `SUBSCRIBE`
Cursor	`CLOSE` `DECLARE` `FETCH`
Sink	`ALTER SINK` `CREATE SINK` `DROP SINK`
Transactions	`BEGIN` `COMMIT` `ROLLBACK`

RBAC

Commands to manage roles and privileges:

Roles	`ALTER ROLE` `CREATE ROLE` `DROP ROLE` `DROP USER` `GRANT ROLE` `REVOKE ROLE` `SHOW ROLES`
Privileges	`ALTER DEFAULT PRIVILEGES` `GRANT PRIVILEGE` `REVOKE PRIVILEGE`
Owners	`ALTER OWNER` `DROP OWNED` `REASSIGN OWNED`

Query Introspection (`Explain`)

Object Introspection (`SHOW`)

Session

Commands related with session state and configurations:

Validations

VALIDATE CONNECTION

Back to top ↑