Is it possible to set the Rows As Arguments value to a macro?

14 views
Skip to first unread message

Aaron Gutierrez

unread,
Oct 25, 2022, 3:08:05 PM10/25/22
to cdap...@googlegroups.com
image.png

I want to take the Rows as Arguments value and set it to a ${some.macro.value} and use it in the URL in the HTTP object. Is this possible? 

Thanks!

Aaron

Vitalii Tymchyshyn

unread,
Oct 25, 2022, 4:14:10 PM10/25/22
to CDAP User
You can look into using Big Query Argument Setter: https://cdap.atlassian.net/wiki/spaces/DOCS/pages/721715749/Google+Cloud+BigQuery+Argument+Setter+Action

Best regards, Vitalii Tymchyshyn

Albert Shau

unread,
Oct 25, 2022, 7:23:40 PM10/25/22
to cdap...@googlegroups.com
Hi Aaron,

Along with the BigQuery Argument Setter plugin, the 'row as arguments' option for the BigQuery Execute plugin is exactly for the use case you described. Assuming your query returns a single row, arguments corresponding to each column will be set and can be referenced by the rest of your pipeline using macros. You can take a look at the 'documentation' tab of the plugin for an example.

Regards,
Albert

--
You received this message because you are subscribed to the Google Groups "CDAP User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cdap-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cdap-user/4160a024-f139-4473-9d94-dbe98fbb3d88n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages