QS 1: How to read a configuration table/file which contain basic properties of a nodes {ex: source and sink table names etc.} and use that output in the next nodes in FUSION pipeline.
tried to use the Remote Program Executor, with command as -
bq query --format csv 'select SOURCE_TABLE,TASK_ID,DELTA_DATE from FUSIONDATASET.TEST_CONFIG where RUN_STATUS=0'
Now how to use this output in the nest pipeline nodes,say the SOURCE_TABLE col, in the source bigQuery node's TABLE property