Hi @Aloknath_Ganage  - Thanks for the details and screenshots.

On doing some research, I believe the Analyzer itself is running correctly... that’s why you see the analyzer_output.tmp file with all the detailed metrics. The issue is likely in the second step, where Lakebridge takes that temp file and merges it into the Excel workbook. That merge step is currently failing, which is why the .xlsx file only shows the empty “Summary / SQL Programs / SQL Script Categories / UNKNOWN SQL Category” tabs with zeros, even though the .tmp file has data.

This is almost always caused by a local Lakebridge/Analyzer installation issue (version mismatch or corruption of the Excel writer/template), not by your input code or the source dialect.

To fix it, please:

• Make sure the Excel report isn’t open when you run the Analyzer and that the output folder is writable.
• Reinstall Lakebridge on that machine:
  

  bash

  databricks labs uninstall lakebridge
  databricks labs install lakebridge
  databricks labs lakebridge install-transpile   # if you’re also using the transpiler

• Re-run the Analyzer once with debug logging and a small test folder:

  bash

  
  databricks labs lakebridge analyze \
    --source-directory <path> \
    --report-file <path>\lakebridge_analysis.xlsx \
    --source-tech <SOURCE_TECH> \
    --debug

   

  After this run, the Excel should hopefully be populated again. If it still comes out empty, please share the tail of the --debug output and the new .tmp + .xlsx files so I can investigate or talk to our Lakebridge team.

   

  If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

  Regards,