CapStormWizardConfig Table
The CapStormWizardConfig table is used to store information about best practice configurations in CapStorm/Platform applications (i.e. CS:Container or Snowflake CapStorm Salesforce Connector). Primary information for the configuration is stored in the config field. The structure of the data in the config field is dependent on the type of configuration record that is stored. All CapStorm best practice wizards have a designated type that maps to a specific structure to be stored. All information in the config field is JSON formatted.
The createdDate, createdBy, lastModifiedDate, and lastModifiedBy fields are audit fields to describe when and who initially created configuration records as well as when and who made the last modification.
The following table describes each field on the CapStormWizardConfig table:
| Column Name | Data Type | Required | Description |
|---|---|---|---|
| id | integer | Yes | Unique identifier assigned to the wizard configuration by the application. |
| name | varchar | Yes | A human-readable name assigned by a user to this configuration. |
| type | varchar | Yes | The type of wizard configuration that is stored in the record. |
| config | varchar | Yes | The actual configuration information in JSON format. The information stored here is dependent on the ‘type’ |
| createdDate | datetime | No | The date and time when the configuration was first created. |
| createdBy | varchar | No | The user who created the configuration. |
| lastModifiedDate | datetime | No | The date and time when the configuration was last modified. |
| lastModifiedBy | varchar | No | The user who last modified the configuration. |