Skip to the content
LeaplogicLeaplogic
  • Home
  • About Us
  • Contact
SIGN IN
  • Home
  • About Us
  • Contact

  • Getting Started
    • Before You Begin
    • Creating an Account
    • Logging into LeapLogic
    • Reset Password
    • Quick Tour of the Web Interface
    • LeapLogic in 15 minutes
      • Prerequisites
      • Step 1. Log into LeapLogic
      • Step 2. Create Assessment and Get Insights
      • Step 3. Create Transformation Pipeline and See Results
      • Step 4. Edit or Optimize the Transformed Code
      • Step 5: Complete the Transformation Lifecycle
  • Introduction to LeapLogic
    • Overview
    • High Level Architecture
    • Supported Legacy and Cloud Platforms
    • Key Features
  • Workload Assessment
    • Overview
    • Value Proposition
    • Creating Assessment
      • Prerequisites
      • Step 1. Provide Primary Inputs
        • Automation Coverage
      • Step 2. Add the Additional Inputs
        • Table Stat Extraction Steps
          • Teradata
          • Oracle
          • Netezza
      • Step 3. Update the Source Configuration
      • Step 4. Configure the Recommendation Settings
    • Assessment Listing
    • Understanding Insights and Recommendations
      • Volumetric Info
      • EDW
        • Oracle
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Vertica
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Snowflake
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Azure Synapse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Teradata
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Netezza
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Google Big Query
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Redshift
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • PostgreSQL
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Duck DB
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • ClickHouse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Exasol
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • DB2
          • Highlights
          • Analysis
          • Optimization
          • Recommendations
          • Lineage
          • Downloadable Reports
      • ETL
        • Informatica
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Ab Initio
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • DataStage
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Talend
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSIS
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Informatica BDM
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Oracle Data Integrator
          • Highlights
          • Analysis
          • Downloadable Reports
        • Pentaho
          • Highlights
          • Analysis
          • Downloadable Reports
        • Azure Data Factory
          • ARM Template
          • Highlights
          • Analysis
          • Downloadable Reports
        • Matillion
          • Highlights
          • Analysis
          • Downloadable Reports
        • SnapLogic
          • Highlights
          • Analysis
          • Downloadable Reports
      • Orchestration
        • AutoSys
          • Highlights
          • Analysis
          • Downloadable Reports
        • Control-M
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
      • BI
        • OBIEE
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Tableau
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • IBM Cognos
          • Highlights
          • Analysis
          • Downloadable Reports
        • MicroStrategy
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Power BI
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSRS
          • Highlights
          • Analysis
          • Downloadable Reports
        • SAP BO
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • WebFOCUS
          • Highlights
          • Analysis
          • Downloadable Reports
      • Analytics
        • SAS
          • Highlight
          • Analysis
          • Lineage
          • Downloadable Reports
        • Alteryx
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
      • Integrated Assessment (EDW, ETL, Orchestration, BI)
        • Highlights
        • Analysis
        • Optimization
        • Lineage
        • Recommendations
    • Managing Assessment Reports
      • Downloading Report
      • Input Report Utility
      • View Configuration
    • Complexity Calculation Logic
    • Key Benefits
    • Ad hoc Query
  • Metadata Management
    • Overview
    • Introduction to Data Catalog
      • Managing Data Catalog
        • Building Data Catalog
        • Insights to Data Catalog
        • Managing the Repository and Data Source
      • Creating Repository (Repo)
      • Creating Data Source
    • Tag Management
    • Key benefits
  • Batch Processing using Pipeline
    • Introduction
    • Designing Pipeline
      • How to create a pipeline
        • Configuring Migration Stage
          • Schema Optimization
        • Configuring Transformation Stage
          • On-premises to Cloud
          • Cloud-to-Cloud
          • LeapLogic Express
        • Configuring Validation Stage
          • Data Validation
            • Table
            • File
            • File and Table
            • Cell-by-cell validation
          • Query Validation
            • Query Validation (When Data is Available)
            • Query Validation (When Data is Not Available)
          • Schema Validation
        • Configuring Execution Stage
        • Configuring ETL Conversion Stage
          • Ab Initio
          • Informatica
          • Informatica BDM
          • Matillion
          • DataStage
          • SSIS
          • IICS
          • Talend
          • Oracle Data Integrator
          • Pentaho
          • SnapLogic
        • Configuring Mainframe Conversion Stage
          • Cobol
          • JCL
        • Configuring Orchestration Stage
          • AutoSys
          • Control-M
        • Configuring BI Conversion Stage
          • OBIEE to Power BI
          • OBIEE to AWS QuickSight
          • Tableau to Amazon QuickSight
          • Tableau to Power BI
          • Tableau to Superset
          • Tableau to Looker
          • IBM Cognos to Power BI
        • Configuring Analytics Conversion Stage
          • SAS
          • Alteryx
        • Configuring Script Conversion Stage
    • Key Features
      • How to schedule a pipeline
      • Configuring Parameters
  • Pipeline Reports
    • Overview of Pipeline Report
    • Pipeline Listing
    • Reports and Insights
      • Migration
      • Transformation
        • On-premises to Cloud
        • Cloud-to-Cloud
        • LeapLogic Express
      • Validation
        • Data
          • File
          • Table
          • File and Table
        • Query
          • Query Validation Report (When Data is Available)
          • Query Validation Report (When Data is not Available)
        • Schema
      • Execution
      • ETL
        • Ab Initio
        • Informatica
        • Informatica BDM
        • Matillion
        • DataStage
        • SSIS
        • IICS
        • Talend
        • Oracle Data Integrator
        • Pentaho
        • SnapLogic
      • Mainframe
        • Cobol
        • JCL
      • Orchestration
        • AutoSys
        • Control-M
      • BI
        • OBIEE to Power BI
        • OBIEE to Amazon QuickSight
        • Tableau to Amazon QuickSight
        • Tableau to Power BI
        • Tableau to Superset
        • Tableau to Looker
        • IBM Cognos to Power BI
      • Analytics
        • SAS
        • Alteryx
      • Shell Script
      • Common Model
    • Automation Level Indicator
      • ETL
        • Informatica
        • Matillion
        • DataStage
        • Informatica BDM
        • SnapLogic
        • IICS
        • Ab Initio
        • SSIS
        • Talend
        • Pentaho
      • Orchestration
        • AutoSys
        • Control-M
      • EDW
      • Analytics
        • SAS
        • Alteryx
      • BI
      • Shell Script
    • Error Specifications & Troubleshooting
  • SQL Transformation
    • Overview
    • Creating and Executing the Online Notebook
      • How to Create and Execute the Notebook
      • Supported Features
    • Configuring the Notebook
      • Transformation
      • Unit Level Validation
      • Script Level Validation
    • Notebook Listing
  • Operationalization
    • Overview
      • Basic
      • Advanced
      • Cron Expression
    • Parallel Run Pipeline Listing
  • Transformation Source
    • Introduction
    • Creating Transformation Source Type
  • Governance
    • Summary of Governance - Roles and Permissions
    • User Creation
      • Creating a new User Account
    • Adding Roles and permissions
      • How to add Roles and Permissions to a new user?
    • Adding Group Accounts
    • Default Quota Limits
    • Product Usage Metrics
  • License
    • EDW
    • ETL
  • LeapLogic Desktop Version
    • Overview
    • Registration and Installation
    • Getting Started
    • Creating Assessment
      • ETL
      • DML
      • Procedure
      • Analytics
      • Hadoop
    • Reports and Insights
      • Downloadable Reports
      • Reports for Estimation
    • Logging and Troubleshooting
    • Sample Scripts
    • Desktop vs. Web Version
    • Getting Help
  • LeapLogic (Version 4.8) Deployment
    • System Requirements
    • Prerequisites
    • Deployment
      • Extracting Package
      • Placing License Key
      • Executing Deployment Script
      • Accessing LeapLogic
    • Uploading License
    • Appendix
    • Getting Help
  • Removed Features
    • Configuring File Validation Stage
    • Variable Extractor Stage
      • Variable Extractor Report
    • Configuring Meta Diff Stage
      • Meta Diff
    • Configuring Data Load Stage
      • Data Load
    • Configuring Multi Algo Stage
  • FAQs
  • Tutorial Videos
  • Notice
Home   »  Workload Assessment   »  Understanding Insights and Recommendations   »  ETL  »  SnapLogic Assessment Report

SnapLogic Assessment Report

This topic contains information about the SnapLogic assessment report. The assessment assesses workloads and produces in-depth insights that help plan the migration. The input format for the SnapLogic assessment is SLP file format.

In This Topic:

  • Highlights
    • Summary
    • Pipeline Complexity
    • Queries
    • Query Complexity
  • Analysis
    • Files
    • Pipelines
    • Queries
    • Entities
    • Artifacts
  • Downloadable Reports
    • Insights and Recommendations
    • Source Inventory Analysis


Highlights

The highlights section gives you a high-level overview of your assessment summary of the analytics performed on the selected workloads. It includes an overview of queries as well as graphical depiction of the complexity of pipelines and queries.

Summary

This section provides an overview of input source files and the associated workload inventory including pipelines, components, queries, and more.

  • Files: Displays the number of source files.
  • Pipelines: Displays the number of pipelines existing in the source files. It is a data flow process to perform a specific task.
  • Components: Displays the number of components existing in the input source files. Components serve as functional building blocks in the pipeline to perform a task.
  • Queries: Displays the number of queries.
  • Entities: Displays the number of entities.
  • Missing Artifacts: Displays the number of missing artifacts.

Pipeline Complexity

This section provides a summarized graphical representation of pipeline complexity that helps in making different decisions, including budget estimation and the effort required for migration.

Queries

It displays a synopsis of analyzed queries along with information about unique, parsed, and unparsed queries.

  • Unique Queries: Displays the number of unique queries. In Unique Queries, duplicate queries are eliminated, and solitary queries are identified.
  • Parsed Queries: Displays the number of parsed queries.
  • Unparsed Queries: Displays the number of unparsed queries.

Query Complexity

This section provides a summarized graphical representation of the query complexity that helps in making different decisions, including budget estimation and the effort required for migration.


Analysis

This topic provides detailed information about source files, pipelines, queries, entities, and artifacts.

Files

This section provides a comprehensive report of the source files along with information about pipelines, transformations, procedures, and queries.

  • File Name: Displays the name of the file.
  • Pipelines: Displays the number of pipelines.
  • Transformations: Displays the number of transformations.
  • Procedures: Displays the number of procedures.
  • Queries: Displays the number of queries.

Pipelines

This section provides detailed information about pipelines, including their components, queries, complexity, and associated files.

  • Pipeline Name: Displays the name of the pipeline.
  • File Name: Displays the associated file name.
  • Components: Displays the number of components in each pipeline.
  • Queries: Displays the number of queries in each pipeline.
  • Complexity: Displays the pipeline complexity.

Browse through each pipeline to get more insights into the associated components.

  • Component Name: Displays the name of the component.
  • Types: Displays the type of the component.
  • Source Name: Displays the associated source component name of each component. Source components feed data to the next component in the pipeline. For example, if a pipeline contains components A, B, C, and D which follow a sequential pattern to perform a task. In this case, A serves as the initial source component which feeds data to component B, and for B, C acts as the destination component. Similarly, B serves as a source component for C, and so on. This data flow from one component to another facilitates efficient data processing and transformation in the pipeline.
  • Destination Name: Displays the associated destination component name of each component. The destination component receives data from upstream components in the pipeline.
  • Execution Mode: Displays the execution mode of each component. The execution mode includes:
    • Validate & Execute: Perform validation and execution on a specific component.
    • Execute Only: Perform only validation on the specific component.
    • Disabled: Disable or inactive the specific component in the pipeline.

Queries

This section provides detailed information about queries segregated into unique, analyzed, and not-analyzed queries.

Unique Queries

This section displays a list of all unique queries along with the total number of unique queries. In Unique Queries, duplicate queries are eliminated, and solitary queries are identified.

  • File Name: Displays the file name associated with the query.
  • Pipeline Name: Displays the name of the pipeline associated with the query.
  • Component Name: Displays the name of the component associated with the query.
  • Source Type: Displays the type of the source component associated with the query.
  • Query Type: Displays the query type.
  • Complexity: Displays the query complexity.

Analyzed

This section displays a list of all queries that meet the analysis criteria.

  • File Name: Displays the file name associated with the query.
  • Pipeline Name: Displays the name of the pipeline associated with the query.
  • Component Name: Displays the name of the component associated with the query.
  • Source Type: Displays the type of the source component associated with the query.
  • Query Type: Displays the query type.
  • Complexity: Displays the query complexity.

Not Analyzed

This section displays a list of all queries that did not meet the analysis criteria.

  • File Name: Displays the file name associated with the query.
  • Pipeline Name: Displays the name of the pipeline associated with the query.
  • Source Type: Displays the type of the source component associated with the query.
  • Query Type: Displays the query type.
  • Complexity: Displays the query complexity.

Entities

This section displays a detailed analysis of the entities. It includes information about connection types, databases, and the associated source files.

  • Entity Name: Displays the name of the entity.
  • Connection Type: Displays the type of connection that is used to connect to database.
  • Database Name: Displays the database name.
  • Database Type: Displays the type of database.
  • File Name: Displays the file name that is associated with the entity.

Artifacts

This section lists all the missing artifacts and external files within the entire inventory.

Missing Files

This section provides details of all the missing artifacts.

  • Artifact Name: Displays the name of the artifact.
  • Type: Displays the type of the artifact.

External Files

Lists all external files including information about the associated components, pipelines, and executable file paths.

  • File Name: Displays the file name.
  • Components: Displays the component associated with the file.
  • Pipeline Name: Displays the pipeline associated with the file.
  • Executable File Path: Displays the location of the external files such as batch files or command line files are located and executed.


Downloadable Reports

Downloadable reports allow you to export detailed SnapLogic assessment reports of your source data which enables you to gain in-depth insights with ease. To access these assessment reports, click Reports.

Types of Reports

In the Reports section, you can see various types of reports such as Insights and Recommendations, and Source Inventory Analysis. 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.

Snaplogic Assessment Report.xlsx: This report provides insights about the source inventory. It includes information about the source inventory, pipelines, and database summary.

This report contains the following information:

  • Report Summary: Provides information about all the generated artifacts.
  • Volumetric Info: Presents a summary of the aggregated inventory after analyzing the source files. For instance, it provides volumetric information about the total number of pipelines, transformations, components, pipeline complexity, query complexity, and so on.
  • Pipeline Summary: Lists all the pipelines associated with the input files. It also provides information about the total number of components, queries, transformations, complexity, and likewise.
  • DB Summary: Provides information about the input and output sources for each pipeline. It includes information about the total number of pipelines, transformations, sources, targets, and so on.

snaplogic_query_details.csv: This report provides information about queries including the used and impacted tables, analyzed status, complexity, and more. If the analyzed status is TRUE, it indicates that the query is analyzed successfully. Conversely, a FALSE status indicates that the query is not analyzed.

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 invalid_query.csv, Pipeline Detail Snaplogic.csv, Snaplogic Parse Component Detail.csv, Snaplogic Read Component Detail.csv, Snaplogic Write Component Detail.csv, and more.

invalid_query.csv: This report lists all the invalid queries.

Pipeline Detail Snaplogic.csv: This report provides information about pipelines including information about components, component types, and more.

Snaplogic Parse Component Detail.csv: This report provides information about parse components.

Snaplogic Read Component Detail.csv: This report provides information about read components.

Snaplogic Write Component Detail.csv: This report provides information about write components.


To learn more, contact our support team or write to: info@leaplogic.io

Copyright © 2025 Impetus Technologies Inc. All Rights Reserved

  • Terms of Use
  • Privacy Policy
  • License Agreement
To the top ↑ Up ↑