Building Cross Platform Lineage


Building Cross
Platform Lineage


With BlackDiamond Studio, get dependencies across multiple languages and sources

Get Started

Dependency Analysis Across Code and Data Objects

With the unveiling of BlackDiamond Studio, Mobilize.Net is also releasing a preview of something much bigger to come. This preview is centered around object inventory and dependency analyses for any code you may have in a single repository or across multiple repos. 

How does it all work?

The code present in your repository in BlackDiamond Studio can be scanned by BlackDiamond Studio's Code Analyzer. This builds some basic reporting on your codebase across multiple languages including an inventory of all code objects (scripts, procedures, and functions among others) and database objects (including tables, views, roles, and others).

This reporting also includes all the dependencies present between the above mentioned code and database objects. Looking to understanding the upstream and downstream dependencies of a single procedures? Easily done. How about all of the procedures present in a database or even an entire Snowflake account? Just as easily done.

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. 

But why might this be valuable for me?

Most dependency analysis tools that exist scan the metadata created by your data platform and report to you on your data objects (things like "View X was created from Table Y"). This gives you a sense of the dependent relationships present among your tables and views, but what about other objects? In most data platforms, there will exist a wide variety of objects beyond tables and views such as procedures and functions. This extends even to platform specific objects (for example, in Snowflake you may have a stage, file format, session policy, role, and a host of others). How do you get an idea of the dependent relationships present in your procedural code? 

With BlackDiamond Studio, that's how. The dependency analysis capabilities of BlackDiamond Studio are not limited to tables and views. By utilizing our secret sauce of "code understanding" that can scan, analyze, and build semantic models of a variety of code languages, you can see what tables and functions a procedure may be dependent on. You can see all of the views that call a specific function. You can see how a unique script written in Python or another language depends on certain objects in your database and vice versa (what objects depend on proprietary scripts to be run). For the first time, you can get a real sense of how any code you have touches your database with BlackDiamond Studio.

 

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.

Crossing Platforms and Languages

Since BlackDiamond Studio puts your dependency analysis together from your source code not your data platform, you can have multiple languages sitting in a single code repository (or across multiple code repos) with a semantic model being built for all of them together. So... what languages are supported now? The following languages can be scanned by Mobilize.Net's code analyzers in BlackDiamond Studio right now:

  • 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 just the first level. There's so much more to come with the launch of BlackDiamond Insights in the near future. Stay tuned.

SnowConvert-Migration

New call-to-action

Mobilize.Net Migrations Testimonials

Mobilize.Net offers valuable technology and services that help customers easily modernize their legacy applications for use on today’s modern platforms and devices program at Microsoft.

- Shawn Nandi, Sr Director, Cloud App Development, Data & AI Marketing

Mobilize.Net has a strong track record of building products that successfully automate challenging source code migrations, and this partnership will empower our customers with the technology to get up and running on Snowflake sooner.

- Chris Degnan, CRO, Snowflake

By using Mobilize.Net’s proven conversion tools and staff, we are able to do this much faster than a manual conversion. This is not simply a move of NextGen to a remote server, but a true conversion to a cloud environment.

- Bruce Collier, President, Local Government Corporation