Data & Storage

OrbexDB Guide

OrbexDB is the Genorbex warehouse layer for native tables, connected data analysis, SQL workflows, pipelines, masking, governance, and AI-assisted business intelligence.

OrbexDB Capabilities

Feature	Usage
Databases, schemas, and tables	Create logical database structures, inspect schema context, load rows, and query native warehouse data.
SQL query engine	Run analytics queries, table reads, joins, aggregations, table creation, inserts, merge/update/delete flows, and supported Snowflake-like SQL patterns.
Assistant-assisted SQL	Ask the AI assistant to analyze available tables, generate SQL, answer business questions, and prepare approved table creation or load actions.
Auto ingest and bucket loading	Load bucket objects, external files, CSV-like data, and cloud storage events into OrbexDB tables through ingest and pipeline services.
Pipelines and scheduling	Create repeatable data pipelines, schedule execution, monitor runs, and use bucket triggers where configured.
Security and governance	Use roles, GRANT/REVOKE-style permissions, masking policy assistance, data masking, and team permissions for controlled access.
Performance features	Use caching, query plans, micro-partitioning, materialized view support, streams, and warehouse-oriented optimization paths where available.
Integrations and exports	Connect OrbexDB to connectors, workflows, notebooks, Cloud Storage Integrator, Dynamic Search, reports, and assistant-generated outputs.

Common Workflow

Create a database

Open OrbexDB, create or select a database, then define schemas and tables for the domain you want to analyze.

Load data

Use uploads, buckets, connector outputs, generated datasets, pipeline jobs, or assistant-prepared create-and-load actions.

Query and analyze

Run SQL directly or ask the AI Assistant Agent to answer questions from available schema and sample row context.

Govern access

Apply roles, team permissions, GRANT/REVOKE-style access, masking policy recommendations, and approval workflows.

Automate

Schedule pipelines, export query results, feed reports, or use workflows to move OrbexDB data into downstream systems.

Governance Notes

Use team permissions to control who can access OrbexDB resources.

Use role and grant flows for object-level access patterns.

Use masking assistance for sensitive columns and policy recommendations.

Review AI-prepared write actions before executing schema or data changes.

SQL Examples

Read data

SELECT * FROM analytics.orders LIMIT 50;

Aggregate

SELECT sales_rep, SUM(deal_value) AS total_value FROM crm.deals GROUP BY sales_rep ORDER BY total_value DESC;

Create table

CREATE TABLE crm.accounts (id STRING, name STRING, owner STRING, created_at TIMESTAMP);

Load rows

INSERT INTO crm.accounts (id, name, owner) VALUES ('acct_1', 'Acme', 'Sales Team');

Related Surfaces

AI Assistant

Ask questions over table context.

Pipelines

Schedule and orchestrate loads.

Exports

Send results to cloud storage.

Access

Manage roles and permissions.

Masking

Protect sensitive columns.

Performance

Use plans, cache, and optimizations.