Have you received the dreaded Authorization error with Smart Data Integration?
 column store error: task framework:  Insufficient privilege. Access denied. .hdbflowgraph SAP HANA Activation Problem
It is documented, but who reads the manual?
In case you need the link it is here – Page 25 in the SPS10 guide.
To use Smart Data Integration in SAP HANA SPS09 the following are required
USER permissions / roles
_SYS_REPO permissions / roles
For the Schema where the Objects are generated, _SYS_REPO requires
I was also using a procedure which then requires additional permissions for the schema that holds the Procedure and the Procedure Table Type.
Show Authoizations and you should get an indication of other areas to investigate.
Thanks must go to my colleague and SAP HANA guru Guneet Wadhwa for exploring the intricacies of SDI and Authoizations with me.