Hi there,
I am wondering if it is possible to schedule updates to the datasource. I don’t mean refreshing data but I mean updating something within my SQL, this triggers an automatic full manual refresh. I would like to update the custom SQL query datasource and then for it to trigger on the next scheduled refresh. Is this possible?
Thanks,
Hi @JSharman
No, currently does not support automatically scheduling updates to the custom SQL query within a datasource to trigger on the next refresh. Custom SQL queries in SPICE or direct query datasources are static once defined, changes require manual edits via the UI or API, followed by a manual refresh or awaiting the next scheduled data refresh (which pulls data using the unchanged query).
Editing the custom SQL involves opening the dataset, selecting edit data set, modifying the SQL, and saving, but this does not integrate with scheduled data refreshes, it’s a separate action. For SPICE datasets, you can schedule full or incremental refreshes, but these execute the existing query without altering it.
Please refer to the below documentations this might be helpful for you.
Hi @JSharman,
Hope everything is well with you! Just checking back in since this thread hasn’t received a response in a while. Were you able to see Xclipse’s reply and/or find a workaround in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!
Thanks!