https://community.databricks.com/t5/data-engineering/databricks-views/m-p/16777#M10890 <P></P> <P>How do we find the definition of View in databricks?</P> <P></P> Mon, 09 Aug 2021 03:24:38 GMT maheshwor 2021-08-09T03:24:38Z https://community.databricks.com/t5/data-engineering/databricks-views/m-p/16777#M10890 <P></P> <P>How do we find the definition of View in databricks?</P> <P></P> Mon, 09 Aug 2021 03:24:38 GMT https://community.databricks.com/t5/data-engineering/databricks-views/m-p/16777#M10890 maheshwor 2021-08-09T03:24:38Z https://community.databricks.com/t5/data-engineering/databricks-views/m-p/16778#M10891 <P>You can use the extended table description. For example, the following python code will print the current definition of the view: </P><P></P><PRE><CODE>table_name = "" df = spark.sql("describe table extended {}".format(table_name)) df.createOrReplaceTempView("view_desription") &nbsp; data = spark.sql( """ select data_type from view_desription where col_name = 'View Text' &nbsp; """ ).collect()[0][0] &nbsp; print(data) &nbsp; &nbsp;</CODE></PRE><P></P> Wed, 01 Sep 2021 21:20:20 GMT https://community.databricks.com/t5/data-engineering/databricks-views/m-p/16778#M10891 Ryan_Chynoweth 2021-09-01T21:20:20Z