Welcome to Upsolver
Start using Upsolver for free
Get started as a Upsolver user
Upsolver Amazon AWS deployment guide
Tutorials and FAQ
Connecting data sources
Amazon AWS data sources
Microsoft Azure data sources
Kafka data source
Google Cloud Storage data source
File upload data source
CDC data sources (Debezium)
JDBC data source
HDFS data source
Data source UI
Data source properties
Data outputs and data transformation
Transform with SQL
Work with Arrays
Create an output
Modify an output in SQL
Add calculated fields
General output properties
Run an output
Edit an output
Duplicate an output
Stop an output
Delete an output
Guide for developers
Upsolver REST API
CI/CD on Upsolver
Upsolver support portal
This page provides a comprehensive list of output properties along with their corresponding descriptions
To modify a property, simply go to the
tab and click on the pencil icon
Not all properties can be modified.
Properties listed below may not apply to all outputs.
See the full list here.
Connection type (e.g. Athena).
Output database name.
Output table name.
The compute cluster running the calculation.
The output interval in minutes, hours or days.
Whether to continue processing indefinitely, stop processing as soon as possible, or stop on a specific date and time.
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.
The retention policy in Upsolver in minutes, hours, or days. The data is deleted permanently after this period elapses (unless
is set to
). By default, the data is kept forever.
Start Execution From
When execution started.
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.
Output name in Upsolver.
Description of output.
Time this output was created.
Which user this output was created by.
If applicable, time this output was last modified.
Which user last modified this output.
Whether or not this output is aggregated.
The lookup table alias.
Click to edit the output clusters.
The workspaces attached to this output.
Adding lookups from reference data
General output properties