We've recently implemented a ADLS Gen 2 data lake with our D365 FO instance, data is exporting correctly, and ingesting into Snowflake as an external stage - not using ADF or Synapse at this stage, although may look at this in the future for incremental loads to Snowflake.
I've previously used Data Entities & BYOD database so the data isn't completely foreign to me, however, I'm struggling to understand how to identify data from the web UI in the database.
For example, we have 3 GL Financial Dimensions configured, with values for each. They relate to items through the Released products menu, however, after countless days of searching and pulling in every single table through Export to Data Lake I cannot seem to find where this data is located. All resources I've found seem to go as far as setting up the Data Lake, not how to consume the data.
The table "EcoResProductDetailsExtended" is not listed in the "Export to Data Lake" menu. What am I missing here?
To help me in the future, are there any easy-to-use resources online?
I understand there is Alex Meyer's table associations, but that doesn't really help me identify where the data is actually located, only the relationships between the tables.
Thanks in advance for the help!
