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