Databricks FILE Type Works on FSx for ONTAP S3 Access Points, But Reads Fail
A developer tested Databricks' beta FILE column type against files stored on Amazon FSx for NetApp ONTAP, accessed via S3 Access Points, publishing findings on August 12, 2026. While registering files against an FSx for ONTAP S3 Access Point succeeded, read operations consistently failed due to restrictions in the session policy attached to temporary credentials issued by Unity Catalog. The FILE type itself functioned correctly, but users must choose between FILE EXTERNAL and FILE MANAGED before ingestion, as the decision cannot be reversed afterward. Object tag values are effectively limited to ASCII, with most CJK character strings being rejected — a behavior AWS Support has escalated to its service team as a potential defect. Additionally, the operator support is inconsistent, with GROUP BY and DISTINCT accepted but equality checks and ORDER BY rejected for FILE type columns.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in