Finance | Project Operations, Human Resources, ...

Trying to export TABLEIDTABLE to the data lake

(0) Share

Report

Posted on by AstridMalanka

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?

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

AstridMalanka 8 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

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.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

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.

Was this reply helpful? Yes No
SAADULLAH M Z 175 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

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.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

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.

Was this reply helpful? Yes No
SAADULLAH M Z 175 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

Create a new View add the SYSTABLEIDVIEW as data source and create a new entity and expose this entity where ever you want.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

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.

Was this reply helpful? Yes No
Suggested answer

SAADULLAH M Z 175 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

You can use SYSTABLEIDVIEW

This is available in AOT > System Documentation > Views

Hope this will help you.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

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?

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Trying to export TABLEIDTABLE to the data lake

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?

Was this reply helpful? Yes No