OS Manuals

/opt/chainguard/dbt-bigquery/bin/daff

dbt BigQuery adapter - data transformation tool for Google BigQuery

From dbt-bigquery 1.10.3-r13 (enterprise-packages), captured 2026-11-08 by running daff --help (exit 1). permalink

daff can produce and apply tabular diffs.
Call as:
  daff a.csv b.csv
  daff [--color] [--no-color] [--output OUTPUT.csv] a.csv b.csv
  daff [--output OUTPUT.html] a.csv b.csv
  daff [--www] a.csv b.csv
  daff parent.csv a.csv b.csv
  daff --input-format sqlite a.db b.db
  daff patch [--inplace] a.csv patch.csv
  daff merge [--inplace] parent.csv a.csv b.csv
  daff trim [--output OUTPUT.csv] source.csv
  daff render [--output OUTPUT.html] diff.csv
  daff copy in.csv out.tsv
  daff in.csv
  daff git
  daff version

The --inplace option to patch and merge will result in modification of a.csv.

If you need more control, here is the full list of flags:
  daff diff [--output OUTPUT.csv] [--context NUM] [--all] [--act ACT] a.csv b.csv
     --act ACT:     show only a certain kind of change (update, insert, delete, column)
     --all:         do not prune unchanged rows or columns
     --all-rows:    do not prune unchanged rows
     --all-columns: do not prune unchanged columns
     --color:       highlight changes with terminal colors (default in terminals)
     --context NUM: show NUM rows of context (0=none)
     --context-columns NUM: show NUM columns of context (0=none)
     --fail-if-diff: return status is 0 if equal, 1 if different, 2 if problem
     --id:          specify column name to use as primary key (repeat for multi-column key)
     --ignore:      specify column name to ignore completely (can repeat)
     --index:       include row/columns numbers from original tables
     --input-format [csv|tsv|ssv|psv|json|sqlite]: set format to expect for input
     --eol [crlf|lf|cr|auto]: separator between rows of csv output.
     --no-color:    make sure terminal colors are not used
     --ordered:     assume row order is meaningful (default for CSV)
     --output-format [csv|tsv|ssv|psv|json|copy|html]: set format for output
     --padding [dense|sparse|smart]: set padding method for aligning columns
     --table NAME:  compare the named table, used with SQL sources. If name changes, use 'n1:n2'
     --unordered:   assume row order is meaningless (default for json formats)
     -w / --ignore-whitespace: ignore changes in leading/trailing whitespace
     -i / --ignore-case: ignore differences in case
     -d EPS / --ignore-epsilon EPS: ignore small floating point differences

  daff render [--output OUTPUT.html] [--css CSS.css] [--fragment] [--plain] diff.csv
     --css CSS.css: generate a suitable css file to go with the html
     --fragment:    generate just a html fragment rather than a page
     --plain:       do not use fancy utf8 characters to make arrows prettier
     --unquote:     do not quote html characters in html diffs
     --www:         send output to a browser
Options (15)
OptionDescriptionSource
--act ACT:show only a certain kind of change (update, insert, delete, column)help
--alldo not prune unchanged rows or columnshelp
--all-rowsdo not prune unchanged rowshelp
--colorhighlight changes with terminal colors (default in terminals)help
--idspecify column name to use as primary key (repeat for multi-column key)help
--ignorespecify column name to ignore completely (can repeat)help
--indexinclude row/columns numbers from original tableshelp
--no-colormake sure terminal colors are not usedhelp
--orderedassume row order is meaningful (default for CSV)help
--table NAME:compare the named table, used with SQL sources.help
--unorderedassume row order is meaningless (default for json formats)help
--fragmentgenerate just a html fragment rather than a pagehelp
--plaindo not use fancy utf8 characters to make arrows prettierhelp
--unquotedo not quote html characters in html diffshelp
--wwwsend output to a browserhelp

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.