- 6520 Views
- 2 replies
- 0 kudos
How do I search for all the columns/field names starting with "XYZ"
I would like to do a big search on all field/columns names that contain "XYZ".I tried below sql but it's giving me an error.SELECT table_name,column_nameFROM information_schema.columnsWHERE column_name like '%<account>%'order by table_name, column_na...
- 6520 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Ian Fox​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your ...
- 0 kudos
- 2899 Views
- 3 replies
- 3 kudos
Resolved! Importing MongoDB with field names containing spaces
I am currently using a Python notebook with a defined schema to import fairly unstructured documents in MongoDB. Some of these documents have spaces in their field names. I define the schema for the MongoDB PySpark connector like the following:Struct...
- 2899 Views
- 3 replies
- 3 kudos
- 3 kudos
Solution: It turns out the issue is not the schema reading in, but the fact that I am writing to Delta tables, which do not currently support spaces. So, I need to transform them prior to dumping. I've been following a pattern of reading in raw data,...
- 3 kudos