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

SHOW SUNDECK TABLES

Return the properties of current active sundeck pin tables.

See also:
DESCRIBE SUNDECK TABLE, ALTER SUNDECK TABLE

Syntax

  SHOW SUNDECK [ TABLES | VIEWS ]

Parameters

<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”).

Examples:

SHOW SUNDECK 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