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

Answer 1

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