# dbt mysql/maria-db does not read schema.yml file

**URL:** <https://discourse.getdbt.com/t/dbt-mysql-maria-db-does-not-read-schema-yml-file/17841>\
**Category:** Help\
**Tags:** dbt-core\
**Created:** [January 23, 2025, 1:32pm UTC](https://discourse.getdbt.com/t/dbt-mysql-maria-db-does-not-read-schema-yml-file/17841 "2025-01-23T13:32:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![maazconnox](https://avatars.discourse-cdn.com/v4/letter/m/65b543/32.png) [@maazconnox](https://discourse.getdbt.com/u/maazconnox)\
**Post date:** [January 23, 2025, 1:32pm UTC](https://discourse.getdbt.com/t/dbt-mysql-maria-db-does-not-read-schema-yml-file/17841/1 "2025-01-23T13:32:10Z")

</div>

## The problem I’m having

We have a dbt project which runs on Mariadb (v 10.11.10). We define a Schema.yml file which we use to generate PRIMARY KEYs (PKs). The Schema.yml file itself is quite large (6k lines approx.) and after a while, when I run “dbt run” it just does not consider anything in the Schema.yml file.

This does not happen when I run the model in isolation “dbt run -s model\_name”.

## The context of why I’m trying to do this

We require PKs for performance reasons.

## What I’ve already tried

I’ve tried breaking up the Schema.yml file into two files. In this case, dbt run read only one of the files and skipped the other.

## Some example code or error messages

No code but not sure if someone else has experienced this before.