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

TABLES

Sundeck CATALOG.TABLES view stores information about pins. This doesn’t display 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 tables;
+---------------+---------------+-----------------+--------------------------------------+-----------+---------------------------+
| DB_NAME       | SCHEMA_NAME   | TABLE_NAME      | CREATED_AT                           | IS_SYSTEM | REFRESH_FREQUENCY_SECONDS |
|---------------+---------------+-----------------+--------------------------------------+-----------+---------------------------|
| ANSHUL_TESTDB | PINTABLE_DEMO | QUERY_SIGNATURE | 2024-06-25 09:15:22.035197 +0000 UTC | FALSE     | 60000                     |
+---------------+---------------+-----------------+--------------------------------------+-----------+---------------------------+
1 Row(s) produced. Time Elapsed: 44.871s