How do I use a parameter in a custom postgres query?

user053351 · August 2020

select * from table where the_date > ?

How do I use the parameter function on postgres? Thanks!

jaeW_at_Onyx · August 2020

Sorry your question doesn't make sense to me.

What's the parameter value?

ETL pipelines in Domo are expected to run without user input ... so where do you want to get the parameter value from?

Either way, you can use a webform or any other datasource to pass 'parameters' into your data flow.

user053351 · August 2020

How do I reference the webform field in the query? There is no documentation.

jaeW_at_Onyx · August 2020

@user053351 you can pull in a webform as a dataset.

From there you could cross apply the webform to your input datasets, or JOIN as necessary.

user053351 · August 2020

So what is the point of this?

jaeW_at_Onyx · August 2020

sorry ... i might be missing context.

what are you trying to build and where are you trying to build it? (your screenshot was incomplete.)

user053351 · August 2020

I just want an example of how this is to be used.

What is a query parameter for? How is it used?

Comments