Overview
IntegrationsPricing

blacksmith run operation

This command runs an operation on top of a SQL database.

Example:

$ blacksmith run operation \
  --integration warehouse \
  --file "./operations/demo.sql" \
  --data "./data/somedata.json" \
  --dryrun

Required flags

  • --integration [integration]: Integration to run the operation against.

    Aliases: -i [integration]

    Example:

    $ blacksmith run operation \
      --integration warehouse \
      --file "./operations/demo.sql"
  • --file [filename]: The relative path to the SQL file to compile and execute against the database.

    Aliases: -f [filename]

    Example:

    $ blacksmith run operation \
      --integration warehouse \
      --file "./operations/demo.sql"

Optional flags

  • --data [filename]: The relative path to the CSV or JSON file to pass down to the SQL template file as data source.

    Aliases: -d [filename]

    Example:

    $ blacksmith run operation \
      --integration warehouse \
      --file "./operations/demo.sql" \
      --data "./data/somedata.json"
  • --dryrun: Only compile the SQL file into <operation>.compiled.sql at the same location of the template file. This prevents the operation to actually run.

    Aliases: -dr

    Example:

    $ blacksmith run operation \
      --integration warehouse \
      --file "./operations/demo.sql" \
      --dryrun
Is something missing?

If you notice something we've missed or could be improved on, please follow this link and submit a pull request to the repository. Once we merge it, the changes will be reflected on the website the next time it is deployed.

Thank you for your contributions!