Administration

Service management

All service management procedures require the app_admin role.

Start services:

CALL veil.core.start_services();

Stop services:

CALL veil.core.stop_services();

Check status:

CALL veil.core.service_status();

Wait for readiness (blocks up to 10 minutes):

CALL veil.core.wait_for_services();

Encoder management

List encoders

SELECT * FROM veil.encoders_v;

View training history

SELECT encoder_name, status, progress, created_at
FROM veil.training_jobs_v
ORDER BY created_at DESC;

View archived versions

SELECT * FROM veil.encoder_versions_v WHERE encoder_name = 'sales';

Delete an encoder

Removes the active model file, all archived versions, the feature view, the feature function, and the registry entry:

CALL veil.delete_encoder('sales');

Feature views

Create from encoder metadata

After training completes, generate the view automatically:

CALL veil.create_view_from_encoder('sales');

Create manually

CALL veil.create_feature_view(
    'my_db.my_schema.sales',
    'sales',
    ARRAY_CONSTRUCT('price', 'sqft', 'bedrooms', 'bathrooms'),
    ARRAY_CONSTRUCT('year_built')
);

Protection

Apply masking policy

CALL veil.protect_column('my_db.my_schema.sales_v', 'features');

Remove masking policy

CALL veil.unprotect_column('my_db.my_schema.sales_v', 'features');

Monitoring

Billing events

SELECT * FROM veil.billing_events_v;

Training job status

SELECT encoder_name, status, progress, error_category
FROM veil.training_jobs_v
WHERE status = 'failed';

Consumer-visible job status shows safe category messages. Full diagnostics are in the SPCS service logs.