All Apps and Add-ons

DB Connect: Why no Column found on Timestamp?

Shadolu
Explorer

After Running the Query there is no option for Timestamp > Choose Column >  "No result"
Kindly see Image. 

Since I'm going to use the timestamp column well "Timestamp"

Shadolu_0-1649745033090.png

currently beginner here 

Tags (2)
0 Karma

tscroggins
Influencer

@Shadolu 

DB Connect can't parse the column names out of your SQL. It's a tedious rewrite, but you could try wrapping your CTE with an outer SELECT and explicitly listing the columns:

SELECT
    COLUMN_1,
    COLUMN_2,
    COLUMN_3,
    ...,
    COLUMN_N
FROM (
    WITH ... (
      ...
    )
    SELECT
        ...
    FROM
        ...
    WHERE
        ...
) T



Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...