The primary is a virtual table which corresponds to the currently selected primary fields table. Field tables are automatically created and can be deleted at any time.


A field table consists essentially of the following columns accessible in a query:

Name Type Description
id Identifier Contains a unique identifier for this value.
value Numeric Contains the value which was
sent to duckprove using the JavaScript API.
time Time Contains the exact time when
the value was received.

Example Query

This is an example query for a field table named revenue. There are more examples available for all kinds of tables.

draw pie-chart
using value, year(revenue.time) as label
from revenue