Friday, 9 September 2022

Postgresql - List all tables

SELECT 

    TABLE_NAME 

FROM INFORMATION_SCHEMA.TABLES 

WHERE 

    TABLE_SCHEMA = 'mydatabase' 

    AND 

    TABLE_TYPE = 'BASE TABLE' 

ORDER BY TABLE_NAME

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 ...