KB486172: "Catalog 'xx' does not exist" error occurs when importing data from an Amazon Athena schema

Steps to Reproduce

• Import data from an Amazon Athena schema, such as xx.yy.
   
  

• A "Catalog 'xx' does not exist." error occurs. 
   
  

What is this happening?

Strategy uses the catalog SQL, 

show tables in #?SCHEMA_NAME?#,

select table_name as TAB_NAME FROM information_schema.tables where table_schema='#?SCHEMA_NAME?#' 

Solution

The solution varies depending on whether you are using the new data import experience or the previous import.
 

1. New Data Import Experience
2. Previous Data Import

New Data Import Experience

• Right-click on the data source's name and choose Edit Catalog Options.
   
  

• Click the existing Property Value for Retrieve tables.
   
  

• Copy and paste the following text into the text box and click Set to....
  

  
  select table_name as TAB_NAME FROM information_schema.tables where table_schema='#?SCHEMA_NAME?#'

  
  

• Click Done.
  

Previous Data Import

• Click the drop down arrow next to the data source and choose Edit Catalog Options.
   
  

• Deselect Use default value for retrieving tables.
   
  

• Add the following text to the text box, replacing the default value.
  

  
  select table_name as TAB_NAME FROM information_schema.tables where table_schema='#?SCHEMA_NAME?#'

  
  
• Click Apply and OK.
  

Reference:
How to show tables in schema like "xx.yy"