Question

Redshift Spectrum and Looker

  • 4 December 2017
  • 2 replies
  • 552 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