Completeness and Accuracy Confirmation for Connector Runs
We have a large amount of work that has to be done to show that we are getting data from source systems and completely and accurately loading it into our data warehouse environment. This is especially important for SOX processes at our institution. When decisions are made that impact SOX auditability, we have to custom build processes to show that we loaded every record, and that every record was loaded correctly (key values match). It would be great if Fivetran connectors included an auditable record of this information. The source system had 5 rows with these values, the destination of the data load has the same 5 rows with the same 5 values. The auditability need would support randomly selected time periods or data feeds from auditors. "Show me that this connector loaded data from this source completely and accurately on April 4th of this year" is a question we often hear from auditors. Being able to depend on Fivetran to show this and have it be included in your SOC1 statements would go a long way to reducing the amount of manual work for data loaded via Fivetran.
-
Hey Scott,
This is Ryan, one of the product managers at Fivetran. We have a feature coming out to provide auditable data checks early next year! Would you want to be part of the private preview when we have it ready?
Best,
Ryan -
yes indeed!
-
Great! I'll reach out to you when we have it ready.
Best,
Ryan
Please sign in to leave a comment.
Comments
3 comments