Item table not showing through netsuite2.com Suiteanalytics Connect

Trying to synchronize  BigQuery to Netsuite via the SuiteAnalytics Connect service, using the netsuite2.com  data source.

However, the items table does not present itself as a source table which I can access.

I have access to many other tables, transaction, transaction_lines etc. – just not the items table.

Any suggestions as to why?

 

Item table not showing through netsuite2.com Suiteanalytics Connect

Add Comment
4 Answer(s)

What role are you using to access the service?

Intermediate Answered on May 17, 2022.
Add Comment

Thank you,

I’m using the ‘Data Warehouse Integrator’ role.

Rookie Answered on May 17, 2022.
Add Comment

Actually, how come it says FivetranRole in the list?

Intermediate Answered on May 17, 2022.
Add Comment

It transpires there was a ‘rogue’ global permission entry for the employee, who holds the Data Warehouse Integrator role, which was preventing access to the Items table,

Employee->Access->Global Permissions->Items:None

This global permission has been removed, and access to the Items list is now available through the SuiteAnalytics Connect.

Thanks for your assistance.

 

Nigel.

Rookie Answered on May 17, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor