Skip to content

[BUG]: Analyzer result not accurate with single script #1757

Open
@zincob

Description

@zincob

Is there an existing issue for this?

  • I have searched the existing issues

Category of Bug / Issue

Analyzer bug

Current Behavior

I've been using the Analyzer for SQL Server. Initially, when I generated SQL scripts directly from SSMS and ran the analyzer, the report only flagged procedures and functions as "very complex."

After using the BladeBridge SQL splitter functionality to break down the SQL scripts into multiple files, I re-ran the analyzer. The results were significantly different and, I believe, more accurate. The new report provided a more nuanced breakdown of procedure complexity, and it also included a Job Complexity categorization, which was missing before.

I created the PR to cover the missing documentation on SQL Server.
I would suggest that the SQL splitter functionality is included in both the documentation and the codebase for the Analyzer.

Expected Behavior

No response

Steps To Reproduce

No response

Relevant log output or Exception details

Sample Query

Operating System

macOS

Version

latest via Databricks CLI

Metadata

Metadata

Labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions