Question

Redshift Spectrum and Looker

  • 4 December 2017
  • 2 replies
  • 523 views

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
Badge

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();
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

Reply