Upsolver
Search…
Welcome to Upsolver
Getting Started
Start using Upsolver for free
Get started as a Upsolver user
Upsolver concepts
Upsolver Amazon AWS deployment guide
Tutorials and FAQ
Glossary
Language guide
Data formats
Data types and features
Database output options
Permissions list
Index
Troubleshooting
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
Data outputs
Data transformation
Guide for developers
Upsolver REST API
CI/CD on Upsolver
Administration
Connections
Clusters
Python UDF
Reference data
Workspaces
Monitoring
Security
Release notes
Change log
Support
Upsolver support portal
Powered By GitBook
Data formats
This page goes over the different data formats available in Upsolver and, if applicable, their corresponding configuration options.
When creating a data source, the content format is typically auto detected, but you can manually select a format and specify additional details, as required.
The following content formats are supported:

Avro

The schema is auto detected.

Parquet

The schema is auto detected.

ORC

The schema is auto detected.

JSON

The schema is auto detected. The body should contain the message itself, which should not be url-encoded.
Store JSON as String
(Optional) Whether to store the JSON in native format in a separate field.

CSV

Infer Types
Header
Delimiter
Null Value
(Optional) Select whether to auto detect the types. If not selected, Upsolver will read all fields as strings.
(Optional) The content header.
If you only add details for one column, additional columns will be labeled as overflow columns.
(Optional) The delimiter between columns of data.
(Optional) The value to be interpreted as a null value.

TSV

Infer Types
Header
(Optional) Whether to auto detect the types.
(Optional) The content header.
If you only add details for one column, additional columns will be labeled as overflow columns.

x-www-form-urlencoded

The body should contain the message itself, which should not be url-encoded.

Protobuf

Schema files
Main File
Message Type
(Optional) Click Select to choose the required schema files.
(Optional) The main file from the list of selected schema files.
(Optional) The message type.

Avro-record

For Amazon S3, Azure Blob Storage, Google Cloud Storage or File Upload data sources.
Avro Record Schema
(Optional) The Avro record schema.

Avro-record

For Amazon Kinesis, Kafka, S3 Over SQS.
Avro Record Schema
Bytes Parsers
Additional Schemas
The Avro record schema.
(Optional) A parser for JSON-format schemas.
(Optional) Additional Avro record schemas.

Avro with Schema Registry

Schema Registry URL
(Optional) The URL to the schema registry.

XML

The schema is auto-detected.
Previous
Type conversion functions
Next
Data types and features
Last modified 1yr ago
Copy link
Contents
Avro
Parquet
ORC
JSON
CSV
TSV
x-www-form-urlencoded
Protobuf
Avro-record
Avro-record
Avro with Schema Registry
XML