Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Catalog 'andes_ext' does not exist

0

Hi,

I am trying to ran a simplest query on tommy_asin_v2 table, at bumblebee I found that it it belongs to the andes_ext.searchdata catalog:

But when I ran: select * from andes_ext.searchdata.tommy_asin_v2 limit 100;

I got the following error: CATALOG_NOT_FOUND: line 1:15: Catalog 'andes_ext' does not exist

My Query Id: 15db55c0-9704-466c-b180-232c56c501da

Thank you and best regards,

dimasot

Topics
AnalyticsDatabase
Tags
Amazon RedshiftAmazon AthenaDatabase
Language
English

asked 3 years ago470 views

1 Answer
0

In order to run query in schema "xx.yy", please enclose the schema with double quotation marks. select * from “andes_ext.searchdata”.tommy_asin_v2 limit 100;

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content