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

PINS

Sundeck CATALOG.PINS view stores information about pins. This also displays system pins too.

Column NameData TypeDescription
DB_NAMETEXTDatabase to which Pin table belongs to
SCHEMA_NAMETEXTSchema to which Pin table belongs to
TABLE_NAMETEXTpin table name
CREATED_ATTEXTTime pin table was created at
IS_SYSTEMTEXTtrue if Pin table is system PIN (i.e. created internally by sundeck) otherwise false.
REFRESH_FREQUENCY_SECONDSTEXTRefresh frequency for this PIN

Example:


anshul@sundeck.io#COMPUTE_WH@SUNDECK.CATALOG>select * from pins;
+------------------+---------------+-----------------+--------------------------------------+-----------+---------------------------+
| DB_NAME          | SCHEMA_NAME   | TABLE_NAME      | CREATED_AT                           | IS_SYSTEM | REFRESH_FREQUENCY_SECONDS |
|------------------+---------------+-----------------+--------------------------------------+-----------+---------------------------|
| SUNDECK_INTERNAL | CATALOG       | WAREHOUSE_POOLS | 2024-06-18 08:27:51.747827 +0000 UTC | TRUE      | 900                       |
| ANSHUL_TESTDB    | PINTABLE_DEMO | QUERY_SIGNATURE | 2024-06-25 09:15:22.035197 +0000 UTC | FALSE     | 60000                     |
+------------------+---------------+-----------------+--------------------------------------+-----------+---------------------------+
2 Row(s) produced. Time Elapsed: 5.717s
anshul@sundeck.io#COMPUTE_WH@OPSCENTER.CATALOG>