Restoring synapselink parquet files

Jani Hämäläinen 105 Reputation points
2025-03-13T07:44:51.5533333+00:00

Hi.

We accidentally unlinked our audit table in synapselink for dataverse. Now we lost all data stored by synapselink from over 6 months and have been deleting data from d365. Is there anyway to recover the parquet files automatically created by synapselink or is our data gone forever.

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,235 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 29,711 Reputation points
    2025-03-13T11:01:20.86+00:00

    Hello Jani,

    Did you confirm whether the Azure Data Lake Storage Gen2 account, where Synapse Link stored the Parquet files, still exists? Because if the storage account hasn't been deleted, the Parquet files might still be intact.

    https://stoneridgesoftware.com/how-to-set-up-synapse-link-for-dataverse-to-enhance-system-integration/

    Also, check if any data retention or deletion policies were configured on the storage account. ​

    If you have backups of the storage account or have enabled Azure Backup for the storage account, you might be able to restore the deleted Parquet files.​

    You may need to contact Azure Support promptly. They can assess if there's any possibility of data recovery.

    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.