Not Outsourcing My Mind - Scaling My Output
I’m having a ball being unleashed to just use AI to get my work done. Consider the following ability to get work done faster. It’s not about “code I don’t know how to write”, and it’s not “vibe coding”, mindless.
I’m in the final stages in revamping Snowflake RBAC (Roll Based Access Control). I have set up a yaml file (with the help of AI, of course) that defines what read only, read write, and full access roles should look like, and how they should be in a hierarchy.
Earlier I had written (with AI) code that automatically generates these database and schema roles scripts. Inception - a script to write scripts. And I’d generated the scripts. Then code to TEST these roles in Snowflake to ensure that they match the canon.
But, at this point, I had made improvements to the Canon roles, which means my script writing script and the scripts it wrote aren’t correct.
So I give the AI the canon,yaml file, and the script writer, and have it update the code to write the scripts correctly. It even found errors in the comments to correct with the new meanings.
Boom!
Then I generate a schema role script with the new code, and give the output back to the AI to test against the canon.
Now I can have the AI write a script to call the script generator to recreate all the existing scripts. Run them into my test environment in Snowflake. And then run the role testing code that AI and I built together to validate these roles. The tests, positive and negative, are logged in a table for review.
And if somebody goes into Snowflake and adds or removes privileges - the next time the test is run, it will be shown!
This doesn’t feel like AI coding for me. This feels like having a large staff of junior to mid developers that I can hand work too. Then I have to review their work.
AI isn’t replacing my mind - it’s scaling my output.