set-properties-from-csv.sql

-- Define file name, this is the instruments file on Drive

@@file_name = select 'example_instruments.csv';

-- Load data from Drive

@instruments_data =
use Drive.Csv with @@file_name
--file=/luminesce-examples/{@@file_name}
--addFileName
enduse;

@instProperties =
select 
ClientInternal as EntityId, 
'ClientInternal' as EntityIdType, 
'Instrument' as Domain,
"Ratings" as PropertyScope, 
RatingType as PropertyCode,
Rating as Value,
"Ratings" as EntityScope
from @instruments_data;

-- Upload the transformed data into LUSID

select *
from Lusid.Property.Writer
where ToWrite = @instProperties
limit 5;