Skip to content

Instantly share code, notes, and snippets.

@josete89
Last active May 4, 2022 16:42
Show Gist options
  • Save josete89/115626003c72c5771241669f56b614c5 to your computer and use it in GitHub Desktop.
Save josete89/115626003c72c5771241669f56b614c5 to your computer and use it in GitHub Desktop.

DESCRIBE FORMATTED `delta-table`;

Query result

# col_name            	data_type           	comment             	 	 
col                 	array<string>       	from deserializer   

# Detailed Table Information
Database:           	test    	 
Owner:              	root
....
Table Parameters:	 	 
	EXTERNAL            	TRUE                               
	spark.sql.create.version	3.2.1               
	spark.sql.partitionProvider	catalog             
	spark.sql.sources.provider	delta               
	spark.sql.sources.schema	{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"integer\",\"nullable\":true,\"metadata\":{}},{\"name\":\"productName\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"quantity\",\"type\":\"integer\",\"nullable\":true,\"metadata\":{}}]}
  ....
  
# Storage Information	
....
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment