cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks Views

maheshwor
New Contributor III

How do we find the definition of View in databricks?

1 ACCEPTED SOLUTION

Accepted Solutions

Ryan_Chynoweth
Honored Contributor III

You can use the extended table description. For example, the following python code will print the current definition of the view:

table_name = ""
df = spark.sql("describe table extended {}".format(table_name))
df.createOrReplaceTempView("view_desription")
 
data = spark.sql(
"""
select data_type 
from view_desription
where col_name = 'View Text'
 
"""
).collect()[0][0]
 
print(data)
 
 

View solution in original post

1 REPLY 1

Ryan_Chynoweth
Honored Contributor III

You can use the extended table description. For example, the following python code will print the current definition of the view:

table_name = ""
df = spark.sql("describe table extended {}".format(table_name))
df.createOrReplaceTempView("view_desription")
 
data = spark.sql(
"""
select data_type 
from view_desription
where col_name = 'View Text'
 
"""
).collect()[0][0]
 
print(data)
 
 

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.