In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds:
During data loads, specifically integrations (APIs, ADO, 3rd party) to have the ability to export or view the data that was loaded into the staging table.
For example data was loaded into the staging table via an API and then imported into the FACT table. The user did not see the current period data in their system. Accidentally the data loaded to the staging table was historical data and not current period. If the user could extract the data from the staging table they could show the integration experts the source data loaded into FCR was incorrect.
How often is this impacting your users?
Who is this impacting? (ex. model builders, solution architects, partners, admins, integration experts, business/end users, executive-level business users)
Impacts users, partners, admins and integration experts.
What would your ideal solution be? How would it add value to your current experience?
The ability to export the data in a staging table into Excel or a text editor.
This would add value to assist in debugging when there are data issues during a data import process.
Please include any images to help illustrate your experience.
