[FLINK-25788] Add show connectors command

• Type: Sub-task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Connectors / Common, Table SQL / API
• Labels: auto-deprioritized-major pull-request-available
• Assignee: Unassigned
• Reporter: Sergey Nuyanzin
• Created: 24/Jan/22 14:39
• Updated: 28/Feb/23 11:59

Description

Currently the only work around to see available connectors is to create a table for non-existing connector and run sql over that table. In Exception there will be a list of available connectors.
The idea is to have command like

Flink SQL> SHOW CONNECTORS;
+----------------+--------+
| connector name | type   |
+----------------+--------+
|     opensearch |  sink  |
|        datagen | source |
|      blackhole |  sink  |
|          print |  sink  |
+----------------+--------+
4 rows in set

Issue Links

• links to: GitHub Pull Request #18487