Related resources:




Providing you are a LUSID user with sufficient access control permissions, you can write a Luminesce SQL query to enumerate through and find particular files stored in Drive, LUSID's file repository and manager.

Note: If you are the LUSID domain owner, you are automatically assigned the built-in lusid-administrator role, which has all the permissions necessary to use the providers in this article.

You can then read data from one or more of these files and assemble a table of results to analyse, or perhaps to perform further operations on such as upserting data into LUSID.

You can also write data to files in Drive, and perform writable operations on those files such as moving and deleting them.

To interact with Read from using the ... providerWrite to using the ... provider
Data in CSV and similarly-structured filesDrive.CsvDrive.SaveAs
Data in Excel filesDrive.Excel
Data in SQlite filesDrive.Sqlite
Data in XML filesDrive.Xml
Data in text filesDrive.RawText
Data in Apache Parquet filesDrive.Parquet
Find filesDrive.File 
Move, rename and delete files Drive.File.Operation