Issue with Vector data type and Cortex functions

[ssilambarasan]

Facing below errors with the Snowflake Quickstart to Build a Retrieval Augmented Generation (RAG) based LLM assistant using Streamlit and Snowflake Cortex

https://quickstarts.snowflake.com/guide/asking_questions_to_your_own_documents_with_snowflake_cortex/index.html?index=..%2F..index#2

Steps to reproduce the behavior: Under Build the Vector Store section; While executing step 1 & step 2.

While creating the table DOCS_CHUNKS_TABLE with CHUNK_VEC VECTOR(FLOAT, 768), It throws Syntax error: unexpected '('. I passed this step as creating the data type as Array.

However, while trying to insert records into docs_chunks_table it throws _Unknown user-defined function SNOWFLAKE.CORTEX.EMBEDTEXT error.

Expected behavior The DOCS_CHUNKS_TABLE should be created with the CHUNK_VEC columns as vector store The Insert statement for docs_chunks_table should insert records into the table

[amirineni111]

I got the same issue. any solution or pre-requisite ?

[mahanteshimath]

When VECTOR datatype will be GA?

[Modredo]

Change function snowflake.cortex.embed_text to snowflake.cortex.EMBED_TEXT_768