[CI/CD Improvements] Standardize and automate formatting for workflows

[mikealfare]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-snowflake functionality, rather than a Big Idea better suited to a discussion

Describe the feature

As a maintainer, I want to automate formatting checks, so that I can focus more on content in PRs and still maintain a code quality standard.

Acceptance Criteria

Beta Give feedback

1. A formatter runs as part of pre-commit, use the same one as dbt-postgres
2. A linter runs as part of pre-commit, use the same one as dbt-postgres
3. docs-issue, stale, and triage-labels are updated to use the naming standards below (other workflows will be updated as separate stories; these workflows require no other changes)

Style standards:

• Job ids, step ids, and variables are in kebab case
• Job names, step names, and description fields follow dbt docs standards (capitalize first word only)
• Extra descriptors should be avoided unless required for disambiguation, e.g.
  • version-number -> version
  • archive-name -> archive
• Workflow files use a four space tab
• Scripts (inline or separate files) use environment variables in env instead of inline substitution like ${{ inputs.value }}

[mikealfare]

This issue is consolidated into #1004.