Dataset View

renee12345
renee12345 Member
edited March 2023 in Datasets

Can you schedule a view to run daily?

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Views aren't scheduled to run, they're run when they're accessed. They're not materialized / saved in an actual dataset. If you're looking to materialize the view and store the contents of the view on a daily basis you can use it as an input in a dataflow and just write out the contents to a dataflow dataset.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MichelleH
    MichelleH Coach
    Answer ✓

    I will also add that views are dependent on another actual dataset in your instance, which you can find in the Lineage tab of the view in the data center. If you just need cards powered by the view to refresh daily, you would need to manage that in via the schedule settings of the source dataset.

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Views aren't scheduled to run, they're run when they're accessed. They're not materialized / saved in an actual dataset. If you're looking to materialize the view and store the contents of the view on a daily basis you can use it as an input in a dataflow and just write out the contents to a dataflow dataset.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MichelleH
    MichelleH Coach
    Answer ✓

    I will also add that views are dependent on another actual dataset in your instance, which you can find in the Lineage tab of the view in the data center. If you just need cards powered by the view to refresh daily, you would need to manage that in via the schedule settings of the source dataset.

  • thank you for the quick responses.


    so, @MichelleH if a dataset is set to run at say 6 am, and runs successfully it will trigger the view to refresh?

  • @renee12345 Yes, that's correct!

  • great, thank you @MichelleH !