As of now, Databricks does not support non-Spark methods (such as direct REST API calls, JDBC/ODBC connections outside Spark, or other query engines within Databricks) to query S3 Tables directly.
Unity Catalog and Databricks’ native cataloging focus primarily on Delta Lake tables and Spark SQL workloads. While Unity Catalog is evolving to support Iceberg via REST Catalog APIs, this is mostly to enable interoperability and external access rather than providing non-Spark query options inside Databricks.
Hope this helps, Lou.