Skip to content

Latest commit

 

History

History
38 lines (28 loc) · 938 Bytes

README.md

File metadata and controls

38 lines (28 loc) · 938 Bytes
Raw

Flowtool

  • simple CLI application for templating your airflow SQL files
  • made for quickly copy/pasting airflow templated sql into BigQuery UI
  • template mappings set from a config.json file
  • can convert most built-in airflow template variables
  • support for different environments variable with ${env}

Setup

  • create a folder ${HOME}/Documents/flowtool
  • create a config.json file with your template variables mapped to their values
{
    "params.project": "gk-africa-data-eu-${env}",
    "params.web_project": "testscore-web",
    "environment": "${env}"
}

Usage

# replace the template variables and add it to the clipboard
flowtool template test.sql

# print all current key/value pairs
flowtool config list

# add new key/value pairs to your config.json...
flowtool config add <key> <value>

# and remove existing keys
flowtool config rm <key>