Catalogs
Catalogs in Peaka represent a collection of data sources or connectors, such as- a SaaS Platform (HubSpot, Stripe, etc.),
- relational databases (PostgreSQL, MariaDB, etc.),
- spreadsheets (Airtable, Google Sheets, etc.),
- a REST API returning a collection of objects (coming soon…).
Schemas
Schemas are a level below catalogs and can be thought of as namespaces that contain a collection of tables. A schema is used to group related tables and views within a catalog, providing a way to organize data in a hierarchical manner. Schemas are inherited from the underlying connector. Schemas have different meanings for relational databases and SaaS connectors in Peaka:- In relational databases, schemas often correspond to a database or a specific user’s workspace. For a PostgreSQL connector, schemas correspond to exact schemas with the connected database.
- In SaaS connectors, schemas refer to the groups of APIs according to the API organization of the SaaS providers. For example, HubSpot organizes its APIs under CRM, Marketing, etc.