Is it possible to query or extract the metadata/document properties from attachments in bulk? Previously I have been able to get around this by using the object IDs to bulk download the files and then use python to output the metadata to a .csv however I've only found that workable for smaller batches of files (<500) with consistent file types (such as all PDFs).
I have tried accessing the Attachments salesforce object through Power BI but it doesn't contain the file metadata and I've also tried writing a python script to access the objects via API (using the simple_salesforce library) and writing to a temporary file which has also not worked out.
Ideally I'd like to avoid bulk downloading files and just working with them in Salesforce (there are >250,000 attachment at this point that I need to analyse the metadata of) however open to any suggestions. I can arrange access to Data Loader (have not yet been set up at my org), or comfortable working on Einstein, SOQL, python or Power BI if any of these will be suitable.