DESCRIBE SUNDECK TABLE

Describes the properties of one pin table.

See also:: ALTER SUNDECK TABLE, SHOW SUNDECK TABLES

Syntax

  DESCRIBE SUNDECK [TABLE|VIEW] <IDENTIFIER>

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:

DESCRIBE SUNDECK TABLE

test#DEMO.PIN> describe sundeck table DEMO.pin.BigTables
+-------------+-----------------+----------------+-------------------------------+-----------------+-----------------------------------------+-------------------------------+
| PIN_DB_NAME | PIN_SCHEMA_NAME | PIN_TABLE_NAME | PIN_REFRESH_FREQUENCY_SECONDS | PIN_CREATED_BY  | PIN_CREATED_AT                          | PIN_LAST_REFRESHED_AT         |
|-------------+-----------------+----------------+-------------------------------+-----------------+-----------------------------------------+-------------------------------|
| DEMO        | PIN             | BIGTABLES      | 60                            | test@sundeck.io | 2023-11-02 13:31:07.970645796 +0000 UTC | 2023-11-02 13:31:08 +0000 UTC |
+-------------+-----------------+----------------+-------------------------------+-----------------+-----------------------------------------+-------------------------------+
1 Row(s) produced. Time Elapsed: 0.887s