AGOL Hosted Views + Arcade Expressions - Are they 'Live'?

Question

Loving the ability to do spatially-based column calculations in Arcade where you can reference other hosted datasets.

We're looking to have a column in a parcel dataset that sums water consumption from points that fall within the parcels.  Easy enough to create and calculate that column w/ Arcade.

However, the water consumption data will be updated daily, so associated column in the parcel/polygon dataset would need to be 'live' - similar to a real view in a SQL Server database where the column is an expression that generates the value any time the view is accessed.

Basically I'm wondering if this is possible in the AGOL hosted environment - is the column value generated by the Arcade expression 'static' once it is run, or does it work like a true database view calculated field where it is 'live'?

We can do this outside of the AGOL/ESRI environment in a SQL Server database with SQL/Python but am curious and interested in using Arcade for this.

Also - I know this works as we need it in Arcade Pop-ups, however in our scenario there is no map needed, we are just looking to work with a dataset (using GeoEvent to consume/process it).

Thanks -

Allen

KellyGerrow · Accepted Answer

If you calculate a value using field calculator using Arcade the value will be static at the time that you calculate the field as the data is entered into a field. If you create an Arcade Expression and use it either in a pop-up or to symbolize the data, the value is calculated when the map is opened and viewed. This will be live depending on the data updates in hosted feature layer view.

-Kelly