Skip to main content

Catalogs

Catalogs is where you browse and manage data in your warehouse. Data is organized as Catalog → Database → Table / View. You can create, delete, or rename objects at any level.

To open Catalogs:

  1. Go to the VeloDB Cloud console.
  2. In the left navigation pane, click Catalogs.

Catalog

A catalog is a collection of databases. VeloDB Cloud has two catalog types:

  • Internal catalog: contains VeloDB's own databases.
  • External catalog: connects to Hive, Iceberg, Hudi, and other lakehouse formats through VeloDB's data-lake support.

The catalog list shows each catalog's name, type, and available actions. To delete a catalog, click the delete icon in the Actions column. To add a new external catalog, click + Add External Catalog.

Database

A database is a collection of tables, views, materialized views, and functions. When you select a catalog, the Databases tab lists all databases under it, showing each database's name, data size, and available actions. You can rename and delete databases from this page.

Table

A table is the basic unit of data in VeloDB Cloud. When you select a database, the Table tab lists all tables under it, showing each table's name, data size, creation time, last modified time, and comment. From this page, you can import data into a table or delete it.

Click a table to open its detail page. The detail page has four tabs:

  • Details: shows the table definition and basic information, including data model, row count, data size, creation time, and last modified time.
  • Field information: lists each column's name, data type, key status, nullability, and visibility.
  • Indexes: shows the table's indexes.
  • Data overview: shows the first 100 rows of the table so you can spot-check the content. The row count comes from the metadata service, so it may lag behind real-time writes.

View

A view is a virtual table backed by a SQL result set. The view page mirrors the table page; attributes that don't apply to views (for example, indexes) are omitted. Views also support Data Preview (first 100 rows).

Materialized view

A materialized view pre-computes and stores query results to accelerate queries and reduce real-time compute load. Catalogs lists materialized views for each database.

Function

Catalogs lists the functions defined in each database, including function type, return type, and creation statement.