Chapter 7: Versions and smart refresh
1 A result that gets a new version
How many letters does the register date between 1520 and 1530?
Partitur
---
id: span
display: kennzahl
duckdb:
- alias: main
path: $PDAI_COLLECTIONS/pirckheimer/pirckheimer.duckdb
read_only: true
partiturs:
- id: duckdb-read
input:
sql: |
-- letters with a year in the register's date field
-- (the register dates letters by date_when)
SELECT count(*) AS n_letters
FROM letters_resolved
WHERE TRY_CAST(left(date_when, 4) AS INTEGER) BETWEEN 1520 AND 1530
artefacts:
- name: span
kind: table
file: span.json
---
How many letters does the register date between 1520 and 1530?354 Briefe.
ohne Erwartung2 A reader that follows, a reader that stays
Report the figure in {{ref:span.span}}, at its latest version.
Partitur
---
id: follows
display: kennzahl
partiturs:
- id: duckdb-read
input:
sql: |
SELECT r.n_letters AS seen_letters
FROM read_json_auto('{{ref:span.span}}') AS f,
unnest(f.data.data.rows) AS t(r)
artefacts:
- name: seen
kind: table
file: seen.json
---
Report the figure in {{ref:span.span}}, at its latest version.354 seen_letters.
ohne ErwartungReport the figure in {{ref:span.span@v1}}, at version 1 only.
Partitur
---
id: stays
display: kennzahl
partiturs:
- id: duckdb-read
input:
sql: |
SELECT r.n_letters AS seen_letters
FROM read_json_auto('{{ref:span.span@v1}}') AS f,
unnest(f.data.data.rows) AS t(r)
artefacts:
- name: seen
kind: table
file: seen.json
---
Report the figure in {{ref:span.span@v1}}, at version 1 only.132 seen_letters.
ohne Erwartung