Container Types

There are two main types of containers in Qualytics:

JDBC Container

JDBC containers are virtual representations of database objects, making it easier to work with data stored in relational databases. Sync creates a container for each table (data organized into rows and columns like a spreadsheet) and each view (a customized display of data from one or more tables) selected for that run. Tables or views left out of the run are not created, and neither are containers deleted earlier unless the run uses Recreate. Other database objects, such as indexes or stored procedures, do not become containers. Acting as a bridge between applications and databases, JDBC enables seamless interaction with these containers, allowing efficient data management and retrieval.

DFS Container

DFS containers are used to represent files stored in distributed file systems, such as Hadoop or cloud storage. These files can include formats like CSV, JSON, or Parquet, which are commonly used for storing and organizing data. DFS containers make it easier for applications to work with these files by providing a structured way to access and process data in large-scale storage systems.

Each DFS container carries the file format that Sync detected for its files. The container's details show it in a File Format row, both in the footer of the datastore tree when the container is selected and in the details shown on the container's breadcrumb, so you can tell a Parquet container from a CSV one at a glance. For the formats Qualytics reads, see Supported File Formats.