search

dbeatty10 / dbt-mysql

dbt-mysql contains all of the code enabling dbt to work with MySQL and MariaDB
Apache License 2.0
75 stars 53 forks source link

Add `indexes` field to the materialization config #156

Closed kenkoooo closed 11 months ago

kenkoooo commented 11 months ago

Describe the feature

To improve performance, dbt-postgres uses indexes to create indexes for tables and views it generates: https://docs.getdbt.com/reference/resource-configs/postgres-configs#indexes

I would also like to use that feature in MySQL.

Describe alternatives you've considered

I can manually run 'CREATE INDEX,' but I believe it will add complexity to the models.

Additional context

None.

Who will this benefit?

This feature will be useful when you want to optimize the performance of the generated tables.

Are you interested in contributing this feature?

Let me try writing some code to implement this feature.

kenkoooo commented 11 months ago

I've encountered more complexity than I initially anticipated, and I've decided not to proceed with the implementation. I'll go ahead and close this issue. Thank you.