Downloadable Reports
Downloadable reports allow you to export detailed assessment reports of your source data which enables you to gain in-depth insights with ease.
In This Topic:
To export assessment reports, click Reports.
In the Reports section, you can see various types of reports such as Insights and Recommendations, Source Inventory Analysis, and Lineage Reports. Each report type offers detailed information allowing you to explore your assessment results.
Insights and Recommendations
This report provides an in-depth insight into the source input files. It contains the final output including the details of dead codes, analyzed queries, complexity, Query Log DML Mapping, Dependency Records, and so on.
Assessment Dead Code File.xlsx: This report contains information about the dead codes i.e., completely unused codes.
This report contains the following information:
- Report Summary: Provides information about all the generated artifacts.
- Dead Code File: Lists all the existing dead code files. It includes the number of mapped and unmapped queries as well as the low, medium, and high complexity counts. Dead codes are queries that are available in DML scripts but do not have any footprint in query execution logs.
Assessment Analysis Analyzed Queries.xlsx: This report contains information about analyzed queries.
This report contains the following information:
- Report Summary: Provides information about all the generated artifacts.
- Analyzed Queries: Lists all the queries along with information about the time required to execute, I/O and CPU utilization ratios, the status of the query analysis and so on.
Assessment Query Log Dml Mapping.xlsx: This report provides information about DML and execution log mappings.
This report contains the following information:
- Report Summary: Provides information about all the generated artifacts.
- Query Log DML Mapping: Provides the count of mapped and unmapped queries in the file. It also includes information about the time required to execute, I/O and CPU utilization ratios, complexities, and so on.
Assessment Dependency Records.xlsx: This report provides information about dependency details of tables in the source files.
This report contains the following information:
- Report Summary: Provides information about all the generated artifacts.
- Assessment Dependency Records: Displays dependency details of tables in the source files. It provides information about impacted tables, previously used tables, parent files, and so on.
Source Inventory Analysis
It is an intermediate report which helps to debug failures or calculate the final report. It includes all the generated CSV reports (such as entities, macros, queries, schema, etc.), analysis report, inventory sheet, and more.
Analysis Report.xlsx: Provides a detailed analysis report of the source inventory including column lineage, schema recommendations, missing DDLs, queries, procedures, and more.
This report contains the following information:
- Report Summary: Provides information about all the generated artifacts.
- Volumetric Info: Lists an aggregated inventory of every source input file. For instance, it provides information about the total number of DML and DDL scripts, entities, queries, procedures, lines of code, and a lot more.
- Element Metadata Collection: Provides metadata details. It includes information about the source and target data storage, source and target data elements, element types, and a lot more.
- Column Flow: Provides information about the source and target data storage schema code, source and target data containers, source and target data element codes and a lot more.
- Schema Recommendation: Provides the schema recommendation details. It includes information about the table names, primary keys, unique keys, partition keys, partition by, cluster by, buckets, and a lot more.
- Column Level Lineage: Provides more granular column level details of the lineage. It displays information about the schemas, source and target tables, source and target elements, source and target element data types, and so on.
- Missing DDLs: Lists all the missing entities in the DDL files.
- Query List: Lists all the queries in the source files along with the complexity.
- Query Type Count: Lists all the queries segregated by statement types along with the count.
- Source Inventory: Provides detailed information about the source files. It lists all the files along with information about the components, component types, usages, and so on.
- Query Complexity Wise Query Count: Provides query complexity along with the number of queries that have the same query complexity values.
- Procedure List: Lists all the procedures existing in the source files along with the total number of queries and count of queries segregated by statement types such as CREATE, INSERT, DELETE, DROP, and so on.
- Query Analysis: Lists all the queries along with the input types, script names, and sub-process names.
Inventory Sheet.xlsx: This report provides information about tables, scripts, unparsed queries, and unresolved properties.
This report contains the following information:
- Report Summary: Provides information about all the generated artifacts.
- Table Details: Lists all the tables existing in the source files. It also includes information about usages, table types, unresolved table names, and so on.
- Script Details: Lists all the scripts along with information about the components, usages, and component types.
- Unparsed Queries Details: Lists all queries that could not be parsed.
- Unresolved Property: The source DML files contains properties that hold key-value information. The key represents the property name, and the value represents the associated data. In some cases, the system encounters multiple values for a property name and fails to resolve it. Those unresolved properties are listed here.
Lineage Report
This report provides complete dependency details for all nodes. It provides an end-to-end data and process lineage that helps to identify the complete dependency structure and the data flow.
This report contains the following information:
- Dependency (Process): Provides information about the process lineage.
- Dependency (Data): Provides information about the data lineage.
- Nodes: Lists all the source and target nodes along with its type.
- Volumetric Info (Summary): Provides volumetric information about the artifact types such as workflows, input tables, output tables, and schedulers.
Leaplogic