Be Good. Do Good.
SELECT TABLENAME,INDEXNAME,INDEXDEF FROM PG_INDEXES
WHERE SCHEMANAME = 'mydatabase' ORDER BY TABLENAME,INDEXNAME;
Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...