Config File

Skippr is configured via skippr.yaml in the working directory.

Format

project: mssql_migration

warehouse:
  kind: snowflake
  database: ANALYTICS
  schema: RAW
  warehouse: COMPUTE_WH
  role: ACCOUNTADMIN

source:
  kind: mssql
  connection_string: ${MSSQL_CONNECTION_STRING}

dbt:
  target_schema: custom_name
  silver_suffix: silver
  gold_suffix: gold

Fields

project (required)

The project identifier. Used as:

• The pipeline name for extract-and-load
• The default dbt schema prefix (e.g. mssql_migration_silver, mssql_migration_gold)

warehouse (required)

The destination warehouse connection. Set kind to the warehouse type, then add the fields that warehouse requires. Authentication is always via environment variables, never the config file.

Example (Snowflake):

warehouse:
  kind: snowflake
  database: ANALYTICS
  schema: RAW
  warehouse: COMPUTE_WH
  role: ACCOUNTADMIN

Every warehouse follows the same pattern — set kind and the warehouse-specific fields. For the full list of supported warehouses and their configuration options, see Destination Connectors:

Warehouse	kind value	Connector docs
Snowflake	snowflake	Snowflake
BigQuery	bigquery	BigQuery
PostgreSQL	postgres	PostgreSQL
Redshift	redshift	Redshift
ClickHouse	clickhouse	ClickHouse
MotherDuck	motherduck	MotherDuck
Athena	athena	Athena
Databricks	databricks	Databricks
Synapse	synapse	Synapse

source (optional)

The data source for extraction. When absent, the pipeline skips extraction and starts at the modeling phase. Set kind to the source type, then add the source-specific fields.

Example (MSSQL):

source:
  kind: mssql
  connection_string: ${MSSQL_CONNECTION_STRING}

For the full list of supported sources and their configuration options, see Source Connectors.

schema_sink (optional)

Register table metadata in an external catalog (e.g. AWS Glue for Athena).

schema_sink:
  kind: glue
  glue_database_name: my_glue_database

Field	Description
kind	glue
glue_database_name	Glue catalog database name

dbt (optional)

Override dbt naming conventions.

Field	Default	Description
target_schema	Same as project	Base schema name for dbt materialisation
silver_suffix	silver	Suffix for silver/staging tier
gold_suffix	gold	Suffix for gold/mart tier

With project: analytics, dbt materialises to:

• analytics_silver (staging models)
• analytics_gold (mart models)

Environment variable substitution

Use ${ENV_VAR} syntax anywhere in skippr.yaml for interpolation. For security best practices, we strongly advise against storing the secure value in skippr.yaml. Use environment variable interpolation instead: replace the field value with your own ${ENV_VAR} reference.

source:
  kind: mssql
  connection_string: ${MSSQL_CONNECTION_STRING}

Set the env var before running skippr:

macOS / Linux

export MSSQL_CONNECTION_STRING="server=tcp:127.0.0.1,1433;database=testdb;user id=sa;password=YourPass;TrustServerCertificate=true"

Windows PowerShell

$env:MSSQL_CONNECTION_STRING = "server=tcp:127.0.0.1,1433;database=testdb;user id=sa;password=YourPass;TrustServerCertificate=true"

Windows Command Prompt

set MSSQL_CONNECTION_STRING=server=tcp:127.0.0.1,1433;database=testdb;user id=sa;password=YourPass;TrustServerCertificate=true