Monday, 31 October 2022

Postgresql - To get the list of tables from a schema

 SELECT 

    table_name 

FROM 

    information_schema.tables 

WHERE 

    table_schema = 'abc'

AND 

    table_type = 'BASE TABLE'

No comments:

Snowflake - Cost Optimization

Reduce auto-suspend to 60 seconds Reduce virtual warehouse size Ensure minimum clusters are set to 1 Consolidate warehouses Separate warehou...