Query with SQL Studio

​

Run a query

1. In the Cloud Console, open a Ready SQLWorkspace.
2. In SQL Studio, select a SQLCatalog database and schema.
3. Browse the catalog tree and find a managed topic source.
4. Enter a bounded query. Use the exact schema and source names and enclose both in double quotes. This example uses a Pulsar topic in public/default:
   SELECT *
   FROM "public/default"."orders-topic"
   LIMIT 100;
   
5. Click Run. You can select part of a script to run only that selection.
6. Review the result rows, execution status, and notices.

​

Create a materialized view

CREATE MATERIALIZED VIEW orders_by_status AS
SELECT status, COUNT(*) AS order_count
FROM "public/default"."orders-topic"
GROUP BY status;

SELECT * FROM orders_by_status;

​

Saved queries and history