PINS
Sundeck CATALOG.PINS view stores information about pins. This also displays system pins too.
| Column Name | Data Type | Description |
|---|---|---|
| DB_NAME | TEXT | Database to which Pin table belongs to |
| SCHEMA_NAME | TEXT | Schema to which Pin table belongs to |
| TABLE_NAME | TEXT | pin table name |
| CREATED_AT | TEXT | Time pin table was created at |
| IS_SYSTEM | TEXT | true if Pin table is system PIN (i.e. created internally by sundeck) otherwise false. |
| REFRESH_FREQUENCY_SECONDS | TEXT | Refresh frequency for this PIN |
kai@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 |
| KAI_TESTDB | PINTABLE_DEMO | QUERY_SIGNATURE | 2024-06-25 09:15:22.035197 +0000 UTC | FALSE | 60000 |
+------------------+---------------+-----------------+--------------------------------------+-----------+---------------------------+
2 Row(s) produced. Time Elapsed: 5.717s
kai@sundeck.io#COMPUTE_WH@OPSCENTER.CATALOG>