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