Solved: Pre-Commit Hook while utilizing Dataform GUI - Page 2

scott-cronson · 12-06-2024 07:33 AM

We are attempting to implement more standardized SQL Formatting across our Dataform repositories. Most of our utilization of Dataform is through the browser GUI rather than local development/Dataform API.

The standard SQL formatting provided does not match the rules we would like to implement. I see that the only way to accomplish is with an External Formatter (we intend to use SQLFluff).

Is it possible to plug into the commit procedure or "Push to remote branch" button in the GUI - in a manner similar to a pre-commit hook? Or is this only possible through local development and custom CI/CD pipelines?

caryna

Hi @scott-cronson,

Welcome to Google Cloud Community!

It looks like this is not yet directly supported in Dataform GUI. However, you can check this related feature request about customisation of sql formatter in Dataform. The request is still under review and at this time, I cannot specify when this enhancement will be implemented. For future updates, I recommend monitoring the tracker and release notes regularly.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

View solution in original post