Overview
Explorer allows you to view data in multiple representations depending on the source and your goal.
Viewing Data in a Grid
The grid view displays data in a table format and is available for both SQL and non-SQL connections.
Opening data in a grid
To open data in a grid:
-
Select a metadata object such as a table, view, file, endpoint, or key
-
Click View Data on the toolbar or use the right-click menu
The dataset opens in a new Data tab.
Row limits and performance
Explorer displays up to 1,000 rows per dataset.
The status bar at the bottom of the grid shows:
-
Maximum number of rows allowed
-
Actual number of rows returned
This limit protects the UI and browser performance.
Read how to change the row limit.
Working with the data grid
When data is displayed in a grid, you can:
-
Resize columns by dragging column borders
-
Sort data by clicking column headers
-
Select all cells using Ctrl+A
-
Copy selected cells using Ctrl+C
These operations are client-side and do not requery the source.
Navigating Nested Datasets
Many non-relational sources return nested data structures.
When a dataset contains nested elements:
-
Explorer displays a Dataset link in the grid
-
Clicking the link drills down one level into the nested dataset
When you are not at the root level:
-
Explorer shows a Back option
-
A row from the previous level is displayed for context
This allows step-by-step navigation through complex nested structures.
Viewing a Single Record (Form View)
In addition to the grid, Explorer provides a form view for inspecting one record at a time.
Opening form view
To open a record in form view:
-
Double-click a row in the grid
or
-
Select a row and click Open Selected Row in a Form View
The record opens in a form-style layout showing all fields and values.
When to use form view
Form view is useful when:
-
Records contain many columns
-
Values are long or deeply nested
-
You want to inspect one record in detail
Viewing Raw Data
Raw data view displays the data exactly as it is returned by the source, without parsing into a grid.
Supported connections
Raw data is available for:
-
File and cloud storage connections
-
Web services and APIs
-
Redis
-
Message queues
Raw data is not available for relational database connections.
Opening raw data
To view raw data:
- Select a non-database connection
- Drill down to a specific file, endpoint, key, or document
- Click Raw Data on the toolbar or use the right-click menu
The raw response opens in a new Raw Data tab.
Exporting Data from a Grid
Grid data can be exported to a file in any supported format.
Exporting a dataset
To export grid data:
-
Open a dataset in grid view
-
Click Export to File in the grid toolbar or Download file in the right click menu.
-
Select a target format such as CSV or JSON
-
Click Export
The exported file is generated using the currently displayed dataset.
Working with Files While Exploring Data
Explorer allows basic file operations directly from the data exploration workflow.
Downloading files
To download a file:
-
Select a file under a supported connection
-
Click Download File or use the right-click menu
The file is downloaded to your local machine.
Uploading files
To upload files:
-
Select a file-based or cloud storage connection
-
Click Upload Files
-
Drag and drop files or select them from your computer
Each file is uploaded individually. Upload progress is displayed in the UI.
The maximum size for a single uploaded file is 10 MB. Contact Etlworks if larger uploads are required.
Deleting files
To delete a single file
-
Select one file under supported connection
-
Click Delete file
-
Confirm the deletion
To delete multiple files
- Select File or Cloud storage connection
- Select Info tab on the right
- Select one or multiple files
- Click Delete selected
- Confirm the deletion
Deleted files are removed immediately from the source.
Summary
Etlworks Explorer allows you to:
-
View data in grid, form, or raw format
-
Navigate nested datasets interactively
-
Export datasets to files
-
Upload, download, and delete files while exploring data