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