DESCRIBE FORMATTED `delta-table`;
Query result
# col_name            	data_type           	comment             	 	 
col                 	array<string>       	from deserializer   
# Detailed Table Information
Database: test 
DESCRIBE FORMATTED `delta-table`;
Query result
# col_name            	data_type           	comment             	 	 
col                 	array<string>       	from deserializer   
# Detailed Table Information
Database: test 
DESCRIBE non-delta-table
| col_name | data_type | comment | 
|---|---|---|
| id | int | |
| productName | string | |
| quantity | int | 
DESCRIBE delta-table
Query result:
| col_name | data_type | comment | 
|---|---|---|
| col | array|from deserializer | 
| { | |
| "tables": [{ | |
| "name": "sales_predictions", | |
| "visibility": "internal", | |
| "columns": [{ "name": "article_number","pci": true }] | |
| }, | |
| { | |
| "name": "sales_trends", | |
| "visibility": "public", | |
| "columns": [{ "name": "date","pci": true }] | 
| { | |
| "outputs":{ | |
| "sales_trends":{ | |
| "file-format":"parquet", | |
| "port-type": "blob", | |
| "location": "s3://my-data-product/sales_trends", | |
| "partition-columns": [ "foobar" ], | |
| "retention-time": {"unit": "day","time": 2} | |
| }, | |
| "sales_predictions":{ | 
| { | |
| "inputs": { | |
| "DataProductA":{ | |
| "tables": ["table1","table2"] | |
| } | |
| } | |
| } | 
| { | |
| "consumers": [{ | |
| "account":"99987654321", | |
| "contact": "[email protected]", | |
| "type": "lakeformation", | |
| "enterprise-system-landscape-information-tracker": "foobar", | |
| "team": "foobar", | |
| "consumer-role-arn": "arn:aws:iam::99987654321:role/ConsumerRole" | |
| }] | |
| } | 
| { | |
| "account-type": "aws", | |
| "producer-role-arn": "arn:aws:iam::12345678999:role/ProducerRole", | |
| "producer-account-id": "12345678999", | |
| "bucket-name": "trading-producer-data" | |
| } | 
| { | |
| "data-product-name": "my_data_product", | |
| "data-product-owner": "[email protected]", | |
| "data-product-mantainer": "[email protected]", | |
| "enterprise-system-landscape-information-tracker": "foobar", | |
| "edc-data-objects": [ "foobar" ],"source-system": "SAP-AFS", | |
| "usage-patterns": ["foobar"], | |
| "version": "0.0.1" | |
| } | 
I hereby claim:
To claim this, I am signing this object: