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 PATHS '<file path>'
[WITH OPTIONS (DATASOURCE = '<data source name>')]
ParametersDescription
<dashboard name>Name of the dashboard; must match the name of the dashboard in the file.
<file paths>

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 PathOutcome
    kifs://reveal/db/nyctaxi.dbFile 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 PATHS 'kifs://reveal/nyctaxi.db'
Data Source
1
2
3
LOAD DASHBOARD "NYC Taxi"
FROM FILE PATHS 'nyctaxi.db'
WITH OPTIONS (DATASOURCE = 'reveal')
Public URL
1
2
LOAD DASHBOARD "NYC Taxi"
FROM FILE PATHS 'https://github.com/kineticadb/kinetica-workbooks/raw/master/quickstart/nyctaxi.db'