Getting Data In

DB Connect: Why am I getting an error: "column does not exist" when trying to search query of new added field?

saeki_takuya_mk
Engager

Hi,

I had connected to PostgreSQL view using DB Connect.
After I add new fields to the view, I tried to select the new fields on 'Database Query' tab but failed with follow error : "column does not exist".

It seems DB Connect doesn't recognize to be changed schema.
But I can get complete schema data on 'Database Info'.

How can I use the new field on query?

I did restart Splunk on browser , but couldn't resolve it.
Configuration > Server Control > restart Splunk

Thanks

Tags (1)
0 Karma
1 Solution

saeki_takuya_mk
Engager

The problem has been resolved.

Solution is that specify view-name with double quote ' " '.

like this..

| dbquery "myDB" "SELECT * FROM \"the_view_name\"" limit=1000

View solution in original post

0 Karma

saeki_takuya_mk
Engager

The problem has been resolved.

Solution is that specify view-name with double quote ' " '.

like this..

| dbquery "myDB" "SELECT * FROM \"the_view_name\"" limit=1000

View solution in original post

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!