Redshift Spectrum and Looker

  • 4 December 2017
  • 2 replies

Hi all!

Have you get error like this:

The Amazon Redshift database encountered an error while running this query.

ERROR: Failed to incorporate external table “schema”.“table_name” into local catalog.

I’m give grants on schema and tables to looker user, but nothing changes:

# grant usage on schema pipe to looker_user;

# grant select on all tables in schema schema to looker_user;

2 replies

Userlevel 4

Hi Evgeny,

Are you seeing the same error when you run a query from outside Looker? There’s this thread on the AWS Dev forum, which points to the auto-commit parameter on the connection, but might also be related to your current release of Redshift.

Hi Brecht,

yep, the same, when try to connect from PSQL like Looker user.

# select version();



PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.1499

(1 row)

It looks like they not fix it. It’s sad.

Thank you