Hi community, need urgent help please!
So, I’m learning snowflake and made a small poc on my previous trial account and as it was almost out of credits, created a new account and copied the same code to new account.
In my new account while running the code, I’m getting the below error -
Request failed for external function CLASSIFY_TEXT$V2 with remote service error: 400 '“unknown model” '; requests batch-id: 01b8a5f2-0001-327a-0000-00016b7a31c5:2:2:0:7; request batch size: 64 rows; request retries: 0; response time (last retry): 21.76ms
I have set the following in my new account -
ALTER ACCOUNT SET CORTEX_ENABLED_CROSS_REGION = ‘AWS_US’;
SELECT SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE(‘2024_08’);
My account is in region Central US(Iowa); In my previous account I had set Central India; But the dynamic table used to refresh in 2 mins without any hiccup
Below is the code which is causing issue-
CREATE OR REPLACE DYNAMIC TABLE DB_WBNR_PORT.WBNR_CARGO.PORTS_OPERATION_CLASSIFIED
WAREHOUSE = COMPUTE_WH
TARGET_LAG='2 mins'
AS
SELECT *,
REGEXP_REPLACE(
SNOWFLAKE.CORTEX.CLASSIFY_TEXT(REPORTED_ISSUE, ARRAY_CONSTRUCT('Weather Disruption','Container Mismanagement and Stacking Issues', 'Berth Availability', 'Harbor Tugboat Availability', 'High-Risk Cargo and Safety Precautions', 'Incorrect Cargo Manifest or Documentation Issues', 'Port Equipment Failure','Crew Change Delays or Immigration Issues')):label,
'"',
''
) AS Incident_Category
FROM DB_WBNR_PORT.WBNR_CARGO.PORT_OPERATIONS_DATA;
i plan to use this data in my streamlit app, thus the question here! really would really appreciate the help!