How to resolve the column name in s3 path saved as UUID format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2023 10:29 AM
our managed databricks tables stored in s3 as default, while i am reading that s3 path directly i am getting the column value as UUID
eg: column name ID in databricks table
while checking the S3 Path, the column name looks like COL- b400af61-9tha-4565-89c4-d6ba43f948b7
how to resolve it, basically i am reading the S3 path directly to generate as external table in Snowflake
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2023 09:48 PM
hi @Retired_mod
Thank you for you are reply but the issue is i am not able to map ID with COL- b400af61-9tha-4565-89c4-d6ba43f948b7. i use
DESCRIBE TABLE EXTENDED table_name
a query to get the list of UUID column names. and for real column name fetting from information schema, is there any other way to match with appropriate column names?
