Data Platform Overview
The data platform is where you work with your data day-to-day. It provides a spreadsheet-like interface with the structure and validation of a database.
Interface Layout
The main interface consists of:
- Toolbar — Menu bar with File, Tools, and Help menus, plus your user profile
- Table Toolbar — Row count, add row button, filter/sort controls, and preset management
- Data Table — Your data in a scrollable, editable grid
- Properties Panel — Column and view settings (right sidebar)
- Activity Panel — Real-time activity feed showing changes by your team
Working with Data
Adding Rows
Click the Add Row button in the table toolbar. A dialog will appear with fields for each column in the current view. Required fields are marked, and constraints are validated before saving.
Editing Cells
Click on any cell to edit it inline. The cell editor adapts to the column type — text fields, number inputs, date pickers, dropdowns, and more.
Press Enter to save, Escape to cancel.
Selecting Rows
Click the checkbox on any row to select it. You can:
- Select individual rows for bulk operations
- Use "Select all" to select all rows on the current page
- Select all rows matching the current filter
Bulk Operations
With rows selected, a floating action bar appears at the bottom with options to:
- Edit — Change a field's value across all selected rows
- Export — Download selected rows
- Delete — Remove selected rows (with confirmation)
Real-Time Updates
SchemaStack uses server-sent events (SSE) to keep your view synchronized with other users. When someone else adds, edits, or deletes data, you'll see the changes appear automatically.
The connection status is shown as a banner:
- Connected — No banner, everything is in sync
- Reconnecting — A brief interruption, reconnecting automatically
- Disconnected — Connection lost, click "Reconnect" to restore
Activity Panel
The Activity Panel (right sidebar) shows a real-time feed of changes happening in the current workspace. Each entry includes:
- Event type — Row created, updated, or deleted; column added or modified; view changed
- Timestamp — When the event occurred
- User — Who made the change
Use the activity panel to stay aware of what your team is doing, review recent changes, or track down when a specific change was made.
Keyboard Shortcuts
| Shortcut | Action |
|---|---|
Ctrl+R | Refresh data |
Enter | Save cell edit |
Escape | Cancel cell edit |