Redshift Spectrum and Looker

[xt84]

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;

[brecht]

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.

[xt84]

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