Enabling Input Tables

For users in your enterprise to create Input Tables, a system administrator must deploy the table definition and create the Tables table, a user table that the system uses to keep track of Input Tables.

1. Deploy table definition

First you need to create a schema named DbConfig.Tables.schema, with the following content:

<Table name="Tables" namespace="DbConfig" storageType="NestedPartitionedOnDisk" >
   <Partitions keyFormula="__WRITABLE_PARTITIONS__[abs((__NS_TN__ + Sym).hashCode() + __DAY_OF_YEAR__) % __NUM_WRITABLE_PARTITIONS__]"/>
   <Column name="Date" dataType="String" columnType="Partitioning" /> 
   <Column name="Namespace" dataType="String" columnType="Normal" />
   <Column name="TableName" dataType="String" columnType="Normal" />
   <Column name="TableInputHandlerBlob" dataType="byte[]" columnType="Normal" /> 
   <Column name="_WorkerName" dataType="String" columnType="Normal" />
   <Column name="_ServerHostName" dataType="String" columnType="Normal" />
   <Column name="_ClientHostName" dataType="String" columnType="Normal" />
   <Column name="_ChangeTime" dataType="DateTime" columnType="Normal" />
   <Column name="_Deleted" dataType="Boolean" columnType="Normal" />
</Table>

Note: the namespace here is called DbConfig.

Place the file in /etc/sysconfig/illumon.d/schema (or the desired path if the file is being configured differently).

Deploy the schema using sudo service iris deploy_schema.

2. Create a user table using the definition:

tableDef = TableDefinition.loadDefinition(new File("/db/Systems/DbConfig/Definitions/Tables.tbl"))

db.addTableDefinition("__DbConfig", "Tables", tableDef)

Note: the namespace here is called _DbConfig.
Users must still be granted write access to Input tables via the ACL Editor before they will be able to create or edit Input Tables.

Once this is accomplished, it is possible to add and edit Input Tables in the Deephaven console.

See Input Tables in the User Guide for more information.

Last Updated: 23 September 2019 12:17 -04:00 UTC Deephaven v.1.20181212 (See other versions)