Is Snapshot data Configurable in Dataverse to Azure Synapse Link ?

Panguluri, Keerthi 1 Reputation point
2022-09-28T13:53:19.823+00:00

1) We would like to check ,if snapshot timings are configurable in Synapse Workspace like 15 mins or 30mins ,currently it is hourly .
2) Currently snapshot is created exactly at HR:00 time ,eg : 1:00 P.M and next 2:00 P.M , are there any options ,wherein we could configure this snapshot process at different time HR:45 time 12:45 P.M and Next 1:45 .

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,187 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2022-09-29T21:27:17.557+00:00

    Hello @Panguluri, Keerthi ,

    Thanks for the question and using MS Q&A platform.

    It is fixed and not user configurable. I have also confirmed with Dataverse product team. Below documents states it is hourly interval.
    Ref doc: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-synapse#access-near-real-time-data-and-read-only-snapshot-data

    246261-image.png

    If you want to have specified time interval, product team recommend using incremental folder update feature (Query and analyze the incremental updates - Power Apps | Microsoft Learn) so user can enter the time interval (in minutes) for how often the incremental updates should be captured (minimum value is 15mins)

    246291-image.png

    Please note that Snapshot data is in public preview. If you have any additional feedback related product improvements, feel free to share your ideas here:
    Dataverse: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas
    Azure Synapse Analytics: https://feedback.azure.com/d365community/forum/9b9ba8e4-0825-ec11-b6e6-000d3a4f07b8

    All the feedback shared in these forums are actively monitored and reviewed by respective product owners. Please do share the URL once you submitted the feedback so that I can pass it on to product team for further review.

    Hope this info helps.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  2. Panguluri, Keerthi 1 Reputation point
    2022-10-14T08:57:06.14+00:00

    Hi @KranthiPakala-MSFT seems the above is happening for our snapshot timings, we have different snapshot times on UAT and prod
    on uat is at 12:24 and 1:24 whereas,
    prod it is on 12:58 and then 1:58 . But isn't it difficult if we need to configure jobs based on the snapshot timings

    Another question on snapshot - We are seeing that few tables have snapshot created and few or not, this is also differing env -to-env, is this expected?
    For e.g., we have a table called account and account_partitioned(snapshot table for account) on UAT, but on prod we are seeing only single table account, now this table is frequently updated at regular intervals, but the snapshot is not available on production, any particular setting on properties that we need to enable for partition data.

    Please advise.

    0 comments No comments

  3. Panguluri, Keerthi 1 Reputation point
    2023-01-23T06:58:58.82+00:00

    Hi @KranthiPakala-MSFT ,

    We are currently unable to enable the Incremental update on powerapps (also tried earlier way of setting preview mode)

    image

    Any idea on why this is happening ?? anything relating to permission.
    Please advise

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.