Importing results from CSV

[!TIP] See otava.yaml for the full example configuration.

Tests

tests:
  local.sample:
    type: csv
    file: tests/local_sample.csv
    time_column: time
    attributes: [commit]
    metrics: [metric1, metric2]
    csv_options:
      delimiter: ','
      quote_char: "'"

CSV options

The delimiter and quote character can also be configured globally:

csv:
  delimiter: ';'
  quote_char: "'"

The corresponding command-line options are --csv-delimiter and --csv-quote-char. They can also be set through the CSV_DELIMITER and CSV_QUOTE_CHAR environment variables. Explicit global values override the csv_options values of individual tests; without a global value, existing per-test settings and defaults are unchanged.

Example

docker-compose -f examples/csv/docker-compose.yaml run --rm otava analyze local.sample

Expected output:

time                       commit      metric1    metric2
-------------------------  --------  ---------  ---------
2024-01-01 02:00:00 +0000  aaa0         154023      10.43
2024-01-02 02:00:00 +0000  aaa1         138455      10.23
2024-01-03 02:00:00 +0000  aaa2         143112      10.29
2024-01-04 02:00:00 +0000  aaa3         149190      10.91
2024-01-05 02:00:00 +0000  aaa4         132098      10.34
2024-01-06 02:00:00 +0000  aaa5         151344      10.69
                                                ·········
                                                   -12.9%
                                                ·········
2024-01-07 02:00:00 +0000  aaa6         155145       9.23
2024-01-08 02:00:00 +0000  aaa7         148889       9.11
2024-01-09 02:00:00 +0000  aaa8         149466       9.13
2024-01-10 02:00:00 +0000  aaa9         148209       9.03