I have two datasets in Carto that I am trying to join. One is static of administrative areas (counties), and the other contains indicator scores calculated on a separate server. My API outputs the data in CSV format, and I have it added to Carto and synced every hour.
I joined the two tables using an UPDATE query, but I don't see any indication that the synced data will update in the static table when the real-time data syncs. Furthermore, I'm having a hard time testing it, as the scores will change incrementally over days/weeks, not quickly.
Does anyone know if a JOIN like I've done will ensure the administrative table updates when the synced table updates?
Sorry, I mistakenly put 'Editor' before. I'm using Carto Builder, the new UI.