Kettle gpload failed ERROR: permission denied: no privilege to create a readable gpfdist(s) external table

Question

When using kettle greenplum bulkloader and ERROR: permission denied: no privilege to create a readable gpfdist(s) external tableenter image description here

Please check [How to ask question](https://stackoverflow.com/help/asking) and format your question properly esp the code. — Morse, Apr 13 '18 at 02:40

score 1 · Accepted Answer · answered Apr 13 '18 at 17:28

1

The user running the program in the database needs to have CREATEEXTTABLE privileges. You can do this with: ALTER ROLE CREATEEXTTABLE (type='readable').

answered Apr 13 '18 at 17:28

user9142937

46
1

Kettle gpload failed ERROR: permission denied: no privilege to create a readable gpfdist(s) external table

1 Answers1