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.
-
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).
- Custom Client tables are prefixed with
-
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.
Updated about 2 years ago
Related Docs