Syntax highlighting for SQLX files in VS Code. SQLX is a BigQuery SQL extension language used with Dataform for data transformation pipelines.
- Full syntax highlighting for
.sqlxfiles - Multi-block support:
config { }- Define metadata, dependencies, and BigQuery settingsjs { }- Write JavaScript for dynamic query generationpre_operations { }- SQL to execute before the main querypost_operations { }- SQL to execute after the main query
- SQLX-specific functions:
ref(),self(),resolve(),when(),incremental(), and more - JavaScript interpolation:
${...}expressions for dynamic SQL - 100+ SQL functions: Including BigQuery-specific functions like
APPROX_COUNT_DISTINCT,FARM_FINGERPRINT, and geospatial functions - Comprehensive config properties: type, schema, dependencies, partitionBy, clusterBy, assertions, and more
- Config blocks with JSON-like property definitions
- JavaScript blocks with full JS syntax highlighting
- Pre/post operation blocks for SQL execution hooks
- Main SQL body with complete SQL syntax support
- DML: SELECT, INSERT, UPDATE, DELETE, MERGE
- DDL: CREATE, ALTER, DROP (TABLE, VIEW, SCHEMA)
- Clauses: FROM, WHERE, JOIN, GROUP BY, HAVING, ORDER BY, WITH (CTEs)
- Window functions: OVER, PARTITION BY, ROWS, RANGE
- All standard and BigQuery-specific data types
- Line comments:
//and-- - Block comments:
/* */
- Open VS Code
- Go to Extensions (Ctrl+Shift+X / Cmd+Shift+X)
- Search for "SQLX"
- Click Install
Simply open any .sqlx file and syntax highlighting will be applied automatically.
- VS Code 1.108.0 or later
Initial release with full SQLX syntax highlighting support.
MIT