Hi,
Working on a project for a customer and I’m wondering what’s the best way to store XML/XSD file format in SingleStore.
A case study was done to capture and load Oil and Gas Well site information via WITSML in Snowflake. I was wondering if someone could point into the right direction on how to implement such solution. (Spark maybe?)
Would they be okay to store the data as JSON vs XML? one option is to use transforms to convert the XML to JSON and then query the data directly or use persistent computed columns on the JSON to provide fast analytics. Spark can also be used to transform the XML to JSON.
1 Like