When working with Amazon SageMaker, API_Request in-database function outputs single column for prediction with data type VARCHAR(1024), along with output column. All input columns are outputted back.
If START_KEY_INDEX argument is used and key columns appear before the START_KEY_INDEX, those key columns are duplicated in the output.
Examples
Query: SELECT * FROM tapidb.API_Request(ON SELECT Col1, Key1, Key2 from Input .... USING START_KEY_INDEX('1') )
Output: Col1, Key1, Key2, Output
Query: SELECT * FROM tapidb.API_Request(ON SELECT Key1, Key2 FROM input .....) Output: Key1, Key2, Output