Fixed the table aws_organizations_account fails to display result when we pass both parent_id and id as query parameter
Limit issue for the query: select id,parent_id,title from aws_organizations_account WHERE parent_id IN (select id from aws_organizations_organizational_unit WHERE parent_id='ou-wkmw-ztedbwld') LIMIT 5
select id,parent_id,title from aws_organizations_account WHERE parent_id IN (select id from aws_organizations_organizational_unit WHERE parent_id='ou-wkmw-ztedbwld') LIMIT 5
Integration test logs
Logs
Example query results
Results
Case 1: CTE and the select query is querying for a single connection ``` > with cost_data as ( select linked_account_id, period_start, unblended_cost_amount as this_month, lag(unblended_cost_amount, 1) over( partition by linked_account_id order by period_start desc ) as previous_month from aws_cost_by_account_monthly ) select linked_account_id, period_start, this_month :: numeric :: float, previous_month :: numeric :: float, ((this_month + previous_month) / 2) :: numeric :: money as "60_day_avg" from cost_data join aws_organizations_account as acc on acc.id = cost_data.linked_account_id where acc.parent_id = 'r-bhwu' order by linked_account_id, period_start; +-------------------+---------------------------+----------------+----------------+------------+ | linked_account_id | period_start | this_month | previous_month | 60_day_avg | +-------------------+---------------------------+----------------+----------------+------------+ | xxxxxxxxxxxx | 2023-07-03T05:30:00+05:30 | 349.2449938927 | 33.2081890726 | $191.23 | | xxxxxxxxxxxx | 2023-08-01T05:30:00+05:30 | 33.2081890726 | 123.6535233683 | $78.43 | | xxxxxxxxxxxx | 2023-09-01T05:30:00+05:30 | 123.6535233683 | -0.0000147239 | $61.83 | | xxxxxxxxxxxx | 2023-10-01T05:30:00+05:30 | -0.0000147239 | 150.1021639716 | $75.05 | | xxxxxxxxxxxx | 2023-11-01T05:30:00+05:30 | 150.1021639716 | 148.9409804602 | $149.52 | | xxxxxxxxxxxx | 2023-12-01T05:30:00+05:30 | 148.9409804602 | 144.4520678504 | $146.70 | | xxxxxxxxxxxx | 2024-01-01T05:30:00+05:30 | 144.4520678504 | 143.5126080015 | $143.98 | | xxxxxxxxxxxx | 2024-02-01T05:30:00+05:30 | 143.5126080015 | 214.8022529982 | $179.16 | | xxxxxxxxxxxx | 2024-03-01T05:30:00+05:30 | 214.8022529982 | 146.9339251547 | $180.87 | | xxxxxxxxxxxx | 2024-04-01T05:30:00+05:30 | 146.9339251547 | 110.3291507393 | $128.63 | | xxxxxxxxxxxx | 2024-05-01T05:30:00+05:30 | 110.3291507393 | 98.49682533 | $104.41 | | xxxxxxxxxxxx | 2024-06-01T05:30:00+05:30 | 98.49682533 | 5.0175839387 | $51.76 | | xxxxxxxxxxxx | 2024-07-01T05:30:00+05:30 | 5.0175839387 |