Spaces:
Sleeping
Sleeping
File size: 1,431 Bytes
f53fbd9 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 | :setvar DemoDatabase "CustomerAIDemo"
:setvar EmbeddingModelName "LocalEmbeddingModel"
:setvar OllamaEndpoint "https://localhost:11435/api/embed"
:setvar OllamaModel "bge-m3"
USE [$(DemoDatabase)];
GO
EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE WITH OVERRIDE;
EXECUTE sp_configure 'external rest endpoint enabled', 1;
RECONFIGURE WITH OVERRIDE;
GO
IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE name = N'AI_User')
BEGIN
CREATE USER AI_User WITHOUT LOGIN;
END
GO
IF EXISTS (SELECT 1 FROM sys.external_models WHERE name = N'$(EmbeddingModelName)')
BEGIN
DROP EXTERNAL MODEL $(EmbeddingModelName);
END
GO
-- Local/private embedding endpoint. Keep this inside the enterprise network for
-- the "data does not leave the firewall" security message.
CREATE EXTERNAL MODEL $(EmbeddingModelName)
AUTHORIZATION AI_User
WITH
(
LOCATION = '$(OllamaEndpoint)',
API_FORMAT = 'Ollama',
MODEL_TYPE = EMBEDDINGS,
MODEL = '$(OllamaModel)'
);
GO
-- Demo convenience only. In production, grant this to a least-privilege
-- analyst/app role instead of PUBLIC.
GRANT EXECUTE ON EXTERNAL MODEL::$(EmbeddingModelName) TO PUBLIC;
GO
SELECT
name,
location,
api_format,
model_type,
model
FROM sys.external_models
WHERE name = N'$(EmbeddingModelName)';
GO
SELECT AI_GENERATE_EMBEDDINGS(N'kiem tra model embedding noi bo' USE MODEL $(EmbeddingModelName)) AS sample_embedding;
GO
|