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

BROKERS

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:

anshul@sundeck.io#COMPUTE_WH@SUNDECK.CATALOG>select name, is_default, hostname from brokers;
+-------------------------------+------------+----------------------+           
| NAME                          | IS_DEFAULT | HOSTNAME             |
|-------------------------------+------------+----------------------|
| Enable Snowflake Enhancements | true       | d4k88hgl.dev.sndk.io |
| Optimized Route               | false      | oxciog5j.dev.sndk.io |
+-------------------------------+------------+----------------------+
2 Row(s) produced. Time Elapsed: 4.160s
anshul@sundeck.io#COMPUTE_WH@OPSCENTER.CATALOG>