Snowflake federated dataset refresh

 have created a Snowflake federated dataset with a Cache TTL of 900 seconds. I have some confusion about the following.

  1. When I add reload data to my base table in Snowflake, I expect the Federated dataset to run in real-time or after 900 secs. But I don't see my 'Last run' section getting updated on the Dataset Overview page. Is this expected? I don't see the run details in the history tab too.
  2. I observed the data gets refreshed in Domo and shows up in the data/preview section though

Can someone help me with

how often the data get updated in Domo and where do I see the history of the run in Domo?

Is there any restriction with operations I do I Snowflake for it to get updated in Domo? Ex, only inserts are captured or full refresh of the table is ignored.

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    @SameerSarnad , i don't know for sure, but i suspect Domo would not refresh the federated dataset unless someone asked for the data.


    so i i'm guessing you just need to interact with a card or dashboard in order to validate that the data is updated.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"