Views

AIQu VEIL exposes views in the core schema for monitoring encoders, training jobs, schedules, and audit history. Admin views include full metadata. Public views expose a subset safe for non-admin roles.

Encoders

core.encoders_v

All registered encoders with full metadata. Requires app_admin. Includes all columns from encoders_public_v plus source_table, feature_columns, passthrough_columns, stage_path, and training configuration.

SELECT * FROM <app_name>.core.encoders_v;

core.encoders_public_v

Encoder list for non-admin roles. Requires app_user.

Column	Type	Description
encoder_name	VARCHAR	Encoder name
output_dims	INTEGER	Latent vector dimension
version	VARCHAR	Current version label
version_num	INTEGER	Numeric version
created_at	TIMESTAMP	Creation time

SELECT * FROM <app_name>.core.encoders_public_v;

Encoder Versions

core.encoder_versions_v

Full version archive. Requires app_admin. Includes all columns from the public view plus source_table, feature_columns, passthrough_columns, and stage_path.

core.encoder_versions_public_v

Version archive for non-admin roles. Requires app_user.

Column	Type	Description
encoder_name	VARCHAR	Encoder name
version_num	INTEGER	Version number
version	VARCHAR	Version label
output_dims	INTEGER	Latent vector dimension
created_at	TIMESTAMP	When this version was trained
created_by	VARCHAR	Role that initiated training
archived_at	TIMESTAMP	When this version was superseded

Training Jobs

core.training_jobs_v

Job status with full metadata. Requires app_admin. Includes all columns from the public view plus source_table, feature_columns, latent_dims, epochs, batch_size, and error_message.

core.training_jobs_public_v

Job status for non-admin roles. Requires app_user.

Column	Type	Description
job_id	VARCHAR	Job identifier
encoder_name	VARCHAR	Target encoder
status	VARCHAR	Current status
progress	FLOAT	Completion percentage
has_error	BOOLEAN	Whether the job failed
duration_seconds	INTEGER	Elapsed time

Status values: pending, running, publishing, completed, failed, cancelled.

SELECT job_id, encoder_name, status, progress
FROM <app_name>.core.training_jobs_public_v
WHERE encoder_name = 'sales';

Training Schedules

core.training_schedules_v

Active schedules with full metadata. Requires app_admin. Includes all columns from the public view plus source_table and version_num from the encoder registry, and last job status from training history.

core.training_schedules_public_v

Active schedules for non-admin roles. Requires app_user.

Column	Type	Description
encoder_name	VARCHAR	Encoder name
schedule	VARCHAR	Cron expression or interval
row_threshold	INTEGER	Growth trigger (null if not set)
baseline_rows	INTEGER	Row count at schedule creation
scheduled_at	TIMESTAMP	When the schedule was created
scheduled_by	VARCHAR	Role that created the schedule
current_version	VARCHAR	Active encoder version
last_job_status	VARCHAR	Status of most recent scheduled run
last_job_completed	TIMESTAMP	Completion time of most recent run

Audit Log

core.audit_log_v

Full audit trail of all operations. Requires app_admin.

core.audit_log_public_v

Audit trail for non-admin roles. Sensitive fields redacted from details and target_object. Requires app_user.

Health

core.health_v

Service health status. Shows whether the encoding and training services are running. Requires app_admin. For detailed diagnostics including container logs, use service_status().

SELECT * FROM <app_name>.core.health_v;