SQLMorph October 2021 Update

Welcome to another installment of our monthly SQLMorph update!  SQLMorph, part of a set of tools that phData provides for customers, is a free-to-use transpiler built to convert SQL statements from source to target.  This empowers our customers to migrate faster between SQL platforms. We’ve touched many times on the complexity that SQLMorph aims to […]

SQLMorph September 2021 Update

Whether you’re new to phData, SQLMorph, or this blog series, we’ve got a lot in store for you today!  Welcome once again to our monthly update on SQLMorph, our free-to-use transpiler built to convert SQL statements from source to target. You may be new and wondering, “What is this series all about?  Why should I […]

SQLMorph August 2021 Update

Welcome back to our monthly update on SQLMorph, our free-to-use transpiler built to convert SQL statements from source to target.  Whether you’re new to the series or a long-time subscriber, we’ve got you covered!  We aim to give you updates not only on the latest and greatest functionality but also to clue you in on […]

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 […]