Translating XMLNAMESPACE in SQL Databricks

[TinaN]

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...

[TinaN · Accepted solution]

Hello Kaniz_Fatma,

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

Best,

Tina