Snow2dbt

Command Line to reverse engineering a Snowflake Table to DBT model and SQL

Be careful this tool is under development. There's no stable release yet.

1. Installing

• From pip

pip install snow2dbt

• From Github repository

pip install https://github.com/tensor365/snow2dbt

2. Authentication

Dbt SSO

If you have already a Snowflake Connection in your profile.yml , snow2dbt will use this identity to connect to your Snowflake tenant. If you've multiple identity in your profile.yml, you can specify the profile you want by using the argument: --profile .

Standard Authentication

If you want to use a standard authentification to Snowflake, you can specify following arguments:

• Password Authentication

```bash 

--account <snowflake_accountname>
--user <snowflake_user>
--password <snowflake_password> 

```

• Keypair Authentication

Not available yet. Incoming soon

```bash

--account <snowflake_accountname>
--key <snowflake_private_key>

```

3. Reversing a Snowflake Table into model/contract

snow2dbt --target <databse>.<schema>.<table>

CLI arguments

Option	Description
--account	Snowflake Account Name
--username	Snowflake Username
--profile	DBT profile used to handle authentification
--target	Target table database.schema.table
-l, --lower	Output type names as lowercase in YAML file
--snake	Convert field names to snake_case
--prefix	Prefix to add to columns names (default: None)
--suffix	Suffix to add to column names (default: None)
--output	Destination folder for scripts. (default: target/bq2dbt)
--description	Description of the table reversed
--auth_mode	Authentification mode used to handle connection to Snowflake
--leading_comma	Adding Leading Comma in front of each field

4. Road Map

In development

• February 2024: adding the capability to reverse entire schema
• February/March 2024: adding the capability to generate SQL file by using Snowflake Lineage