In APEX 24.2.0 (on OCI ATP), when I attempt to create a Search Configuration based on a SQL query (as opposed to based on a table), APEX does not pick up any of the columns in the query.
Given this SQL (the embedding column is a Vector type).
SELECT cbc.id
, cbp.post_id
, cbp.post_title
, cbp.post_url
, cbp.post_author
, cbc.embedding
, cbc.chunk_text
FROM cnba_post_chunks cbc
, cnba_blog_posts cbp
WHERE cbp.post_id = cbc.post_id
Even though the SQL compiles:
None of the columns are selectable in the next step in the Wizard:
Even if I create the Search Configuration based on a table, and then change it to be based on SQL, it still only sees the columns from the original table configuration. Given that many vector searches are based on chunked tables, we need to be able to use SQL queries as a source.