Open
Description
Custom Query example:
with data as (#(lf)select *#(lf)exclude (total_aum_1, total_aum_2)#(lf), total_aum_1 * 1000000 as total_aum_1#(lf), total_aum_2 * 1000000 as total_aum_2#(lf)from db.funds.evestment_equity#(lf) )#(lf) select *,#(lf) CASE WHEN as_of_date = (SELECT MAX(as_of_date) from data) #(lf) THEN 'Latest Date'#(lf) ELSE TO_CHAR(as_of_date::DATE)#(lf) END LATEST_DATE#(lf) from data
Ideally, this should also had been parsed with db, table and attributes names. Any input is appreciated.