Initialize a new Snowflake workspace, generate profiles, sources, and environment variables to use in your dbt project.
kbc dbt init [flags]
The command must be run in a directory with a dbt project (i.e., containing dbt_project.yml
) or its subdirectory.
See the introduction to dbt support for more information.
-H, --storage-api-host <string>
-T, --target-name <string>
-W, --workspace-name <string>
➜ kbc dbt init
Please enter the Keboola Storage API host, e.g., "connection.keboola.com".
? API host: connection.north-europe.azure.keboola.com
Please enter the Keboola Storage API token. The value will be hidden.
? API token: **************************************************
Please enter the target name.
Allowed characters: a-z, A-Z, 0-9, "_".
? Target Name: TARGET1
? Enter a name for the workspace to be created: dbt_workspace
Creating a new workspace, please wait.
Created new workspace "dbt_workspace".
Profile stored in "profiles.yml".
Sources stored in "models/_sources" directory.
Commands to set environment for the dbt target:
export DBT_KBC_TARGET1_TYPE=snowflake
export DBT_KBC_TARGET1_SCHEMA=WORKSPACE_12345
export DBT_KBC_TARGET1_WAREHOUSE=KEBOOLA_PROD_SMALL
export DBT_KBC_TARGET1_DATABASE=KEBOOLA_1234
export DBT_KBC_TARGET1_ACCOUNT=keboola.west-europe.azure
export DBT_KBC_TARGET1_USER=KEBOOLA_WORKSPACE_12345
export DBT_KBC_TARGET1_PASSWORD=abcd1234
© 2024 Keboola