Skip to main content
The new command creates a new Squirrels project with a basic structure and sample files.

Usage

sqrl new {name} [options]

Positional arguments

ArgumentDescription
nameThe name of the project folder to create. Optional (and ignored) if --curr-dir is used

Options

In addition to the global options, this command supports the following options:
OptionDescription
--curr-dirCreate the project in the current directory
--use-defaultsUse default values for unspecified options (except project folder name) instead of prompting for input
--connections {yml,py}Configure database connections as yaml (default) or python
--parameters {py,yml}Configure parameters as python (default) or yaml
--build {sql,py}Create build model as sql (default) or python file
--federate {sql,py}Create federated model as sql (default) or python file
--dashboard {y,n}Include (y) or exclude (n, default) a sample dashboard file
--admin-password ADMIN_PASSWORDThe password for the admin user. By default, a random password is generated

Examples

Create a new project folder named “my-project” and answer input prompts for setup:
sqrl new my-project
Create a project in the current directory (the following are equivalent):
sqrl new --curr-dir
sqrl new .
sqrl init
Create a new project folder named “my-project” with Python-based parameters and SQL-based build model:
sqrl new my-project --parameters py --build sql
Create a project folder named “my-project” using default settings instead of prompting for input:
sqrl new my-project --use-defaults

Notes

  • If no options are specified, the command will prompt for input
  • The --use-defaults option can be used to skip all prompts
  • The generated .env file contains sensitive information and should not be committed to version control