Monday, 31 October 2022

Create/ Drop Triggers in Postgresql

SELECT 

    * 

FROM 

    information_schema.triggers

WHERE 

    trigger_schema = 'abc' 




SELECT 

    CONCAT('DROP TRIGGER IF EXISTS ',trigger_name,' ON ',trigger_schema,'.',event_object_table,';') AS sql

FROM 

    information_schema.triggers

WHERE 

    trigger_schema = 'abc' 

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

  • SQL Error : Multiple ResultSets were returned by the query
    Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
  • DATA MINING
    Data mining is the process of finding patterns from large data sets and analyzing data from different perspectives. It allows business use...