Cross-Language Code Understanding

Code Understanding. What does that actually mean? For us here at Mobilize.Net, delivering understanding means more than code analysis. Code Understanding is understanding the state of your codebase and the opportunities present for optimization, performance improvements, and workflow enhancements. This means understanding your codebase's semantics plus the context of your code's place and purpose in your data platform. Understanding how your codebase interacts with your database is one of the foundational pillars of BlackDiamond.

Currently, BlackDiamond Studio has the ability to produce an object inventory and a dependency analysis for any code targeted at Snowflake. You can try it out today by signing up for a free account with BlackDiamond Studio, and reviewing our documentation on the extended metadata analysis features available. 

Dependency graph between procedural code (in this example, written in JavaScript embedded as a Snowflake procedure) represented by green triangles, data objects (in this example, tables) represented as blue squares, and the database where those objects reside represented by red circles.

Multiple Languages Supported

What languages are supported now? Another great question:

• Snowflake SQL
• JavaScript procedures embedded in Snowflake SQL
• Teradata SQL and BTEQ
• Oracle SQL and PL/SQL
• SQL Server SQL and TSQL
• Spark Scala and Snowpark Scala

This is only the beginning of the kind of exploration that Mobilize.Net can provide when it comes to code understanding and analysis. There is plenty more to come, so stay tuned.