Adeegso hagahan haddii aad tahay maamule goobta shaqada ee ChatGPT ama isticmaale ChatGPT Plus ama ChatGPT Pro oo doonaya inuu ChatGPT ku xidho Snowflake isaga oo adeegsanaya adeegaha MCP ee Snowflake maamusho.

Inta badan dejintu waxay ka dhacdaa Snowflake. Marka Snowflake diyaar noqoto, dhammaystir xidhiidhka qaab-dhismeedka Snowflake ee ChatGPT, dabadeedna hawlgeli xirmo-ku-darka Snowflake ee adeegsanaya qaab-dhismeedkaas.

Waxa aad dejinayso

Waxaad abuuraysaa adeegaha MCP ee Snowflake maamusho, kaas oo u shaqaynaya bar-dhammaadka isku-xidhaha ChatGPT. Adeegaha MCP wuxuu qeexayaa:

• Ficillada ChatGPT adeegsan karo

• Xogta ama walxaha Snowflake ee qalabkaasi geli karo.

• Doorka Snowflake ee isticmaale kastaa ku oggolaado.

• Kaydka xogta, bandhig-qorshaha iyo magaca adeegaha MCP ee Snowflake ee aqoonsada bar-dhammaadka.

Kadib waxaad ChatGPT gudaheeda ku habaynaysaa Snowflake - Qaab-dhismeedka Rasmiga ah adigoo adeegsanaya URL-ka buuxa ee adeegaha MCP ee la maamulo. Shaashadda dejinta qaab-dhismeedku waxay URL-ka u muujin kartaa afar goobood oo kala duwan:

• Horgalaha martigeliyaha Snowflake.

• Kaydka xogta.

• Bandhig-qorshaha.

• Magaca adeegaha MCP.

ChatGPT wuxuu ogaan karaa oo keliya qalabka uu adeegaha MCP soo bandhigo, isla markaana uu oggol yahay doorka Snowflake ee isticmaaluhu ku oggolaaday.

Kahor intaadan bilaabin

Waxaad u baahan tahay:

• Gelitaanka maamule ama mulkiile goobta shaqada ee ChatGPT, ama gelitaanka ChatGPT Plus ama ChatGPT Pro.

• Gelitaanka Snowflake oo abuuri kara walxaha adeegaha MCP, oggolaanshona siin kara.

• Kaydka xogta iyo bandhig-qorshaha Snowflake ee adeegaha MCP lagu kaydin doono.

• Go'aan ku saabsan waxa ChatGPT loo oggolaanayo, sida Cortex Search, Cortex Analyst, SQL akhris-keliya ah, ama habraac ama hawl gaar ah.

• Door Snowflake oo leh mudnaanta ugu yar, kaas oo isticmaalayaashu adeegsan doonaan marka ay abka oggolaanayaan.

• Horgalaha martigeliyaha akoonka Snowflake, oo ay ku jirto daba-galka gobol ama daruur kasta.

Haddii akoonkaaga Snowflake uu gelitaanka ku xaddido siyaasad shabakad ama liis IP-yo la oggol yahay, weydii maamule Snowflake inuu oggolaado xidhiidhada soo galaya ee ka imanaya xuduudaha IP-ga bixitaanka isku-xidhaha ChatGPT ee hadda jira. Liisku wuu isbeddelaa waana in mar walba la cusboonaysiiyaa.

Qiimayaasha la diyaarinayo

• Horgalaha martigeliyaha Snowflake: wax kasta oo ka horreeya .snowflakecomputing.com gudaha URL-ka akoonka Snowflake.

• Kaydka xogta: kaydka xogta ee uu ku jiro adeegaha MCP.

• Bandhig-qorshaha: bandhig-qorshaha uu ku jiro adeegaha MCP.

• Magaca adeegaha MCP: magaca walaxda adeegaha MCP ee Snowflake.

• URL-ka buuxa ee adeegaha MCP ee la maamulo, haddii shaashadda dejinta ChatGPT ay URL codsato.

• Doorka Snowflake: doorka ay tahay inay isticmaalayaashu adeegsadaan marka ay abka oggolaanayaan.

• Liiska qalabka: walxaha iyo ficillada Snowflake ee aad doonayso in ChatGPT adeegsado.

Go'aami waxa ChatGPT samayn karo

Dooro oo keliya awoodaha aad doonayso inaad soo bandhigto. Ikhtiyaarrada caanka ah waxaa ka mid ah:

• Ku raadi Cortex Search si aad jawaabo uga hesho xogta ama nuxurka Snowflake ee la tusmeeyay.

• Su'aalo iyo jawaabo Cortex Analyst ah oo loo marayo muuqaal macneyeed la ansixiyay.

• SQL akhris-keliya ah oo loogu talagalay gelitaan weydiimeed la xakameeyo.

• Wakiil Snowflake, habraac kaydsan ama UDF loogu talagalay habsocod shaqo oo gaar ah.

Haddii aad SQL hawlgeliso, ka dhig akhris-keliya ilaa ururkaagu dib u eego oo ansixiyo gelitaanka wax-qorista.

Fur xaashida shaqada Snowflake

1. Gal abka Snowflake.

2. U wareeg door abuuri kara adeegaha MCP, gelitaanna siin kara.

3. Tag Goobaha shaqada.

   

4. Abuur goob shaqo oo leh fayl SQL ah.

   

5. Macnaha goobta shaqada u deji kaydka xogta iyo bandhig-qorshaha lagu abuuri doono adeegaha MCP.

   

Abuur adeegaha MCP ee Snowflake

Snowflake gudaheeda, ku gal door abuuri kara adeegaha MCP, gelitaanna siin kara. Ka fur xaashi shaqo kaydka xogta iyo bandhig-qorshaha lagu abuurayo adeegaha MCP.

Orod amar la mid ah tusaalahan soo socda. Magacyada ku beddel kaydka xogta, bandhig-qorshaha, adeegyada, muuqaallada, bakhaarka iyo magaca adeegaha Snowflake ee adiga kuu gaarka ah.

CREATE MCP SERVER CHATGPT_SNOWFLAKE_MCP
FROM SPECIFICATION $$
tools:
- name: "support-search"
type: "CORTEX_SEARCH_SERVICE_QUERY"
identifier: "CHATGPT_APPS.TOOLS.SUPPORT_SEARCH_SERVICE"
title: "Support Search"
description: "Search support content for relevant customer issues."
- name: "revenue-analyst"
type: "CORTEX_ANALYST_MESSAGE"
identifier: "CHATGPT_APPS.TOOLS.REVENUE_SEMANTIC_VIEW"
title: "Revenue Analyst"
description: "Answer revenue questions using the approved semantic view."
- name: "sql-readonly"
type: "SYSTEM_EXECUTE_SQL"
title: "Read-only SQL"
description: "Run read-only SQL queries against approved Snowflake data."
config:
read_only: true
query_timeout: 600
warehouse: "CHATGPT_WH"
$$;

Magacyada qalabka iyo walxaha Snowflake ee amarkan ku jira waa tusaalooyin:

• support-search wuxuu soo bandhigayaa adeegga Cortex Search ee la cayimay.

• revenue-analyst wuxuu soo bandhigayaa muuqaalka macneyeed ee la cayimay. Ku dar qalab loogu talagalay muuqaallo kale markii loo baahdo.

• sql-readonly wuxuu soo bandhigayaa SQL akhris-keliya ah oo leh bakhaarka la cayimay.

Adeegso magacyo qalab oo joogto ah oo wax sharraxaya si ChatGPT u doorto qalabka saxda ah. Abuurista adeegaha MCP si toos ah gelitaan uguma siinayso walxaha Snowflake ee salka ku haya.

Ikhtiyaarrada dheeraadka ah ee qeexitaanka, eeg: Abuur adeegaha MCP ee Snowflake maamusho.

Sii oggolaanshaha saxda ah ee Snowflake

Dooro doorka Snowflake ee isticmaalayaashu ku oggolaan doonaan, dabadeed doorkaas u oggolow gelitaanka

1. Kaydka xogta iyo bandhig-qorshaha.

2. Adeegaha MCP.

3. Walax kasta oo salka ku haysa oo qalabku adeegsado, sida adeeg raadin, muuqaal macneyeed ama bakhaar.

Tusaale:

GRANT USAGE ON DATABASE CHATGPT_APPS TO ROLE CHATGPT_CONNECTOR_ROLE;
GRANT USAGE ON SCHEMA CHATGPT_APPS.TOOLS TO ROLE CHATGPT_CONNECTOR_ROLE;
GRANT USAGE ON MCP SERVER CHATGPT_APPS.TOOLS.CHATGPT_SNOWFLAKE_MCP TO ROLE CHATGPT_CONNECTOR_ROLE;

GRANT USAGE ON CORTEX SEARCH SERVICE CHATGPT_APPS.TOOLS.SUPPORT_SEARCH_SERVICE TO ROLE CHATGPT_CONNECTOR_ROLE;
GRANT SELECT ON SEMANTIC VIEW CHATGPT_APPS.TOOLS.REVENUE_SEMANTIC_VIEW TO ROLE CHATGPT_CONNECTOR_ROLE;
GRANT USAGE ON WAREHOUSE CHATGPT_WH TO ROLE CHATGPT_CONNECTOR_ROLE;

Haddii adeegaha MCP uu soo bandhigo UDF, habraac kaydsan ama Wakiil Cortex, walaxdaasna sii oggolaanshaha loo baahan yahay.

Hubi in Snowflake diyaar tahay

Orod:

SHOW MCP SERVERS IN SCHEMA CHATGPT_APPS.TOOLS;

Kadib orod:

DESCRIBE MCP SERVER CHATGPT_APPS.TOOLS.CHATGPT_SNOWFLAKE_MCP;

Xaqiiji:

• Adeeguhu inuu ku jiro kaydka xogta iyo bandhig-qorshaha la filayay.

• Liiska qalabku inuu yahay kii aad rabtay.

• identifier-ka qalab kasta inuu tilmaamayo walaxda saxda ah ee Snowflake.

• Doorka isku xidhaya inuu USAGE ku leeyahay adeegaha MCP.

• Doorka isku xidhaya inuu haysto oggolaanshaha loo baahan yahay ee walax kasta oo salka ku haysa.

Geli faahfaahinta adeegaha Snowflake gudaha ChatGPT

1. Gudaha ChatGPT, u wareeg akoonka ama goobta shaqada ee abku ka dhex shaqaynayo.

2. Fur Dejimaha. Dejin ka wada shaqaynaysa goobta shaqada oo dhan, adigoo maamule goobta shaqada ah fur Dejimaha goobta shaqada.

3. Tag Xirmo-ku-darrada.

4. Raadi Snowflake.

5. Hawlgeli Snowflake - Qaab-dhismeedka Rasmiga ah.

6. Fur Snowflake - Qaab-dhismeedka Rasmiga ah, geli magac xidhiidh oo cad, kadibna dooro Ku xidh.

7. Geli URL-ka buuxa ee adeegaha MCP ee la maamulo:

https://<snowflake_host_prefix>.snowflakecomputing.com/api/v2/databases/{database}/schemas/{schema}/mcp-servers/{server}

Tusaale:

https://myorg-myaccount.azure.snowflakecomputing.com/api/v2/databases/CHATGPT_APPS/schemas/TOOLS/mcp-servers/CHATGPT_SNOWFLAKE_MCP

Haddii shaashadda dejintu habaynta Snowflake u muujiso goobo kala duwan, isticmaal isla qiimayaasha URL-ka:

Horgalaha martigeliyaha Snowflake

Isticmaal wax kasta oo ka horreeya .snowflakecomputing.com gudaha URL-ka akoonkaaga Snowflake, oo ay ku jirto daba-galka gobol ama daruur kasta.

Tusaale ahaan, haddii URL-ka akoonku ku bilaabmo:

https://myorg-myaccount.azure.snowflakecomputing.com

Horgalaha martigeliyuhu waa:

myorg-myaccount.azure

Kaydka xogta

Geli kaydka xogta ee uu ku jiro adeegaha MCP, sida:

CHATGPT_APPS

Bandhig-qorshaha

Geli bandhig-qorshaha uu ku jiro adeegaha MCP, sida:

TOOLS

Magaca adeegaha MCP

Geli magaca walaxda adeegaha MCP ee Snowflake, sida:

CHATGPT_SNOWFLAKE_MCP

Habee macmiilka Oggolaanshaha furan

Si aad ugu xidhanto, waxaad Snowflake uga baahan tahay Aqoonsiga Macmiilka iyo Sirta Macmiilka.

Markaad isticmaasho session:role:all, Snowflake wuxuu adeegsadaa doorka caadiga ah ee isticmaale kasta. Doorka caadiga ah waa inuu ku jiraa liiska doorarka la oggol yahay ee isku-darka Oggolaanshaha furan, haddii la habeeyay, waana inaan la xannibin. Haysashada door kale oo la ansixiyay si toos ah uma dooranayso doorkaas.

1. Daaqadda dejinta ChatGPT, fur Dejimaha horumarsan ee Oggolaanshaha furan, dooro Macmiil Oggolaansho furan oo Isticmaaluhu Qeexay, kadibna nuqul ka samee URL-ka dib-u-wicitaanka ee ChatGPT lagu muujiyay.

2. Abuur isku-dar amni oo Oggolaansho furan oo gaar ah, adigoo OAUTH_CLIENT_TYPE = 'CONFIDENTIAL' adeegsanaya, OAUTH_REDIRECT_URI-na u dejinaya isla URL-ka dib-u-wicitaanka.

3. Snowflake gudaheeda ku orod amarkan soo socda, adigoo magaca isku-darka ku qoraya xarfo waaweyn:

   SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('YOUR_INTEGRATION_NAME');

4. Natiijada JSON, oauth_client_id ku dheji Aqoonsiga macmiilka Oggolaanshaha furan, oauth_client_secret-na ku dheji Sirta macmiilka Oggolaanshaha furan gudaha ChatGPT.

5. Habka xaqiijinta bar-dhammaadka token-ka u deji client_secret_basic.

Ku xidh oo maamul Snowflake

1. Isla daaqadda dejinta ChatGPT, dooro Sii wad, gal Snowflake, kadibna oggolow xidhiidhka.

2. Dejinta goobta shaqada, habee siyaasadda rakibidda xirmo-ku-darka iyo gelitaanka doorarka ama kooxaha xubnaha adeegsan doona. Hubi in Snowflake iyo Snowflake - Qaab-dhismeedka Rasmiga ah labaduba hawlgashan yihiin.

3. Maamulayaasha goobta shaqada ayaa mas'uul ka ah habaynta Gelitaanka isticmaalaha ee doorarka adeegsan doona Snowflake.

4. Maamulayaasha goobta shaqada ayaa mas'uul ka ah dib-u-eegista Xakamaynta ficillada ee qalabka la soo bandhigay.

5. Maamulayaasha goobta shaqada ayaa mas'uul ka ah dib-u-eegista Oggolaanshaha abka si loo doorto goorta ChatGPT xubnaha waydiinayo kahor adeegsiga abka.

Oggolaanshahan abku wuxuu khuseeyaa wada sheekaysiyada ChatGPT. Wakiillada goobta shaqadu waxay adeegsadaan xakamaynta wakiil kasta ee uu dejiyay dhisaha wakiilku si loo go'aamiyo ficillada abka ee la heli karo iyo goorta isticmaalayaasha kama-dambaysta ah la waydiinayo inay ansixiyaan. Hab-dhaqanka wakiilka, eeg: Wakiillada Goobta Shaqada ChatGPT ee Enterprise iyo Business.

Tijaabi abka

1. Fur wada sheekaysi, dooro Snowflake, kadibna tijaabi xidhiidhka.

2. Xaqiiji in ChatGPT ogaado qalabka aad habaysay.

3. Marka hore samee ficil akhris oo khatartiisu yar tahay, sida raadin ama weydiin akhris-keliya ah oo lagu sameeyo xog la ansixiyay.

4. Xaqiiji in oggolaanshaha Snowflake uu ka hortago gelitaanka ka baxsan doorka iyo walxaha la ansixiyay.

5. Dejinta goobta shaqada, ku tijaabi xubno aan maamule ahayn oo la oggol yahay, kuwaas oo leh doorar Snowflake oo caadi ah oo kala duwan. Xidhiidh maamule oo guulaysta ma xaqiijinayo in xubin kastaa xidhiidhi karo.

Maamulayaasha goobta shaqada, hawlgelinta Snowflake oo keliya kuma filna. Haddii Snowflake - Qaab-dhismeedka Rasmiga ah aan la hawlgelin oo aan la isku xidhin, xirmo-ku-darku wuxuu xubnaha ugu muuqan karaa mid naafo ah.

URL-ka adeegaha MCP iyo hab-dhaqanka Oggolaanshaha furan

ChatGPT wuxuu ku xidhmaa URL-ka buuxa ee adeegaha MCP ee Snowflake maamusho:

https://<snowflake_host_prefix>.snowflakecomputing.com/api/v2/databases/{database}/schemas/{schema}/mcp-servers/{server}

ChatGPT wuxuu adeegsadaa horgalaha martigeliyaha Snowflake ee URL-kaas si uu u helo bar-dhammaadyadan Oggolaanshaha furan ee Snowflake:

• Oggolaanshaha: https://<snowflake_host_prefix>.snowflakecomputing.com/oauth/authorize

• Token: https://<snowflake_host_prefix>.snowflakecomputing.com/oauth/token-request

Ha ku dhejin URL-ka Snowsight, URL-ka xididka akoonka Snowflake oo keliya, ama URL leh qaybo waddo oo dheeraad ah. URL-ka MCP waa inuu ka koobnaadaa /api/v2/databases/{database}/schemas/{schema}/mcp-servers/{server} oo uu si sax ah ugu dhigmo walxahaaga Snowflake.

Xallinta dhibaatooyinka

Snowflake maamulaha ayuu u hawlgashan yahay, laakiin xubin ayuu ka naafo yahay

• Xaqiiji in Snowflake iyo Snowflake - Qaab-dhismeedka Rasmiga ah labaduba ka hawlgashan yihiin Dejimaha goobta shaqada > Xirmo-ku-darrada.

• Fur Snowflake - Qaab-dhismeedka Rasmiga ah oo dhammaystir habka Ku xidh. Hawlgelinta qaab-dhismeedka iyada oo aan la isku xidhin kuma filna.

• Fur Snowflake oo xaqiiji in qaab-dhismeedku u muuqdo abka looga baahan yahay.

• Xaqiiji in doorka ama kooxda xubinta ay dhibaatadu saamaysay ay oggol tahay siyaasadda rakibidda xirmo-ku-darka.

Adeegaha MCP lama helin

• Dib u hubi URL-ka buuxa ee adeegaha MCP, ama afarta goobood ee qaab-dhismeedka haddii shaashadda dejintu ku waydiiso.

• Xaqiiji in adeegaha MCP ku jiro isla kaydka xogta iyo bandhig-qorshahaas saxda ah.

Wax qalab ahi kama muuqdo ChatGPT

• Xaqiiji in qeexitaanka adeegaha MCP uu qalab ka kooban yahay.

• Xaqiiji in doorku USAGE ku leeyahay adeegaha MCP.

Qalab ayaa muuqda laakiin wuu fashilmaa marka la adeegsado

• Xaqiiji in doorku haysto oggolaanshaha looga baahan yahay walaxda Snowflake ee salka ku haysa, sida adeegga raadinta, muuqaalka macneyeed, bakhaarka, habraaca ama UDF.

Qalabka SQL wuu fashilmay

• Xaqiiji in magaca bakhaarku sax yahay, bakhaarkuna shaqaynayo.

• Xaqiiji in doorku USAGE ku leeyahay bakhaarka.

• Xaqiiji in read_only: true la dejiyay haddii aad rabtay gelitaan akhris-keliya ah.

Doorka ALL ee la codsaday si cad ayaa loo xannibay

Weydii maamulahaaga Snowflake inuu doorkaaga caadiga ah la barbar dhigo doorarka uu oggol yahay iyo kuwa uu xannibay isku-darka Oggolaanshaha furan. Haysashada door kale oo la oggol yahay si toos ah uma dooranayso doorkaas. Haddii ay habboon tahay, doorka caadiga ah u beddel door la ansixiyay, kadibna dib u xidh. Beddelidda doorkaaga caadiga ah waxay sidoo kale saamaynaysaa fadhiyadaada Snowflake ee ka baxsan ChatGPT.

Oggolaanshuhu wuu fashilmay

• Xaqiiji in isticmaaluhu geli karo Snowflake.

• Markaad adeegsanayso session:role:all, xaqiiji in isku-darka Oggolaanshaha furan uu oggol yahay doorka caadiga ah ee isticmaalaha.

• Xaqiiji in dejintu adeegsanayso habka Oggolaanshaha furan ee MCP ay Snowflake maamusho.

• Xaqiiji in Aqoonsiga Macmiilka iyo Sirta Macmiilku ku habboon yihiin isku-darka Oggolaanshaha furan ee Snowflake, iyo in URI-ga dib-u-hagiddiisu la mid yahay URL-ka dib-u-wicitaanka ee ChatGPT lagu muujiyay.

Siyaasadda shabakadda Snowflake ama liiska IP-yada la oggol yahay ayaa xannibaya isku-xidhaha

• Weydii maamule Snowflake inuu cusboonaysiiyo siyaasadda shabakadda ama xeerarka gelitaanka Snowflake.

• Oggolow xidhiidhada soo galaya ee ka imanaya xuduudaha IP-ga bixitaanka isku-xidhaha ChatGPT ee hadda jira.

• Liiskan oggolaanshaha ku habee Snowflake. Wuxuu ka duwan yahay liiska IP-yada goobta shaqada ChatGPT loo oggol yahay.

• Marka ay suurtagal tahay, otomaatig uga dhig cusboonaysiinta JSON-ka la daabacay, sababtoo ah xuduuduhu way isbeddeli karaan.

Dhibaato ku timid xidhiidhka magaca martigeliyaha

Adeegso horgalaha saxda ah ee martigeliyaha Snowflake. Magacyada martigeliyayaasha Snowflake ee leh xarriiqo-hoose waxay sababi karaan dhibaatooyin; doorbid xarriiqooyin-gaaban.

Tixraacyo

• Adeegaha MCP ee Snowflake maamusho

• CREATE MCP SERVER

• DESCRIBE MCP SERVER

• SHOW MCP SERVERS