BROKERS
Sundeck CATALOG.BROKERS view stores information about brokers.
| Column Name | Data Type | Description |
|---|---|---|
| NAME | TEXT | Broker name |
| IS_DEFAULT | TEXT | true if broker is default otherwise false |
| DEFAULT_WAREHOUSE | TEXT | Default warehouse to run queries on |
| HOSTNAME | TEXT | Hostname to connect to broker |
| LAST_MODIFIED_AT | TEXT | Last time broker was modified at. |
| DDL | TEXT | DDL to create this broker |
| RESULTS_PATH | TEXT | Result path used for this flow |
| COMMENT | TEXT | Comments text |
ube@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
ube@sundeck.io#COMPUTE_WH@OPSCENTER.CATALOG>