CPD3 sqldb Configuration

Database output generation profile configuration

The keys immediately below this are profile names that are selected by the application. For example, aerosol is the commonly used default profile. However, any non-empty name is acceptable and can be used to create customized configurations that can be selected at run time. In general, profile names should be all lower case to preserve case insensitivity. In the paths listed <PROFILE> is used as a placeholder to real profile name (e.g. replace <PROFILE> with aerosol for the default profile).

Table generation types

The keys immediately below this are unique names selected by the user. These names can be any non-empty text and are generally used to designate different components to be configured. In the paths listed <IDENTIFIER> is used as a placeholder to real name selected during configuration.

Table columns, keyed on the SQL column name

The keys immediately below this are unique names selected by the user. These names can be any non-empty text and are generally used to designate different components to be configured. In the paths listed <IDENTIFIER> is used as a placeholder to real name selected during configuration.

Indicate that this column is part of the table key and needs to be merged appropriately

Column output type

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Constant value to fill the column with

The keys below this one have an arbitrary structure. That is, the exact contents are not directly interpreted by the system so they are defined by conventions or subsequent usage.

Missing value code written to the column value when no valid value is available

The keys below this one have an arbitrary structure. That is, the exact contents are not directly interpreted by the system so they are defined by conventions or subsequent usage.

Path within the input values

Input value

A sequence selection is a means of selecting a sequence of values in the data. The specification consists of selections for the various components of the sequence name.

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Time format string, refer to Qt documentation for available substitutions

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Time position of the segment/row to use

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Column input value

This is a specification of a single real valued input used in calculation. The specification generally takes the form of either a value from the data or a constant.

Whole table data input selection

A sequence selection is a means of selecting a sequence of values in the data. The specification consists of selections for the various components of the sequence name.

Additional inputs requested for processing

A sequence selection is a means of selecting a sequence of values in the data. The specification consists of selections for the various components of the sequence name.

Processing chain stages

The keys immediately below this are array indices. These are indexes into an ordered list, with the first element being zero. For example, #0 is the first element of the array. The paths represented here use #0 as a placeholder for all indices.

Data generating component name

The end time to invoke the generator with

s

The end time to invoke the generator with

This is an absolute point in time specified as the number of seconds from the Unix epoch (1970-01-01T00:00:00Z).

Input file name used with the generator

Do not provide times to the input generator

Allow merging of identical processing inputs

Data generating component name

The start time to invoke the generator with

s

The start time to invoke the generator with

This is an absolute point in time specified as the number of seconds from the Unix epoch (1970-01-01T00:00:00Z).

Input station used with the generator

Allow merging of identical processing chains

The unique identifier that must match for chain merging

Data removal type

This is an enumeration value. It accepts a single string (not case sensitive) from a list of possible choices. Possible values:

Unix epoch column name

Datetime combined column name

Date column name

Year column name

Date column name

Time column name

Date column name

Hour of day column name

Year column name

Day of year column name