Skip to content
Home ยป redshift

redshift

How to check if an external table exists in Redshift

Sometimes you just want to know if a particular external table or schema exists in Amazon Redshift (Spectrum). This article outlines various alternatives to achieve that. First, if you’d like to list the tables that match your criteria, you can do that by querying SVV_EXTERNAL_TABLES. This table has some interesting…