On this page

    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.