ROUTINES
Sundeck CATALOG.ROUTINES view stores information about routines.
| Column Name | Data Type | Description |
|---|---|---|
| NAME | TEXT | Routine name |
| NAMESPACE | TEXT | Namespace to which routine belongs to |
| REF_COUNT | TEXT | Number of references (from broker and other routines) to this routine |
| CREATED_AT | TEXT | Time this routine was created at |
| LAST_MODIFIED_AT | TEXT | Last time routine was modified at. |
| DDL | TEXT | DDL to create this routine |
| COMMENT | TEXT | Comments text |
kai@sundeck.io#COMPUTE_WH@SUNDECK.CATALOG>select name,ref_count from routines;
+--------------------+-----------+
| NAME | REF_COUNT |
|--------------------+-----------|
| Optimal Route | 1 |
| Reject Bad Queries | 0 |
+--------------------+-----------+
2 Row(s) produced. Time Elapsed: 9.536s
kai@sundeck.io#COMPUTE_WH@OPSCENTER.CATALOG>