Exploration
VDA offers powerful and comprehensive data exploration capabilities, allowing users to efficiently locate and access the data they need. This functionality supports searches based on various criteria, including table names, column names, database names, schema names, and tags associated with tables. Here’s a detailed overview of these search capabilities:
Table Search
Description: Allows users to search for data by specifying the table name.
Use Case: Ideal for users who know the specific table they need to access or analyze.
Example: A user can quickly locate the "Bank" table to review the data
Benefit: Streamlines the process of finding relevant tables, saving time and effort.
Steps
Click on Dataset
Enter the table name followed by *(if you don't remember exact name)
Column Search
Description: Enables users to search within tables based on column names.
Use Case: Useful when users are looking for specific data attributes or fields across multiple tables.
Example: A user searching for "card" can find all tables containing this column.
Benefit: Facilitates detailed and targeted data searches, enhancing data discovery.
Database Search
Description: Supports searches by database names(Ex. postgres, Oracle etc), helping users locate data within specific databases.
Use Case: Essential for organizations with multiple databases, allowing users to focus their search on a particular database.
Example: A user can search for the "postgres" to find all relevant tables and datasets within this type of database.
Benefit: Simplifies navigation through large, complex data environments by narrowing down search scope.
Schema Search
Description: Allows users to search based on schema names within a database.
Use Case: Beneficial for users who need to access data organized under specific schemas.
Example: Searching for the "public" schema will return all tables and objects within that schema.
Benefit: Provides an organized view of data structures, making it easier to locate data assets.
Tag-Based Search
Description: Enables searches using tags associated with tables, allowing for thematic or categorical searches.
Use Case: Useful for users who categorize data tables with tags such as "financial," "archived," or "sensitive."
Example: A user searching for the tag "sensitive" will find all tables marked as containing sensitive information.
Benefit: Enhances data organization and discoverability, enabling users to find data based on specific characteristics or purposes.
Data Exploration Benefits
Efficiency: The ability to search based on table, column, database, schema, and tags significantly reduces the time spent locating specific data.
Comprehensiveness: By supporting multiple search criteria, the VDA tool ensures that users can find exactly what they need, regardless of their starting point or the detail they have.
Usability: A user-friendly search interface allows both technical and non-technical users to perform searches with ease, promoting wider adoption and usage.
Data Discovery: Enhanced search capabilities foster better data discovery, enabling users to uncover hidden insights and relationships within the data.
Organization: Helps maintain a well-organized data environment, where data assets are easily accessible and efficiently categorized.
Last updated
