Documentation

Core Concepts

Understand the underlying architecture of Automat BI, including Inventory, Catalog, system roles, and automated scheduling.

← Back to Documentation Hub

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.parquet to a clear name like sales.
  • 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.


← Back to Documentation Hub