🗄️ Data Objects Overview

Data objects are discrete pieces of data imported into ARPIA from various sources, forming the building blocks for all data operations. The Data Objects interface allows you to manage repositories, tables, views, functions, and automated triggers efficiently.

🎯 Interface Overview

Repository Selection - Choose from your available repositories (e.g., education_registry)

Search - Quickly filter objects using the search bar

Quick Actions - AI ASSISTANT, TABLE, VIEW, TRIGGER, FUNCTION buttons for rapid creation

⚙️ Key Features

Tables

Import and manage your data in structured tables. Each table displays:

Row Count
Collation settings
API usage metrics (Last 3 Months)
Creation timestamp

What you can do with tables:

View Object - Inspect columns, indexes, sample data, and the SQL query used to create the table
Edit Data - Import from CSV/TXT files, add new rows, and edit existing data with an interactive preview
Import - Bulk import data from CSV/TXT files with options for handling duplicates and date formats
Table Data Profile - Analyze data quality with statistics, charts, and categorical analysis for each column
See Token - Generate API access token for programmatic table access
Design Object - Add, edit, or delete fields and manage table structure
Duplicate - Create empty (structure only) or complete copies with compression options
Create Snapshot - Generate compressed backup (optimized for querying or long-term storage)
Create Knowledge Node - Build a Knowledge Node using this table as the primary data source
Add Trigger - Automate actions on table events (INSERT, UPDATE, DELETE)

Learn more about Data Object Actions

Views

Create virtual tables dynamically from existing physical tables.

Learn how to create a view

Functions

Create custom SQL routines (functions or stored procedures) that encapsulate reusable logic for calculations, transformations, and multi-step operations.

Learn how to create functions

Triggers

Automate actions when table events (INSERT, UPDATE, DELETE) occur.

Available trigger types:

Replication - Record and track data changes for analysis
Notification - Send alerts and trigger workflows based on data changes
WebHook - Send data to external systems via HTTP POST in JSON format
Audit Log - Maintain comprehensive change logs for compliance
Manual Trigger - Execute custom SQL code for specialized automation

Configure triggers with conditions and filters to fire only when specific criteria are met.

Learn how to create a trigger

Prepared Tables

Specialized data objects used in DataWorkshop for machine learning models.

Tables Snapshots

Create compressed copies of your tables in two formats:

Compress Only - Faster to create, optimized for querying data
Compressed Snapshot for Backup - Comprehensive format for backups and long-term archival

AI Assistant

Generate tables or views by describing your requirements in plain language. The Arpia Codex Assistant analyzes your needs in context of existing repository objects.

Note: To use the AI Assistant, you must enable AI in the workarea.