Hello,

I have created a vector search index for a delta table with 1,400 rows. Using this vector index to find matching records on a table with 52M records with the query below ran for 20hrs and failed with: 'HTTP request failed with status: {"error_code":403,"message":"Invalid access token.  Do you have any suggestions to improve performance?

Thank you!

Query: 

SELECT

                columns...

FROM

   delta table,

   LATERAL (

      SELECT *

      FROM

         VECTOR_SEARCH(

            index => "my vector index",

            query_text => column from delta table,

            query_type => 'ANN',

            num_results => 1

         )

   )