Skip to main content
Solved

ODX Server timestamp

  • February 25, 2021
  • 5 replies
  • 155 views

Forum|alt.badge.img

Is there a way to get the timetamp of when a table was transferred from source to ODX Server? Like the DW_Timestamp. The only system field i can find is odx_batch_number. 

Best answer by Christian Hauggaard

Sorry for the late reply. You can view standard transfers from data source to ODX storage in the ODX execution log, by right clicking on the ODX instance and selecting “View Execution Log”

 

However, there is currently no way to directly query this execution log data.

A workaround would be to add a query table with a new column GETDATE(). 

Another potential workaround could be to extract the timestamp from the latest created table folder in your data lake for the relevant data source (assuming you are using data lake ODX storage). 

 

 

View original
Did this topic help you find an answer to your question?

5 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Sorry for the late reply. You can view standard transfers from data source to ODX storage in the ODX execution log, by right clicking on the ODX instance and selecting “View Execution Log”

 

However, there is currently no way to directly query this execution log data.

A workaround would be to add a query table with a new column GETDATE(). 

Another potential workaround could be to extract the timestamp from the latest created table folder in your data lake for the relevant data source (assuming you are using data lake ODX storage). 

 

 


Forum|alt.badge.img+2
  • Contributor
  • 52 replies
  • May 1, 2023

Hi @Christian Hauggaard ,

Is it likely that these type of system fields will become available in ODX server tables? Adding a query table for something like this seems like a workaround that requires more manual work, which I would like to avoid. The latest timestamp of a refresh is relevant to show in dashboards, so end-users can see how ‘old’ the data is that they are looking at.

 

NOTE: with an ADF data source it is not even possible to add query tables as far as I can see.


KaiMueller
TimeXtender Xpert
Forum|alt.badge.img+1
  • TimeXtender Xpert
  • 6 replies
  • January 29, 2024

Hi,

are there any news regarding ODX timestamps?

We have a customer where the MDW runs quite some time and we need to know, when the ODX tasks  are actually finished (local SQL Server storage for ODX). The customer has also >15 data sources, each with several dozen tables. Query tables would work, but that would be quite a lot of work to add this for all tables. It would be ideal to have an overview on a per table basis. As we are using incremental loads for several tables, we can’t use the tablename to get the info. Has someone found a way to show this?

 

Cheers,

Kai


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @KajEmergo and @KaiMueller  

In the new version it is possible to use the TimeXtender API to extract some of this info. It shows which transfer task completed at a specific time, however it does not currently show which tables (i.e. which tables are included in the transfer task)

Please feel free to submit a product idea


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • January 29, 2024

Hi @KaiMueller 

I was not on this originally. 

I made a guide for DW incremental load. When you look at the _I table it has some date fields.

The DW_INC_ODXBatchTimeStamp is the date when the folder was created.

If there was new data, the date for the  DW_INC_ODXBatchTimeStamp field would be updated with that, so it is what you are looking for.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings