Custom Client Schema

Database schemas are logical collections of data objects. The Disco Database has the following schemas:

  • Client schema ([Client]) - Contains all tables created and maintained in the Client Extension. You need to create your tables in the [Client] schema, which exists in your Database instance.
  • DBO schema ([dbo]) - Contains DirectScale tables

The Client schema contains all tables created and maintained in the Client Extension. You can edit your custom tables in the Data Editor.

  1. Using the Visual editor, select a table in the Table List sidebar:

    • Custom Client tables are prefixed with client (Client.CurrencyLog).
    • DirectScale tables are prefixed with dbo (dbo.CRM_Stats).
  2. Under the SQL editor, to select a Client table, enter the following query format:

    UPDATE [client].[tablename] SET column1 = 'value'
    

    All queries must have the schema name or they will fail.

⚠Important

Client Custom tables must have a recordnumber (int) primary key column and a last_modified (datetime) column to edit.

Both schema names appear in custom reports and data viewed with the SQL Manager.