Adeegso hagahan haddii aad tahay maamule goobta shaqada ChatGPT ah oo ururkaaga u diyaarinaya qaabka abka Snowflake. Qaabku ma aha abka ugu dambeeya ee xubnuhu isticmaalaan. Waa hab diyaarin oo abuura ab qabyo ah oo u gaar ah goobta shaqada ka dib markaad bixiso habaynta Snowflake ee loo baahan yahay.
Snowflake ahaan, inta badan diyaarintu waxay ka dhacdaa Snowflake. Waxaad abuurtaa server MCP oo Snowflake maamusho, waxaad doorka saxda ah siisaa marin u helka server-ka MCP iyo walxihiisa hoose, ka dibna waxaad gelisaa URL-ka server-ka MCP ee la maamulo ama goobihiisa qaybaha ah habka diyaarinta qaabka ChatGPT. Ka dib marka ChatGPT abuuro abka qabyada ah, waad daabici kartaa oo u maamuli kartaa sida ababka kale ee goobta shaqada.
Waxa aad diyaarinayso
Waxaad ChatGPT ka dhex abuuraysaa ab Snowflake ah oo u gaar ah goobta shaqada. Abku wuxuu ku xidhmaa server MCP oo ay Snowflake maamusho, kaas oo qeexaya:
Ficillada ChatGPT isticmaali karto, oo loo yaqaan tools.
Xogta ama walxaha Snowflake ee tools-kaasi geli karaan.
Doorka Snowflake ee isticmaalayaashu ay tahay inay ku oggolaadaan.
Kaydka xogta Snowflake, bandhig-qorshaha, iyo magaca server-ka MCP ee aqoonsada bar-dhammaadka isku xidhaha.
ChatGPT waxay ogaan kartaa oo isticmaali kartaa oo keliya tools-ka uu soo bandhigo server-ka MCP iyo kuwa uu oggol yahay doorka Snowflake ee isticmaaluhu ku oggolaado.
Ka hor inta aanad bilaabin
Waxaad u baahan tahay:
Marin u helka maamule ama mulkiile goobta shaqada ChatGPT.
Marin Snowflake oo abuuri kara walxaha server-ka MCP isla markaana bixin kara rukhsado.
Kaydka xogta iyo bandhig-qorshaha Snowflake ee server-ka MCP ku jiri doono.
Go'aan ku saabsan waxa ChatGPT loo oggolaanayo inay sameyso, sida Cortex Search, Cortex Analyst, SQL akhris-keliya, ama hab-raac ama hawl gaar ah.
Door Snowflake oo leh mudnaan ugu yar, kaas oo isticmaalayaashu adeegsan doonaan marka ay abka oggolaanayaan.
Horgalaha martigeliyaha koontada Snowflake, oo ay ku jiraan gobol kasta ama daba-gal daruur.
Qiimayaasha la diyaarinayo
Horgalaha martigeliyaha Snowflake: wax kasta oo ka horreeya .snowflakecomputing.com ee URL-ka koontada Snowflake.
Kaydka xogta: kaydka xogta ee ka kooban server-ka MCP.
Bandhig-qorshe: bandhig-qorshaha ka kooban server-ka MCP.
Magaca server-ka MCP: magaca walaxda server-ka MCP ee Snowflake.
URL-ka buuxa ee server-ka MCP ee la maamulo, haddii shaashadda diyaarinta ChatGPT ay URL ku weydiiso.
Doorka Snowflake: doorka ay isticmaalayaashu adeegsanayaan marka ay abka oggolaanayaan.
Liiska tools-ka: walxaha iyo ficillada Snowflake ee aad rabto in ChatGPT isticmaasho.
Go'aami waxa ChatGPT sameyn karto
Dooro oo keliya awoodaha aad rabto inaad soo bandhigto. Ikhtiyaarrada caamka ah waxaa ka mid ah:
Ku raadi Cortex Search si aad jawaabo uga hesho xogta ama nuxurka Snowflake ee la indeks-gareeyay.
Su'aal iyo jawaab Cortex Analyst ah iyada oo loo marayo muuqaal semantic ah oo la ansixiyay.
SQL akhris-keliya oo loogu talagalay marin su'aalayn oo la xakameeyay.
Wakiil Snowflake ah, hab-raac kaydsan, ama UDF oo loogu talagalay socod-shaqo gaar ah.
Haddii aad SQL karti geliso, ka dhig akhris-keliya ilaa ururkaagu dib u eego oo ansixiyo marin qorid.
Abuur server-ka Snowflake MCP
Snowflake dhexdiisa, ku gal door abuuri kara server-ka MCP isla markaana bixin kara marin. Fur worksheet ku jira kaydka xogta iyo bandhig-qorshaha halka server-ka MCP laga abuurayo.
Abuur server MCP oo liis gareeya oo keliya tools-ka ay tahay in ChatGPT isticmaasho. Magacyada walxaha ku beddel kaydkaaga xogta Snowflake, bandhig-qorshaha, adeegyada, muuqaalada, warehouse-ka, iyo magaca server-ka.
Tusaale:
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: "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 tools-ku waa inay noqdaan kuwo deggan oo sharraxaad leh si ChatGPT u dooran karto tool-ka saxda ah. Abuurista server-ka MCP si otomaatig ah uma bixiso marin u helka walxaha Snowflake ee hoose.
Bixi rukhsadaha Snowflake ee saxda ah
Dooro doorka Snowflake ee isticmaalayaashu ku oggolaan doonaan, ka dibna doorkaas sii marin u helka kaydka xogta, bandhig-qorshaha, server-ka MCP, iyo walax kasta oo hoose oo tools-ku adeegsadaan.
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 USAGE ON WAREHOUSE CHATGPT_WH TO ROLE CHATGPT_CONNECTOR_ROLE;
Haddii server-ka MCP uu soo bandhigo muuqaal semantic ah, UDF, hab-raac kaydsan, ama Cortex Agent, sidoo kale bixi rukhsadaha looga baahan yahay walxahaas.
Xaqiiji in Snowflake diyaar yahay
Orod:
SHOW MCP SERVERS IN SCHEMA CHATGPT_APPS.TOOLS;
Kadib orod:
DESCRIBE MCP SERVER CHATGPT_APPS.TOOLS.CHATGPT_SNOWFLAKE_MCP;
Xaqiiji:
Server-ku wuxuu ku jiraa kaydka xogta iyo bandhig-qorshaha la filayay.
Liiska tools-ku waa sidii aad ugu talagashay.
Aqoonsade kasta oo tool ah wuxuu tilmaamayaa walaxda Snowflake ee saxda ah.
Doorka isku xidhmaya wuxuu USAGE ku leeyahay server-ka MCP.
Doorka isku xidhmaya wuxuu leeyahay rukhsadaha loo baahan yahay ee walax kasta oo hoose.
Bilow diyaarinta qaabka gudaha ChatGPT
ChatGPT dhexdiisa, u wareeg goobta shaqada ee abku laga heli doono.
Fur Dejinta goobta shaqada > Ababka.
Dooro Hagaha.
Raadi Snowflake.
Dooro qaabka abka Snowflake oo bilow diyaarinta.
Geli magac iyo sharraxaad ab oo cad, sida Snowflake ama Snowflake - Analytics.
Geli faahfaahinta server-ka MCP ee la maamulo ee habka diyaarintu codsado.
Haddii shaashadda diyaarintu weydiiso URL-ka buuxa ee server-ka MCP ee la maamulo, isticmaal qaabkan:
https://<snowflake_host_prefix>.snowflakecomputing.com/api/v2/databases/{database}/schemas/{schema}/mcp-servers/{server}
Haddii shaashadda diyaarintu weydiiso goobo kala gaar ah, isticmaal isla qiimayaasha URL-kaas:
Horgalaha martigeliyaha Snowflake.
Kaydka xogta.
Bandhig-qorshe.
Magaca server-ka MCP.
Abuur oo daabac abka qabyada ah
Kaydi diyaarinta qaabka Snowflake gudaha ChatGPT.
Abuur abka qabyada ah.
Dib u eeg faahfaahinta abka qabyada ah, dejinta auth-ka, iyo ficillada la heli karo.
Daabac abka qabyada ah marka uu diyaar noqdo.
Xaqiiji in abku ka muuqdo Dejinta goobta shaqada > Ababka > La kartiyeeyay.
U habee Marinka isticmaalaha doorarka ay tahay inay isticmaalaan.
Dib u eeg Xakamaynta ficilka ee tools-ka la soo bandhigay.
Dib u eeg Rukhsadaha abka si aad u doorato goorta ChatGPT ay xubnaha weydiiso ka hor inta aanay abka isticmaalin.
Rukhsadahan abku waxay khuseeyaan wada sheekaysiyada ChatGPT. Wakiillada goobta shaqadu waxay isticmaalaan xakamayno wakiil kasta u gaar ah oo uu dejiyo dhisaha wakiilka si loo go'aamiyo ficillada abka ee la heli karo iyo goorta isticmaalayaasha ugu dambeeya la weydiiyo inay ansixiyaan. Dhaqanka wakiilka, eeg: Wakiillada Goobta Shaqada ChatGPT ee Enterprise iyo Business.
Tijaabi abka
Ka bilow habka isku xidhka ChatGPT adigoo ah isticmaale tijaabo oo la oggol yahay.
Gal Snowflake oo dooro doorka loogu talagalay haddii lagu weydiiyo.
Xaqiiji in ChatGPT ay ka ogaato server-ka MCP tools-kii la filayay.
Marka hore socodsii ficil akhris oo khatar yar, sida raadis ama su'aal akhris-keliya oo ka dhan ah xog la ansixiyay.
Xaqiiji in rukhsadaha Snowflake ay ka hortagaan marin ka baxsan doorka iyo walxaha la ansixiyay.
URL-ka server-ka MCP iyo dhaqanka Oggolaansha furan
ChatGPT waxay ku xidhantaa URL-ka buuxa ee server-ka MCP ee Snowflake maamusho. ChatGPT waxay isticmaashaa horgalaha martigeliyaha Snowflake ee URL-kaas si ay u xaliso bar-dhammaadyada Oggolaansha furan ee Snowflake.
Ha ku dhejin URL Snowsight, URL-ka xididka koontada Snowflake oo keligiis ah, ama URL kasta oo leh qaybo waddo oo dheeraad ah. URL-ka MCP waa inuu ku jiraa kaydka xogta, bandhig-qorshaha, iyo waddada server-ka MCP, waana inuu si sax ah ugu dhigmo walxahaaga Snowflake.
Xallinta dhibaatooyinka
Server-ka MCP lama helin: dib u hubi URL-ka buuxa ee server-ka MCP ama horgalaha martigeliyaha, kaydka xogta, bandhig-qorshaha, iyo goobaha server-ka ee kala gaar ah.
Tools kama muuqdaan ChatGPT: xaqiiji in qeexidda server-ka MCP ay ku jiraan tools iyo in doorku USAGE ku leeyahay server-ka MCP.
Tool ayaa muuqda laakiin wuu fashilmaa marka la isticmaalo: xaqiiji in doorku haysto rukhsadda saxda ah ee walaxda Snowflake ee hoose.
Tool-ka SQL wuu fashilmaa: xaqiiji in magaca warehouse-ku sax yahay, warehouse-ku diyaar yahay, doorku USAGE ku leeyahay, iyo in read_only uu true yahay haddii aad ugu talagashay marin akhris-keliya.
Oggolaanshuhu wuu fashilmaa: xaqiiji in isticmaaluhu geli karo Snowflake oo isticmaali karo doorka loogu talagalay.
Arrin isku xidhka magaca martigeliyaha: isticmaal horgalaha martigeliyaha Snowflake ee saxda ah. Magacyada martigeliyaha Snowflake ee leh xariiq-hoosaadyo waxay keeni karaan dhibaatooyin; doorbido xariiqo-dhexe.