# RisingWave

## Docs

- [RisingWave feature lifecycle and deprecation](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/changelog/product-lifecycle.md): This document outlines the stages of development for individual features within RisingWave (Technical Preview, Public Preview, General Availability), and the policy for how features are deprecated and removed from the product. It also provides a list of features currently in Public Preview.
- [Release notes](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/changelog/release-notes.md): This page summarizes changes in each version of RisingWave, including new features and important bug fixes.
- [RisingWave release lifecycle and version support policy](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/changelog/release-support-policy.md): Provides a summary of recent version support end dates and details the RisingWave versioning scheme (SemVer), release cadence, support rules, backporting policy, and deprecation communication.
- [Go](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/client-libraries/go.md): Use RisingWave in your Go application
- [Java](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/client-libraries/java.md): Use RisingWave in your Java application
- [Node.js](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/client-libraries/nodejs.md): Use RisingWave in your Node.js application
- [Overview](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/client-libraries/overview.md): You can use third-party PostgreSQL drivers to seamlessly interact with RisingWave from your applications.
- [Python](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/client-libraries/python.md): Describes how to use third-party Python drivers to interact with RisingWave.
- [Ruby](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/client-libraries/ruby.md): Use RisingWave in your Ruby application.
- [Billing](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/billing-overview.md): This guide provides detailed information on the billing procedures, and how to manage your bills and payment methods. Understanding these elements will help you effectively manage your costs while using RisingWave Cloud services.
- [Change database user password](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/change-database-user-password.md)
- [Check spending details](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/check-spending-details.md): You can view the usage and the corresponding charges for each project during the ongoing billing period. You can also download a PDF version of the invoice for your records.
- [Check status and metrics of projects](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/check-status-and-metrics.md): You can check and monitor your projects' overall running status and detailed metrics.
- [Choose a project plan](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/choose-a-project-plan.md): RisingWave Cloud offers different types of RisingWave projects.
- [Connect to a project](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/connect-to-a-project.md): After [getting a project up and running](/cloud/manage-projects/#create-a-project), you need to connect to it so that you can interact with RisingWave.
- [Connection errors](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/connection-errors.md): This topic summarizes the connection errors that you may encounter when using RisingWave Cloud and their corresponding solutions.
- [Workspace](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/console-overview.md): It is the most intuitive and easy way to interact with RisingWave via workspace. It offers graphical tools for managing data and visualizing results.
- [Create a PrivateLink connection](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/create-a-connection.md): Follow the steps below to create a PrivateLink connection between RisingWave Cloud and your VPC.
- [Create a database user](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/create-a-database-user.md): Choose one of the following to create a [database user](/cloud/manage-database-users/).
- [Delete a database user](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/delete-a-database-user.md): If you no longer need a database user, you can delete it.
- [Develop with RisingWave Cloud](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/develop-overview.md): RisingWave Cloud leverages the superpower of RisingWave, an open-source distributed SQL database specifically designed for stream processing. RisingWave provides an interface language that resembles PostgreSQL, enabling your team to build real-time data services without the high engineering cost and…
- [Drop a PrivateLink connection](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/drop-a-connection.md): Follow the steps below to drop a connection to your VPC when you no longer need it.
- [Export metrics](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/export-metrics.md): This article describes how to use metrics API to export metrics from a RisingWave Cloud project to various monitoring systems like Prometheus, DataDog, and InfluxDB. The metrics include all major components such as `etcd`, `frontend`, `compute`, `compactor`, and `meta`.
- [FAQ](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/faq.md): Frequently Asked Questions
- [Forgot password?](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/forgot-password.md): If you see this message “_Incorrect email or password._” when you try to log in to RisingWave Cloud, you can use **Forgot password?** to reset your password.
- [What's RisingWave Cloud?](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/intro.md): RisingWave Cloud simplifies and streamlines data processing for modern data workflows. It is a fully-managed and scalable stream processing platform powered by the open-source project RisingWave. Our mission is to make data processing accessible to everyone. With RisingWave Cloud, we can help you de…
- [Manage database users](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/manage-database-users.md): In RisingWave, a database user is similar to a database user or role in Postgres, allowing a person or application to access a specific database or set of databases within a project.
- [Manage payment methods](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/manage-payment-methods.md)
- [Manage projects](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/manage-projects.md): A project in RisingWave Cloud provides the necessary resources for hosting independent data repositories and streaming pipelines. Within a project, you can create and manage database users and databases.
- [Manage sinks](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/manage-sinks.md): To stream data out of RisingWave, you must create a sink. A sink refers to an external target that you can send data to. You can deliver data to downstream systems via our sink connectors.
- [Manage sources](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/manage-sources.md): To ingest data into RisingWave, you must first create a source. A source refers to an external data feed that RisingWave can read from. You can connect RisingWave to a variety of external sources like databases and message brokers. After a source is connected, you can create materialized views to pe…
- [Invite and manage users in your organization](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/manage-users.md): Users in an organization can access the same set of resources for seamless collaboration. As the organization owner, you can invite others to join your organization as member users and share resources among them.
- [Manage your account](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/manage-your-account.md): You can refer to the following guide to manage your RisingWave Cloud account.
- [Monitor materialized views](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/monitor-materialized-views.md): You can view all [materialized views](/reference/key-concepts#materialized-views) defined in the databases of a project.
- [Organization](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/organization-overview.md): In RisingWave Cloud, an organization serves as the central entity that owns all resources, such as accounts, projects, database objects, and VPC connections.
- [Role-based access control (RBAC)](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/organization-rbac.md): In RisingWave Cloud, Role-based access control (RBAC) system empowers organizations to precisely manage access permissions based on their roles. Among RisingWave Cloud users in the organization, each user is associated with a pre-defined role. The organization administrator will have permission to e…
- [Pricing](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/pricing.md): RisingWave Cloud offers a flexible pricing model based on your usage and the resources consumed within your organization. This guide will help you understand how the pricing works in RisingWave Cloud.
- [PrivateLink connection](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/privatelink-overview.md): In RisingWave Cloud, if you want to connect RisingWave instances with your services inside your private Virtual Private Cloud (VPC) network, you can use the PrivateLink service to establish a private and secure connection between RisingWave Cloud and your private VPC in the same region.
- [Bring your own cloud](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/project-byoc.md): This guide outlines the services that RisingWave deploys in a BYOC environment and walks you through the process of enabling BYOC in a step-by-step manner.
- [Quick start](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/quickstart.md): Get started with RisingWave Cloud in 5 steps.
- [Review and pay invoices](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/review-and-pay-invoices.md): In [**Invoices**](https://cloud.risingwave.com/billing/invoices/), you can access a detailed history of your bills, including invoice IDs, billing periods, invoice status, payment amounts, payment methods, and payment times.
- [Scale a project manually](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/scale-a-project-manually.md): After creating a project, you have the flexibility to scale its resources and capacity to meet your specific data processing and analysis needs. This can be achieved through two methods: increasing or decreasing the number of worker nodes (horizontal scaling) or adjusting the resource capacity of ea…
- [Set up service accounts for applications](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/service-account.md): In RisingWave Cloud, a user account typically represents an individual user who interacts with resources via the user interface. On the other hand, a service account represents an application. It accesses RisingWave Cloud resources on the application's behalf, using API keys for authentication.
- [Sign up and log in](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/signup-login.md)
- [Set up Single Sign-On (SSO) for your organization](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/sso.md): Single Sign-On (SSO) is an authentication method that allows a user to access multiple applications with one set of login credentials.
- [Stop and delete projects](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/stop-and-delete-projects.md): You can manually control the running state of your projects or delete them.
- [Update RisingWave version](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/cloud/update-database-version.md): When a newer version of RisingWave becomes available, you can easily update your project to the latest version. Check out the [Release Notes of RisingWave](/changelog/release-notes) to learn about the exciting new features in each version.
- [Overview of data delivery](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/delivery/overview.md): RisingWave supports delivering data to downstream systems via its sink connectors.
- [User betting behavior analysis](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/demos/betting-behavior-analysis.md): Identify high-risk and high-value users by analyzing and identifying trends in user betting patterns.
- [Example repository](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/demos/example-repository.md)
- [Inventory management and demand forecast](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/demos/inventory-management-forecast.md): Track inventory levels and forecast demand to prevent shortages and optimize restocking schedules.
- [Market data enrichment and transformation](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/demos/market-data-enrichment.md): Transform raw market data in real-time to provide insights into market trends, asset health, and trade opportunities.
- [Market and trade activity surveillance](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/demos/market-trade-surveillance.md): Detect suspicious patterns, compliance breaches, and anomalies from trading activities in real-time.
- [Marketing campaign performance analysis](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/demos/marketing-analysis.md): Analyze and optimize marketing campaign performance in real-time.
- [Overview](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/demos/overview.md): Discover the wide range of real-world use cases where RisingWave delivers concrete value with the list of runnable demos.
- [Risk and profit analysis in sports betting](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/demos/sports-risk-profit-analysis.md): Manage your sports betting positions in real-time by using RisingWave to monitor exposure and risk.
- [Hardware requirements](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/hardware-requirements.md): This topic describes hardware requirements and recommendations for production deployments. Actual resource requirements may vary based on your specific workload.
- [Install psql without PostgreSQL](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/install-psql-without-postgresql.md): To use RisingWave, you need a PostgreSQL client, not the PostgreSQL server. The PostgreSQL [official installers and packages](https://www.postgresql.org/download/) come with all the components needed to run a PostgreSQL server, but some of these components are not needed for RisingWave.
- [Cluster scaling](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/k8s-cluster-scaling.md): This article describes adaptive parallelism as the default scaling policy for all new streaming jobs starting from v1.7 in RisingWave. With adaptive parallelism, the system will automatically adjust parallelism to leverage added CPU cores or nodes in the cluster, ensuring optimal resource utilizatio…
- [Migrate from etcd to SQL backend for metadata management](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/migrate-to-sql-backend.md)
- [Node-specific configurations](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/node-specific-configurations.md): In RisingWave, certain configurations are node-specific and can vary between different nodes. These configurations are stored in a [TOML file](https://github.com/risingwavelabs/risingwave/blob/main/src/config/example.toml), which is read at system startup.
- [RisingWave Cloud](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/risingwave-cloud.md): Experience intuitive and effortless stream processing with RisingWave Cloud. Sign up now and get a free, fully managed cluster up and running with a few clicks.
- [Start RisingWave using Docker Compose](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/risingwave-docker-compose.md): This topic describes how to start RisingWave using Docker Compose on a single machine. With this option, data is persisted in your preferred storage service, and observability is enabled for enhanced monitoring and analysis.
- [Deploy RisingWave on Kubernetes with Helm](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/risingwave-k8s-helm.md): This guide walks you through the process of deploying RisingWave in a single Kubernetes cluster with [Helm](https://helm.sh/).
- [Deploy RisingWave on Kubernetes with Operator](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/risingwave-kubernetes.md): This article will help you use the [Kubernetes Operator for RisingWave](https://github.com/risingwavelabs/risingwave-operator) (hereinafter ‘the Operator’) to deploy a RisingWave cluster in Kubernetes.
- [Uninstall RisingWave from a Kubernetes cluster](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/uninstall-risingwave-k8s.md): This topic describes how to uninstall RisingWave from a Kubernetes cluster with Helm and how to remove the persistent volume claims (PVCs) and data in object stores.
- [Upgrade RisingWave in a Kubernetes cluster](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/deploy/upgrade-risingwave-k8s.md): This topic describes upgrade RisingWave in a K8s deployment with the RisingWave Kubernetes Operator and Helm.
- [Overview](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/faq/faq-overview.md): In this section, we present the most frequently asked questions and some additional information.
- [Using RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/faq/faq-using-risingwave.md)
- [When to use RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/faq/faq-when-to-use-risingwave.md)
- [RisingWave vs. Apache Flink: Which one to choose?](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/faq/risingwave-flink-comparison.md): In the rapidly evolving landscape of big data, stream processing has become increasingly important. A number of frameworks have emerged to aid in this process, including RisingWave and Apache Flink, two popular distributed stream processing systems in the open-source world. While both of these syste…
- [RisingWave vs. Flink: Feature-by-feature comparison](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/faq/rw-flink-feature-comparison.md): A comprehensive comparison of features between RisingWave and Apache Flink, covering SQL capabilities, data types, streaming operations, and system functionalities.
- [Elastic disk cache](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/get-started/disk-cache.md): This topic describes the elastic disk cache feature of RisingWave.
- [What is RisingWave?](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/get-started/intro.md): RisingWave is an event stream processing platform for developers. It offers an unified experience for real-time data ingestion, stream processing, and low-latency serving.
- [Quick start](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/get-started/quickstart.md): This guide aims to provide a quick and easy way to get started with RisingWave.
- [Query serving benchmarks: sysbench results](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/get-started/rw-benchmarks-query.md): This topic provides an overview of RisingWave's ad-hoc query serving performance characteristics (latency and throughput) based on the industry-standard sysbench benchmark.
- [Stream processing benchmarks: Nexmark results](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/get-started/rw-benchmarks-stream-processing.md): This topic provides an overview of RisingWave's stream processing performance characteristics based on rigorous testing using the industry-standard Nexmark benchmark and an extended set of real-world SQL queries.
- [RisingWave Premium Edition](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/get-started/rw-premium-edition-intro.md): This topic introduces the RisingWave Premium Edition and offers a complete list of all premium features.
- [RisingWave use cases](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/get-started/use-cases.md): RisingWave excels in a variety of real-time data processing scenarios, making it an ideal choice for several categories of use cases, including:
- [Iceberg table engine](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/iceberg/iceberg-table-engine.md)
- [Interact with Iceberg](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/iceberg/overview.md): Learn about different ways to use Iceberg with RisingWave
- [Read data from Iceberg tables](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/iceberg/read-from-iceberg.md)
- [Write data to Iceberg tables](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/iceberg/write-to-iceberg.md)
- [Extract metadata from sources](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/advanced/extract-metadata-from-sources.md): Extract metadata from sources during ingestion.
- [Generate test data](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/advanced/generate-test-data.md): The built-in load generator can generate mock data, which can be used in demos and tests. It provides an easy way to simulate the data stream without connecting to an actual external data source.
- [Modify source or table schemas](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/advanced/modify-source-or-table-schemas.md): This topic describes how to modify the schema of a RisingWave source or table.
- [Connecting with CREATE SOURCE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/getting-started/connect-with-create-source.md): Establish a non-persistent connection to an external data source in RisingWave.
- [Connecting with CREATE TABLE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/getting-started/connect-with-create-table.md): Connect to a data source and store the ingested data in RisingWave.
- [Data formats and encoding options](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/getting-started/formats-and-encoding-options.md): Configure RisingWave to handle various data formats and encodings from your sources.
- [Overview of data ingestion in RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/getting-started/overview.md): Learn about connecting to data sources and ingesting data into RisingWave.
- [Supported sources](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/getting-started/sources.md): This topic lists the source connectors in RisingWave.
- [Connect to Apache Iceberg](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/sources/iceberg.md): Connect RisingWave to your Apache Iceberg tables for batch ingestion.
- [Apache Iceberg configuration options](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/sources/iceberg-config.md): Reference for all configuration parameters for connecting to Apache Iceberg.
- [Connect to Kafka](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/sources/kafka.md): Quickly connect RisingWave to your Apache Kafka broker to start ingesting data.
- [Kafka configuration options](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/sources/kafka-config.md): Reference for all configuration parameters when connecting RisingWave to Apache Kafka.
- [Connect to PostgreSQL CDC](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/sources/pg-cdc.md): Ingest real-time changes from your PostgreSQL database using change data capture (CDC).
- [PostgreSQL CDC configuration options](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/ingestion/sources/pg-cdc-config.md): Reference for all configuration parameters for connecting to PostgreSQL CDC.
- [Sink data from RisingWave to Amazon DynamoDB](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/amazon-dynamodb.md): This guide describes how to sink data from RisingWave to DynamoDB using the DynamoDB sink connector in RisingWave.
- [Sink data from RisingWave to Apache Doris](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/apache-doris.md): This guide describes how to sink data from RisingWave to Apache Doris. Apache Doris is an open-source real-time data warehouse suitable for online analytical processing (OLAP). For more information, see [Apache Doris](https://doris.apache.org).
- [Sink data from RisingWave to Apache Iceberg](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/apache-iceberg.md): This guide describes how to sink data from RisingWave to Apache Iceberg using the Iceberg sink connector in RisingWave.
- [Sink to Kafka](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/apache-kafka.md): This topic describes how to sink data from RisingWave to a Kafka broker and how to specify security (encryption and authentication) settings.
- [Sink data from RisingWave to Apache Pulsar](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/apache-pulsar.md): This guide describes how to sink data from RisingWave to Apache Pulsar.
- [Sink to AWS Kinesis](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/aws-kinesis.md): This topic describes how to sink data from RisingWave to AWS Kinesis Data Streams.
- [Sink data from RisingWave to Azure Blob](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/azure-blob.md): This guide describes how to sink data from RisingWave to Azure Blob using the Azblob connector in RisingWave.
- [Sink data from RisingWave to Google BigQuery](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/bigquery.md): This guide describes how to sink data from RisingWave to Google BigQuery.
- [Sink data from RisingWave to Cassandra or ScyllaDB](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/cassandra-or-scylladb.md): You can sink data from RisingWave to [Cassandra](https://cassandra.apache.org/). As [ScyllaDB](https://www.scylladb.com/) can work as a drop-in replacement for Cassandra, it means you can sink data from RisingWave to ScyllaDB as well.
- [Sink data from RisingWave to ClickHouse](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/clickhouse.md): This guide describes how to sink data from RisingWave to ClickHouse using the ClickHouse sink connector in RisingWave.
- [Sink data from RisingWave to CockroachDB](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/cockroachdb.md): CockroachDB is a distributed SQL database system developed by Cockroach Labs that is designed for scalability and resilience. Since CockroachDB is compatible with PostgreSQL, you can sink data from RisingWave to CockroachDB using the JDBC sink connector.
- [Sink data from RisingWave to Delta Lake](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/delta-lake.md): This guide describes how to sink data from RisingWave to Delta Lake. Delta Lake is an open-source storage framework designed to allow you to build a lakehouse architecture with another compute engine. For more information, see [Delta Lake](https://delta.io).
- [Sink data from RisingWave to Elasticsearch](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/elasticsearch.md): This guide describes how to sink data from RisingWave to Elasticsearch using the Elasticsearch sink connector in RisingWave.
- [Sink data from RisingWave to Google Pub/Sub](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/google-pub-sub.md): This guide describes how to sink data from RisingWave to Google Pub/Sub using the Google Pub/Sub sink connector in RisingWave. Pub/Sub is used for streaming analytics and data integration pipelines to load and distribute data. For more information, see [Google Pub/Sub](https://cloud.google.com/pubsu…
- [Sink data from RisingWave to MongoDB](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/mongodb.md): This guide describes how to sink data from RisingWave to MongoDB. MongoDB is a document database designed for ease of application development and scaling. For more information, see [MongoDB](https://www.mongodb.com/).
- [Sink data from RisingWave to MQTT](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/mqtt.md): This guide describes how to sink data from RisingWave to the MQTT topic using the MQTT sink connector in RisingWave.
- [Sink data from RisingWave to MySQL with the JDBC connector](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/mysql.md): This guide will introduce how to sink data from RisingWave to JDBC-available databases using the JDBC sink connector.
- [Sink data to NATS and NATS JetStream](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/nats-and-nats-jetstream.md): This guide describes how to sink data from RisingWave to NATS subjects using the NATS sink connector in RisingWave. Both NATS and NATS JetStream are supported by this connector.
- [Sink data from RisingWave to OpenSearch](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/opensearch.md): This guide describes how to sink data from RisingWave to OpenSearch using the OpenSearch sink connector in RisingWave.
- [Sink data from RisingWave to PostgreSQL](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/postgresql.md)
- [Sink data from RisingWave to Redis](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/redis.md): This guide describes how to sink data from RisingWave to Redis.
- [Sink data from RisingWave to Snowflake](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/snowflake.md): This guide describes how to sink data from RisingWave to Snowflake using the Snowflake sink connector in RisingWave.
- [Sink data from RisingWave to SQL Server](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/sql-server.md): This guide describes how to sink data from RisingWave to Microsoft SQL Server.
- [Sink data from RisingWave to StarRocks](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/starrocks.md): This guide describes how to sink data from RisingWave to StarRocks.
- [Sink data from RisingWave to Supabase](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/supabase.md): [Supabase](https://supabase.com) is an open-source Firebase alternative. It uses PostgreSQL as the underlying storage system and therefore can be integrated with RisingWave seamlessly.
- [Sink data from RisingWave to TiDB with the JDBC connector](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/destinations/tidb.md): As TiDB is compatible with MySQL, you can sink data to TiDB the same way you would sink data to MySQL with the JDBC connector.
- [Use dbt for data transformations](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/other/dbt.md): This guide provides instructions for using dbt to manage real-time data transformations in RisingWave.
- [Ingest data from Amazon MSK](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/amazon-msk.md): Amazon Managed Streaming for Apache Kafka (MSK) is a fully managed service that simplifies the setup, scaling, and management of Apache Kafka clusters, a popular open-source distributed streaming platform.
- [Ingest data from AutoMQ Kafka](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/automq-kafka.md): [AutoMQ for Kafka](https://docs.automq.com/zh/docs/automq-s3kafka/YUzOwI7AgiNIgDk1GJAcu6Uanog) is a cloud-native version of Kafka specifically optimized for cloud environments.
- [Ingest data from Azure Blob](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/azure-blob.md): [Azure Blob Storage](https://learn.microsoft.com/en-us/azure/storage/blobs/), provided by Microsoft Azure, allows you to store and manage large amounts of unstructured data.
- [Ingest data from Citus CDC](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/citus-cdc.md): RisingWave supports ingesting change data capture (CDC) data from Citus database. Version 10.2 of Citus is supported.
- [Ingest data from Confluent Cloud](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/confluent-cloud.md): This guide will go over how to set up a Kafka cluster on Confluent Cloud so you can connect and read data from it with RisingWave. See [Confluent](https://www.confluent.io) for more details and how to get started.
- [Ingest data from Coreflux broker](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/coreflux-broker.md): You can ingest data from [Coreflux](https://coreflux.org/).
- [Ingest data from EMQX broker](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/emqx.md): Describes how to ingest data from EMQX broker.
- [Ingest data from Amazon EventBridge webhook](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/eventbridge-webhook.md): Ingest Amazon EventBridge events directly into your RisingWave database for real-time processing and analytics.
- [Ingest data from GitHub webhook](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/github-webhook.md): Ingest GitHub events directly into your RisingWave database for real-time processing and analytics.
- [Ingest data from Google Cloud Storage](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/google-cloud-storage.md): Use the SQL statement below to connect RisingWave to a Google Cloud Storage source.
- [Ingest data from Google Pub/Sub](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/google-pub-sub.md): Use the SQL statement below to connect RisingWave to Google Pub/Sub source.
- [Ingest data from HiveMQ broker](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/hivemq.md)
- [Ingest data from HubSpot webhook](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/hubspot-webhook.md): Ingest HubSpot events directly into your RisingWave database for real-time processing and analytics.
- [Ingest data from Instaclustr Kafka](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/instaclustr-kafka.md): You can ingest data from Kafka deployed in Instaclustr, a fully managed and integrated platform with popular open-source tools such as Kafka, PostgreSQL, Cassandra, and Redis. It facilitates easy Kafka Connect integration and includes a dedicated ZooKeeper along with Kraft that delivers a seamless K…
- [Ingest data from Kinesis](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/kinesis.md): Use the SQL statement below to connect RisingWave to Kinesis Data Streams.
- [Ingest data from MongoDB CDC](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/mongodb-cdc.md)
- [Ingest data from MQTT brokers](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/mqtt.md): You can ingest data from a MQTT broker into RisingWave by using the MQTT source connector in RisingWave.
- [Ingest CDC data from MySQL](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/mysql-cdc.md): Change Data Capture (CDC) refers to the process of identifying and capturing data changes in a database, and then delivering the changes to a downstream service in real time.
- [Ingest data from MySQL table](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/mysql-table.md): Describes how to ingest data from MySQL table to RisingWave using table-valued function.
- [Ingest data from NATS JetStream](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/nats-jetstream.md): You can ingest data from NATS JetStream into RisingWave by using the NATS source connector in RisingWave.
- [Ingest data from Neon CDC](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/neon-cdc.md): Neon is a Serverless Postgres designed for the cloud that separates compute and storage to offer modern developer features such as autoscaling, branching, bottomless storage, and others.
- [Ingest data from PostgreSQL table](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/postgresql-table.md): Describes how to ingest data from PostgreSQL table to RisingWave using table-valued function.
- [Ingest data from Pulsar](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/pulsar.md): You can ingest data from Pulsar into RisingWave by using the Pulsar source connector in RisingWave.
- [Ingest data from RedHat AMQ Streams](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/redhat-amq-streams.md): You can ingest data from RedHat AMQ Streams into RisingWave by using the Kafka source connector in RisingWave.
- [Ingest data from Redpanda](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/redpanda.md): As Redpanda is fully compatible with Kafka, you can ingest data from Redpanda into RisingWave in the same way as you ingest data from Kafka.
- [Ingest data from RudderStack webhook](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/rudderstack-webhook.md): Ingest RudderStack events directly into your RisingWave database for real-time processing and analytics.
- [Ingest data from S3 buckets](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/s3.md): Use the SQL statement below to connect RisingWave to an Amazon S3 source. RisingWave supports CSV, [ndjson](https://github.com/ndjson) and Parquet file formats.
- [Ingest data from Segment webhook](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/segment-webhook.md): Ingest Segment events directly into your RisingWave database for real-time processing and analytics.
- [Ingest data from Solace](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/solace.md)
- [Ingest data from SQL Server CDC](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/sql-server-cdc.md)
- [Ingest data from Supabase CDC](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/supabase-cdc.md): [Supabase](https://supabase.com) is an open-source Firebase alternative. It uses PostgreSQL as the underlying storage system and therefore can be integrated with RisingWave seamlessly.
- [Ingest data from WarpStream](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/warpstream.md): You can ingest data from [WarpStream](https://www.warpstream.com/), an Apache Kafka-compatible data streaming platform built directly on top of object storage, into RisingWave.
- [Ingest data from webhook](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/sources/webhook.md): Describes how to ingest data from webhook to RisingWave.
- [Connect Beekeeper Studio to RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/visualization/beekeeper-studio.md): Beekeeper Studio is a modern, easy to use SQL editor and database manager. It provides a graphical user interface, allowing you to efficiently query and manage PostgreSQL, MySQL, SQL Server and more. Since RisingWave is PostgreSQL-compatible, you can easily connect Beekeeper Studio to RisingWave.
- [Connect Bytebase to RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/visualization/bytebase.md): Introduce how to integrate Bytebase with RisingWave for schema management.
- [Connect DBeaver to RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/visualization/dbeaver.md): DBeaver is a versatile database tool that provides a user-friendly interface for managing and interacting with a variety of database systems. DBeaver allows users to connect to databases, execute SQL scripts, export data to various formats, and perform other database-related tasks. Features such as…
- [Configure Grafana to read data from RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/visualization/grafana.md): Grafana is an open-source analytics and visualization web application. It is well suited for time-series data as well as application and server monitoring.
- [Connect Looker to RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/visualization/looker.md): Looker is a BI (business intelligence) platform that provides data insights through interactive dashboards, reports, and SQL querying. It can integrate with databases like PostgreSQL, MySQL, and more.
- [Connect Metabase to RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/visualization/metabase.md): Metabase is an open-source business intelligence tool that lets you visualize and share data insights. It provides an easy way to create charts, dashboards, and metrics on top of databases.
- [Overview](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/visualization/overview.md): You can use a variety of visualization tools, such as [Apache Superset](/docs/current/superset-integration/) or [Grafana](/docs/current/grafana-integration/) to query and visualize data in RisingWave.
- [Configure Superset to read data from RisingWave](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/integrations/visualization/superset.md): Apache Superset is an open-source data exploration and data visualization software application. As a database, RisingWave can act as a data source for Business Intelligence tools like Apache Superset.
- [Access control](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/access-control.md): RisingWave uses a user-based access control to handle authentication and authorization. Privileges can be granted to or revoked by users to control what actions can be performed on different object levels.
- [Alter a streaming job](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/alter-streaming.md): This document explains how to modify the logic in streaming pipelines within RisingWave. Understanding these mechanisms is essential for effectively managing your data processing workflows.
- [Cluster limit](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/cluster-limit.md): This guide introduces the cluster limit designed to enhance user experience when cluster resources are limited. It sets a limit on the number of actors per parallelism (i.e., CPU core). Exceeding this limit when you create materialized view, table, or sink will trigger a warning message.
- [Dedicated compute node](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/dedicated-compute-node.md): By default, a compute node can process both streaming jobs and ad-hoc queries (i.e. serving). Alternatively, you can process streaming and serving by different compute nodes respectively, to mitigate resource contention or to isolate streaming or serving failure. This guide introduces how to set up…
- [Manage a large number of streaming jobs](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/manage-a-large-number-of-streaming-jobs.md): By default, RisingWave is configured to utilize the maximum available CPUs across compute nodes for streaming jobs. In RisingWave, a streaming job refers to the creation of a table, source, index, materialized view, or sink. This design aims to achieve high performance by fully utilizing compute res…
- [Manage secrets](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/manage-secrets.md): By default, credentials for connecting to external services (like MySQL) are specified in plain text within the `WITH` clause of `CREATE SOURCE / SINK` statements. This practice poses security risks, particularly for large organizations where multiple teams manage connected services.
- [Back up and restore meta service](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/meta-backup.md): This guide introduces how to back up meta service data and restore from a backup.
- [Monitor a RisingWave cluster](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/monitor-risingwave-cluster.md): If you run RisingWave in a Kubernetes cluster, you can monitor its performance, including the usage of resources like CPU, memory, and network, and the status of different nodes.
- [Monitor statement progress](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/monitor-statement-progress.md): SQL statements like `CREATE MATERIALIZED VIEW`, `CREATE INDEX`, or `CREATE SINK` might take a while to complete, because they may consume a lot of data. In RisingWave, you can view the progress of such a statement, and abort it if necessary.
- [Set up secure connections to RisingWave with SSL/TLS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/secure-connections-with-ssl-tls.md): RisingWave supports secure connections with TLS/SSL for enhanced client/server communication security.
- [Telemetry](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/telemetry.md): RisingWave collects anonymous usage statistics to better understand how the community is using RisingWave. The sole intention of this exercise is to help improve the product. These statistics are related to system resource usage, OS versions and system uptime. RisingWave doesn't have access to any u…
- [Tune reserved memory and cache eviction policy](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/tune-reserved-memory.md): This topic introduces the concept and the tuning method of reserved memory and cache eviction policy.
- [View and configure runtime parameters](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/view-configure-runtime-parameters.md)
- [View and configure system parameters](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/view-configure-system-parameters.md)
- [Workload isolation and interaction](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/operate/workload-isolation-interaction.md): Manage multiple workloads efficiently in RisingWave using database isolation, resource groups for dedicated compute resources, and cross-database queries for unified access.
- [Best practices for optimizing performance](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/best-practices.md): Learn best practices for maximizing the performance of your RisingWave deployments.
- [Frequently asked questions (FAQ)](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/faq.md): Answers to common questions about RisingWave performance tuning and troubleshooting.
- [Monitoring and metrics](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/metrics.md): Understand and monitor key performance indicators (KPIs) in RisingWave using Grafana dashboards.
- [Performance guide overview](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/overview.md): Introduction to the RisingWave Performance Guide, covering key concepts, target audience, and guide structure.
- [General troubleshooting approach](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/performance-troubleshoot-ov.md): A step-by-step guide to systematically diagnose performance problems in RisingWave.
- [Specific bottlenecks](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/specific-bottlenecks.md): Identify and resolve specific resource bottlenecks in RisingWave, including CPU, memory, storage, and more.
- [End-to-end latency](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/troubleshoot-e2e-latency.md): Explore the factors affecting end-to-end latency in RisingWave and provide strategies for optimizing performance.
- [High latency](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/troubleshoot-high-latency.md): Troubleshoot and resolve high latency and slow stream processing issues in RisingWave.
- [Workload analysis](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/performance/workload-analysis.md): Understand RisingWave's workload, key performance metrics, and the critical role of backpressure.
- [Deletes and updates](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/deletes-and-updates.md): Similar to traditional databases, RisingWave supports data updates and deletions within tables. Additionally, when data in a table is modified or deleted, any materialized views built on that table will be updated accordingly.
- [Emit on window close](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/emit-on-window-close.md)
- [Indexes](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/indexes.md): Indexes in a database are designed to increase the speed at which the database management system (DBMS) can locate and retrieve the desired data from a table or a materialized view.
- [Maintain wide table with table sinks](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/maintain-wide-table-with-table-sinks.md): This guide introduces how to maintain a wide table whose columns come from different sources. Traditional data warehouses or ETL use a join query for this purpose. However, streaming join brings issues such as low efficiency and high memory consumption.
- [Overview of data processing](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/overview.md): Data processing is a crucial step in converting raw data into valuable insights.
- [Dynamic filters](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/sql/dynamic-filters.md): Dynamic filters function as filter operators, but the filter condition contains a dynamic variable. They enable filtering data streams in real-time and allow a condition to be defined that incoming data must meet in order to be processed.
- [Joins](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/sql/joins.md): A JOIN clause, also known as a join, combines the results of two or more table expressions based on certain conditions, such as whether the values of some columns are equal.
- [Full SQL references](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/sql/sql-references.md)
- [Temporal filters](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/sql/temporal-filters.md): Temporal filters allow you to filter data based on time intervals, which are used to retrieve data within a specific time range.
- [Time windows](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/sql/time-windows.md): In stream processing, time windows are time intervals based on which we can divide events and perform data computations.
- [Top-N by group](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/sql/top-n-by-group.md): Top-N queries return only the N top-most or the N bottom-most records from a table or view based on a condition.
- [Time travel queries](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/time-travel-queries.md): This guide describes how to leverage the time travel feature. This feature helps access historical data at a specific time.
- [Transactions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/transactions.md)
- [Watermarks](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/processing/watermarks.md): In stream processing, watermarks are integral when using event time processing logic with event time based operations. Watermarks are like markers or signals that track the progress of event time, allowing you to process events within their corresponding time windows. A watermark is an estimate of t…
- [Python SDK](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/python-sdk/intro.md): Describes how to use the purpose-built Python SDK by RisingWave to build event-driven applications.
- [Architecture](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/reference/architecture.md): This topic covers the nodes, their responsibilities, and relationships within our product architecture for developers seeking a deeper understanding of RisingWave.
- [Data persistence](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/reference/data-persistence.md): RisingWave adopts the [Chandy–Lamport algorithm](https://en.wikipedia.org/wiki/Chandy%E2%80%93Lamport%5Falgorithm) to create checkpoints. A checkpoint is a global snapshot that represents a consistent state of the entire system at a particular point in time.
- [Fault tolerance](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/reference/fault-tolerance.md): RisingWave is a fault-tolerant distributed stream processing system.
- [Glossary](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/reference/key-concepts.md): This page explains key concepts and terms that are used throughout the documentation. In the first part, we present terms closely related to RisingWave. In the second part, we include a broader range of terms in a glossary.
- [Access and use your processed data](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/serve/overview.md): RisingWave allows you to access and use insights from your streaming data immediately. It also functions like any other database, allowing you to query batch or raw data that you've inserted.
- [Query with SELECT statements](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/serve/query-with-select.md)
- [RisingWave as a PostgreSQL foreign data wrapper](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/serve/risingwave-as-postgres-fdw.md): A foreign data wrapper in PostgreSQL allows you to directly virtualize data stored in an external database as a local external table, also known as a foreign table. This tutorial will demonstrate how to interact between PostgreSQL and RisingWave. In this example, RisingWave will use CDC (Change Data…
- [Subscription](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/serve/subscription.md): Subscription is used to pull data change records for a specific table or materialized view (MV).
- [SQL commands](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/overview.md): Overview of the SQL commands supported by RisingWave.
- [ALTER CONNECTION](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-connection.md): The `ALTER CONNECTION` command modifies the definition of a connection. To use this command, you must own the connection.
- [ALTER DATABASE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-database.md): The `ALTER DATABASE` command modifies the definition of a database.
- [ALTER FUNCTION](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-function.md): The `ALTER FUNCTION` command modifies the definition of a function. To use this command, you must own the function.
- [ALTER INDEX](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-index.md): The `ALTER INDEX` command modifies the definition of an index.
- [ALTER MATERIALIZED VIEW](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-materialized-view.md): The `ALTER MATERIALIZED VIEW` command modifies the metadata of a materialized view. To use this command, you must own the materialized view.
- [ALTER SCHEMA](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-schema.md): The `ALTER SCHEMA` command modifies the definition of a schema. To use this command, you must own the schema.
- [ALTER SECRET](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-secret.md): Use the `ALTER SECRET` command to alter the secrets that store sensitive credentials.
- [ALTER SINK](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-sink.md): The `ALTER SINK` command modifies the metadata of a sink.
- [ALTER SOURCE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-source.md): The `ALTER SOURCE` command modifies the definition of a source.
- [ALTER SUBSCRIPTION](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-subscription.md): The `ALTER SUBSCRIPTION` command modifies the definition of a subscription.
- [ALTER SWAP](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-swap.md)
- [ALTER SYSTEM](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-system.md): The `ALTER SYSTEM` command modifies the value of a server configuration parameter.
- [ALTER TABLE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-table.md): The `ALTER TABLE` command modifies the definition of a table.
- [ALTER USER](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-user.md): Use the `ALTER USER` command to modify the name, password, system permissions, and other properties of an existing user.
- [ALTER VIEW](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-alter-view.md): The `ALTER VIEW` command modifies the metadata of a view. To use this command, you must own the view.
- [AS CHANGELOG](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-as-changelog.md): Use the `AS CHANGELOG` clause to convert a changelog operation in a stream into a column.
- [BEGIN](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-begin.md): RisingWave supports read-only transactions. You can use the `BEGIN READ ONLY` command to start a read-only transaction.
- [CANCEL JOBS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-cancel-jobs.md): Use `CANCEL JOBS/JOB` to cancel specific streaming jobs that are in progress.
- [COMMENT ON](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-comment-on.md): You can use the `COMMENT ON` command to add comments on tables or columns in RisingWave. Comments are stored as metadata of tables or columns.
- [COMMIT](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-commit.md): RisingWave supports read-only transactions. You can use the `COMMIT` command to commit the current transaction.
- [CREATE AGGREGATE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-aggregate.md): The `CREATE AGGREGATE` command can be used to create [user-defined aggregate functions](/sql/udfs/user-defined-functions) (UDAFs). Currently, UDAFs are only supported in Python and JavaScript as embedded UDFs.
- [CREATE CONNECTION](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-connection.md): Use the `CREATE CONNECTION` command to create a reusable catalog for connector parameters.
- [CREATE DATABASE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-database.md): Use the `CREATE DATABASE` command to create a new database.
- [CREATE FUNCTION](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-function.md): The `CREATE FUNCTION` command can be used to create [user-defined functions](/sql/udfs/user-defined-functions) (UDFs).
- [CREATE INDEX](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-index.md): Use the `CREATE INDEX` command to construct an [index](/processing/indexes) on a table or a materialized view.
- [CREATE MATERIALIZED VIEW](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-mv.md): Use the `CREATE MATERIALIZED VIEW` command to create a materialized view. A materialized view can be created based on sources, tables, materialized views, or indexes.
- [CREATE SCHEMA](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-schema.md): Use the `CREATE SCHEMA` command to create a new schema.
- [CREATE SECRET](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-secret.md): Use the `CREATE SECRET` command to create secrets to store sensitive credentials securely.
- [CREATE SINK](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-sink.md): Use the `CREATE SINK` command to create a sink. A sink is an external target where you can send data processed in RisingWave. You can create a sink from a table or a materialized view.
- [CREATE SINK INTO](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-sink-into.md): Use the `CREATE SINK INTO` command to create a sink into RisingWave's table.
- [CREATE SOURCE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-source.md): A source is a resource that RisingWave can read data from. You can create a source in RisingWave using the `CREATE SOURCE` command.
- [CREATE TABLE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-table.md): Use the `CREATE TABLE` command to create a new table. Tables consist of fixed columns and insertable rows.
- [CREATE USER](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-user.md): Use the `CREATE USER` command to create a new user account in RisingWave.
- [CREATE VIEW](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-create-view.md): Use the `CREATE VIEW` command to create a non-materialized view, which runs every time the view is referenced in a query. A non-materialized view can be created based on sources, tables, views, or indexes.
- [DELETE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-delete.md): Use the `DELETE` command to permanently remove rows from a table.
- [DESCRIBE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-describe.md): Use the `DESCRIBE` command to view columns in the specified table, source, sink, view, or materialized view.
- [DISCARD](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-discard.md): Use the `DISCARD` command to reset the state of current session
- [DROP AGGREGATE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-aggregate.md): Use the `DROP AGGREGATE` command to remove an existing [user-defined aggregate function (UDAF)](/sql/udfs/user-defined-functions). The usage is similar to `DROP FUNCTION`, except that it's for aggregate functions.
- [DROP CONNECTION](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-connection.md): Use the `DROP CONNECTION` command to remove a connection.
- [DROP DATABASE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-database.md): Use the `DROP DATABASE` command to remove a database from your RisingWave instance.
- [DROP FUNCTION](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-function.md)
- [DROP INDEX](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-index.md): Use the `DROP INDEX` command to remove an index from a table or a materialized view.
- [DROP MATERIALIZED VIEW](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-mv.md): Use the `DROP MATERIALIZED VIEW` command to remove a materialized view from the database.
- [DROP SCHEMA](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-schema.md): Use the `DROP SCHEMA` command to remove a schema from a database.
- [DROP SECRET](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-secret.md): Use the `DROP SECRET` command to drop the secrets that store sensitive credentials.
- [DROP SINK](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-sink.md): Use the `DROP SINK` command to remove a [sink](/sql/commands/sql-create-sink) if you no longer need to deliver data to the sink.
- [DROP SOURCE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-source.md): Use the `DROP SOURCE` command to remove a [source](/sql/commands/sql-create-source) if you no longer need the data inflow from the source.
- [DROP TABLE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-table.md): Use the `DROP TABLE` command to remove a table from the database.
- [DROP USER](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-user.md): Use the `DROP USER` command to remove a user from RisingWave.
- [DROP VIEW](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-drop-view.md): Use the `DROP VIEW` command to remove an existing view from a particular schema.
- [EXPLAIN](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-explain.md): Use the `EXPLAIN` command to show the execution plan of a statement.
- [FLUSH](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-flush.md): The `FLUSH` command commits any pending data changes and forces RisingWave to persist updated data to storage, which guarantees subsequent reads can access the latest data.
- [GRANT](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-grant.md): Use the `GRANT` command to grant specific privileges to a user.
- [INSERT](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-insert.md): Use the `INSERT` command to insert new rows into an existing table.
- [RECOVER](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-recover.md): Use the `RECOVER` command to trigger an ad-hoc recovery manually. This is helpful when there is a high barrier latency and you need to force a recovery to activate. By doing this, commands like `CANCEL` or `DROP` can take effect immediately.
- [REVOKE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-revoke.md): Use the `REVOKE` command to revoke privileges from a user.
- [SELECT](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-select.md): Use the `SELECT` command to retrieve rows from a table or materialized view. It returns the rows that satisfy the criteria that you specify with the clauses and conditions in your query.
- [SET](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-set.md): Use the `SET` command to change a runtime parameter.
- [SET BACKGROUND_DDL](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-set-background-ddl.md): Data Definition Language (DDL) commands, such as creating materialized views, will first **backfill** historical data from the referenced relations, and completion time varies based on the volume of data to be backfilled.
- [SET RW_IMPLICIT_FLUSH](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-set-rw-implicit-flush.md): The `RW_IMPLICIT_FLUSH` configuration option controls the behavior of implicit flushes after batch operations.
- [SET TIME ZONE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-set-time-zone.md): Use the `SET TIME ZONE` command to specify the time zone that should be used to interpret date and time values.
- [SHOW CLUSTER](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-cluster.md): Use the `SHOW CLUSTER` command to display various details of your cluster, such as the cluster's address, type, state, and starting time.
- [SHOW COLUMNS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-columns.md): Use the `SHOW COLUMNS` command to view columns in the specified table, source, sink, view or materialized view.
- [SHOW CONNECTIONS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-connections.md): Use the `SHOW CONNECTIONS` command to see connections that have been created.
- [SHOW CREATE INDEX](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-create-index.md): Use the `SHOW CREATE INDEX` command to see what query was used to create the specified index.
- [SHOW CREATE MATERIALIZED VIEW](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-create-mv.md): Use the `SHOW CREATE MATERIALIZED VIEW` command to see what query was used to create the specified materialized view.
- [SHOW CREATE SINK](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-create-sink.md): Use the `SHOW CREATE SINK` command to see the SQL statement used to create the specified sink. By using this command, you can verify the sink's settings and troubleshoot any issues.
- [SHOW CREATE SOURCE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-create-source.md): Use the `SHOW CREATE SOURCE` command to see the SQL statement used to create the specified source. By using this command, you can verify the source's settings and troubleshoot any issues.
- [SHOW CREATE TABLE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-create-table.md): Use the `SHOW CREATE TABLE` command to see what query was used to create the specified table.
- [SHOW CREATE VIEW](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-create-view.md): Use the `SHOW CREATE VIEW` command to see what query was used to create the specified view.
- [SHOW CURSORS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-cursors.md): Use the `SHOW CURSORS` command to display all cursors in the current session.
- [SHOW DATABASES](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-databases.md): Use the `SHOW DATABASES` command to show all databases.
- [SHOW FUNCTIONS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-functions.md): Run `SHOW FUNCTIONS` to get a list of existing [user-defined functions](/sql/udfs/user-defined-functions). The returned information includes the name, argument types, return type, language, and server address of each function.
- [SHOW INDEXES](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-indexes.md): Use the `SHOW INDEXES` command to view indexes from a particular table.
- [SHOW INTERNAL TABLES](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-internal-tables.md): Use the `SHOW INTERNAL TABLES` command to view the existing internal tables in RisingWave. Internal tables are tables that store intermediate results (also known as internal states) of queries.
- [SHOW JOBS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-jobs.md): Use `SHOW JOBS` to get all streaming jobs that are in progress, including their IDs, the specific statements, and their progresses.
- [SHOW MATERIALIZED VIEWS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-mv.md): Use the `SHOW MATERIALZED VIEWS` command to show existing materialized views.
- [SHOW PARAMETERS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-parameters.md): You can use the `SHOW PARAMETERS` command to view the [system parameters](/operate/view-configure-system-parameters), along with their current values.
- [SHOW PROCESSLIST](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-processlist.md): Use the `SHOW PROCESSLIST` command to display the current workload of the system. The output of this command consists of id, user, host, database, time, and info.
- [SHOW SCHEMAS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-schemas.md): Use the `SHOW SCHEMAS` command to show schemas in the `dev` database.
- [SHOW SINKS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-sinks.md): Use the `SHOW SINKS` command to return a list of all sinks.
- [SHOW SOURCES](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-sources.md): Use the `SHOW SOURCES` command to show existing sources.
- [SHOW SUBSCRIPTION CURSORS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-subscription-cursors.md): Use the `SHOW SUBSCRIPTION CURSORS` command to display all subscription cursors in the current session.
- [SHOW TABLES](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-tables.md): Use the `SHOW TABLES` command to view tables in a particular schema.
- [SHOW VIEWS](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-show-views.md): Use the `SHOW VIEW` command to list existing views in a particular schema.
- [START TRANSACTION](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-start-transaction.md): RisingWave supports read-only transactions. You can use the `START TRANSACTION READ ONLY` command to start a read-only transaction. For more information about transactions in RisingWave, see [Transactions](/processing/transactions).
- [UPDATE](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/commands/sql-update.md): Use the `UPDATE` command to modify values of existing rows in a table.
- [ARRAY type](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/array-type.md): An array `T[]` is an ordered list of zero or more elements that share the same data type. PostgreSQL uses one-based indexing for arrays, meaning an array with n elements starts at `array[1]` and ends at `array[n]`. RisingWave also applies one-based indexing to align with PostgreSQL.
- [Casting](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/casting.md): Certain data types can be cast to and from other types implicitly or explicitly.
- [JSONB](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/jsonb.md): Use the `JSONB` data type to create a column that can store JSON data.
- [Map type](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/map-type.md)
- [Overview of data types](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/overview.md): RisingWave supports the following data types:
- [rw_int256](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/rw-int256.md)
- [Struct](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/struct.md): Use the struct data type to create a column that contains nested columns. The nested columns can be of different data types, including the struct type.
- [Supported protobuf types](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/supported-protobuf-types.md): RisingWave supports a variety of protobuf data types, which are converted to equivalent types in RisingWave. This page provides an overview of the supported protobuf types and their corresponding RisingWave types.
- [Timestamp](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/data-types/timestamp.md): Use the timestamp data type to handle date and time information.
- [Aggregate functions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/aggregate.md): Aggregate functions compute a single result from a set of input values.
- [Array functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/array.md)
- [Binary string functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/binarystring.md)
- [Comparison functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/comparison.md)
- [Conditional expressions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/conditional.md)
- [Cryptographic functions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/cryptographic.md): Raw encryption functions are basic encryption functions that perform encryption and decryption of data using cryptographic algorithms.
- [Date and time functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/datetime.md)
- [JSON functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/json.md)
- [Logical operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/logical.md)
- [Map functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/map.md)
- [Mathematical functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/mathematical.md)
- [SQL functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/overview.md): Functions and operators that can be used in SQL queries.
- [Set-returning functions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/set-returning.md)
- [String functions and operators](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/string.md)
- [System administration functions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/sys-admin.md): This page lists both RisingWave system administration functions and PostgreSQL system administration functions that are supported in RisingWave.
- [System information functions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/sys-info.md): RisingWave provides functions to help you get system information, including database, schema, user, role, session, and more.
- [Window functions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/functions/window-functions.md): Window functions compute a single result for each row over a set of rows that are related to the current row (the "window").
- [Identifiers](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/identifiers.md)
- [SQL references](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/overview.md)
- [Psql commands](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/psql-commands.md): RisingWave supports the following psql commands:
- [FROM clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/from-clause.md): The `FROM` clause specifies the source of the data on which the query should operate. Logically, the `FROM` clause is where the query starts execution. It can contain a single table, a combination of multiple joined tables, or another SELECT query inside a subquery node.
- [Generated columns](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/generated-columns.md): A generated column is a special column that is always computed from other columns. In RisingWave, you can create a generated column when creating a table or source.
- [GROUP BY clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/group-by-clause.md): The `GROUP BY` clause groups rows in a table with identical data, thus eliminating redundancy in the output and aggregates that apply to these groups.
- [HAVING clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/having-clause.md): The `HAVING` clause is optional and eliminates group rows that do not satisfy a given condition. `HAVING` is similar to the `WHERE` clause, but `WHERE` occurs before the grouping, and `HAVING` occurs after.
- [LIMIT clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/limit-clause.md): `LIMIT` is an output modifier. Logically it is applied at the end of the query, and the `LIMIT` clause restricts the number of rows fetched.
- [Literals](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/literals.md): Literals play a crucial role in enhancing the accuracy of data representation and optimizing system efficiency. See the following subsections for the introduction of various types of literals.
- [ORDER BY clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/order-by-clause.md): Use the `ORDER BY` clause to sort the result set of a query based on one or more columns in ascending or descending order. It is commonly used to organize data in a specific sequence for better analysis and presentation.
- [Query syntax](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/overview.md): Syntax and usage of common query clauses.
- [Set operations](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/set-operations.md): The results of two queries can be combined using the set operations `UNION` and `INTERSECT`.
- [Value expressions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/value-exp.md): Value expressions are used in a variety of contexts, such as in the target list of the `SELECT` command, as new column values in `INSERT` or `UPDATE`, or in search conditions in a number of commands.
- [VALUES clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/values-clause.md)
- [WHERE clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/where-clause.md): The `WHERE` clause specifies any conditions or filters to apply to your data. This allows you to select only a specific subset of the data. The `WHERE` clause is used right after the `FROM` clause.
- [WITH clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/with-clause.md): The `WITH` clause provides a way to write supplemental statements for a larger query. These statements, also known as Common Table Expressions or CTEs, can be viewed as defining temporary tables that exist just for one query.
- [WITH ORDINALITY clause](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/query-syntax/with-ordinality-clause.md): The `WITH ORDINALITY` clause can be used with set functions in the `FROM` clause of a query.
- [Information schema](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/system-catalogs/information-schema.md): The information schema consists of a set of views that contain information about the objects defined in the current database.
- [System catalogs](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/system-catalogs/overview.md): System catalogs that can be used to query metadata.
- [PostgreSQL catalogs](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/system-catalogs/pg-catalog.md): RisingWave supports these system catalogs and views of PostgreSQL.
- [RisingWave catalogs](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/system-catalogs/rw-catalog.md): RisingWave catalogs contain system tables and views that provide metadata about different relations in the system, as well as information about the cluster jobs and their status.
- [Embedded Python UDFs](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/udfs/embedded-python-udfs.md): You can define embedded Python UDFs, which will be executed in an embedded Python interpreter within RisingWave. The Python code is directly included within the [CREATE FUNCTION](/sql/commands/sql-create-function) statement.
- [SQL UDFs](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/udfs/sql-udfs.md): You can define SQL UDFs in RisingWave by using the [CREATE FUNCTION](/sql/commands/sql-create-function) command.
- [External Java UDFs](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/udfs/use-udfs-in-java.md): This article provides a step-by-step guide for installing the RisingWave Java UDF SDK, defining functions using Java, starting a Java process as a UDF server, and declaring and using UDFs in RisingWave.
- [Use UDFs in JavaScript](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/udfs/use-udfs-in-javascript.md): This article provides a step-by-step guide for defining JavaScript functions in RisingWave.
- [External Python UDFs](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/udfs/use-udfs-in-python.md): This article provides a step-by-step guide for defining and running external Python UDFs, and calling them from RisingWave.
- [Use UDFs in Rust](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/udfs/use-udfs-in-rust.md): This article provides a step-by-step guide for defining Rust functions in RisingWave.
- [User-defined functions](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/sql/udfs/user-defined-functions.md): In modern data processing and analysis, SQL language is a powerful tool for handling structured data. However, as the complexity of data analysis increases, standard SQL statements and built-in functions may not be sufficient to meet all data processing needs. This is where user-defined functions (U…
- [Iceberg table engine](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/store/iceberg-table-engine.md): Learn how to use the Iceberg table engine in RisingWave to store data natively in the Iceberg format.
- [Overview](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/store/overview.md): Learn how to store data persistently inside RisingWave.
- [Meta failure](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/troubleshoot/meta-failure.md): If the meta fails to start or abruptly exits during operation, there is currently only one known issue that can cause this problem: the meta node fails to remain active while participating in the campaign.
- [Node failure](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/troubleshoot/node-failure.md): When it comes to crafting downtime-sensitive applications, users often have some common questions:
- [Overview](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/troubleshoot/overview.md): This guide assumes that you deploy RisingWave on K8s using the RisingWave K8s Operator. In the Operator, we packaged RisingWave, RisingWave Dashboard, and third-party observability and logging tools like Prometheus and Grafana.
- [Deployment issues](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/troubleshoot/troubleshoot-deployment-issues.md): This page summarizes some issues about deployment.
- [Out of memory](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/troubleshoot/troubleshoot-oom.md): Out-of-Memory (OOM) is a common issue in data processing systems that can have multiple causes. This guide aims to help you identify the root causes of OOM errors and efficiently resolve the issues.
- [Recovery failure](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/troubleshoot/troubleshoot-recovery-failure.md): When there are some problems in the RisingWave cluster, such as node restart and network abnormalities, the cluster will enter recovery processing to ensure data consistency.
- [Sources and sinks](https://risingwavelabs-wyx-add-timestamp-dedicated-page.mintlify.app/troubleshoot/troubleshoot-source-sink.md): Generally, the performance of streaming jobs can be significantly affected by the sources and sinks.

## Optional

- [Join Slack community](https://go.risingwave.com/slack)
- [GitHub](https://github.com/risingwavelabs/risingwave)