Statements

BigQuery DDL, DML, transaction, and DCL statements supported in BigQuery compatibility mode.

Preview

BigQuery data definition (DDL), data manipulation (DML), transaction, and data control (DCL) statements in BigQuery compatibility mode.

Data definition language

Statement	Support	Notes
CREATE TABLE	Supported	Column-definition and AS SELECT forms. CREATE OR REPLACE is supported. Requires either a column list or an AS SELECT.
CREATE VIEW	Supported	AS SELECT form.
CREATE SCHEMA	Supported	IF NOT EXISTS supported. AUTHORIZATION is not supported; OPTIONS(...) and DEFAULT COLLATE are ignored.
DROP TABLE, DROP VIEW, DROP SCHEMA	Supported	IF EXISTS, CASCADE/RESTRICT, and multiple objects in one statement.
CREATE VECTOR INDEX	With limitations	Requires a dimension option (Firebolt needs an explicit vector dimension that BigQuery infers).
ALTER TABLE	With limitations	One operation per statement. Dropping several columns in one statement is not supported.
CREATE MATERIALIZED VIEW, DROP MATERIALIZED VIEW	Not supported
CREATE EXTERNAL TABLE	Not supported
CREATE TABLE LIKE, CREATE TABLE COPY, CREATE TABLE CLONE, CREATE SNAPSHOT TABLE	Not supported
CREATE FUNCTION, CREATE TABLE FUNCTION, CREATE PROCEDURE, DROP FUNCTION	Not supported
CREATE ROW ACCESS POLICY, CREATE SEARCH INDEX	Not supported
ALTER SCHEMA, ALTER VIEW, ALTER MATERIALIZED VIEW, ALTER ORGANIZATION	Not supported

Data manipulation language

Statement	Support	Notes
INSERT	Supported	INSERT ... VALUES and INSERT ... SELECT. The target must be a plain table name.
UPDATE	Supported	With a WHERE clause.
DELETE	Supported	With a WHERE clause.
TRUNCATE TABLE	Supported	Removes all rows (executed as an unconditional delete). Multiple targets in one statement are supported.
MERGE	Not supported

Transaction control

BigQuery transactions run a group of statements atomically.

Statement	Support	Notes
BEGIN TRANSACTION	Supported	START TRANSACTION is an accepted synonym.
COMMIT TRANSACTION	Supported	COMMIT is accepted.
ROLLBACK TRANSACTION	Supported	ROLLBACK is accepted.

Data control language

BigQuery data control language manages access to resources.

Statement	Support	Notes
GRANT	Not supported	Use native Firebolt SQL for access control.
REVOKE	Not supported	Use native Firebolt SQL for access control.

Limitations

• Column types in a CREATE TABLE ... AS SELECT column list are read as names only and do not re-type the selected columns.
• INSERT, UPDATE, and DELETE do not support a RETURNING clause.
• Procedural statements (CALL, EXECUTE IMMEDIATE, scripting) are not supported in this mode.