HOWTO query awsdms_apply_exceptions and awsdms_validation_failures_v1

Question

Hi,

I can do select * from these but I can't do by field/column. 
Is this an expected behaviour?

The database is PostgreSQL and I've setup Oracle to PostgreSQL DMS.

> select distinct failure_type from awsdms_validation_failures_v1 ;
ERROR:  column "failure_type" does not exist
LINE 1: select distinct failure_type from awsdms_validation_failures...
                        ^
> select task_name from awsdms_apply_exceptions ;
ERROR:  column "task_name" does not exist
LINE 1: select task_name from awsdms_apply_exceptions ;
               ^

anish_g · Answer

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;`

HOWTO query awsdms_apply_exceptions and awsdms_validation_failures_v1

Add your answer

Relevant content