Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage


Sundeck CATALOG.BROKERS view stores information about brokers.

Column NameData TypeDescription
NAMETEXTBroker name
IS_DEFAULTTEXTtrue if broker is default otherwise false
DEFAULT_WAREHOUSETEXTDefault warehouse to run queries on
HOSTNAMETEXTHostname to connect to broker
LAST_MODIFIED_ATTEXTLast time broker was modified at.
DDLTEXTDDL to create this broker
RESULTS_PATHTEXTResult path used for this flow
COMMENTTEXTComments text

Example:>select name, is_default, hostname from brokers;
| NAME                          | IS_DEFAULT | HOSTNAME             |
| Enable Snowflake Enhancements | true       | |
| Optimized Route               | false      | |
2 Row(s) produced. Time Elapsed: 4.160s>