SQL Workspaces Naming Rules

StreamNative maps SQLCatalog and topic names to identifiers in the SQLWorkspace engine.

SQLCatalog and topic mapping

Source system	Database	Schema	Source
Pulsar	SQLCatalog name	Full Pulsar tenant and namespace, such as `public/default`	Local topic name
Kafka	SQLCatalog name	`public`	Kafka topic name

StreamNative preserves mapped database, schema, and topic names when they fit the SQLWorkspace engine’s 63-byte identifier limit. Longer names are shortened and receive a deterministic suffix. Use the exact schema and source names shown in SQL Studio.

Quoted identifiers

Always enclose topic-derived schema and source names in double quotes, including names that do not contain punctuation:

SELECT * FROM "public/default"."order-events";
SELECT * FROM "public"."events.production";

Double quotes identify SQL objects. Single quotes represent string values and cannot be used in place of identifier quotes. Unquoted identifiers are normalized by the SQLWorkspace engine. Quoting preserves case and avoids conflicts with SQL keywords or punctuation. For more information about sources, tables, and materialized views, see RisingWave SQL reference.

⌘I

Overview

Engine

Get Started

Operations

Access Control

SQLCatalog and topic mapping

Quoted identifiers

​SQLCatalog and topic mapping

​Quoted identifiers

SQLCatalog and topic mapping

Quoted identifiers