You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: