[Redshift] Can't query Redshift Spectrum

TeamSQL / desktop-app

This repository is currently being used for hosting the official issue & bug tracker of TeamSQL Desktop App.

102 stars 6 forks source link

[Redshift] Can't query Redshift Spectrum #433

Closed ponkon closed 5 years ago

ponkon commented 5 years ago

When I try to query a Redshift Spectrum table with TeamSQL I get:

[Amazon](500310) Invalid operation: schema "spectrum" does not exist;

However the same query works when I run it in psql.

I'm guessing this is because Redshift Spectrum tables are considered "External Schemas" and aren't created in the same way that regular redshift tables are, however they are supposed to be queried as if they're the same.

selcukayhan commented 5 years ago

Hi @ponkon,

I am able to create external tables, connect and execute scripts on Redshift Spectrum my scripts are below. Would you please send us details about your issue and your TeamSQL Client's version?

Thank you for reaching out us.

ponkon commented 5 years ago

You are 100% correct - my issue was I wasn't selecting the correct database in the upper right corner of the UI. Once I selected the database on which my spectrum schema was created on it worked perfectly.

Looking forward to using TeamSQL! Sorry you had to go through the debugging to find that everything did indeed work...