Skip to content
Home ยป AWS

AWS

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… 

Solve “Error parsing parameter … : Expected: ‘=’, received: ‘EOF’ for input:” in AWS CLI

The following error might occur when you would like to pass the contents of a file to an AWS CLI command. Amazon web services has very strict rules regarding referring to file contents. When you refer to the content of a file you need to use the file:// protocol. The…