Reveal

LOAD DASHBOARD

Kinetica provides a SQL interface for loading Reveal dashboards from a variety of sources:


LOAD DASHBOARD Syntax
1
2
3
LOAD DASHBOARD "<dashboard name>"
FROM FILE PATH '<file path>'
[WITH OPTIONS (DATASOURCE = '<data source name>')]
Parameters Description
<dashboard name>

Name of the dashboard.

Important

This name must match the name of the dashboard in the file.

<file path>

Dashboard source file path.

If a data source is specified, the path must resolve to an accessible file at that location.

If no data source is specified, the file path can refer to one of two locations:

  • Public URL

  • KiFS path

    File Path Outcome
    kifs://reveal/db/nyctaxi.db File nyctaxi.db, under the KiFS virtual directory reveal/db
<data source name> Name of data source through which the dashboard will be loaded.

For example, to load a dashboard named nyctaxi.db into Reveal:

KiFS
1
2
LOAD DASHBOARD "NYC Taxi"
FROM FILE PATH 'kifs://reveal/nyctaxi.db'
Data Source
1
2
3
LOAD DASHBOARD "NYC Taxi"
FROM FILE PATH 'nyctaxi.db'
WITH OPTIONS (DATASOURCE = 'reveal')
Public URL
1
2
LOAD DASHBOARD "NYC Taxi"
FROM FILE PATH 'https://github.com/kineticadb/examples/raw/master/quickstart/nyctaxi.db'