Table had no Fields associated with it


#1

Hi There,

I am running into this error on Metabase when querying for a table in Amazon Redshift.

Table 'adt_demographics' has no Fields associated with it.

My connection details are setup with a view only user using these settings:

ALTER GROUP ro_group ADD USER metabase_viewer;

GRANT USAGE ON SCHEMA stg TO GROUP ro_group;

GRANT SELECT ON ALL TABLES IN SCHEMA stg TO GROUP ro_group;

ALTER DEFAULT PRIVILEGES IN SCHEMA stg GRANT SELECT ON TABLES TO GROUP ro_group;

REVOKE CREATE ON SCHEMA stg FROM GROUP ro_group;

Any tips or tricks with this one. I am running the latest version of Metabase


#2

One of these should help. Also, don’t forget to include version, OS etc.

https://discourse.metabase.com/search?q=table%20has%20no%20fields%20associated


#3

I have looked through those post already and they do not seem to be helping. Because most of them are using the latest version of Metabase.

Also I am using Metabase 0.32.4 and I have it setup on Amazon Elastic Beanstalk


#4

Hi @jay.jain
Are you using views on Redshift? Then you’re probably seeing issue #6505
Otherwise have a look at some of the other issues - if you want one that seems to be exactly the same as your problem, then click the :+1: on the first post and click the Subscribe-button to get notifications, when anything happens:
https://github.com/metabase/metabase/issues?q=is%3Aissue+“has+no+Fields+associated+with+it”


#5

Hey,

I am not using views. I am trying to query the table themselves.