Managing Catalogs preview

Arctic Catalog Page

Arctic catalog information is broken out into tabs as shown in the following image:

Data Tab

The data tab lists the folders, tables, and views that are available in the catalog’s selected branch.

1. List of data objects: Displays a list of all the objects in the selected branch.
2. Filter search bar: Enables you to filter the data objects in the selected branch based on keywords.
3. History button: Navigates you to the Commits tab where you can view the history of the commits made in the selected branch.

With folders, a second level breadcrumb will appear when you select a folder. This breadcrumb is a navigation aid that provides links to the pages that are in the hierarchy of the current folder. The top level page is the current catalog that you are in.

Commits Tab

The commit tab displays all the commits that have been created for the selected branch.

1. List of commits: Displays a list of commits for the selected branch. Commit information includes the author, the commit ID, the commit message, and the commit time.
2. Go to data button: Navigates you to the Data tab where you can view all the available data objects.
3. Filter search bar: Enables you to filter the commits based on keywords.

You can take the following actions for each commit:

• Go to data: Navigate to the available data objects for the selected commit.
• Create branch (): Create a branch off the selected commit.
• Add tag: Create a tag to refer easily to a particular commit in queries.

When you select a commit, you will navigate to the commit details page that contains the following information:

• Author: If using Dremio Sonar the author’s ID is displayed. If using an external engine, the username is displayed.
• Commit time: The time that the commit was made.
• Tags: Any tags that are associated with the commit. You can also create a new tag for this commit.
• Description: The commit message which provides a description of the commit and can be the SQL string that the commit represents.

Tags Tab

The Tags tab displays all the tags that have been created for the selected branch.

1. List of tags: Displays a list of tags in the selected branch and includes the following information: the tag name, author, commit ID, commit message, and the commit time.
2. Filter search bar: Enables you to filter the tags based on keywords.

You can take the following actions for each tag:

• Go to data: Navigate to the available data objects for the particular commit referred to by the tag.
• Create branch (): Create a branch off the selected commit referred to by the tag.
• Add tag: Create an additional tag to refer easily to the particular commit.

Branches Tab

The Branches tab displays the default and other branches that are available.

1. Default branch: The main branch in the catalog.
2. Other branches: Other branches that have been created in the catalog.
3. Filter search bar: Enables you to filter the branches based on keywords.

Branch information that is available includes the commit ID, the commit message, and the commit time. You can take the following actions for each branch:

• Go to data: Navigate to the available data objects for the branch.
• Merge (): Merge a branch into another branch.
• Create branch (): Create a branch.
• Additional options (…):
  • Add tag: Create a tag that refers to the head commit of the selected branch.
  • Delete: Permanently remove a branch. Once a branch is deleted, it cannot be restored.

Learning More

To learn how to add a catalog or connect an engine to Arctic, see Setting Up Arctic. To learn about the available SQL commands for Arctic to manage your tables and views, as well as using commits, branches, and tags, see SQL Commands.