Core Concepts
Understand the underlying architecture of Automat BI, including Inventory, Catalog, system roles, and automated scheduling.
Data Backbone Workflow
The platform separates data assets into distinct layers to protect raw records while providing clean analytical views:
- Data Automation Pipelines interact directly with Inventory to read and write physical objects.
- Reports query the Catalog to access secure, business-friendly views.
- Dashboards & Reports render structured insights for decision-makers.
Inventory: Physical Data Layer
The Inventory acts as a registry of all physical data storage locations connected to your site.
Supported Components
- Databases: BigQuery, ClickHouse, PostgreSQL tables.
- Files: Parquet, CSV, Excel, and JSON files stored in cloud storage or local volumes.
- APIs: Structured REST and HTTP responses.
Features
- Automatic schema detection across file formats.
- Native dialect support (BigQuery SQL, ClickHouse SQL).
- Visibility rules to hide staging tables from end users.
- Tenant isolation based on account configuration.
Catalog: Business Abstraction Layer
The Catalog provides curated, business-friendly views mapped over physical inventory tables.
Core Capabilities
- Abstraction: Map raw file paths like
s3://data/sales_2026.parquetto a clear name likesales. - Consolidation: Combine partitioned files (
s3://data/sales_*.parquet) into unified logical datasets. - Security Rules: Apply row-level and column-level filters automatically based on user context.
- Storage Independence: Switch underlying physical tables without altering downstream reports.
Administration & Governance
User Roles & Permissions
Access control relies on explicit Role-Based Access Control (RBAC):
| Role | Permissions |
|---|---|
| Viewer | View dashboards and standard reports. |
| Analyst | Create and modify reports and dashboards. |
| Designer | Build Data Automation pipelines and define Catalog abstraction rules. |
| Admin | Manage site configurations, integrations, and global user permissions. |
| Tenant Admin | Manage accounts and access within a specific tenant boundary. |
Jobs & Scheduling
Sequence multiple pipelines into automated Jobs that execute on set schedules or system events.
- Cron Scheduling: Set precise recurring run times.
- Event Triggers: Start execution when new files arrive or API webhooks trigger.
- Monitoring: Track execution logs, inspect bottlenecks, and receive failure alerts.
Dimensions: Smart Filters
Dimensions represent business hierarchies (such as Category → Subcategory → Product) used across reports and dashboards. Stored as specialized Catalog entries, dimensions allow cross-report slicing and automatic time intelligence.