sgoley

> ```shell > /Library/bin:$CONDA1/Scripts > ``` @fredngo you have a little misspelling here! Took me a minute to track it down but I did!

+1 for this! Was trying to look at the possibility of doing something like the "Drizly" workflow described [here](https://github.com/sqlfluff/sqlfluff-github-actions/tree/main/menu_of_workflows/drizly) of getting all the sqlfmt changes as annotations to be accepted...

Came up with this as a basic workflow action to run the entire models directory on each run. Working on a variation of this for changed files only. And dont...

@tconbeer here's what I ended up doing since Emily Hawkins rightly pointed out from drizly that there can be a lot of edge cases: https://gist.github.com/sgoley/af3e1f857251786afb1d739ada2e2a03 I actually had to fork...

And the reason we did the loop like this: ``` run: | for changed_file in ${{ steps.get_files_to_lint.outputs.lintees }}; do echo "formatting ${changed_file}" sqlfmt ${changed_file} || continue done ``` was because...

Recommending to @nickcatal to close this and document this as the correct answer for assigning a null value to a field with an update operation.

Alternative might be to build something like this as a whole separate UDF: ``` -- extract all key value pairs as an array from a json dict -- input: json...