[BUG] dbt Fusion: Recommended `static_analysis` configs to resolve introspective query warning message

*Copied from [fivetran/dbt_asana #46](https://github.com/fivetran/dbt_asana/issues/46).*

### Is there an existing issue for this?

- [x] I have searched the existing issues

### Describe the Issue

We have seen in other [packages](https://github.com/fivetran/dbt_marketo/issues/48) that dbt Fusion users might get a warning message from package models that use [introspective queries](https://docs.getdbt.com/docs/fusion/new-concepts#rendering-introspective-queries) (ie `run_query()` or `dbt_utils.get_column_values()`)

### Relevant error log or model output

```
warning: dbt1000: Detected unsafe introspection which may lead to non-deterministic static analysis.
To suppress this warning, set static_analysis to 'unsafe' in the nodes' configuration.
Learn more: https://docs.getdbt.com/docs/fusion/new-concepts.
Nodes: 'model.marketo.marketo__calendar_spine' (execute), 'model.marketo.marketo__change_data_details' (execute), 'model.marketo.marketo__change_data_pivot' (execute), ...
```

### Expected behavior
No warnings

### Possible solution

As recommended by dbt Labs, Fusion users should add the following sort of configuration to their root project's `dbt_project.yml` for the models highlighted in the warning message.

```yml
models:
package_name:
model_path:
model_name:
+static_analysis: unsafe # Uses dbt Core rendering strategy to allow for introspective queries -- see https://docs.getdbt.com/docs/fusion/new-concepts for details
```

If a lot of folks are running into this warning, we should consider adding the configs to the package itself so that each individual doesn't need to add these them.

### dbt Project configurations
Any

### Package versions
Any

### What database are you using dbt with?
Any

### How are you running this dbt package?
dbt Fusion

### dbt Version
Latest

### Additional Context

_No response_

### Are you willing to open a PR to help address this issue?

- [ ] Yes.
- [ ] Yes, but I will need assistance.
- [ ] No.