Pre-Commit Hook while utilizing Dataform GUI

[scott-cronson]

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 · Accepted solution]

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.

[scott-cronson]

Thank you for the reply @caryna - that is what I was afraid of. Glad to have confirmation and will explore an alternative workaround. I have voted on that feature request and will await further updates.