Customer Settings - Connectors
Customer connectors let RebelCore register governed database views as External Silver Data.
Excel remains the default dataset import method. Database connectors are used when your organisation wants RebelCore to build a gold semantic dataset directly from a controlled database view instead of uploading a file.
Supported connectors
The dataset import blade currently supports:
- Microsoft SQL
- PostgreSQL
- MySQL
Redshift and Snowflake are shown as work in progress and are not available for External Silver Data imports yet.
External Silver Data contract
Only database views are exposed to RebelCore. Tables, stored procedures, functions, and arbitrary SQL are not shown or imported.
Every view intended for RebelCore must be prefixed with:
v_rc_For example:
v_rc_hr_employeesv_rc_sales_pipelinev_rc_finance_invoicesViews without this prefix are ignored by the import blade and cannot be registered as External Silver Data.
When data is read
Selecting a view in the import blade registers the view metadata only. RebelCore reads rows from the customer database when the module is built and vectorized into the gold semantic dataset.
Recommended view design
Create one view per business dataset. Keep column names clear, stable, and business-readable. Include only columns that are approved for RebelCore use.
Avoid exposing operational tables directly through a view that contains more data than needed. The view should already represent the curated silver-level data that RebelCore can promote into the gold semantic layer.