On this page

    INFORMATION_SCHEMA.VIEWS

    The INFORMATION_SCHEMA.VIEWS view contains metadata for views in a project.

    Syntax
    SELECT * 
    FROM INFORMATION_SCHEMA.VIEWS
    

    Example Output

    TABLE_CATALOGTABLE_SCHEMATABLE_NAMEVIEW_DEFINITION
    DREMIOOthers4-weeks-recipesSELECT * FROM “4week_recipes.json” WHERE cuisine = ‘greek’
    DREMIOOthersEmployee-SalarySELECT * FROM “employees.parquet” WHERE salary > 15000
    DREMIOOthersPaymentSELECT * FROM “payment_lookup.csv” WHERE payment_lookup = ‘Cash’
    DREMIOOthersrestaurant-reviewsSELECT * FROM “restaurant_reviews.parquet” WHERE city = ‘Carnegie’
    DREMIOOthersSales-RecordsSELECT * FROM “100_Sales_Records_inconsistency.csv” WHERE ‘Item Type’ = ‘Baby Food’
    DREMIOOthersSFIncidentsSELECT * FROM “SF_incidents2016.json” WHERE DayOfWeek = ‘Friday’
    DREMIOTaxiTripNYCTaxiFareSELECT * FROM “NYC-taxi-trips” WHERE fare_amount > 20
    DREMIOWeatherNYCtaxifareSELECT * FROM “NYC-taxi-trips” WHERE fare_amount > 20
    DREMIOWeatherSFWeatherElevationSELECT “TO_NUMBER”(“ELEVATION”, ‘##.##') AS “ELEVATION” FROM “Samples”.“samples.dremio.com”.“SF weather 2018-2019.csv”
    DREMIOWeatherzipsSELECT * FROM “Weather”.“SFWeatherElevation”

    Fields

    FieldData TypeDescription
    TABLE_CATALOGvarcharThe name of the catalog, which is always DREMIO.
    TABLE_SCHEMAvarcharThe path (source, space, folders) to the view.
    TABLE_NAMEvarcharThe name of the view.
    VIEW_DEFINITIONvarcharThe original SQL query (underlying DDL statement) used to define the view.