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
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
Transform with SQL
Mapping data to a desired schema
Transforming data with SQL
Aggregate streaming data
Query hierarchical data
Work with Arrays
View outputs
Create an output
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
Administration
Connections
Clusters
Python UDF
Reference data
Workspaces
Monitoring
Security
Release notes
Change log
Support
Upsolver support portal
Powered By GitBook
Transform with SQL
This page provides an overview of the Transform with SQL feature in Upsolver.

Transform with SQL Architecture and Components

Transform with SQL provides an easy to use and powerful SQL interface for data ingestion, integration, and transformation when creating Upsolver outputs without the need to write code in a programming language.
Transform with SQL in the Upsolver UI is based on ANSI SQL so it is easy and intuitive to use for anyone with basic SQL knowledge. Users write regular SQL queries with extensions for streaming data use cases such as window aggregations, and the Upsolver engine continuously executes the queries.
Transform with SQL is used to ingest data, read data from various streaming sources and data lakes (including Amazon S3, Amazon Kinesis Streams, and Apache Kafka), and writing data to the desired target (e.g. Amazon Athena, Amazon Redshift, ElasticSearch, and RDS).
Data outputs and data transformation - Previous
Data transformation
Next
Mapping data to a desired schema
Last modified 7mo ago
Copy link