https://delta.io logo
r

Rahul Sharma

04/28/2023, 11:14 AM
hello Team , i am not able to see delta Table schema in glue only i can see array type col ,i am using EMR and running below query
Copy code
%%sql
CREATE TABLE nm.delta_test (
  gender STRING,
  salary INT
) USING DELTA
LOCATION '<s3://nm-dev/nm/test>';
Please let me know if this possible to show the schema also in glue
p

Parthiban Jaganathan

04/28/2023, 5:17 PM
in Glue UI?
r

Rahul Sharma

04/29/2023, 2:41 AM
yes
j

Jon Stockham

05/02/2023, 7:26 AM
You need to create a symlink table rather than a native deltalake table. Note that the symlink table should be only used to read from, for writes you must use the deltalake native table. With Glue crawlers you can choose between the two types.
2 Views