[Bug] manifest generation error

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Describe the issue

I am trying to install the ad reporting model package in fivetran and I have not been able to get it to run.
It runs fine in my local environment, but once I try to run it in fivetran I get the same error.

Details:
* dbt configuration passed all checks

- package: fivetran/ad_reporting
version: 1.7.0

dbt version:
1.6.6

Error:
The following dbt command:
```zsh
dbt compile
failed during the Manifest Generation process.

The failure details:

Exit code: 2

Output:

07:46:41 Running with dbt=1.6.6
07:46:42 Registered adapter: snowflake=1.6.4
07:46:42 Unable to do partial parsing because saved manifest not found. Starting full parse.
07:47:06 Encountered an error:
Parsing Error
Invalid metrics config given in FilePath(searched_path='models', relative_path='ad_reporting_metrics.yml', modification_time=1674507072.0, project_root='/tmp/dbt/project/dbt_packages/ad_reporting')

The following internal error occurred during the Manifest Generation process:

The 'manifest.json' artifact file not found after executing the command generating the manifest.

```
### Relevant error log or model output

_No response_

### Expected behavior

Deploy ad reporting model

### dbt Project configurations

```yml
name: 'ad_model'
version: '1.0.0'
config-version: 2

# This setting configures which "profile" dbt uses for this project.
profile: 'ad_model'

# These configurations specify where dbt should look for different types of files.
# The `model-paths` config, for example, states that models in this project can be
# found in the "models/" directory. You probably won't need to change these!
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]

clean-targets: # directories to be removed by `dbt clean`
- "target"
- "dbt_packages"

# Configuring models
# Full documentation: https://docs.getdbt.com/docs/configuring-models

# In this example config, we tell dbt to build all models in the example/
# directory as views. These settings can be overridden in the individual model
# files using the `{{ config(...) }}` macro.
models:
ad_model:
# Config indicated by + and applies to all files under models/example/
example:
+materialized: view
vars:
facebook_ads_schema: FACEBOOK_ADS
facebook_ads_database: FIVETRAN_DATABASE

google_ads_schema: GOOGLE_ADS
google_ads_database: FIVETRAN_DATABASE

microsoft_ads_schema: BINGADS
microsoft_ads_database: FIVETRAN_DATABASE

linkedin_ads_schema: LINKEDIN_ADS
linkedin_ads_database: FIVETRAN_DATABASE

twitter_ads_schema: TWITTER_ADS
twitter_ads_database: FIVETRAN_DATABASE

vars:
ad_reporting__amazon_ads_enabled: False # by default this is assumed to be True
ad_reporting__apple_search_ads_enabled: False # by default this is assumed to be True
ad_reporting__pinterest_ads_enabled: False # by default this is assumed to be True
ad_reporting__reddit_ads_enabled: False # by default this is assumed to be True
ad_reporting__snapchat_ads_enabled: False # by default this is assumed to be True
ad_reporting__tiktok_ads_enabled: False # by default this is assumed to be True
```
### Package versions

package: fivetran/ad_reporting
version: 1.7.0

### What database are you using dbt with?

snowflake

### dbt Version

1.6.6

### Additional Context

_No response_

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

- [ ] Yes.
- [ ] Yes, but I will need assistance and will schedule time during our [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance
- [X] No.