do you see performance issue in the following sql query?
        CREATE VIEW [{self.schema}].[{self.view_name}] AS
        select 'Total Transactions' as Description, 
                count(*) as 'Total Count',
                CAST( GETDATE() AS Date ) as 'valid_date' from 
        (	select *, max([FILE_MOD_TS]) over (partition by [FILE_NAME]) as MAX_MOD_TS
            from raw.gwia_transaction_details
        ) gwia_transaction_details
        where gwia_transaction_details.FILE_MOD_TS=gwia_transaction_details.MAX_MOD_TS
        
        union
        select 'Total Agents' , count(*) as 'Total Count ',
                max(file_date) as 'Valid Date' from
        (	select	*, max([FILE_MOD_TS]) over (partition by [FILE_NAME]) as MAX_MOD_TS
            from raw.gwia_agent_details
            where agent_status in ('A','I')
            and file_date in (select max(FILE_DATE) from raw.gwia_agent_details)
        ) gwia_agent_details
        where gwia_agent_details.FILE_MOD_TS=gwia_agent_details.MAX_MOD_TS
        
        
        union
        select 'Total Investors', 
                count(*) as'Total Count', 
                max(FILE_DATE) as 'Valid Date' from 
        (	select *, max([FILE_MOD_TS]) over (partition by [FILE_NAME]) as MAX_MOD_TS
            from raw.gwia_investor_details
            where FILE_DATE in (select max(FILE_DATE) from raw.gwia_investor_details)
        ) gwia_investor_details
        where gwia_investor_details.FILE_MOD_TS=gwia_investor_details.MAX_MOD_TS