Get rows from Teradata Temporal table

(0) Share

Report

Posted on by blini

I'm trying to get some data from Teradata temporal table using Power Automate flow. In order to retrieve the data I need to filter 'VALIDTIME' but I cannot do this using ODATA filters.

Teradata 'Get Rows' action in Power Automate requires to use odata as filter and not SQL

The following SQL works and is able to retrieve the data, but I need to convert this sql to ODATA in order to use in Power Automate flow:

locking view [table_name] for access 
validtime as of date'2024-03-22'
select count(*)
from [table_name]

locking view [table_name] for access 
nonsequenced validtime
select count(*)
from [table_name]
where BEGIN(BUSINESS_PD) <= DATE '2024-04-22'
 and end(business_pd) >= date'2024-04-23'

Thanks in advance