Data Exploration

Exploring Tables

The data exploration view provides a comprehensive way to understand your data structure and contents.

Table View

When you select a table, you'll see:

• Column Headers - Click to sort by that column
• Data Grid - Scrollable view of table data
• Row Count - Total number of records
• Pagination - Navigate through large datasets

Filtering Data

Apply filters to focus on specific data subsets:

Quick Filters

• Click the filter icon on any column header
• Select filter type (equals, contains, greater than, etc.)
• Enter the filter value
• Apply multiple filters for complex queries

Filter Types

Data Profiling

Click on any column to view detailed profiling information:

• Data Type - Column data type and format
• Null Count - Number of null/missing values
• Unique Values - Count of distinct values
• Distribution - Value distribution histogram
• Min/Max - Minimum and maximum values for numeric columns
• Sample Values - Common values in the column

Exporting Data

Export data for use in other applications:

1. Apply any desired filters to the data
2. Click the Export button in the toolbar
3. Select the export format:
   • CSV - Comma-separated values
   • JSON - JavaScript Object Notation
   • Excel - Microsoft Excel format
   • Parquet - Columnar storage format
4. Choose to export all data or only filtered results
5. Download the file