Skip to main content

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.