What is a DFS Datastore
The DFS (Distributed File System) Datastore feature in Qualytics is designed to handle data stored in distributed file systems.
This includes file systems like Hadoop Distributed File System (HDFS) or similar distributed storage solutions.
Supported Distributed File Systems:
Qualytics supports DFS Datastores, catering to distributed file systems like:
- Amazon S3
- Google Cloud Storage
- Windows Azure Storage Blob
- Azure Blob File System
Users provide connection details for DFS Datastores, allowing Qualytics to establish a connection to the distributed file system.
The Catalog operation involves walking the directory tree, reading files with supported filename extensions, and creating containers based on file metadata.
Data Quality and Profiling:
DFS Datastores support the initiation of Profile Operations, allowing users to understand the structure and characteristics of the data stored in the distributed file system.
For a more detailed understanding of how Qualytics manages and interacts with containers in DFS Datastores, please refer to the Containers section in our comprehensive user guide.
This section covers topics such as container deletion, field deletion, and the initial profile of a Datastore's containers.
Multi-Token Filename Globbing and Container Formation:
Filenames with similar structures in the same folder are automatically included in a single globbed container during the Catalog operation.
Use Folders for Precise File Grouping
Organizing files within distinct folders is a straightforward and effective strategy in Distributed File Systems (DFS).
When all files in a folder share a common schema, it simplifies the process of grouping and managing them.
This approach ensures precise file grouping without relying on complex glob patterns.
How to Use Folders for Shared Schema:
1. Create a Folder:
Begin by creating a new folder in your distributed filesystem.
Suppose you have order data files with filenames like
Create a folder named
Ordersto group these files.
Qualytics Pattern: Qualytics will automatically create the container
orders_*.csv based on the filenames.
2. Place Related Files in the Folder:
Move or upload files that share a common schema into the created folder.
- Move the order data files into the
3. Repeat for Each Schema:
Create separate folders for different schemas, and organize files accordingly.
- Suppose you have customer data files with filenames like
- Create a folder named
Customersto group these files.
Qualytics Pattern: Qualytics will automatically create the pattern
customers_*.csv based on the filenames.
4. Naming Conventions:
Consider adopting clear and consistent naming conventions for folders to enhance organization.
- Use descriptive names for folders, such as
Customers, to make it easier to identify the contents.
Flowchart: Using Folders for Shared Schema
A[Start] -->|Create a Folder| B(Create Folder)
B -->|Place Related Files| C(Move or Upload Files)
C -->|Repeat for Each Schema| D(Create Separate Folders)
D -->|Naming Conventions| E(Consider Clear Naming)
E --> F[End]
Use Filename Conventions for Posix Globs:
This option leverages filename conventions that align with POSIX globs, allowing our system to automatically organize files for you.
The system intelligently analyzes filename patterns, making the process seamless and efficient.
How to Use Filename Conventions for Posix Globs
1. Follow Clear Filename Conventions:
Adopt clear and consistent filename conventions that lend themselves to POSIX globs.
- Suppose you have log files with filenames like
- Use a consistent naming convention like
*serves as a placeholder for varying elements.
*in the convention acts as a wildcard, representing any variation in the filename. In this example, it matches the date part (
2. Upload or Move Files:
Upload or move files with filenames following the adopted conventions to your distributed filesystem.
- Move log files with the specified naming convention to your DFS.
3. System Analysis:
Our system will automatically detect and analyze the filename conventions, creating appropriate glob patterns.
- With filenames like
app_log_20240228.txt, the system will create the pattern
Flowchart: Using Folders for Filename Conventions
A[Start] -->|Follow Clear Conventions| B(Adopt Consistent Conventions)
B -->|Upload or Move Files| C(Move Files to DFS)
C -->|System Analysis| D(Automatic Pattern Creation)
D --> E[End]
Why not manually creating your own Globs?
While our system offers powerful features to automate file organization, we strongly discourage manually creating globs.
This option may lead to errors, inconsistencies, and hinder the efficiency of our system.
We recommend leveraging our automated tools for a seamless and error-free experience.
Complexity and Error-Prone:
Manually creating globs can be complex, prone to typos, and susceptible to errors in pattern formation.
- Suppose you want to group log files with the pattern
app_log_*.txt. A manual attempt might result in mistakes like
Inconsistencies Across Files:
Manual glob creation may lead to inconsistencies across different files, making it challenging to establish a uniform file organization.
- Trying to manually create globs for order data files with varying date formats (
orders-20240228.csv) can result in inconsistent patterns.
Explore Deeper Knowledge
If you want to go deeper into the knowledge or if you are curious and want to learn more about DFS filename globbing, you can explore our comprehensive guide here: How DFS Filename Globbing Works.