Hello,
I need the table SQLDICTIONARY to be exported to the lake but since it is a system table, I understand it cannot be exported. And it is needed on some entities schema.
How can I create a custom table that will get the data from SQLDICTIONARY, since the table id is not the same in every environment?
Thanks
Hi Astrid,
Can you explain the business requirement for having table IDs in a Data Lake? What is the underlying reason? What data is exported with table IDs in a column?
There is a workaround to get system tables in a data entity. First create an entity using the wizard with the naming you need for the system table, but use e.g. the physical table CustTable. When the wizard is completed, you can remove all fields and datasources and build the data entity with any table you need. Be aware that if there is no natural key, you would need to use it for export purposes only. Also rebuild the staging table when you changed the contents of the data entity.
Hi,
I did something similar for inventory transaction table, never thought about doing it for a system table, I can try that.
The reason is that we are moving all our systems to F&O and we are exporting the entities to the lake to merge with our current data, but some entities have views that need that sql table.
For example I got errors building the following views.
INVENTITEMPRICEID
INVENTITEMPRICESIMID
and the reason:
Invalid object name 'SQLDICTIONARY'.
also, now that I think about it, I am not sure it will work, even if I manage to create the entity.
Data Lake exports tables and creates views for the entity schema, so it wont be exporting the table anyway because it is a system table.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 724 Most Valuable Professional
André Arnaud de Cal... 619 Super User 2025 Season 2
Sohaib Cheema 400 User Group Leader
