Creating tables with Flink SQL in SSB
You can create tables in SQL Stream Builder (SSB) using Flink DDL. When using Flink DDL, you can use Kudu, Hive, Schema Registry as catalogs. When using Kudu, Hive and Schema Registry catalog, you need to create a Streams Messaging, Real-time Data Mart or Data Engineering cluster within your environment. Aditionally to catalogs, there are predefined templates based on the supported connectors that you only need to fill out to use as a CREATE TABLE statement for your SQL query.
- You have prepared your environment based on the checklist in the Prepare your environment section.
- You have set Ranger policies for Flink and SSB.
- You have created a Streams Messaging, Real-time Data Mart or Data Engineering cluster in your environment.
- You have tables in Kudu, Hive and added a schema to Schema Registry.