SQLMorph July 2021 Update

Our development team has been hard at work over the last few weeks working on our free-to-use transpiler, built to convert SQL statements from source to target.  While SQLMorph already contains over 19,000 lines of ANTLR SQL grammar in nine different dialects, we have been continuously evaluating new opportunities to expand the tool. Over the […]

SQLMorph – Free SQL Translator to Snowflake

The four phases of our free SQL translation tool, SQLMorph.

Every Computer Science student takes a course on compilers, but it’s rare that you get to build one yourself. Therefore the phData Internal Engineering team jumped at the chance to build a transpiler, a special type of compiler so that our customers and engineers can get out of the business of manual SQL Translation. The […]

SQLMorph June 2021 Update

Our development team has been hard at work over the last couple of weeks working on our free-to-use transpiler, built to convert SQL statements from source to target.  While SQLMorph already contains over 19,000 lines of ANTLR SQL grammar in nine different dialects, we have been continuously evaluating new opportunities to expand the tool. Over […]

phData Traverse: Snowflake Account Privileges, Explained

Navy Traverse logo

Traverse is an application built by phData to help users and administrators better understand roles and privileges in the Snowflake Data Cloud. Creating and auditing privileges in a data warehouse with many users is difficult. Access control for sensitive data needs to be carefully managed. Teams, users, and projects can have different access requirements for […]

SQLMorph May 2021 Update

A graphic showing 11 different technologies that use the SQLMorph dialect

Our free-to-use transpiler, built to convert SQL statements from source to target, has received a fairly large refactor over the last month. We frequently see the need to be able to use the SQL dialect grammars we have built internally in other use cases and technologies. Validating SQL can be a very complicated task due […]

SQLMorph April 2021 Update

For those new to SQLMorph, it is a free-to-use transpiler built to convert SQL statements from source to target. By using this tool either through the UI or published Python script, it allows you to quickly translate your existing SQL statements into their destination.  This lets you spend more time on complex topics such as […]

Intro to SQLMorph Series

Here at phData, we strive to build automation for mundane tasks whenever possible.  This allows us to focus on solving the more complex and challenging problems that our customers face. Over the years, we have built a few different tools (CloudFoundation, Tram, and PAMS to name a few) that increase productivity, security, and development/deployment of […]