SQL AI functions in EU region

drag7ter — Wed, 10 Jul 2024 09:01:57 GMT

I know that currently foundation model with pay-per-token are not available in EU only in US. In EU I should create serving point and use provisioned foundation model.

But even creating a serving point with llm from catalog (share models). I used the same LLM as AI Funcrions use mixtral_8x7b_instruct

Then after serving point was successfully provisioned I started SQL Serverless Warehouse in the same workspace in EU region, but running sql statements fail with an error.

SELECT ai_analyze_sentiment('I am happy');

[AI_FUNCTION_HTTP_REQUEST_ERROR] Error occurred while making an HTTP request for function `ai_analyze_sentiment`: [REMOTE_FUNCTION_HTTP_FAILED_ERROR] The remote HTTP request failed with code 404, and error message 'HTTP request failed with status: {"error_code":"RESOURCE_DOES_NOT_EXIST","message":"The given endpoint does not exist, please retry after checking the specified model and version deployment exists."}' SQLSTATE: 57012 SQLSTATE: 08000

Could someone tell steps how use ai functions in EU region. Is it possible?

topic SQL AI functions in EU region in Data Engineering

SQL AI functions in EU region