BF.B Inc. Earnings Embeddings in Snowflake

-- Mount VectorFin Iceberg catalog in Snowflake
CREATE OR REPLACE ICEBERG TABLE BF.B_embeddings
  EXTERNAL_VOLUME = 'vectorfin_gcs'
  CATALOG = 'vectorfin_polaris'
  CATALOG_TABLE_NAME = 'embeddings.transcripts';

-- Query BF.B embeddings
SELECT ticker, fiscal_period, chunk_idx,
       VECTOR_COSINE_SIMILARITY(embedding, :query_vec) AS score
FROM   BF.B_embeddings
WHERE  ticker = 'BF.B'
  AND  fiscal_period = '2024-Q4'
ORDER  BY score DESC
LIMIT  10;