Dbt Formatter Save Abandoned
Formatting for dbt jinja-flavored sql
Project README
DBT Formatter
Install
npm install -s dbt-formatter
Usage
import formatter from 'dbt-formatter';
const mySql = "SELECT * FROM {{ ref('myTableRef') }}";
const myOpts = { sql: 'default', indent: 2, upper: false };
formatter.format(mySql, myOpts);
This will result in:
SELECT
*
FROM
{{ ref('myTableRef') }}
Usage options
Fine tune dbt-formatter behavior with the following options:
| Option | Default | Description |
|---|---|---|
| sql | default |
The sql dialect you want to use, currently only default is available |
| indent | 2 |
How many spaces you want an indentation to be |
| upper | false |
Formats sql reserved words to be uppercase when set to true |
| newline | false |
Appends a new line at the end of the formatted sql string |
| lowerWords | false |
Lowercases all words as identified by the tokenizer |
| allowCamelcase | true |
Allows column names to be camelcased |
Development
NPM scripts
-
npm test: Run test suite -
npm start: Runnpm run buildin watch mode -
npm run build: Generate bundles and typings, create docs -
npm run lint: Lints code -
npm run package: Package dbt-formatter as a binary
Roadmap
- Add more sql dialects:
- snowflake
- redshift
- bigquery
- postgres
- presto
Open Source Agenda is not affiliated with "Dbt Formatter" Project. README Source: henriblancke/dbt-formatter
Open Source Agenda Badge
