Exception Handling for a missing table

[SwatiDham]

I have a loop running for a bunch of different sites to be concatenate data into a single table using snowflake sql

For one particular site there is an underlying table missing. I don't want to remove that site from the loop but have the loop skip and continue to concatenate the data.

Since the table is missing i get this error and the execution stops: 

The following error occurred: Invalid argument. (Connector error: ERROR [42S02] SQL compilation error: Object 'XXX' does not exist or not authorized.). 

I have tried to use seterrormode, fetch the count of rows but i am not able to handle this exception.

Any ideas?

[chriscammers]

One thing you could do is query snowflakes system catalog before you try to query the table.

I've done this with sql server and those queries are easy to find.

Best of luck