Using SQL Stream Builder
Getting Started
Projects
Creating a project
Navigating in a project
Managing member of a project
Source control of a project
Masking information before using source control
Setting the environment for a project
Importing a project
Data sources
Adding Kafka Data Source
Adding Catalogs
Using auto discovery of services
Setting up the service discovery
Using the service discovery on Streaming SQL Console
Connectors
Using connectors with templates
Adding new connectors
Kafka connectors
CDC connectors
JDBC connector
Filesystem connector
Datagen connector
Faker connector
Blackhole connector
Data formats
Adding data formats
Tables
Kafka tables
Configuring Kafka tables
Schema Definition tab
Event Time tab
Data Transformations tab
Properties tab
Deserialization tab
Assigning Kafka keys in streaming queries
Performance & Scalability
Creating Webhook tables
Flink SQL tables
Iceberg tables
SQL jobs
Creating and naming SQL jobs
Running SQL Stream jobs
Configuring SQL job settings
Adjusting logging configuration in Advanced Settings
Configuring YARN queue for SQL jobs
Configuring state backend for SSB
Managing session for SQL jobs
Executing SQL jobs in production mode
Functions
Creating Python User-defined Functions
Creating Javascript User-defined Functions
Developing JavaScript functions
Creating Java User-defined functions
Using System Functions
Materialized views
Creating Materialized Views
Configuring Retention Time for Materialized Views
Materialized View Pagination
Using Dynamic Materialized View Endpoints
Configuring Materialized View database information
Using SQL Stream Builder with Cloudera Data Visualization
Widgets
Creating widgets
Choosing data sources
Managing data source jobs
Customizing visualization types
Configuring widget, fields and legend
Configuring graph style
Visualization type: Area
Visualization type: Bar
Visualization type: Donut
Visualization type: Gauge
Visualization type: Data grid
Visualization type: Line
Visualization type: Pie
Visualization type: Scatter
Visualization type: Spline
Managing widgets on the Dashboard
Notifications
REST API
Monitoring
Collecting diagnostic data
Governance
Flink SQL
Flink DDL
Managing time in SSB
Flink DML
Flink Queries
Other supported statements
Data Types
Dynamic SQL Hints
SQL Examples
Data Enrichment
Joining streaming and bounded tables
Example: joining Kafka and Kudu tables
Updating SQL queries with PROCTIME function