Output properties

This page provides a comprehensive list of output properties along with their corresponding descriptions

To modify a property, simply go to the Properties tab and click on the pencil icon.

Note: Not all properties can be modified.

Properties

• General

• Hive Metastore

• Resources

• Scheduling

• Advanced

• Display Data

• Sidebar

Note: Properties listed below may not apply to all outputs.

General

See the full list here.

Hive Metastore

Property	Description
Connection	Connection type (e.g. Athena).
Database Name	Output database name.
Table Name	Output table name.

Resources

Property	Description
Compute Cluster	The compute cluster running the calculation.

Scheduling

Property	Description
Output Interval	The output interval in minutes, hours or days.
Ending At	Whether to continue processing indefinitely, stop processing as soon as possible, or stop on a specific date and time.
Soft Retention	A setting that prevents data deletion when the retention policy in Upsolver activates. When enabled, the metadata is purged but the underlying data (e.g. S3 object) is not deleted.
Retention	The retention policy in Upsolver in minutes, hours, or days. The data is deleted permanently after this period elapses (unless Soft Retention is set to Yes). By default, the data is kept forever.
Start Execution From	When execution started.

Advanced

Property	Description
Shards #	The number of independent shards to write, to increase parallelism and reduce latency. This should remain 1 in most cases, and should never be larger than the number of shards of the data sources.
Output Shards #	Set the number of files to be created each interval in the output. This applies only to aggregated outputs (for non-aggregated outputs, the Shards configuration has this effect).
Upsert Partition Fields	Determines weather or not the partitions fields will be included as part of the Upsert Key. Enable this for improved performance if updated records always reside in the same partition.
Allow Not Partitioned Table	Enable this feature to allow writing to a table that is not partitioned time. It is highly recommended to partition by time unless you are always going to be querying across all partitions.
Compaction Shards #	The number of files that can be compacted in parallel during a compaction.

Display Data

Property	Description
Name	Output name in Upsolver.
Description	Description of output.
Creation Time	Time this output was created.
Created By	Which user this output was created by.
Modified Time	If applicable, time this output was last modified.
Modified By	Which user last modified this output.

Sidebar

Property	Description
Aggregated	Whether or not this output is aggregated.
Aliases	The lookup table alias.
Clusters	Click to edit the output clusters.
Attached Workspaces	The workspaces attached to this output.