449
Hello,
I need the table TABLEIDTABLE exported to the lake. But I am not even able to see the table on the AOT.
I have a view that uses that underline table and I understand that the values could vary on the environments, so it would be to hard code it.
Is there a way to do it?
Thanks to everyone for guiding me in the right direction.
In the end, I will try to use odata to load SystemTableIdTableEntities directly to azure, whether I load it to the lake and then to the database or directly to the database using synapse.
I just checked and that view pulls data from TABLEIDTABLE & SYSANCESTORSTABLE and I am not able to export either of them.
Do you have any link on how I can create a table and pull data from those tables? I am not sure how to do it.
Create your custom Table and pull the data from SysTableIdView and Make sure you have a batch job that updates the table after every deployment.
I hope in this way you can utilize.
when exporting to the lake, you need the underline table, because you export tables, if they are not exposed i wont be able to export it.
Create a new View add the SYSTABLEIDVIEW as data source and create a new entity and expose this entity where ever you want.
Hi, the SYSTABLEIDVIEW, pull data for a table of a similar name, but when I checked the database the other day, the table was empty, the table is also not exposed on the lake.
You can use SYSTABLEIDVIEW
This is available in AOT > System Documentation > Views
Hope this will help you.
Good morning, I was trying to explain what I am doing.
I have a connector to my UAT environment that lets me export tables and entities schemas to the lake.
From there I use the CDMUtilSolution to read the json and csv files into views and tables on synapse.
One of the entities, has a view that is calling that table.
Hi Astrid,
Is your last reply related to the original question? On the screenshot you shared, I don't see any warning or error message.
Or do you want to clarify you are exporting the tables directly and you are not using data entities?
When I try to export it says the following tables/views are missing. It is not an normal export, it is exporting through the lake, it does not work as a job export. Maybe I am not explaining myself?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,326
Super User 2024 Season 2
#2
Martin Dráb
228,166
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (