Dewi¶

Commands¶

Global parameters: - -c --config : config file location - -o --output : output directory

Build parameters: - -f --files : Specific files/directories to validate - -d --datamodel : Location of datamodel file - -g --generators : Comma separated list of generators to execute

examples.

> dewi build
> dewi build -c ./dewi/project.yaml -o .
> dewi build --config ./dewi/project.yaml --output .

Optional¶

Validate¶

Validates the yaml configs configured in the project configuration Defaults to the 'dewi' directory in the current working directory

Validate parameters: - -f --files : Specific files/directories to validate

examples.

> dewi validate
> dewi validate -c ./dewi/project.yaml -o .
> dewi validate -f tables/x_hub.yaml

Compile¶

Compiles the configuration files into a datamodel.yaml

Validate parameters: - -f --files : Specific files/directories to compile

examples.

> dewi compile
> dewi compile -c ./dewi/project.yaml -o .
> dewi compile -f tables/x_hub.yaml

Generate¶

Generates files from a compiled datamodel.yaml

Generate parameters: - -d --datamodel : Location of datamodel file - -g --generators : Comma separated list of generators to execute

examples.

> dewi generate
> dewi generate -c ./dewi/project.yaml -o .
> dewi generate --datamodel /some/dir/datamodel.yaml
> dewi generate --generators CreateTable,CreateSPs

Import source¶

Import table definitions from a SQL Server and store them as dewi configs

Importsource parameters: - -c, --config : Path to project.yaml - -o, --output : Path to place generated files - -v, --verbose : Verbose output - -s, --server : Hostname of the server - -d, --database: Database name - -u, --user : SQL Username - -p, --password : SQL Password - -sc, --schema : database schema to import from - -ts, --target : Optional target schema name to write in config files - -f, --force : Overwrite existing local files

examples:

> dewi importsource --server ayb.database.windows.net --user sql_server_user_account --password "verysecretpassword" --database ayb_dev_dwh --schema dbo --output out/ --target ayb_stg