DESCRIBE

Use the DESCRIBE command to get the attribute names and types for the data lake table. In 11.2.2.9 release, this command is applicable to data lake tables and SQL on Parquet tables, not for NPS tables.

Syntax

Syntax for describing table names:

DESCRIBE tblname

Inputs

The DESCRIBE command takes the following inputs:

Table 1. DESCRIBE inputs
Input	Description
tblname	The name of the table.
schemaname.tblname	The names of the schema and the table.
dbname.schemaname.tblname	The names of the database, schema, and table.

Privileges

You must have the List privilege for the table the attribute names and types of you want to check.

Usage

Example:

DATALAKE.NETEZZA_SCHEMA(ADMIN)=> set schema sales;
SET SCHEMA
DATALAKE.SALES(ADMIN)=> DESCRIBE products;
 ATTRIBUTE |              TYPE               
-----------+---------------------------------
 ID        | INTEGER
 NAME      | NATIONAL CHARACTER VARYING(512)
 COST      | DOUBLE PRECISION
(3 rows)