> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/reference-1/reference.md).

# Reference

SQL command reference for using Upsolver.

### :sparkles: Learning Paths

Follow the [learning path](/content/reference-1/learning-paths.md) to ingest data from your source:

* [Amazon Kinesis](/content/reference-1/learning-paths/amazon-kinesis.md)
* [Amazon S3](/content/reference-1/learning-paths/amazon-s3.md)
* [Apache Kafka](/content/reference-1/learning-paths/apache-kafka.md)
* [Confluent Cloud](/content/reference-1/learning-paths/confluent-cloud.md)
* [Microsoft SQL Server](/content/reference-1/learning-paths/microsoft-sql-server.md)
* [MongoDB](/content/reference-1/learning-paths/mongodb.md)
* [MySQL](/content/reference-1/learning-paths/mysql.md)
* [PostgreSQL](/content/reference-1/learning-paths/postgresql.md)

### SQL Commands

Create entities in Upsolver to configure your environment and create jobs:

* [Clusters](/content/reference-1/sql-commands/clusters.md)
* [Connections](/content/reference-1/sql-commands/connections.md)
* [Jobs](/content/reference-1/sql-commands/jobs.md)
* [Materialized Views](/content/reference-1/sql-commands/materialized-views.md)
* [Tables](/content/reference-1/sql-commands/tables.md)
* [Iceberg Tables](/content/reference-1/sql-commands/iceberg-tables.md)

### Functions & Operators

Use functions and operators to create advanced solutions in your jobs: 

* [Data Types](/content/reference-1/functions-and-operators/data-types.md)
* [Functions](/content/reference-1/functions-and-operators/functions.md)
* [Operators](/content/reference-1/functions-and-operators/operators.md)

### Monitoring

Learn how to use datasets, system tables and metrics to monitor your data, environment, and jobs: 

* [Clusters](/content/reference-1/monitoring/clusters.md)
* [Datasets](/content/reference-1/monitoring/datasets.md)
* [Job Status](/content/reference-1/monitoring/job-status.md)
* [System Catalog](/content/reference-1/monitoring/system-catalog.md)

### General

Additional reference materials to help you understand how to get the best out of Upsolver:

* [Common SQL Syntax](/content/reference-1/general/common-sql-syntax.md)
* [View Entity Syntax](/content/reference-1/general/view-entity-syntax.md)
* [Keyboard Shortcuts](/content/reference-1/general/keyboard-shortcuts.md)