Skip to main content

DESCRIBE TABLE

Provide high-level information regarding the overall column properties of an existing dataset. Dremio displays the column headers indicating the type of information being described and rows for each table column with their associated attributes described, such as data types, properties, and policies.

Syntax
DESCRIBE TABLE <table_name>

Parameters

<table_name> String

The name of the table that you want to describe.

Example

Describing a table
DESCRIBE TABLE taxistats
COLUMN_NAMEDATA_TYPEIS_NULLABLENUMERIC_PRECISIONNUMERIC_SCALEEXTENDED_PROPERTIESMASKING_POLICY
pickup_datetimeTIMESTAMPYESnullnull[][]
passenger_countBIGINTYES640[]count_hide
trip_distance_miDOUBLEYES53null[][]
fare_amountDOUBLEYES53null[][]
tip_amountDOUBLEYES53null[][]
total_amountDOUBLEYES53null[][]

The cells containing a '[]' indicate "empty" values.