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:

Insights and Recommendations
Source Inventory Analysis
Lineage Report

Related Topics:

To export assessment reports, click Reports from the top right corner of the View Assessment page.

In the Reports section, you can see various types of reports such as Insights and Recommendations, Source Inventory Analysis, and Lineage Report. 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 source inventory, queries, column level lineage, and so on.

Here, you can see the EDW folder along with databricksrecommendation.csv, DML Assessment.xlsx and Lineage Dependency Report.xlsx reports.

databricksrecommendation.csv: This report contains Databricks-specific schema optimization recommendations such as clustering keys, tuning based on workloads, tuning based on table sizes, and more.

DML Assessment.xlsx: This report provides insights about the source inventory. It helps you plan the next frontier of a modern data platform methodically. It includes a report summary, schema recommendations, column level lineage, 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.
Column Level Lineage: Provides more granular column level details of the lineage. It displays information about the source and target schemas, tables, elements, 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.
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.
Procedures 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.
Schema Recommendation: Provides the schema recommendation details. It includes information about the tables, primary keys, unique keys, partition keys, partition by, cluster by, buckets, and a lot more.
Query Type Count: Provides the count of queries segregated by statement types.
Query Complexity Wise Query Count: Provides query complexity along with the number of queries that have the same query complexity values.
Query Analysis: Lists all the queries along with information about the input types, scripts, sub-processes, and a lot more.

Lineage Dependency Report.xlsx: This report contains information about views and script level lineages. It includes information about used and impacted tables, views, files, direct dependencies, dependency hierarchy and more.

This report contains the following information:

view_report: Provides information about the views.
script_report: Provides information about script level lineage.

Browse through the EDW folder access reports such as dead codes, analyzed queries, 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.

Browse through the dml folder to see the generated CSV reports, inventory sheet, and more.

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.