Skip to main content
Editing files in Designer 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 Designer.

Video example

Create files to edit

The following file types can be created within Designer 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 Maia project contains any of the following files, you can edit them in Code Editor: .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 Designer.

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.

Databricks

When naming variables, avoid using Databricks reserved keywords.
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 Designer yet.

Amazon Redshift

When naming variables, avoid using Amazon Redshift reserved keywords.
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 Designer 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 Designer command palette, press cmd + k (Mac) or CTRL + k (Windows) to activate the command palette in Designer. 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.