Requesting help on organization data Athena error - data collector 3.5

[silk206]

Hi,

I am updating our cudos to v2 and updated the data collector to 3.5, and noticing I cannot pull data that is being assumed into quicksights that are in array format.

I have a ticket with AWS now and seeing in quicksights dataset summary_view, fields are being skipped due to being arrays - currently have my ingest broken until this is resolved, thank you.

SQL_EXCEPTION Learn more
This is a general SQL error. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.

Error details:

[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. COLUMN_NOT_FOUND: line 16:490: Column 'parent_tags' cannot be resolved or requester is not authorized to access requested resources [Execution ID: b7578c4a-74cf-422c-93cd-52ae4715b529

[iakov-aws]

Hello,

you can uncomment this line in lambda https://github.com/awslabs/cid-framework/blob/main/data-collection/deploy/module-organization.yaml#L245

or (preferably) you can use 'ParentTags' column instead