topic Translating XMLNAMESPACE in SQL Databricks in Get Started Discussions

Translating XMLNAMESPACE in SQL Databricks

TinaN — Tue, 06 Aug 2024 21:46:03 GMT

We are loading a data source that contains XML. I am translating their queries to create views in Databricks. They use 'XMLNAMESPACES' to construct/parse XML. Below is an example. What is best practice for translating 'XMLNAMESPACES' in Databricks?

CREATE OR REPLACE VIEW source_vw
AS WITH XMLNAMESPACES('uuid:ee2fbfd9-47a5-4dc8-a9eb-42d9995802ab' as REM)
SELECT...

Re: Translating XMLNAMESPACE in SQL Databricks

Retired_mod — Thu, 08 Aug 2024 15:41:20 GMT

Hi @TinaN, To handle XMLNAMESPACES in Databricks, use the from_xml function for parsing XML data, where you can define namespaces within your parsing logic. Start by reading the XML data using spark.read.format("xml"), then apply the from_xml function, specifying the necessary namespaces. This allows you to effectively translate SQL queries involving XML namespaces into Databricks code. If you have any specific details or additional requirements, feel free to share them!

Re: Translating XMLNAMESPACE in SQL Databricks

TinaN — Thu, 08 Aug 2024 20:18:42 GMT

Hello Kaniz_Fatma,

Thanks for the quick response. We are experimenting with from_xml to parse the data. I appreciate your input.

Best,

Tina