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:

Development

NPM scripts

• npm test: Run test suite
• npm start: Run npm run build in 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