📌 Summary

<aside> 💡

Databases in cofi.ai serve as the central repositories where data from multiple sources is unified, structured, and prepared for use in models, metrics, and dashboards. They provide a transparent and flexible way to manage the data that powers your workspace.

</aside>

🎯 What is a Database?

A database represents the organized structure of all the data that flows into your workspace. Each database consolidates and standardizes data from various sources—such as CSV uploads, ERP systems, or CRMs—so that it can be used for analysis and visualization.

Databases act as the link between data sources (where data originates) and models (where insights are generated).

🗂 Database Structure

Each database includes three main sections that help you view, manage, and configure data:

1. Overview

• Displays a summary of the database, including record count, status, and timestamps for last creation and update.
• Allows you to filter, search, or export data for quick review.
• Shows data health indicators (e.g., ✅ OK or ⚠️ Error).

2. Sources

• Lists all the data sources connected to the database.
• Allows you to add, remove, or reconfigure sources (like connected systems or file uploads).
• Provides real-time visibility into synchronization status and last refresh.

3. Settings

• Defines the schema, or structure, of your data.
• Allows configuration of column types, formulas, and relationships to other databases.