What is the recommended way to indicate Primary Key in Redshift using dbt? The documentation on it seems lacking in this regard.

The problem I’m having

Indicating Primary Key in Redshift using dbt

The context of why I’m trying to do this

I want to inform BI tools and Data Catalog, the Primary Key of a table

What I’ve already tried

I tried a version of post-hook solution suggested here in this post