Code Editor

Editing files in uses Code Editor. You can edit a variety of file types, and when you edit .sql or .py files you can then link these to your SQL Script and Python Pushdown components in your orchestration pipelines to run those scripts.

Code Editor is powered by the Monaco Editor, which also powers Visual Studio Code and other editors across the web.

Code Editor supports basic syntax colorization and works with the command palette in .

---

Video example

---

Create files to edit

The following file types can be created within and then edited in Code Editor:

• .sql
• .py

To create .sql or .py files:

1. In the Files panel, click the + icon.
2. Choose what file to create:
   1. Python script (.py)
   2. SQL script (.sql)

This will situate the newly created file outside any folders.

To create a file inside a folder, click the three dots … alongside that folder and then click Add → Python script (or other type of file).

Creating a new Python script or SQL script will open that new script in Code Editor.

---

Edit files

If the repository you have connected to a project contains any of the following files, you can edit them in Code Editor:

• .sql
• .py
• .yaml (including the shared-pipelines.yaml file)
• .csv
• .md
• .txt
• .sc
• .js
• .css
• .xml
• .html

.sql files can be used in the SQL Script component and .py files can be used in the Python Pushdown component in your orchestration pipelines.

We are working to add support for editing .json files.

All the file types in this list can be imported to and exported from .

---

Rename, move, and delete files

You can rename, move, and delete any files in your project.

---

Using variables in the code editor

Snowflake

When naming variables, avoid using Snowflake reserved keywords.

Applies to	Note
Code written inside the SQL Script component.	Supports both existing variable code ${variable} and Snowflake variable syntax.
Code written inside the SQL transformation component.	Supports the existing variable code ${variable}.
Code written inside SQL script files.	Only Snowflake variable syntax is supported.
Code written inside the Python Pushdown component or Python script files.	Only Python variable syntax is supported.

Databricks

When naming variables, avoid using Databricks reserved keywords.

Applies to	Note
Code written inside the SQL Script component.	Supports both existing variable code ${variable} and Databricks variable syntax.
Code written inside the SQL transformation component.	Supports the existing variable code ${variable}.
Code written inside SQL script files.	Only Databricks variable syntax is supported.
Code written inside Python script files.	Only Python variable syntax is supported.

The Python Pushdown component is not yet available for Databricks projects. You can use Code Editor to edit your .py files, but you cannot run these Python scripts from a Databricks project in yet.

Amazon Redshift

When naming variables, avoid using Amazon Redshift reserved keywords.

Applies to	Note
Code written inside the SQL Script component.	Supports the existing variable code ${variable}.
Code written inside the SQL transformation component.	Supports the existing variable code ${variable}.
Code written inside SQL script files.	Variables not supported. Coming soon.
Code written inside Python script files.	Only Python variable syntax is supported.

The Python Pushdown component is not yet available for Amazon Redshift projects. You can use Code Editor to edit your .py files, but you cannot run these Python scripts from an Amazon Redshift project in yet.

However, you can use the Python Script component to run Python scripts from within that component’s inline editor.

---

Command palette

Designer

Using the command palette, press cmd + k (Mac) or CTRL + k (Windows) to activate the command palette in . Type the name of the file you wish to open and then press Enter. Alternatively, activate the command palette by clicking the magnifying glass (search) in the top-left.

Monaco Editor

Using the Monaco Editor command palette, press fn + F1 (Mac) or F1 (Windows) to access all command palette actions available in Monaco Editor-powered editors.