Skip to content
ROKKS Docs
DRAFTEnglish end user manual · web beta f7b7740e7371 · Android beta ed5d9494be9eDownload PDF

CSV to Dashboard

Goal

Section titled “Goal”

Load a flat CSV file, review its per-file transform plan, and create a dashboard widget from the resulting governed source. This tutorial uses the public Pagila rental facts CSV as a deterministic sample; the relation-aware Pagila maiden flight uses the six-table JSON instead.

Download the CSV source and derivation record with the sample. It pins 11,138,814 bytes, 51,805 rows, 21 columns, and SHA-256 0e7a033d85e4e5657e2fefd5e81f68c7c067de92a43e3dae4b96ad75aef4a2ee.

Steps

Section titled “Steps”
  1. Open Data Fabric → File Areas and create a regular File Area named Pagila CSV Practice.
  2. Choose Upload Files and upload pagila-rental-facts.csv.
  3. Wait for Source and Sample, then open Plan. Review the 21 flattened fields and correct field names, types, units, nullability, and keys.
  4. Run Load and wait for the lifecycle to reach Loaded. If you can access Job Queue, require the FILE_ETL job to reach DONE.
  5. Open Workspaces, enter or create ACME Analytics, and create a practice dashboard.
  6. Choose Add column, then use the empty slot labelled Add or drag widget here. The slot creates a new widget directly in edit mode.
  7. In the Data Model canvas, select the governed table produced by the file load.
  8. Choose a line chart and configure SUM(payment_amount) by month of rental_date.
  9. Choose Run Query and inspect the preview.
  10. Wait for the first instant save to finish, then choose Close. The Widget Builder has no separate Apply or Save action.

MOCKUP — flat CSV tutorial. This source-derived asset shows the regular File Area used by this exercise. It is not evidence that the separate Constellation maiden flight was loaded.

MOCKUPSource-derived illustration — not a captured product state
Mockup of a loaded Pagila file area
Pagila File Areas state. Fixture totals are certified; the pictured UI state is a source-derived mockup.Source baseline: beta f7b7740e

MOCKUP — flat CSV tutorial. This source-derived asset shows the per-file Define Transformation controls for the flattened CSV, not the six-node Constellation editor.

MOCKUPSource-derived illustration — not a captured product state
Mockup of the Pagila transform plan
Pagila transform mapping based on the current File Areas plan surface.Source baseline: beta f7b7740e

MOCKUP — flat CSV tutorial. This source-derived asset shows a flat-file FILE_ETL job. Read its own MOCKUP label; it is not a configured product capture.

MOCKUPSource-derived illustration — not a captured product state
Mockup of an in-progress Pagila FILE_ETL job
In-progress Worker and ETL state based on the current Job Queue and FILE_ETL phase contracts.Source baseline: beta f7b7740e

Common mistakes

Section titled “Common mistakes”

Do not skip the transform review. A wrong type in the source will show up later as missing chart options, bad sorting, or failed filters.

Do not use production data for a first learning run unless your organization has approved that workflow.

Do not use this flattened table as the relation-aware maiden-flight model. Complete the JSON Constellation workflow when you need separate tables, declared relationships, and qualified fields.

Section titled “Related”