Explore Folder OvalSight
Click on the connection name in the Data Lake OvalSight will display the contents of the selected connection. It provides detailed statistics for insights into the selected connector and its folders, subfolders, and files. The following details are available on the dashboard:
OvalSight Summary
The Folder OvalSight Summary offers comprehensive insights into the structure and content of specific folders. This Summary provides an in-depth analysis of nested levels within a folder, detailing all subfolders and files up to the last level.
Folder Tiles
The Folder OvalSight Summary gives a quick overview of a folder's structure and data content. It displays key details like:
Folder level within the Data Lake
Depth of nested subfolders
Total number of subfolders (including empty ones)
Total number of files
The Total Folders, Empty Folders, and Total File Count tiles include Expand and Collapse options.
Drill down to view folder names, file counts, and last modified dates.
Click a folder name to open it in File Explorer and see file details.
Use the search bar at the top of the pop-up to find specific folders.
The Total File Count tile also includes Expand and Collapse options.
Clicking the icon opens a pop-up displaying all files, their names, and the last modified dates.
Clicking a file name navigates to the File Explorer file details page, displaying all associated file information for the selected data lake.
This summary helps to understand the folder's complexity and data volume at a glance. This information supports informed decisions on data organization and access permissions.
Top 10 File Formats
The Summary uses interactive charts to make analyzing file formats and sizes within a folder easy.
Donut Charts: These colorful charts show the most common file formats (top 10) and their prevalence. Hovering over a section reveals details like file names, the number of files, and their percentage of the total.
Total Formats: A central number displays the overall number of unique file formats, highlighting format diversity.
File Types Exploration: Clicking on a file type count segment in the chart shows a list of all files within that range.
View All: Explore all file formats, not just the top 10, by clicking the "View All" button. The full list displays each format with its file count and percentage. Click a format to view all associated files.
File Size Ranges
The Summary provides insights into how storage space is utilized within the folder. A "File Size Range Analysis" chart breaks down files into five size categories:
Less than 100KB
100KB - 1MB
1MB - 10MB
10MB - 100MB
Over 100MB
Hovering over a section reveals how many files fall into each size range.
Click on a specific size segment to see a detailed list of all files within that range. This helps identify large or potentially redundant files that might be good candidates for archiving, compression, or deletion.
Folder & File Modification Summary
The Folder OvalSight Summary shows how data usage changes over time. It uses bar graphs to track folder and file modifications by quarter within a chosen year. This helps to identify trends and patterns in data activity, such as:
A spike in folder changes during a quarter might indicate a project phase or data migration.
Increased file modifications could signal periods of busy workflow or data intake.
By understanding trends to plan future needs and manage data proactively. Hover over a bar to see the number of folders or files modified in that quarter. Click a bar to view all items changed during that period for deeper analysis or action.
List View of Folder OvalSight
The List View provides a detailed look at a folder's immediate contents. Unlike the Summary, which offers a high-level overview, the List View analyzes the files within the selected folder and its direct subfolders.
The List View displays metadata for all folders within Data Lake itself with the following details:
Folder Name: Names of all folders and subfolders in a Data Lake or a File System.
OvalSight Summary: On clicking the OvalSight icon, it displays the OvalSight Summary of that particular folder.
File OvalSight: On clicking the OvalSIght icon, it displays details about the immediate files of that particular folder.
Folder Level: Displays the folder level of any particular folder featured in the Folder OvalSight tab. The main or first level of a folder is assigned a Folder Level of '1', the second level as ‘2’, and so on.
Folder Type: Indicates the category the folder falls into, with five defined categories:
RFWF - Regular Folder with Files
RFNF - Regular Folder with No Files
SFWF - Structured Folder with Files
SSFWF - Semi-Structured Folder with Files
UFWF - Unstructured Folder with Files
Catalog: Shows the option for Authors to catalog a folder.
Subfolder Count: Displays the number of subfolders that are inside any particular folder.
Number of Files: Displays the number of files in that particular folder, excluding files in its subfolders.
Folder Size: Displays the size of the folder in kilobytes (KB).
File Sizes: It displays the number of files below 100 KB, between 100 KB to 200 KB, and above 200 KB.
File Types: This column displays the various types of files found in the folder, such as .ddl, .yaml, .parquet, and .csv. Clicking the eye icon that appears on hover brings up a pop-up list of all the file types.
Sample Files: This column showcases the last 50 modified sample files from the folder. Clicking the eye icon that appears on hover reveals a pop-up list of these 50 sample files.
Last Modified Date: This column indicates the date on which a folder was last modified on the source, based on the modification date of any file within it.
Quick & Easy Discovery of Folder OvalSight
The Folder OvalSight List View offers a simple, table-based layout for easy data exploration. Use filters, search, and sorting to quickly locate needed data.
Filters: Use the drop-down in each column to apply predefined filters. Narrow down results by searching within filter options.
Search: Use the search bar to find specific data objects. Apply conditional search using the eight dots icon to include or exclude keywords.
Sort: Click column headers to sort data. Sort by multiple columns to create a customized view.
File OvalSight
The File OvalSight column provides a quick view of file analysis within a folder. Clicking the File OvalSight icon in this column opens a pop-up window displaying detailed information about those files.
File Name: Displays all the file names existing in that particular folder.
File Type: Shows the type of file, such as .json, .csv, .zip, etc.
Catalog: Shows the option for Authors to catalog a file.
Size: Displays the size of the file in kilobytes (KB).
Last Modified Date: This shows the latest date when the file was modified at the source system. The change of this date will be reflected when the admin will re-catalog the Data Lake.
Tree View of Folder OvalSight
Folder OvalSight Tree View provides a dynamic way to explore the data structure. Navigate through folders and subfolders with detailed Folder OvalSight information displayed at each level, similar to the List View.
Access the view by clicking the Tree tab within Folder OvalSight.
Quickly drill up through the folder hierarchy for easier navigation.
Tree View offers search, sort, and filter options, enabling efficient metadata management and analysis, even in complex folder structures.
Data Lake Search
Data Lake Search enables searching for files and folders across the entire Data Lake connection.
Search by file or folder names to open a pop-up window displaying detailed information about the search results, including:
Folder/File Name: Identifies the searched Folder or File.
Folder/File Level: Indicates the hierarchical position of the Folder or File
Type: Distinguishes between folders and files.
Catalog: Shows the option for Authors to catalog a file.
Size: Displays the folder or file size in kilobytes (KB).
Last Modified Date: This shows the latest date when the folder or file was modified at the source system. The change in this date will be reflected when the admin re-catalogs the Data Lake.
Copyright © 2025, OvalEdge LLC, Peachtree Corners, GA USA
Last updated
Was this helpful?