Thursday, 27 May 2021

Postgresql: Get all tables count from DB

 SELECT schemaname,relname,n_live_tup 

  FROM pg_stat_user_tables 

  ORDER BY n_live_tup DESC;

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...