Skip to main content
The get-file command copies a sample file or asset into your project. If a file with the same name already exists, a timestamp suffix is added to avoid overwriting.

Usage

sqrl get-file {file_name} [options]

Positional arguments

ArgumentDescription
file_nameThe sample file or asset to copy (see supported values below)

Supported file_name values

file_nameDescription
.envCreate sample .env and .env.example files
.gitignoreCreates a sample .gitignore
squirrels.ymlCreates a sample project manifest
user.pyCreates a sample user model file
connections.pyCreates a sample connections file (python)
parameters.pyCreates a sample parameters file (python)
context.pyCreates a sample context helpers file
macros_example.sqlCreates sample Jinja SQL macros
sources.ymlCreates sample model source definitions
build_exampleCreates a sample build (static) model file
dbview_exampleCreates a sample dbview (runtime SQL) model file
federate_exampleCreates a sample federate (runtime) model file
dashboard_exampleCreates a sample dashboard file
expenses.dbCreates a sample SQLite database (expenses)
weather.dbCreates a sample SQLite database (weather)
seed_categoriesCreates sample CSV and YAML files for categories seed
seed_subcategoriesCreates sample CSV and YAML files for subcategories seed

Options by file

Some file_name values accept additional options which are all optional:
  • squirrels.yml
    • --no-connections: Exclude the connections section
    • --parameters: Include the parameters section
    • --dashboards: Include the dashboards section
  • build_example
    • --format {sql,py}: Create model as SQL (default) or Python file
  • federate_example
    • --format {sql,py}: Create model as SQL (default) or Python file

Examples

Copy sample environment files:
sqrl get-file .env
Copy a sample manifest including parameters and dashboards sections:
sqrl get-file squirrels.yml --parameters --dashboards
Copy a sample build model as Python:
sqrl get-file build_example --format py
Copy the expenses sample database:
sqrl get-file expenses.db

Notes

  • Existing files are not overwritten; a timestamp is appended to the copied filename if needed