Show Schemas

The SHOW SCHEMAS command returns a result set showing the schemas available in the Connect environment.

show schemas;

None.

The Connect environment includes four schemas by default. Developers can create custom schemas using the CREATE SCHEMA command.

delta – Use this schema to create and manage custom temporary and other working tables needed to support ETL steps and pipelines.
staging – The staging schema contains standard staging tables used to modify data within Incent. The incent validate orders andincent upload orders commands provide a standard mechanism for transferring data from staging tables into corresponding target tables within the Incent application. Note that developers can SELECT, INSERT, UPDATE, and DELETE data in staging schema tables.CREATE and DROP table actions are prohibited.
xactly – The xactly schema provides read-only access to Incent application tables. Incent application tables contain data about payees, positions, sales orders, calculation results, and more.
xdms – Provides read-only access to tables related to buttons in the Incent DELTA Portal user interface. Developers can query these tables to evaluate input parameters associated with any custom DELTA Portal button processes that exist in a customer’s Incent instance.

select * from (show schemas);
 
select name, created_instant from (show schemas);