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
0 Karma
Get Updates on the Splunk Community!

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...