CREATE INTEGRATIONยถ

์‹œ์Šคํ…œ์— ์ƒˆ ํ†ตํ•ฉ์„ ๋งŒ๋“ค๊ฑฐ๋‚˜ ๊ธฐ์กด ํ†ตํ•ฉ์„ ๋Œ€์ฒดํ•ฉ๋‹ˆ๋‹ค. ํ†ตํ•ฉ์€ Snowflake์™€ ์„œ๋“œ ํŒŒํ‹ฐ ์„œ๋น„์Šค ๊ฐ„์˜ ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ์ œ๊ณตํ•˜๋Š” Snowflake ์˜ค๋ธŒ์ ํŠธ์ž…๋‹ˆ๋‹ค.

์ฐธ๊ณ  ํ•ญ๋ชฉ:

ALTER INTEGRATION, DROP INTEGRATION, SHOW INTEGRATIONS , DESCRIBE INTEGRATION

๊ตฌ๋ฌธยถ

CREATE [ OR REPLACE ] <integration_type> INTEGRATION [ IF NOT EXISTS ] <object_name>
  [ <integration_type_params> ]
  [ COMMENT = '<string_literal>' ]
Copy

์—ฌ๊ธฐ์„œ integration_type_params ๋Š” ํ†ตํ•ฉ ์œ ํ˜•์— ํŠน์ •ํ•œ ๋งค๊ฐœ ๋ณ€์ˆ˜์ž…๋‹ˆ๋‹ค.

ํŠน์ • ๊ตฌ๋ฌธ, ์‚ฌ์šฉ๋ฒ• ๋…ธํŠธ, ์˜ˆ์ œ๋Š” ๋‹ค์Œ์„ ์ฐธ์กฐํ•˜์‹ญ์‹œ์˜ค.

์ผ๋ฐ˜์ ์ธ ์‚ฌ์šฉ๋ฒ• ๋…ธํŠธยถ

  • OR REPLACE ๋ฐ IF NOT EXISTS ์ ˆ์€ ์ƒํ˜ธ ๋ฐฐํƒ€์ ์ด๋ฏ€๋กœ, ๊ฐ™์€ ๋ฌธ์—์„œ ๋‘˜ ๋‹ค ์‚ฌ์šฉํ•  ์ˆ˜๋Š” ์—†์Šต๋‹ˆ๋‹ค.

  • CREATE OR REPLACE <์˜ค๋ธŒ์ ํŠธ> ๋ฌธ์€ ์›์ž์„ฑ์ž…๋‹ˆ๋‹ค. ์ฆ‰, ์˜ค๋ธŒ์ ํŠธ๊ฐ€ ๋ฐ”๋€” ๋•Œ ๋‹จ์ผ ํŠธ๋žœ์žญ์…˜์œผ๋กœ ์ด์ „ ์˜ค๋ธŒ์ ํŠธ๊ฐ€ ์‚ญ์ œ๋˜๊ณ  ์ƒˆ ์˜ค๋ธŒ์ ํŠธ๊ฐ€ ์ƒ์„ฑ๋ฉ๋‹ˆ๋‹ค.