Raise Warning when Table and Column Names are Equal in Snowflake Join

App Development
1

Occasionally users submit a query where the table and column names are equal in the join condition. This can lead to fan-outs.

Example

select
    table_a.*
from table_a
left outer join table_b
    on table_a.col_1 = table_a.col_1

Exception handling seems to be only available for Snowflake Scripting

Is there a programatic way to raise a warning when this happens?

4

Hi @veerahkr
Welcome to the community :wave: and thanks for being patient.

Can you share further details about the setup? Unfortunately, I am not able to see how your app/integration interacts with Pipedrive and how the issue originates as a result of that.