1 Answer
- Newest
- Most votes
- Most comments
0
Please check if the "select * from awsdms_validation_failures_v1" sql query shows the "header columns" in upper case like below.
PGDB01=> select * from awsdms_validation_failures_v1;
TASK_NAME | TABLE_OWNER | TABLE_NAME | FAILURE_TIME | KEY_TYPE | KEY | FAILURE_TYPE | DETAILS
-----------+-------------+------------+--------------+----------+-----+--------------+---------
(0 rows)
If they are in upper case then you would need to use the column names in double quotes, like below.
select "TASK_NAME" from awsdms_validation_failures_v1;
answered 17 days ago
Relevant content
- asked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago