| 摘要 |
Disclosed are methods and systems for updating a report with real-time data. The method and systems involve receiving a request to view both historic data and real-time data in the report, identifying one or more data objects associated with the request, identifying one or more ETL jobs associated with the identified one or more data objects, determining a delta ETL job associated with the identified one or more ETL jobs and a upload timestamp of a delta ETL job, generating a data warehouse query based on the upload timestamp of the delta ETL job, generating a real-time query based on the transformations in the one or more ETL jobs and the upload timestamp of the delta ETL job, executing queries of the data warehouse query and real-time query to obtain historic data and real-time data and updating the report with both real-time data and historic data. |
