Creating or Importing a SQL Work File

You can write and run code within the data tab of the workspace page to manipulate a dataset in your sandbox. You can author your queries directly in our integrated SQL editor. Code can be written in SQL, PL/pgSQL or any other language installed in the target database.

Any SQL code developed in the SQL editor is automatically created in the schema of the workspace sandbox.

For information about the SQL Editor, see SQL Editor.

Note: Work File Name Validation

Valid names for SQL files include numbers, letters, spaces, and any of these characters: ( ) . - _

Work files with other characters in the name cannot be created.

Prerequisites

Procedure

  1. To create or import a SQL file, click Create New SQL File.

  2. Provide a name and optionally a description for the file. A query editor appears.


    You can upload a SQL file (or any other type of file) with the Upload a File command on the Work Files tab in your workspace.