Big Query - How to setup Analytical App

[Owlpet]

Hi all,

I'm looking to create an analytical app so I can enter a custom query into BigQuery through a Text Box, however haven't had much luck.

My code consist of an end_date which I need to update daily.

i.e. WITH start_date AS (SELECT "20190501"),end_date AS (SELECT "20201001")

Steps I took to test:

1. Select my project

2. Entered my custom query

3. Select Update Value - select inputCustomFilter

4. Checkbox Replace a specific string:

When I run the workflow and amend the code from Text Box to 20201026, I only receive results up to 20201001.

Any help would be greatly appreciated!

Thanks,

Peter

[joshuaburkhow]

Hey @Owlpet 

Can you send a screenshot of the action tool? 

[Owlpet]

Hi Joshua,

I realised I had an older version of BigQuery and recently updated it but still no luck.

Please see below for screenshot

Thanks,

Peter