Upgrade to Pro — share decks privately, control downloads, hide ads and more …

SnowflakeにMySQLとJOINする機能を
実装する

Kurochan
April 04, 2021

 SnowflakeにMySQLとJOINする機能を
実装する

Kurochan

April 04, 2021
Tweet

More Decks by Kurochan

Other Decks in Technology

Transcript

  1. SnowflakeͷUDF • UDF = User Defined Function • UDF͸SQLͷଞʹJavascript͕ॻ͚Δ •

    UDF͸ʮߦʯΛฦؔ͢਺ • External Function΋ʮߦʯΛฦؔ͢਺ • ࠓճ͸SnowflakeͷςʔϒϧͱRDSͷςʔϒϧΛJOIN͍ͨ͠…
  2. UDTF • User Defined Table Function • ʮςʔϒϧʯΛฦؔ͢਺ • UDF:

    select my_function(); • UDTF: select * from table(my_table_function()); • ͋ͱ͸ؔ਺Λςʔϒϧؔ਺ʹม׵͢Δؔ਺͕͋Ε͹ɺ
 External FunctionΛUDTFͰϥοϓ͢Ε͹͍͍͸ͣ…ʂ