sprockit.Resource
[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
Each row in this table represents a resource used or produced by a Sprockit-managed process. Resources can be inputs to or outputs of a process, as indicated by the [IsInput] field.
Example A process reads data from a staging table and two dimension tables, then uses that data to produces a fact table. The staging and dimension tables are the process's inputs, while the fact table is its output.
A process can have any number of input or output resources, but an object can be an output resource of no more than one process.
Approaches to resource configuration are described in Configuring processes in Sprockit.
Columns
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| PK | ResourceId | INT | Unique identifier for the resource. | IDENTITY |
| FK1 | ProcessId | INT | Identifies the process which which this resource is associated. | |
| IsInput | BIT | Indicates whether the resource is an input to or an output of the process indicated by [ProcessId]. | 1 if the resource is an input to the process; 0 if the resource is an output of the process. |
|
| DbName | NVARCHAR(128) | The name of the database in which the resource object is found. | ||
| SchemaName | NVARCHAR(128) | The name of the database schema in which the resource object is found. | ||
| ResourceName | NVARCHAR(128) | The schema-scoped name of the resource object. | ||
| IndexRebuildMode | TINYINT | Required index maintenance behaviour specific to this resource (overrides Sprockit's DefaultIndexRebuildMode property). | Affects output resources only (values specified for input resources have no effect). This field is optional – a value is only required if you wish to override the configured default behaviour. | |
| IndexRebuild Fragmentation Threshold | TINYINT | The minimum level of fragmentation that will trigger index maintenance, specific to this resource (overrides Sprockit's DefaultIndexRebuild FragmentationThreshold property). | Affects output resources only (values specified for input resources have no effect). This field is optional – a value is only required if you wish to override the configured default behaviour. |
Relationships
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
References to other tables
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| FK1 | ProcessId | sprockit.Process | ProcessId |
References to this table from others
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| sprockit.IndexMaintenanceTask.RL2 | ResourceId | ResourceId |
| sprockit.uvw_Resource.RL1 | ResourceId | ResourceId |
Page generated from database metadata by DbScout.