SHOW SUNDECK TABLES
Return the properties of current active sundeck pin tables.
- See also:
- DESCRIBE SUNDECK TABLE, ALTER SUNDECK TABLE
SHOW SUNDECK [ TABLES | VIEWS ]
<IDENTIFIER>- Specifies the identifier for the Snowflake table to be used as Pin table. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive (e.g. “My Table”).
TEST#DEMO.PIN> show sundeck tables
+-------------+-----------------+----------------+-------------------------------+-----------------+--------------------------------------+
| PIN_DB_NAME | PIN_SCHEMA_NAME | PIN_TABLE_NAME | PIN_REFRESH_FREQUENCY_SECONDS | PIN_CREATED_BY | PIN_CREATED_AT |
|-------------+-----------------+----------------+-------------------------------+-----------------+--------------------------------------|
| DEMO | PIN | BIGTABLES | 60 | test@sundeck.io | 2023-11-03 04:52:38.774094 +0000 UTC |
| DEMO | PIN | XXLTABLES | 180 | test@sundeck.io | 2023-11-02 05:51:46.277431 +0000 UTC |
+-------------+-----------------+----------------+-------------------------------+-----------------+--------------------------------------+
2 Row(s) produced. Time Elapsed: 0.350s