upsert-source-race.td 112 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056
  1. # Copyright Materialize, Inc. and contributors. All rights reserved.
  2. #
  3. # Use of this software is governed by the Business Source License
  4. # included in the LICENSE file at the root of this repository.
  5. #
  6. # As of the Change Date specified in that file, in accordance with
  7. # the Business Source License, use of this software will be governed
  8. # by the Apache License, Version 2.0.
  9. # Try to trigger a race by creating source, rendering it, then dropping, in a loop.
  10. $ set-arg-default single-replica-cluster=quickstart
  11. # Must be a subset of the keys in the rows AND
  12. # in a different order than the value.
  13. $ set keyschema={
  14. "type": "record",
  15. "name": "Key",
  16. "fields": [
  17. {"name": "b", "type": "string"},
  18. {"name": "a", "type": "long"}
  19. ]
  20. }
  21. $ set schema={
  22. "type" : "record",
  23. "name" : "envelope",
  24. "fields" : [
  25. {
  26. "name": "before",
  27. "type": [
  28. {
  29. "name": "row",
  30. "type": "record",
  31. "fields": [
  32. {
  33. "name": "a",
  34. "type": "long"
  35. },
  36. {
  37. "name": "data",
  38. "type": "string"
  39. },
  40. {
  41. "name": "b",
  42. "type": "string"
  43. }]
  44. },
  45. "null"
  46. ]
  47. },
  48. {
  49. "name": "after",
  50. "type": ["row", "null"]
  51. }
  52. ]
  53. }
  54. $ kafka-create-topic topic=dbzupsert partitions=1
  55. $ kafka-ingest format=avro topic=dbzupsert key-format=avro key-schema=${keyschema} schema=${schema} repeat=1000000
  56. {"b": "bdata", "a": ${kafka-ingest.iteration}} {"before": {"row": {"a": ${kafka-ingest.iteration}, "data": "fish", "b": "bdata"}}, "after": {"row": {"a": ${kafka-ingest.iteration}, "data": "fish2", "b": "bdata"}}}
  57. > CREATE CONNECTION IF NOT EXISTS csr_conn TO CONFLUENT SCHEMA REGISTRY (
  58. URL '${testdrive.schema-registry-url}'
  59. );
  60. > CREATE CONNECTION kafka_conn
  61. TO KAFKA (BROKER '${testdrive.kafka-addr}', SECURITY PROTOCOL PLAINTEXT);
  62. > CREATE SOURCE upsert
  63. IN CLUSTER ${arg.single-replica-cluster}
  64. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  65. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  66. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  67. ENVELOPE DEBEZIUM
  68. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  69. > CREATE DEFAULT INDEX ON mv
  70. > DROP SOURCE upsert CASCADE
  71. > CREATE SOURCE upsert
  72. IN CLUSTER ${arg.single-replica-cluster}
  73. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  74. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  75. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  76. ENVELOPE DEBEZIUM
  77. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  78. > CREATE DEFAULT INDEX ON mv
  79. > DROP SOURCE upsert CASCADE
  80. > CREATE SOURCE upsert
  81. IN CLUSTER ${arg.single-replica-cluster}
  82. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  83. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  84. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  85. ENVELOPE DEBEZIUM
  86. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  87. > CREATE DEFAULT INDEX ON mv
  88. > DROP SOURCE upsert CASCADE
  89. > CREATE SOURCE upsert
  90. IN CLUSTER ${arg.single-replica-cluster}
  91. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  92. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  93. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  94. ENVELOPE DEBEZIUM
  95. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  96. > CREATE DEFAULT INDEX ON mv
  97. > DROP SOURCE upsert CASCADE
  98. > CREATE SOURCE upsert
  99. IN CLUSTER ${arg.single-replica-cluster}
  100. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  101. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  102. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  103. ENVELOPE DEBEZIUM
  104. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  105. > CREATE DEFAULT INDEX ON mv
  106. > DROP SOURCE upsert CASCADE
  107. > CREATE SOURCE upsert
  108. IN CLUSTER ${arg.single-replica-cluster}
  109. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  110. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  111. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  112. ENVELOPE DEBEZIUM
  113. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  114. > CREATE DEFAULT INDEX ON mv
  115. > DROP SOURCE upsert CASCADE
  116. > CREATE SOURCE upsert
  117. IN CLUSTER ${arg.single-replica-cluster}
  118. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  119. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  120. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  121. ENVELOPE DEBEZIUM
  122. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  123. > CREATE DEFAULT INDEX ON mv
  124. > DROP SOURCE upsert CASCADE
  125. > CREATE SOURCE upsert
  126. IN CLUSTER ${arg.single-replica-cluster}
  127. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  128. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  129. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  130. ENVELOPE DEBEZIUM
  131. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  132. > CREATE DEFAULT INDEX ON mv
  133. > DROP SOURCE upsert CASCADE
  134. > CREATE SOURCE upsert
  135. IN CLUSTER ${arg.single-replica-cluster}
  136. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  137. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  138. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  139. ENVELOPE DEBEZIUM
  140. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  141. > CREATE DEFAULT INDEX ON mv
  142. > DROP SOURCE upsert CASCADE
  143. > CREATE SOURCE upsert
  144. IN CLUSTER ${arg.single-replica-cluster}
  145. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  146. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  147. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  148. ENVELOPE DEBEZIUM
  149. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  150. > CREATE DEFAULT INDEX ON mv
  151. > DROP SOURCE upsert CASCADE
  152. > CREATE SOURCE upsert
  153. IN CLUSTER ${arg.single-replica-cluster}
  154. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  155. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  156. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  157. ENVELOPE DEBEZIUM
  158. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  159. > CREATE DEFAULT INDEX ON mv
  160. > DROP SOURCE upsert CASCADE
  161. > CREATE SOURCE upsert
  162. IN CLUSTER ${arg.single-replica-cluster}
  163. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  164. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  165. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  166. ENVELOPE DEBEZIUM
  167. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  168. > CREATE DEFAULT INDEX ON mv
  169. > DROP SOURCE upsert CASCADE
  170. > CREATE SOURCE upsert
  171. IN CLUSTER ${arg.single-replica-cluster}
  172. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  173. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  174. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  175. ENVELOPE DEBEZIUM
  176. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  177. > CREATE DEFAULT INDEX ON mv
  178. > DROP SOURCE upsert CASCADE
  179. > CREATE SOURCE upsert
  180. IN CLUSTER ${arg.single-replica-cluster}
  181. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  182. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  183. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  184. ENVELOPE DEBEZIUM
  185. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  186. > CREATE DEFAULT INDEX ON mv
  187. > DROP SOURCE upsert CASCADE
  188. > CREATE SOURCE upsert
  189. IN CLUSTER ${arg.single-replica-cluster}
  190. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  191. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  192. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  193. ENVELOPE DEBEZIUM
  194. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  195. > CREATE DEFAULT INDEX ON mv
  196. > DROP SOURCE upsert CASCADE
  197. > CREATE SOURCE upsert
  198. IN CLUSTER ${arg.single-replica-cluster}
  199. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  200. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  201. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  202. ENVELOPE DEBEZIUM
  203. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  204. > CREATE DEFAULT INDEX ON mv
  205. > DROP SOURCE upsert CASCADE
  206. > CREATE SOURCE upsert
  207. IN CLUSTER ${arg.single-replica-cluster}
  208. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  209. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  210. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  211. ENVELOPE DEBEZIUM
  212. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  213. > CREATE DEFAULT INDEX ON mv
  214. > DROP SOURCE upsert CASCADE
  215. > CREATE SOURCE upsert
  216. IN CLUSTER ${arg.single-replica-cluster}
  217. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  218. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  219. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  220. ENVELOPE DEBEZIUM
  221. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  222. > CREATE DEFAULT INDEX ON mv
  223. > DROP SOURCE upsert CASCADE
  224. > CREATE SOURCE upsert
  225. IN CLUSTER ${arg.single-replica-cluster}
  226. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  227. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  228. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  229. ENVELOPE DEBEZIUM
  230. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  231. > CREATE DEFAULT INDEX ON mv
  232. > DROP SOURCE upsert CASCADE
  233. > CREATE SOURCE upsert
  234. IN CLUSTER ${arg.single-replica-cluster}
  235. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  236. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  237. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  238. ENVELOPE DEBEZIUM
  239. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  240. > CREATE DEFAULT INDEX ON mv
  241. > DROP SOURCE upsert CASCADE
  242. > CREATE SOURCE upsert
  243. IN CLUSTER ${arg.single-replica-cluster}
  244. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  245. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  246. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  247. ENVELOPE DEBEZIUM
  248. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  249. > CREATE DEFAULT INDEX ON mv
  250. > DROP SOURCE upsert CASCADE
  251. > CREATE SOURCE upsert
  252. IN CLUSTER ${arg.single-replica-cluster}
  253. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  254. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  255. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  256. ENVELOPE DEBEZIUM
  257. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  258. > CREATE DEFAULT INDEX ON mv
  259. > DROP SOURCE upsert CASCADE
  260. > CREATE SOURCE upsert
  261. IN CLUSTER ${arg.single-replica-cluster}
  262. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  263. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  264. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  265. ENVELOPE DEBEZIUM
  266. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  267. > CREATE DEFAULT INDEX ON mv
  268. > DROP SOURCE upsert CASCADE
  269. > CREATE SOURCE upsert
  270. IN CLUSTER ${arg.single-replica-cluster}
  271. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  272. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  273. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  274. ENVELOPE DEBEZIUM
  275. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  276. > CREATE DEFAULT INDEX ON mv
  277. > DROP SOURCE upsert CASCADE
  278. > CREATE SOURCE upsert
  279. IN CLUSTER ${arg.single-replica-cluster}
  280. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  281. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  282. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  283. ENVELOPE DEBEZIUM
  284. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  285. > CREATE DEFAULT INDEX ON mv
  286. > DROP SOURCE upsert CASCADE
  287. > CREATE SOURCE upsert
  288. IN CLUSTER ${arg.single-replica-cluster}
  289. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  290. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  291. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  292. ENVELOPE DEBEZIUM
  293. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  294. > CREATE DEFAULT INDEX ON mv
  295. > DROP SOURCE upsert CASCADE
  296. > CREATE SOURCE upsert
  297. IN CLUSTER ${arg.single-replica-cluster}
  298. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  299. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  300. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  301. ENVELOPE DEBEZIUM
  302. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  303. > CREATE DEFAULT INDEX ON mv
  304. > DROP SOURCE upsert CASCADE
  305. > CREATE SOURCE upsert
  306. IN CLUSTER ${arg.single-replica-cluster}
  307. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  308. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  309. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  310. ENVELOPE DEBEZIUM
  311. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  312. > CREATE DEFAULT INDEX ON mv
  313. > DROP SOURCE upsert CASCADE
  314. > CREATE SOURCE upsert
  315. IN CLUSTER ${arg.single-replica-cluster}
  316. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  317. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  318. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  319. ENVELOPE DEBEZIUM
  320. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  321. > CREATE DEFAULT INDEX ON mv
  322. > DROP SOURCE upsert CASCADE
  323. > CREATE SOURCE upsert
  324. IN CLUSTER ${arg.single-replica-cluster}
  325. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  326. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  327. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  328. ENVELOPE DEBEZIUM
  329. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  330. > CREATE DEFAULT INDEX ON mv
  331. > DROP SOURCE upsert CASCADE
  332. > CREATE SOURCE upsert
  333. IN CLUSTER ${arg.single-replica-cluster}
  334. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  335. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  336. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  337. ENVELOPE DEBEZIUM
  338. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  339. > CREATE DEFAULT INDEX ON mv
  340. > DROP SOURCE upsert CASCADE
  341. > CREATE SOURCE upsert
  342. IN CLUSTER ${arg.single-replica-cluster}
  343. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  344. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  345. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  346. ENVELOPE DEBEZIUM
  347. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  348. > CREATE DEFAULT INDEX ON mv
  349. > DROP SOURCE upsert CASCADE
  350. > CREATE SOURCE upsert
  351. IN CLUSTER ${arg.single-replica-cluster}
  352. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  353. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  354. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  355. ENVELOPE DEBEZIUM
  356. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  357. > CREATE DEFAULT INDEX ON mv
  358. > DROP SOURCE upsert CASCADE
  359. > CREATE SOURCE upsert
  360. IN CLUSTER ${arg.single-replica-cluster}
  361. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  362. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  363. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  364. ENVELOPE DEBEZIUM
  365. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  366. > CREATE DEFAULT INDEX ON mv
  367. > DROP SOURCE upsert CASCADE
  368. > CREATE SOURCE upsert
  369. IN CLUSTER ${arg.single-replica-cluster}
  370. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  371. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  372. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  373. ENVELOPE DEBEZIUM
  374. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  375. > CREATE DEFAULT INDEX ON mv
  376. > DROP SOURCE upsert CASCADE
  377. > CREATE SOURCE upsert
  378. IN CLUSTER ${arg.single-replica-cluster}
  379. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  380. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  381. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  382. ENVELOPE DEBEZIUM
  383. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  384. > CREATE DEFAULT INDEX ON mv
  385. > DROP SOURCE upsert CASCADE
  386. > CREATE SOURCE upsert
  387. IN CLUSTER ${arg.single-replica-cluster}
  388. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  389. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  390. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  391. ENVELOPE DEBEZIUM
  392. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  393. > CREATE DEFAULT INDEX ON mv
  394. > DROP SOURCE upsert CASCADE
  395. > CREATE SOURCE upsert
  396. IN CLUSTER ${arg.single-replica-cluster}
  397. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  398. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  399. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  400. ENVELOPE DEBEZIUM
  401. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  402. > CREATE DEFAULT INDEX ON mv
  403. > DROP SOURCE upsert CASCADE
  404. > CREATE SOURCE upsert
  405. IN CLUSTER ${arg.single-replica-cluster}
  406. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  407. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  408. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  409. ENVELOPE DEBEZIUM
  410. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  411. > CREATE DEFAULT INDEX ON mv
  412. > DROP SOURCE upsert CASCADE
  413. > CREATE SOURCE upsert
  414. IN CLUSTER ${arg.single-replica-cluster}
  415. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  416. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  417. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  418. ENVELOPE DEBEZIUM
  419. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  420. > CREATE DEFAULT INDEX ON mv
  421. > DROP SOURCE upsert CASCADE
  422. > CREATE SOURCE upsert
  423. IN CLUSTER ${arg.single-replica-cluster}
  424. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  425. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  426. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  427. ENVELOPE DEBEZIUM
  428. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  429. > CREATE DEFAULT INDEX ON mv
  430. > DROP SOURCE upsert CASCADE
  431. > CREATE SOURCE upsert
  432. IN CLUSTER ${arg.single-replica-cluster}
  433. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  434. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  435. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  436. ENVELOPE DEBEZIUM
  437. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  438. > CREATE DEFAULT INDEX ON mv
  439. > DROP SOURCE upsert CASCADE
  440. > CREATE SOURCE upsert
  441. IN CLUSTER ${arg.single-replica-cluster}
  442. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  443. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  444. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  445. ENVELOPE DEBEZIUM
  446. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  447. > CREATE DEFAULT INDEX ON mv
  448. > DROP SOURCE upsert CASCADE
  449. > CREATE SOURCE upsert
  450. IN CLUSTER ${arg.single-replica-cluster}
  451. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  452. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  453. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  454. ENVELOPE DEBEZIUM
  455. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  456. > CREATE DEFAULT INDEX ON mv
  457. > DROP SOURCE upsert CASCADE
  458. > CREATE SOURCE upsert
  459. IN CLUSTER ${arg.single-replica-cluster}
  460. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  461. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  462. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  463. ENVELOPE DEBEZIUM
  464. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  465. > CREATE DEFAULT INDEX ON mv
  466. > DROP SOURCE upsert CASCADE
  467. > CREATE SOURCE upsert
  468. IN CLUSTER ${arg.single-replica-cluster}
  469. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  470. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  471. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  472. ENVELOPE DEBEZIUM
  473. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  474. > CREATE DEFAULT INDEX ON mv
  475. > DROP SOURCE upsert CASCADE
  476. > CREATE SOURCE upsert
  477. IN CLUSTER ${arg.single-replica-cluster}
  478. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  479. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  480. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  481. ENVELOPE DEBEZIUM
  482. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  483. > CREATE DEFAULT INDEX ON mv
  484. > DROP SOURCE upsert CASCADE
  485. > CREATE SOURCE upsert
  486. IN CLUSTER ${arg.single-replica-cluster}
  487. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  488. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  489. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  490. ENVELOPE DEBEZIUM
  491. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  492. > CREATE DEFAULT INDEX ON mv
  493. > DROP SOURCE upsert CASCADE
  494. > CREATE SOURCE upsert
  495. IN CLUSTER ${arg.single-replica-cluster}
  496. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  497. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  498. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  499. ENVELOPE DEBEZIUM
  500. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  501. > CREATE DEFAULT INDEX ON mv
  502. > DROP SOURCE upsert CASCADE
  503. > CREATE SOURCE upsert
  504. IN CLUSTER ${arg.single-replica-cluster}
  505. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  506. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  507. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  508. ENVELOPE DEBEZIUM
  509. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  510. > CREATE DEFAULT INDEX ON mv
  511. > DROP SOURCE upsert CASCADE
  512. > CREATE SOURCE upsert
  513. IN CLUSTER ${arg.single-replica-cluster}
  514. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  515. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  516. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  517. ENVELOPE DEBEZIUM
  518. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  519. > CREATE DEFAULT INDEX ON mv
  520. > DROP SOURCE upsert CASCADE
  521. > CREATE SOURCE upsert
  522. IN CLUSTER ${arg.single-replica-cluster}
  523. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  524. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  525. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  526. ENVELOPE DEBEZIUM
  527. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  528. > CREATE DEFAULT INDEX ON mv
  529. > DROP SOURCE upsert CASCADE
  530. > CREATE SOURCE upsert
  531. IN CLUSTER ${arg.single-replica-cluster}
  532. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  533. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  534. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  535. ENVELOPE DEBEZIUM
  536. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  537. > CREATE DEFAULT INDEX ON mv
  538. > DROP SOURCE upsert CASCADE
  539. > CREATE SOURCE upsert
  540. IN CLUSTER ${arg.single-replica-cluster}
  541. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  542. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  543. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  544. ENVELOPE DEBEZIUM
  545. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  546. > CREATE DEFAULT INDEX ON mv
  547. > DROP SOURCE upsert CASCADE
  548. > CREATE SOURCE upsert
  549. IN CLUSTER ${arg.single-replica-cluster}
  550. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  551. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  552. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  553. ENVELOPE DEBEZIUM
  554. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  555. > CREATE DEFAULT INDEX ON mv
  556. > DROP SOURCE upsert CASCADE
  557. > CREATE SOURCE upsert
  558. IN CLUSTER ${arg.single-replica-cluster}
  559. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  560. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  561. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  562. ENVELOPE DEBEZIUM
  563. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  564. > CREATE DEFAULT INDEX ON mv
  565. > DROP SOURCE upsert CASCADE
  566. > CREATE SOURCE upsert
  567. IN CLUSTER ${arg.single-replica-cluster}
  568. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  569. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  570. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  571. ENVELOPE DEBEZIUM
  572. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  573. > CREATE DEFAULT INDEX ON mv
  574. > DROP SOURCE upsert CASCADE
  575. > CREATE SOURCE upsert
  576. IN CLUSTER ${arg.single-replica-cluster}
  577. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  578. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  579. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  580. ENVELOPE DEBEZIUM
  581. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  582. > CREATE DEFAULT INDEX ON mv
  583. > DROP SOURCE upsert CASCADE
  584. > CREATE SOURCE upsert
  585. IN CLUSTER ${arg.single-replica-cluster}
  586. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  587. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  588. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  589. ENVELOPE DEBEZIUM
  590. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  591. > CREATE DEFAULT INDEX ON mv
  592. > DROP SOURCE upsert CASCADE
  593. > CREATE SOURCE upsert
  594. IN CLUSTER ${arg.single-replica-cluster}
  595. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  596. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  597. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  598. ENVELOPE DEBEZIUM
  599. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  600. > CREATE DEFAULT INDEX ON mv
  601. > DROP SOURCE upsert CASCADE
  602. > CREATE SOURCE upsert
  603. IN CLUSTER ${arg.single-replica-cluster}
  604. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  605. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  606. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  607. ENVELOPE DEBEZIUM
  608. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  609. > CREATE DEFAULT INDEX ON mv
  610. > DROP SOURCE upsert CASCADE
  611. > CREATE SOURCE upsert
  612. IN CLUSTER ${arg.single-replica-cluster}
  613. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  614. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  615. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  616. ENVELOPE DEBEZIUM
  617. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  618. > CREATE DEFAULT INDEX ON mv
  619. > DROP SOURCE upsert CASCADE
  620. > CREATE SOURCE upsert
  621. IN CLUSTER ${arg.single-replica-cluster}
  622. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  623. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  624. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  625. ENVELOPE DEBEZIUM
  626. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  627. > CREATE DEFAULT INDEX ON mv
  628. > DROP SOURCE upsert CASCADE
  629. > CREATE SOURCE upsert
  630. IN CLUSTER ${arg.single-replica-cluster}
  631. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  632. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  633. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  634. ENVELOPE DEBEZIUM
  635. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  636. > CREATE DEFAULT INDEX ON mv
  637. > DROP SOURCE upsert CASCADE
  638. > CREATE SOURCE upsert
  639. IN CLUSTER ${arg.single-replica-cluster}
  640. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  641. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  642. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  643. ENVELOPE DEBEZIUM
  644. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  645. > CREATE DEFAULT INDEX ON mv
  646. > DROP SOURCE upsert CASCADE
  647. > CREATE SOURCE upsert
  648. IN CLUSTER ${arg.single-replica-cluster}
  649. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  650. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  651. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  652. ENVELOPE DEBEZIUM
  653. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  654. > CREATE DEFAULT INDEX ON mv
  655. > DROP SOURCE upsert CASCADE
  656. > CREATE SOURCE upsert
  657. IN CLUSTER ${arg.single-replica-cluster}
  658. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  659. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  660. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  661. ENVELOPE DEBEZIUM
  662. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  663. > CREATE DEFAULT INDEX ON mv
  664. > DROP SOURCE upsert CASCADE
  665. > CREATE SOURCE upsert
  666. IN CLUSTER ${arg.single-replica-cluster}
  667. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  668. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  669. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  670. ENVELOPE DEBEZIUM
  671. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  672. > CREATE DEFAULT INDEX ON mv
  673. > DROP SOURCE upsert CASCADE
  674. > CREATE SOURCE upsert
  675. IN CLUSTER ${arg.single-replica-cluster}
  676. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  677. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  678. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  679. ENVELOPE DEBEZIUM
  680. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  681. > CREATE DEFAULT INDEX ON mv
  682. > DROP SOURCE upsert CASCADE
  683. > CREATE SOURCE upsert
  684. IN CLUSTER ${arg.single-replica-cluster}
  685. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  686. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  687. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  688. ENVELOPE DEBEZIUM
  689. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  690. > CREATE DEFAULT INDEX ON mv
  691. > DROP SOURCE upsert CASCADE
  692. > CREATE SOURCE upsert
  693. IN CLUSTER ${arg.single-replica-cluster}
  694. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  695. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  696. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  697. ENVELOPE DEBEZIUM
  698. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  699. > CREATE DEFAULT INDEX ON mv
  700. > DROP SOURCE upsert CASCADE
  701. > CREATE SOURCE upsert
  702. IN CLUSTER ${arg.single-replica-cluster}
  703. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  704. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  705. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  706. ENVELOPE DEBEZIUM
  707. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  708. > CREATE DEFAULT INDEX ON mv
  709. > DROP SOURCE upsert CASCADE
  710. > CREATE SOURCE upsert
  711. IN CLUSTER ${arg.single-replica-cluster}
  712. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  713. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  714. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  715. ENVELOPE DEBEZIUM
  716. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  717. > CREATE DEFAULT INDEX ON mv
  718. > DROP SOURCE upsert CASCADE
  719. > CREATE SOURCE upsert
  720. IN CLUSTER ${arg.single-replica-cluster}
  721. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  722. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  723. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  724. ENVELOPE DEBEZIUM
  725. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  726. > CREATE DEFAULT INDEX ON mv
  727. > DROP SOURCE upsert CASCADE
  728. > CREATE SOURCE upsert
  729. IN CLUSTER ${arg.single-replica-cluster}
  730. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  731. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  732. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  733. ENVELOPE DEBEZIUM
  734. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  735. > CREATE DEFAULT INDEX ON mv
  736. > DROP SOURCE upsert CASCADE
  737. > CREATE SOURCE upsert
  738. IN CLUSTER ${arg.single-replica-cluster}
  739. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  740. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  741. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  742. ENVELOPE DEBEZIUM
  743. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  744. > CREATE DEFAULT INDEX ON mv
  745. > DROP SOURCE upsert CASCADE
  746. > CREATE SOURCE upsert
  747. IN CLUSTER ${arg.single-replica-cluster}
  748. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  749. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  750. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  751. ENVELOPE DEBEZIUM
  752. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  753. > CREATE DEFAULT INDEX ON mv
  754. > DROP SOURCE upsert CASCADE
  755. > CREATE SOURCE upsert
  756. IN CLUSTER ${arg.single-replica-cluster}
  757. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  758. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  759. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  760. ENVELOPE DEBEZIUM
  761. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  762. > CREATE DEFAULT INDEX ON mv
  763. > DROP SOURCE upsert CASCADE
  764. > CREATE SOURCE upsert
  765. IN CLUSTER ${arg.single-replica-cluster}
  766. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  767. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  768. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  769. ENVELOPE DEBEZIUM
  770. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  771. > CREATE DEFAULT INDEX ON mv
  772. > DROP SOURCE upsert CASCADE
  773. > CREATE SOURCE upsert
  774. IN CLUSTER ${arg.single-replica-cluster}
  775. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  776. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  777. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  778. ENVELOPE DEBEZIUM
  779. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  780. > CREATE DEFAULT INDEX ON mv
  781. > DROP SOURCE upsert CASCADE
  782. > CREATE SOURCE upsert
  783. IN CLUSTER ${arg.single-replica-cluster}
  784. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  785. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  786. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  787. ENVELOPE DEBEZIUM
  788. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  789. > CREATE DEFAULT INDEX ON mv
  790. > DROP SOURCE upsert CASCADE
  791. > CREATE SOURCE upsert
  792. IN CLUSTER ${arg.single-replica-cluster}
  793. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  794. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  795. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  796. ENVELOPE DEBEZIUM
  797. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  798. > CREATE DEFAULT INDEX ON mv
  799. > DROP SOURCE upsert CASCADE
  800. > CREATE SOURCE upsert
  801. IN CLUSTER ${arg.single-replica-cluster}
  802. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  803. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  804. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  805. ENVELOPE DEBEZIUM
  806. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  807. > CREATE DEFAULT INDEX ON mv
  808. > DROP SOURCE upsert CASCADE
  809. > CREATE SOURCE upsert
  810. IN CLUSTER ${arg.single-replica-cluster}
  811. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  812. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  813. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  814. ENVELOPE DEBEZIUM
  815. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  816. > CREATE DEFAULT INDEX ON mv
  817. > DROP SOURCE upsert CASCADE
  818. > CREATE SOURCE upsert
  819. IN CLUSTER ${arg.single-replica-cluster}
  820. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  821. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  822. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  823. ENVELOPE DEBEZIUM
  824. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  825. > CREATE DEFAULT INDEX ON mv
  826. > DROP SOURCE upsert CASCADE
  827. > CREATE SOURCE upsert
  828. IN CLUSTER ${arg.single-replica-cluster}
  829. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  830. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  831. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  832. ENVELOPE DEBEZIUM
  833. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  834. > CREATE DEFAULT INDEX ON mv
  835. > DROP SOURCE upsert CASCADE
  836. > CREATE SOURCE upsert
  837. IN CLUSTER ${arg.single-replica-cluster}
  838. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  839. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  840. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  841. ENVELOPE DEBEZIUM
  842. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  843. > CREATE DEFAULT INDEX ON mv
  844. > DROP SOURCE upsert CASCADE
  845. > CREATE SOURCE upsert
  846. IN CLUSTER ${arg.single-replica-cluster}
  847. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  848. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  849. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  850. ENVELOPE DEBEZIUM
  851. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  852. > CREATE DEFAULT INDEX ON mv
  853. > DROP SOURCE upsert CASCADE
  854. > CREATE SOURCE upsert
  855. IN CLUSTER ${arg.single-replica-cluster}
  856. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  857. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  858. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  859. ENVELOPE DEBEZIUM
  860. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  861. > CREATE DEFAULT INDEX ON mv
  862. > DROP SOURCE upsert CASCADE
  863. > CREATE SOURCE upsert
  864. IN CLUSTER ${arg.single-replica-cluster}
  865. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  866. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  867. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  868. ENVELOPE DEBEZIUM
  869. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  870. > CREATE DEFAULT INDEX ON mv
  871. > DROP SOURCE upsert CASCADE
  872. > CREATE SOURCE upsert
  873. IN CLUSTER ${arg.single-replica-cluster}
  874. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  875. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  876. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  877. ENVELOPE DEBEZIUM
  878. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  879. > CREATE DEFAULT INDEX ON mv
  880. > DROP SOURCE upsert CASCADE
  881. > CREATE SOURCE upsert
  882. IN CLUSTER ${arg.single-replica-cluster}
  883. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  884. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  885. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  886. ENVELOPE DEBEZIUM
  887. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  888. > CREATE DEFAULT INDEX ON mv
  889. > DROP SOURCE upsert CASCADE
  890. > CREATE SOURCE upsert
  891. IN CLUSTER ${arg.single-replica-cluster}
  892. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  893. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  894. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  895. ENVELOPE DEBEZIUM
  896. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  897. > CREATE DEFAULT INDEX ON mv
  898. > DROP SOURCE upsert CASCADE
  899. > CREATE SOURCE upsert
  900. IN CLUSTER ${arg.single-replica-cluster}
  901. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  902. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  903. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  904. ENVELOPE DEBEZIUM
  905. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  906. > CREATE DEFAULT INDEX ON mv
  907. > DROP SOURCE upsert CASCADE
  908. > CREATE SOURCE upsert
  909. IN CLUSTER ${arg.single-replica-cluster}
  910. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  911. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  912. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  913. ENVELOPE DEBEZIUM
  914. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  915. > CREATE DEFAULT INDEX ON mv
  916. > DROP SOURCE upsert CASCADE
  917. > CREATE SOURCE upsert
  918. IN CLUSTER ${arg.single-replica-cluster}
  919. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  920. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  921. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  922. ENVELOPE DEBEZIUM
  923. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  924. > CREATE DEFAULT INDEX ON mv
  925. > DROP SOURCE upsert CASCADE
  926. > CREATE SOURCE upsert
  927. IN CLUSTER ${arg.single-replica-cluster}
  928. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  929. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  930. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  931. ENVELOPE DEBEZIUM
  932. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  933. > CREATE DEFAULT INDEX ON mv
  934. > DROP SOURCE upsert CASCADE
  935. > CREATE SOURCE upsert
  936. IN CLUSTER ${arg.single-replica-cluster}
  937. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  938. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  939. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  940. ENVELOPE DEBEZIUM
  941. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  942. > CREATE DEFAULT INDEX ON mv
  943. > DROP SOURCE upsert CASCADE
  944. > CREATE SOURCE upsert
  945. IN CLUSTER ${arg.single-replica-cluster}
  946. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  947. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  948. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  949. ENVELOPE DEBEZIUM
  950. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  951. > CREATE DEFAULT INDEX ON mv
  952. > DROP SOURCE upsert CASCADE
  953. > CREATE SOURCE upsert
  954. IN CLUSTER ${arg.single-replica-cluster}
  955. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  956. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  957. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  958. ENVELOPE DEBEZIUM
  959. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  960. > CREATE DEFAULT INDEX ON mv
  961. > DROP SOURCE upsert CASCADE
  962. > CREATE SOURCE upsert
  963. IN CLUSTER ${arg.single-replica-cluster}
  964. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  965. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  966. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  967. ENVELOPE DEBEZIUM
  968. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  969. > CREATE DEFAULT INDEX ON mv
  970. > DROP SOURCE upsert CASCADE
  971. > CREATE SOURCE upsert
  972. IN CLUSTER ${arg.single-replica-cluster}
  973. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  974. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  975. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  976. ENVELOPE DEBEZIUM
  977. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  978. > CREATE DEFAULT INDEX ON mv
  979. > DROP SOURCE upsert CASCADE
  980. > CREATE SOURCE upsert
  981. IN CLUSTER ${arg.single-replica-cluster}
  982. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  983. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  984. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  985. ENVELOPE DEBEZIUM
  986. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  987. > CREATE DEFAULT INDEX ON mv
  988. > DROP SOURCE upsert CASCADE
  989. > CREATE SOURCE upsert
  990. IN CLUSTER ${arg.single-replica-cluster}
  991. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  992. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  993. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  994. ENVELOPE DEBEZIUM
  995. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  996. > CREATE DEFAULT INDEX ON mv
  997. > DROP SOURCE upsert CASCADE
  998. > CREATE SOURCE upsert
  999. IN CLUSTER ${arg.single-replica-cluster}
  1000. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1001. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1002. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1003. ENVELOPE DEBEZIUM
  1004. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1005. > CREATE DEFAULT INDEX ON mv
  1006. > DROP SOURCE upsert CASCADE
  1007. > CREATE SOURCE upsert
  1008. IN CLUSTER ${arg.single-replica-cluster}
  1009. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1010. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1011. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1012. ENVELOPE DEBEZIUM
  1013. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1014. > CREATE DEFAULT INDEX ON mv
  1015. > DROP SOURCE upsert CASCADE
  1016. > CREATE SOURCE upsert
  1017. IN CLUSTER ${arg.single-replica-cluster}
  1018. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1019. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1020. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1021. ENVELOPE DEBEZIUM
  1022. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1023. > CREATE DEFAULT INDEX ON mv
  1024. > DROP SOURCE upsert CASCADE
  1025. > CREATE SOURCE upsert
  1026. IN CLUSTER ${arg.single-replica-cluster}
  1027. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1028. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1029. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1030. ENVELOPE DEBEZIUM
  1031. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1032. > CREATE DEFAULT INDEX ON mv
  1033. > DROP SOURCE upsert CASCADE
  1034. > CREATE SOURCE upsert
  1035. IN CLUSTER ${arg.single-replica-cluster}
  1036. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1037. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1038. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1039. ENVELOPE DEBEZIUM
  1040. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1041. > CREATE DEFAULT INDEX ON mv
  1042. > DROP SOURCE upsert CASCADE
  1043. > CREATE SOURCE upsert
  1044. IN CLUSTER ${arg.single-replica-cluster}
  1045. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1046. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1047. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1048. ENVELOPE DEBEZIUM
  1049. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1050. > CREATE DEFAULT INDEX ON mv
  1051. > DROP SOURCE upsert CASCADE
  1052. > CREATE SOURCE upsert
  1053. IN CLUSTER ${arg.single-replica-cluster}
  1054. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1055. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1056. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1057. ENVELOPE DEBEZIUM
  1058. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1059. > CREATE DEFAULT INDEX ON mv
  1060. > DROP SOURCE upsert CASCADE
  1061. > CREATE SOURCE upsert
  1062. IN CLUSTER ${arg.single-replica-cluster}
  1063. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1064. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1065. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1066. ENVELOPE DEBEZIUM
  1067. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1068. > CREATE DEFAULT INDEX ON mv
  1069. > DROP SOURCE upsert CASCADE
  1070. > CREATE SOURCE upsert
  1071. IN CLUSTER ${arg.single-replica-cluster}
  1072. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1073. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1074. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1075. ENVELOPE DEBEZIUM
  1076. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1077. > CREATE DEFAULT INDEX ON mv
  1078. > DROP SOURCE upsert CASCADE
  1079. > CREATE SOURCE upsert
  1080. IN CLUSTER ${arg.single-replica-cluster}
  1081. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1082. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1083. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1084. ENVELOPE DEBEZIUM
  1085. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1086. > CREATE DEFAULT INDEX ON mv
  1087. > DROP SOURCE upsert CASCADE
  1088. > CREATE SOURCE upsert
  1089. IN CLUSTER ${arg.single-replica-cluster}
  1090. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1091. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1092. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1093. ENVELOPE DEBEZIUM
  1094. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1095. > CREATE DEFAULT INDEX ON mv
  1096. > DROP SOURCE upsert CASCADE
  1097. > CREATE SOURCE upsert
  1098. IN CLUSTER ${arg.single-replica-cluster}
  1099. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1100. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1101. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1102. ENVELOPE DEBEZIUM
  1103. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1104. > CREATE DEFAULT INDEX ON mv
  1105. > DROP SOURCE upsert CASCADE
  1106. > CREATE SOURCE upsert
  1107. IN CLUSTER ${arg.single-replica-cluster}
  1108. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1109. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1110. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1111. ENVELOPE DEBEZIUM
  1112. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1113. > CREATE DEFAULT INDEX ON mv
  1114. > DROP SOURCE upsert CASCADE
  1115. > CREATE SOURCE upsert
  1116. IN CLUSTER ${arg.single-replica-cluster}
  1117. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1118. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1119. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1120. ENVELOPE DEBEZIUM
  1121. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1122. > CREATE DEFAULT INDEX ON mv
  1123. > DROP SOURCE upsert CASCADE
  1124. > CREATE SOURCE upsert
  1125. IN CLUSTER ${arg.single-replica-cluster}
  1126. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1127. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1128. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1129. ENVELOPE DEBEZIUM
  1130. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1131. > CREATE DEFAULT INDEX ON mv
  1132. > DROP SOURCE upsert CASCADE
  1133. > CREATE SOURCE upsert
  1134. IN CLUSTER ${arg.single-replica-cluster}
  1135. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1136. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1137. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1138. ENVELOPE DEBEZIUM
  1139. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1140. > CREATE DEFAULT INDEX ON mv
  1141. > DROP SOURCE upsert CASCADE
  1142. > CREATE SOURCE upsert
  1143. IN CLUSTER ${arg.single-replica-cluster}
  1144. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1145. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1146. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1147. ENVELOPE DEBEZIUM
  1148. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1149. > CREATE DEFAULT INDEX ON mv
  1150. > DROP SOURCE upsert CASCADE
  1151. > CREATE SOURCE upsert
  1152. IN CLUSTER ${arg.single-replica-cluster}
  1153. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1154. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1155. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1156. ENVELOPE DEBEZIUM
  1157. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1158. > CREATE DEFAULT INDEX ON mv
  1159. > DROP SOURCE upsert CASCADE
  1160. > CREATE SOURCE upsert
  1161. IN CLUSTER ${arg.single-replica-cluster}
  1162. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1163. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1164. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1165. ENVELOPE DEBEZIUM
  1166. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1167. > CREATE DEFAULT INDEX ON mv
  1168. > DROP SOURCE upsert CASCADE
  1169. > CREATE SOURCE upsert
  1170. IN CLUSTER ${arg.single-replica-cluster}
  1171. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1172. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1173. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1174. ENVELOPE DEBEZIUM
  1175. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1176. > CREATE DEFAULT INDEX ON mv
  1177. > DROP SOURCE upsert CASCADE
  1178. > CREATE SOURCE upsert
  1179. IN CLUSTER ${arg.single-replica-cluster}
  1180. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1181. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1182. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1183. ENVELOPE DEBEZIUM
  1184. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1185. > CREATE DEFAULT INDEX ON mv
  1186. > DROP SOURCE upsert CASCADE
  1187. > CREATE SOURCE upsert
  1188. IN CLUSTER ${arg.single-replica-cluster}
  1189. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1190. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1191. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1192. ENVELOPE DEBEZIUM
  1193. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1194. > CREATE DEFAULT INDEX ON mv
  1195. > DROP SOURCE upsert CASCADE
  1196. > CREATE SOURCE upsert
  1197. IN CLUSTER ${arg.single-replica-cluster}
  1198. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1199. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1200. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1201. ENVELOPE DEBEZIUM
  1202. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1203. > CREATE DEFAULT INDEX ON mv
  1204. > DROP SOURCE upsert CASCADE
  1205. > CREATE SOURCE upsert
  1206. IN CLUSTER ${arg.single-replica-cluster}
  1207. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1208. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1209. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1210. ENVELOPE DEBEZIUM
  1211. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1212. > CREATE DEFAULT INDEX ON mv
  1213. > DROP SOURCE upsert CASCADE
  1214. > CREATE SOURCE upsert
  1215. IN CLUSTER ${arg.single-replica-cluster}
  1216. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1217. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1218. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1219. ENVELOPE DEBEZIUM
  1220. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1221. > CREATE DEFAULT INDEX ON mv
  1222. > DROP SOURCE upsert CASCADE
  1223. > CREATE SOURCE upsert
  1224. IN CLUSTER ${arg.single-replica-cluster}
  1225. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1226. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1227. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1228. ENVELOPE DEBEZIUM
  1229. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1230. > CREATE DEFAULT INDEX ON mv
  1231. > DROP SOURCE upsert CASCADE
  1232. > CREATE SOURCE upsert
  1233. IN CLUSTER ${arg.single-replica-cluster}
  1234. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1235. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1236. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1237. ENVELOPE DEBEZIUM
  1238. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1239. > CREATE DEFAULT INDEX ON mv
  1240. > DROP SOURCE upsert CASCADE
  1241. > CREATE SOURCE upsert
  1242. IN CLUSTER ${arg.single-replica-cluster}
  1243. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1244. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1245. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1246. ENVELOPE DEBEZIUM
  1247. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1248. > CREATE DEFAULT INDEX ON mv
  1249. > DROP SOURCE upsert CASCADE
  1250. > CREATE SOURCE upsert
  1251. IN CLUSTER ${arg.single-replica-cluster}
  1252. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1253. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1254. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1255. ENVELOPE DEBEZIUM
  1256. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1257. > CREATE DEFAULT INDEX ON mv
  1258. > DROP SOURCE upsert CASCADE
  1259. > CREATE SOURCE upsert
  1260. IN CLUSTER ${arg.single-replica-cluster}
  1261. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1262. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1263. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1264. ENVELOPE DEBEZIUM
  1265. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1266. > CREATE DEFAULT INDEX ON mv
  1267. > DROP SOURCE upsert CASCADE
  1268. > CREATE SOURCE upsert
  1269. IN CLUSTER ${arg.single-replica-cluster}
  1270. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1271. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1272. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1273. ENVELOPE DEBEZIUM
  1274. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1275. > CREATE DEFAULT INDEX ON mv
  1276. > DROP SOURCE upsert CASCADE
  1277. > CREATE SOURCE upsert
  1278. IN CLUSTER ${arg.single-replica-cluster}
  1279. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1280. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1281. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1282. ENVELOPE DEBEZIUM
  1283. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1284. > CREATE DEFAULT INDEX ON mv
  1285. > DROP SOURCE upsert CASCADE
  1286. > CREATE SOURCE upsert
  1287. IN CLUSTER ${arg.single-replica-cluster}
  1288. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1289. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1290. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1291. ENVELOPE DEBEZIUM
  1292. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1293. > CREATE DEFAULT INDEX ON mv
  1294. > DROP SOURCE upsert CASCADE
  1295. > CREATE SOURCE upsert
  1296. IN CLUSTER ${arg.single-replica-cluster}
  1297. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1298. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1299. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1300. ENVELOPE DEBEZIUM
  1301. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1302. > CREATE DEFAULT INDEX ON mv
  1303. > DROP SOURCE upsert CASCADE
  1304. > CREATE SOURCE upsert
  1305. IN CLUSTER ${arg.single-replica-cluster}
  1306. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1307. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1308. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1309. ENVELOPE DEBEZIUM
  1310. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1311. > CREATE DEFAULT INDEX ON mv
  1312. > DROP SOURCE upsert CASCADE
  1313. > CREATE SOURCE upsert
  1314. IN CLUSTER ${arg.single-replica-cluster}
  1315. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1316. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1317. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1318. ENVELOPE DEBEZIUM
  1319. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1320. > CREATE DEFAULT INDEX ON mv
  1321. > DROP SOURCE upsert CASCADE
  1322. > CREATE SOURCE upsert
  1323. IN CLUSTER ${arg.single-replica-cluster}
  1324. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1325. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1326. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1327. ENVELOPE DEBEZIUM
  1328. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1329. > CREATE DEFAULT INDEX ON mv
  1330. > DROP SOURCE upsert CASCADE
  1331. > CREATE SOURCE upsert
  1332. IN CLUSTER ${arg.single-replica-cluster}
  1333. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1334. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1335. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1336. ENVELOPE DEBEZIUM
  1337. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1338. > CREATE DEFAULT INDEX ON mv
  1339. > DROP SOURCE upsert CASCADE
  1340. > CREATE SOURCE upsert
  1341. IN CLUSTER ${arg.single-replica-cluster}
  1342. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1343. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1344. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1345. ENVELOPE DEBEZIUM
  1346. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1347. > CREATE DEFAULT INDEX ON mv
  1348. > DROP SOURCE upsert CASCADE
  1349. > CREATE SOURCE upsert
  1350. IN CLUSTER ${arg.single-replica-cluster}
  1351. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1352. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1353. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1354. ENVELOPE DEBEZIUM
  1355. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1356. > CREATE DEFAULT INDEX ON mv
  1357. > DROP SOURCE upsert CASCADE
  1358. > CREATE SOURCE upsert
  1359. IN CLUSTER ${arg.single-replica-cluster}
  1360. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1361. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1362. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1363. ENVELOPE DEBEZIUM
  1364. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1365. > CREATE DEFAULT INDEX ON mv
  1366. > DROP SOURCE upsert CASCADE
  1367. > CREATE SOURCE upsert
  1368. IN CLUSTER ${arg.single-replica-cluster}
  1369. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1370. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1371. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1372. ENVELOPE DEBEZIUM
  1373. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1374. > CREATE DEFAULT INDEX ON mv
  1375. > DROP SOURCE upsert CASCADE
  1376. > CREATE SOURCE upsert
  1377. IN CLUSTER ${arg.single-replica-cluster}
  1378. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1379. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1380. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1381. ENVELOPE DEBEZIUM
  1382. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1383. > CREATE DEFAULT INDEX ON mv
  1384. > DROP SOURCE upsert CASCADE
  1385. > CREATE SOURCE upsert
  1386. IN CLUSTER ${arg.single-replica-cluster}
  1387. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1388. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1389. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1390. ENVELOPE DEBEZIUM
  1391. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1392. > CREATE DEFAULT INDEX ON mv
  1393. > DROP SOURCE upsert CASCADE
  1394. > CREATE SOURCE upsert
  1395. IN CLUSTER ${arg.single-replica-cluster}
  1396. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1397. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1398. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1399. ENVELOPE DEBEZIUM
  1400. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1401. > CREATE DEFAULT INDEX ON mv
  1402. > DROP SOURCE upsert CASCADE
  1403. > CREATE SOURCE upsert
  1404. IN CLUSTER ${arg.single-replica-cluster}
  1405. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1406. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1407. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1408. ENVELOPE DEBEZIUM
  1409. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1410. > CREATE DEFAULT INDEX ON mv
  1411. > DROP SOURCE upsert CASCADE
  1412. > CREATE SOURCE upsert
  1413. IN CLUSTER ${arg.single-replica-cluster}
  1414. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1415. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1416. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1417. ENVELOPE DEBEZIUM
  1418. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1419. > CREATE DEFAULT INDEX ON mv
  1420. > DROP SOURCE upsert CASCADE
  1421. > CREATE SOURCE upsert
  1422. IN CLUSTER ${arg.single-replica-cluster}
  1423. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1424. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1425. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1426. ENVELOPE DEBEZIUM
  1427. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1428. > CREATE DEFAULT INDEX ON mv
  1429. > DROP SOURCE upsert CASCADE
  1430. > CREATE SOURCE upsert
  1431. IN CLUSTER ${arg.single-replica-cluster}
  1432. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1433. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1434. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1435. ENVELOPE DEBEZIUM
  1436. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1437. > CREATE DEFAULT INDEX ON mv
  1438. > DROP SOURCE upsert CASCADE
  1439. > CREATE SOURCE upsert
  1440. IN CLUSTER ${arg.single-replica-cluster}
  1441. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1442. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1443. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1444. ENVELOPE DEBEZIUM
  1445. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1446. > CREATE DEFAULT INDEX ON mv
  1447. > DROP SOURCE upsert CASCADE
  1448. > CREATE SOURCE upsert
  1449. IN CLUSTER ${arg.single-replica-cluster}
  1450. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1451. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1452. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1453. ENVELOPE DEBEZIUM
  1454. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1455. > CREATE DEFAULT INDEX ON mv
  1456. > DROP SOURCE upsert CASCADE
  1457. > CREATE SOURCE upsert
  1458. IN CLUSTER ${arg.single-replica-cluster}
  1459. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1460. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1461. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1462. ENVELOPE DEBEZIUM
  1463. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1464. > CREATE DEFAULT INDEX ON mv
  1465. > DROP SOURCE upsert CASCADE
  1466. > CREATE SOURCE upsert
  1467. IN CLUSTER ${arg.single-replica-cluster}
  1468. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1469. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1470. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1471. ENVELOPE DEBEZIUM
  1472. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1473. > CREATE DEFAULT INDEX ON mv
  1474. > DROP SOURCE upsert CASCADE
  1475. > CREATE SOURCE upsert
  1476. IN CLUSTER ${arg.single-replica-cluster}
  1477. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1478. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1479. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1480. ENVELOPE DEBEZIUM
  1481. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1482. > CREATE DEFAULT INDEX ON mv
  1483. > DROP SOURCE upsert CASCADE
  1484. > CREATE SOURCE upsert
  1485. IN CLUSTER ${arg.single-replica-cluster}
  1486. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1487. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1488. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1489. ENVELOPE DEBEZIUM
  1490. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1491. > CREATE DEFAULT INDEX ON mv
  1492. > DROP SOURCE upsert CASCADE
  1493. > CREATE SOURCE upsert
  1494. IN CLUSTER ${arg.single-replica-cluster}
  1495. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1496. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1497. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1498. ENVELOPE DEBEZIUM
  1499. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1500. > CREATE DEFAULT INDEX ON mv
  1501. > DROP SOURCE upsert CASCADE
  1502. > CREATE SOURCE upsert
  1503. IN CLUSTER ${arg.single-replica-cluster}
  1504. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1505. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1506. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1507. ENVELOPE DEBEZIUM
  1508. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1509. > CREATE DEFAULT INDEX ON mv
  1510. > DROP SOURCE upsert CASCADE
  1511. > CREATE SOURCE upsert
  1512. IN CLUSTER ${arg.single-replica-cluster}
  1513. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1514. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1515. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1516. ENVELOPE DEBEZIUM
  1517. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1518. > CREATE DEFAULT INDEX ON mv
  1519. > DROP SOURCE upsert CASCADE
  1520. > CREATE SOURCE upsert
  1521. IN CLUSTER ${arg.single-replica-cluster}
  1522. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1523. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1524. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1525. ENVELOPE DEBEZIUM
  1526. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1527. > CREATE DEFAULT INDEX ON mv
  1528. > DROP SOURCE upsert CASCADE
  1529. > CREATE SOURCE upsert
  1530. IN CLUSTER ${arg.single-replica-cluster}
  1531. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1532. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1533. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1534. ENVELOPE DEBEZIUM
  1535. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1536. > CREATE DEFAULT INDEX ON mv
  1537. > DROP SOURCE upsert CASCADE
  1538. > CREATE SOURCE upsert
  1539. IN CLUSTER ${arg.single-replica-cluster}
  1540. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1541. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1542. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1543. ENVELOPE DEBEZIUM
  1544. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1545. > CREATE DEFAULT INDEX ON mv
  1546. > DROP SOURCE upsert CASCADE
  1547. > CREATE SOURCE upsert
  1548. IN CLUSTER ${arg.single-replica-cluster}
  1549. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1550. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1551. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1552. ENVELOPE DEBEZIUM
  1553. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1554. > CREATE DEFAULT INDEX ON mv
  1555. > DROP SOURCE upsert CASCADE
  1556. > CREATE SOURCE upsert
  1557. IN CLUSTER ${arg.single-replica-cluster}
  1558. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1559. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1560. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1561. ENVELOPE DEBEZIUM
  1562. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1563. > CREATE DEFAULT INDEX ON mv
  1564. > DROP SOURCE upsert CASCADE
  1565. > CREATE SOURCE upsert
  1566. IN CLUSTER ${arg.single-replica-cluster}
  1567. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1568. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1569. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1570. ENVELOPE DEBEZIUM
  1571. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1572. > CREATE DEFAULT INDEX ON mv
  1573. > DROP SOURCE upsert CASCADE
  1574. > CREATE SOURCE upsert
  1575. IN CLUSTER ${arg.single-replica-cluster}
  1576. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1577. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1578. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1579. ENVELOPE DEBEZIUM
  1580. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1581. > CREATE DEFAULT INDEX ON mv
  1582. > DROP SOURCE upsert CASCADE
  1583. > CREATE SOURCE upsert
  1584. IN CLUSTER ${arg.single-replica-cluster}
  1585. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1586. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1587. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1588. ENVELOPE DEBEZIUM
  1589. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1590. > CREATE DEFAULT INDEX ON mv
  1591. > DROP SOURCE upsert CASCADE
  1592. > CREATE SOURCE upsert
  1593. IN CLUSTER ${arg.single-replica-cluster}
  1594. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1595. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1596. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1597. ENVELOPE DEBEZIUM
  1598. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1599. > CREATE DEFAULT INDEX ON mv
  1600. > DROP SOURCE upsert CASCADE
  1601. > CREATE SOURCE upsert
  1602. IN CLUSTER ${arg.single-replica-cluster}
  1603. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1604. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1605. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1606. ENVELOPE DEBEZIUM
  1607. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1608. > CREATE DEFAULT INDEX ON mv
  1609. > DROP SOURCE upsert CASCADE
  1610. > CREATE SOURCE upsert
  1611. IN CLUSTER ${arg.single-replica-cluster}
  1612. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1613. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1614. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1615. ENVELOPE DEBEZIUM
  1616. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1617. > CREATE DEFAULT INDEX ON mv
  1618. > DROP SOURCE upsert CASCADE
  1619. > CREATE SOURCE upsert
  1620. IN CLUSTER ${arg.single-replica-cluster}
  1621. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1622. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1623. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1624. ENVELOPE DEBEZIUM
  1625. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1626. > CREATE DEFAULT INDEX ON mv
  1627. > DROP SOURCE upsert CASCADE
  1628. > CREATE SOURCE upsert
  1629. IN CLUSTER ${arg.single-replica-cluster}
  1630. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1631. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1632. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1633. ENVELOPE DEBEZIUM
  1634. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1635. > CREATE DEFAULT INDEX ON mv
  1636. > DROP SOURCE upsert CASCADE
  1637. > CREATE SOURCE upsert
  1638. IN CLUSTER ${arg.single-replica-cluster}
  1639. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1640. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1641. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1642. ENVELOPE DEBEZIUM
  1643. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1644. > CREATE DEFAULT INDEX ON mv
  1645. > DROP SOURCE upsert CASCADE
  1646. > CREATE SOURCE upsert
  1647. IN CLUSTER ${arg.single-replica-cluster}
  1648. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1649. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1650. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1651. ENVELOPE DEBEZIUM
  1652. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1653. > CREATE DEFAULT INDEX ON mv
  1654. > DROP SOURCE upsert CASCADE
  1655. > CREATE SOURCE upsert
  1656. IN CLUSTER ${arg.single-replica-cluster}
  1657. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1658. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1659. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1660. ENVELOPE DEBEZIUM
  1661. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1662. > CREATE DEFAULT INDEX ON mv
  1663. > DROP SOURCE upsert CASCADE
  1664. > CREATE SOURCE upsert
  1665. IN CLUSTER ${arg.single-replica-cluster}
  1666. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1667. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1668. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1669. ENVELOPE DEBEZIUM
  1670. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1671. > CREATE DEFAULT INDEX ON mv
  1672. > DROP SOURCE upsert CASCADE
  1673. > CREATE SOURCE upsert
  1674. IN CLUSTER ${arg.single-replica-cluster}
  1675. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1676. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1677. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1678. ENVELOPE DEBEZIUM
  1679. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1680. > CREATE DEFAULT INDEX ON mv
  1681. > DROP SOURCE upsert CASCADE
  1682. > CREATE SOURCE upsert
  1683. IN CLUSTER ${arg.single-replica-cluster}
  1684. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1685. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1686. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1687. ENVELOPE DEBEZIUM
  1688. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1689. > CREATE DEFAULT INDEX ON mv
  1690. > DROP SOURCE upsert CASCADE
  1691. > CREATE SOURCE upsert
  1692. IN CLUSTER ${arg.single-replica-cluster}
  1693. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1694. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1695. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1696. ENVELOPE DEBEZIUM
  1697. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1698. > CREATE DEFAULT INDEX ON mv
  1699. > DROP SOURCE upsert CASCADE
  1700. > CREATE SOURCE upsert
  1701. IN CLUSTER ${arg.single-replica-cluster}
  1702. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1703. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1704. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1705. ENVELOPE DEBEZIUM
  1706. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1707. > CREATE DEFAULT INDEX ON mv
  1708. > DROP SOURCE upsert CASCADE
  1709. > CREATE SOURCE upsert
  1710. IN CLUSTER ${arg.single-replica-cluster}
  1711. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1712. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1713. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1714. ENVELOPE DEBEZIUM
  1715. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1716. > CREATE DEFAULT INDEX ON mv
  1717. > DROP SOURCE upsert CASCADE
  1718. > CREATE SOURCE upsert
  1719. IN CLUSTER ${arg.single-replica-cluster}
  1720. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1721. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1722. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1723. ENVELOPE DEBEZIUM
  1724. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1725. > CREATE DEFAULT INDEX ON mv
  1726. > DROP SOURCE upsert CASCADE
  1727. > CREATE SOURCE upsert
  1728. IN CLUSTER ${arg.single-replica-cluster}
  1729. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1730. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1731. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1732. ENVELOPE DEBEZIUM
  1733. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1734. > CREATE DEFAULT INDEX ON mv
  1735. > DROP SOURCE upsert CASCADE
  1736. > CREATE SOURCE upsert
  1737. IN CLUSTER ${arg.single-replica-cluster}
  1738. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1739. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1740. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1741. ENVELOPE DEBEZIUM
  1742. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1743. > CREATE DEFAULT INDEX ON mv
  1744. > DROP SOURCE upsert CASCADE
  1745. > CREATE SOURCE upsert
  1746. IN CLUSTER ${arg.single-replica-cluster}
  1747. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1748. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1749. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1750. ENVELOPE DEBEZIUM
  1751. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1752. > CREATE DEFAULT INDEX ON mv
  1753. > DROP SOURCE upsert CASCADE
  1754. > CREATE SOURCE upsert
  1755. IN CLUSTER ${arg.single-replica-cluster}
  1756. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1757. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1758. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1759. ENVELOPE DEBEZIUM
  1760. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1761. > CREATE DEFAULT INDEX ON mv
  1762. > DROP SOURCE upsert CASCADE
  1763. > CREATE SOURCE upsert
  1764. IN CLUSTER ${arg.single-replica-cluster}
  1765. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1766. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1767. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1768. ENVELOPE DEBEZIUM
  1769. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1770. > CREATE DEFAULT INDEX ON mv
  1771. > DROP SOURCE upsert CASCADE
  1772. > CREATE SOURCE upsert
  1773. IN CLUSTER ${arg.single-replica-cluster}
  1774. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1775. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1776. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1777. ENVELOPE DEBEZIUM
  1778. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1779. > CREATE DEFAULT INDEX ON mv
  1780. > DROP SOURCE upsert CASCADE
  1781. > CREATE SOURCE upsert
  1782. IN CLUSTER ${arg.single-replica-cluster}
  1783. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1784. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1785. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1786. ENVELOPE DEBEZIUM
  1787. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1788. > CREATE DEFAULT INDEX ON mv
  1789. > DROP SOURCE upsert CASCADE
  1790. > CREATE SOURCE upsert
  1791. IN CLUSTER ${arg.single-replica-cluster}
  1792. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1793. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1794. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1795. ENVELOPE DEBEZIUM
  1796. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1797. > CREATE DEFAULT INDEX ON mv
  1798. > DROP SOURCE upsert CASCADE
  1799. > CREATE SOURCE upsert
  1800. IN CLUSTER ${arg.single-replica-cluster}
  1801. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1802. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1803. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1804. ENVELOPE DEBEZIUM
  1805. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1806. > CREATE DEFAULT INDEX ON mv
  1807. > DROP SOURCE upsert CASCADE
  1808. > CREATE SOURCE upsert
  1809. IN CLUSTER ${arg.single-replica-cluster}
  1810. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1811. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1812. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1813. ENVELOPE DEBEZIUM
  1814. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1815. > CREATE DEFAULT INDEX ON mv
  1816. > DROP SOURCE upsert CASCADE
  1817. > CREATE SOURCE upsert
  1818. IN CLUSTER ${arg.single-replica-cluster}
  1819. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1820. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1821. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1822. ENVELOPE DEBEZIUM
  1823. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1824. > CREATE DEFAULT INDEX ON mv
  1825. > DROP SOURCE upsert CASCADE
  1826. > CREATE SOURCE upsert
  1827. IN CLUSTER ${arg.single-replica-cluster}
  1828. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1829. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1830. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1831. ENVELOPE DEBEZIUM
  1832. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1833. > CREATE DEFAULT INDEX ON mv
  1834. > DROP SOURCE upsert CASCADE
  1835. > CREATE SOURCE upsert
  1836. IN CLUSTER ${arg.single-replica-cluster}
  1837. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1838. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1839. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1840. ENVELOPE DEBEZIUM
  1841. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1842. > CREATE DEFAULT INDEX ON mv
  1843. > DROP SOURCE upsert CASCADE
  1844. > CREATE SOURCE upsert
  1845. IN CLUSTER ${arg.single-replica-cluster}
  1846. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1847. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1848. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1849. ENVELOPE DEBEZIUM
  1850. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1851. > CREATE DEFAULT INDEX ON mv
  1852. > DROP SOURCE upsert CASCADE
  1853. > CREATE SOURCE upsert
  1854. IN CLUSTER ${arg.single-replica-cluster}
  1855. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1856. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1857. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1858. ENVELOPE DEBEZIUM
  1859. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1860. > CREATE DEFAULT INDEX ON mv
  1861. > DROP SOURCE upsert CASCADE
  1862. > CREATE SOURCE upsert
  1863. IN CLUSTER ${arg.single-replica-cluster}
  1864. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1865. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1866. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1867. ENVELOPE DEBEZIUM
  1868. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1869. > CREATE DEFAULT INDEX ON mv
  1870. > DROP SOURCE upsert CASCADE
  1871. > CREATE SOURCE upsert
  1872. IN CLUSTER ${arg.single-replica-cluster}
  1873. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1874. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1875. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1876. ENVELOPE DEBEZIUM
  1877. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1878. > CREATE DEFAULT INDEX ON mv
  1879. > DROP SOURCE upsert CASCADE
  1880. > CREATE SOURCE upsert
  1881. IN CLUSTER ${arg.single-replica-cluster}
  1882. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1883. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1884. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1885. ENVELOPE DEBEZIUM
  1886. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1887. > CREATE DEFAULT INDEX ON mv
  1888. > DROP SOURCE upsert CASCADE
  1889. > CREATE SOURCE upsert
  1890. IN CLUSTER ${arg.single-replica-cluster}
  1891. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1892. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1893. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1894. ENVELOPE DEBEZIUM
  1895. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1896. > CREATE DEFAULT INDEX ON mv
  1897. > DROP SOURCE upsert CASCADE
  1898. > CREATE SOURCE upsert
  1899. IN CLUSTER ${arg.single-replica-cluster}
  1900. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1901. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1902. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1903. ENVELOPE DEBEZIUM
  1904. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1905. > CREATE DEFAULT INDEX ON mv
  1906. > DROP SOURCE upsert CASCADE
  1907. > CREATE SOURCE upsert
  1908. IN CLUSTER ${arg.single-replica-cluster}
  1909. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1910. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1911. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1912. ENVELOPE DEBEZIUM
  1913. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1914. > CREATE DEFAULT INDEX ON mv
  1915. > DROP SOURCE upsert CASCADE
  1916. > CREATE SOURCE upsert
  1917. IN CLUSTER ${arg.single-replica-cluster}
  1918. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1919. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1920. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1921. ENVELOPE DEBEZIUM
  1922. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1923. > CREATE DEFAULT INDEX ON mv
  1924. > DROP SOURCE upsert CASCADE
  1925. > CREATE SOURCE upsert
  1926. IN CLUSTER ${arg.single-replica-cluster}
  1927. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1928. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1929. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1930. ENVELOPE DEBEZIUM
  1931. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1932. > CREATE DEFAULT INDEX ON mv
  1933. > DROP SOURCE upsert CASCADE
  1934. > CREATE SOURCE upsert
  1935. IN CLUSTER ${arg.single-replica-cluster}
  1936. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1937. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1938. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1939. ENVELOPE DEBEZIUM
  1940. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1941. > CREATE DEFAULT INDEX ON mv
  1942. > DROP SOURCE upsert CASCADE
  1943. > CREATE SOURCE upsert
  1944. IN CLUSTER ${arg.single-replica-cluster}
  1945. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1946. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1947. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1948. ENVELOPE DEBEZIUM
  1949. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1950. > CREATE DEFAULT INDEX ON mv
  1951. > DROP SOURCE upsert CASCADE
  1952. > CREATE SOURCE upsert
  1953. IN CLUSTER ${arg.single-replica-cluster}
  1954. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1955. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1956. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1957. ENVELOPE DEBEZIUM
  1958. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1959. > CREATE DEFAULT INDEX ON mv
  1960. > DROP SOURCE upsert CASCADE
  1961. > CREATE SOURCE upsert
  1962. IN CLUSTER ${arg.single-replica-cluster}
  1963. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1964. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1965. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1966. ENVELOPE DEBEZIUM
  1967. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1968. > CREATE DEFAULT INDEX ON mv
  1969. > DROP SOURCE upsert CASCADE
  1970. > CREATE SOURCE upsert
  1971. IN CLUSTER ${arg.single-replica-cluster}
  1972. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1973. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1974. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1975. ENVELOPE DEBEZIUM
  1976. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1977. > CREATE DEFAULT INDEX ON mv
  1978. > DROP SOURCE upsert CASCADE
  1979. > CREATE SOURCE upsert
  1980. IN CLUSTER ${arg.single-replica-cluster}
  1981. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1982. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1983. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1984. ENVELOPE DEBEZIUM
  1985. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1986. > CREATE DEFAULT INDEX ON mv
  1987. > DROP SOURCE upsert CASCADE
  1988. > CREATE SOURCE upsert
  1989. IN CLUSTER ${arg.single-replica-cluster}
  1990. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  1991. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  1992. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  1993. ENVELOPE DEBEZIUM
  1994. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  1995. > CREATE DEFAULT INDEX ON mv
  1996. > DROP SOURCE upsert CASCADE
  1997. > CREATE SOURCE upsert
  1998. IN CLUSTER ${arg.single-replica-cluster}
  1999. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2000. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2001. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2002. ENVELOPE DEBEZIUM
  2003. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2004. > CREATE DEFAULT INDEX ON mv
  2005. > DROP SOURCE upsert CASCADE
  2006. > CREATE SOURCE upsert
  2007. IN CLUSTER ${arg.single-replica-cluster}
  2008. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2009. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2010. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2011. ENVELOPE DEBEZIUM
  2012. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2013. > CREATE DEFAULT INDEX ON mv
  2014. > DROP SOURCE upsert CASCADE
  2015. > CREATE SOURCE upsert
  2016. IN CLUSTER ${arg.single-replica-cluster}
  2017. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2018. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2019. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2020. ENVELOPE DEBEZIUM
  2021. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2022. > CREATE DEFAULT INDEX ON mv
  2023. > DROP SOURCE upsert CASCADE
  2024. > CREATE SOURCE upsert
  2025. IN CLUSTER ${arg.single-replica-cluster}
  2026. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2027. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2028. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2029. ENVELOPE DEBEZIUM
  2030. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2031. > CREATE DEFAULT INDEX ON mv
  2032. > DROP SOURCE upsert CASCADE
  2033. > CREATE SOURCE upsert
  2034. IN CLUSTER ${arg.single-replica-cluster}
  2035. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2036. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2037. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2038. ENVELOPE DEBEZIUM
  2039. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2040. > CREATE DEFAULT INDEX ON mv
  2041. > DROP SOURCE upsert CASCADE
  2042. > CREATE SOURCE upsert
  2043. IN CLUSTER ${arg.single-replica-cluster}
  2044. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2045. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2046. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2047. ENVELOPE DEBEZIUM
  2048. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2049. > CREATE DEFAULT INDEX ON mv
  2050. > DROP SOURCE upsert CASCADE
  2051. > CREATE SOURCE upsert
  2052. IN CLUSTER ${arg.single-replica-cluster}
  2053. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2054. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2055. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2056. ENVELOPE DEBEZIUM
  2057. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2058. > CREATE DEFAULT INDEX ON mv
  2059. > DROP SOURCE upsert CASCADE
  2060. > CREATE SOURCE upsert
  2061. IN CLUSTER ${arg.single-replica-cluster}
  2062. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2063. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2064. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2065. ENVELOPE DEBEZIUM
  2066. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2067. > CREATE DEFAULT INDEX ON mv
  2068. > DROP SOURCE upsert CASCADE
  2069. > CREATE SOURCE upsert
  2070. IN CLUSTER ${arg.single-replica-cluster}
  2071. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2072. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2073. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2074. ENVELOPE DEBEZIUM
  2075. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2076. > CREATE DEFAULT INDEX ON mv
  2077. > DROP SOURCE upsert CASCADE
  2078. > CREATE SOURCE upsert
  2079. IN CLUSTER ${arg.single-replica-cluster}
  2080. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2081. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2082. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2083. ENVELOPE DEBEZIUM
  2084. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2085. > CREATE DEFAULT INDEX ON mv
  2086. > DROP SOURCE upsert CASCADE
  2087. > CREATE SOURCE upsert
  2088. IN CLUSTER ${arg.single-replica-cluster}
  2089. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2090. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2091. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2092. ENVELOPE DEBEZIUM
  2093. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2094. > CREATE DEFAULT INDEX ON mv
  2095. > DROP SOURCE upsert CASCADE
  2096. > CREATE SOURCE upsert
  2097. IN CLUSTER ${arg.single-replica-cluster}
  2098. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2099. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2100. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2101. ENVELOPE DEBEZIUM
  2102. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2103. > CREATE DEFAULT INDEX ON mv
  2104. > DROP SOURCE upsert CASCADE
  2105. > CREATE SOURCE upsert
  2106. IN CLUSTER ${arg.single-replica-cluster}
  2107. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2108. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2109. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2110. ENVELOPE DEBEZIUM
  2111. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2112. > CREATE DEFAULT INDEX ON mv
  2113. > DROP SOURCE upsert CASCADE
  2114. > CREATE SOURCE upsert
  2115. IN CLUSTER ${arg.single-replica-cluster}
  2116. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2117. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2118. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2119. ENVELOPE DEBEZIUM
  2120. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2121. > CREATE DEFAULT INDEX ON mv
  2122. > DROP SOURCE upsert CASCADE
  2123. > CREATE SOURCE upsert
  2124. IN CLUSTER ${arg.single-replica-cluster}
  2125. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2126. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2127. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2128. ENVELOPE DEBEZIUM
  2129. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2130. > CREATE DEFAULT INDEX ON mv
  2131. > DROP SOURCE upsert CASCADE
  2132. > CREATE SOURCE upsert
  2133. IN CLUSTER ${arg.single-replica-cluster}
  2134. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2135. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2136. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2137. ENVELOPE DEBEZIUM
  2138. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2139. > CREATE DEFAULT INDEX ON mv
  2140. > DROP SOURCE upsert CASCADE
  2141. > CREATE SOURCE upsert
  2142. IN CLUSTER ${arg.single-replica-cluster}
  2143. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2144. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2145. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2146. ENVELOPE DEBEZIUM
  2147. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2148. > CREATE DEFAULT INDEX ON mv
  2149. > DROP SOURCE upsert CASCADE
  2150. > CREATE SOURCE upsert
  2151. IN CLUSTER ${arg.single-replica-cluster}
  2152. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2153. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2154. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2155. ENVELOPE DEBEZIUM
  2156. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2157. > CREATE DEFAULT INDEX ON mv
  2158. > DROP SOURCE upsert CASCADE
  2159. > CREATE SOURCE upsert
  2160. IN CLUSTER ${arg.single-replica-cluster}
  2161. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2162. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2163. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2164. ENVELOPE DEBEZIUM
  2165. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2166. > CREATE DEFAULT INDEX ON mv
  2167. > DROP SOURCE upsert CASCADE
  2168. > CREATE SOURCE upsert
  2169. IN CLUSTER ${arg.single-replica-cluster}
  2170. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2171. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2172. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2173. ENVELOPE DEBEZIUM
  2174. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2175. > CREATE DEFAULT INDEX ON mv
  2176. > DROP SOURCE upsert CASCADE
  2177. > CREATE SOURCE upsert
  2178. IN CLUSTER ${arg.single-replica-cluster}
  2179. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2180. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2181. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2182. ENVELOPE DEBEZIUM
  2183. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2184. > CREATE DEFAULT INDEX ON mv
  2185. > DROP SOURCE upsert CASCADE
  2186. > CREATE SOURCE upsert
  2187. IN CLUSTER ${arg.single-replica-cluster}
  2188. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2189. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2190. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2191. ENVELOPE DEBEZIUM
  2192. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2193. > CREATE DEFAULT INDEX ON mv
  2194. > DROP SOURCE upsert CASCADE
  2195. > CREATE SOURCE upsert
  2196. IN CLUSTER ${arg.single-replica-cluster}
  2197. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2198. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2199. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2200. ENVELOPE DEBEZIUM
  2201. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2202. > CREATE DEFAULT INDEX ON mv
  2203. > DROP SOURCE upsert CASCADE
  2204. > CREATE SOURCE upsert
  2205. IN CLUSTER ${arg.single-replica-cluster}
  2206. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2207. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2208. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2209. ENVELOPE DEBEZIUM
  2210. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2211. > CREATE DEFAULT INDEX ON mv
  2212. > DROP SOURCE upsert CASCADE
  2213. > CREATE SOURCE upsert
  2214. IN CLUSTER ${arg.single-replica-cluster}
  2215. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2216. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2217. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2218. ENVELOPE DEBEZIUM
  2219. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2220. > CREATE DEFAULT INDEX ON mv
  2221. > DROP SOURCE upsert CASCADE
  2222. > CREATE SOURCE upsert
  2223. IN CLUSTER ${arg.single-replica-cluster}
  2224. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2225. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2226. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2227. ENVELOPE DEBEZIUM
  2228. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2229. > CREATE DEFAULT INDEX ON mv
  2230. > DROP SOURCE upsert CASCADE
  2231. > CREATE SOURCE upsert
  2232. IN CLUSTER ${arg.single-replica-cluster}
  2233. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2234. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2235. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2236. ENVELOPE DEBEZIUM
  2237. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2238. > CREATE DEFAULT INDEX ON mv
  2239. > DROP SOURCE upsert CASCADE
  2240. > CREATE SOURCE upsert
  2241. IN CLUSTER ${arg.single-replica-cluster}
  2242. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2243. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2244. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2245. ENVELOPE DEBEZIUM
  2246. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2247. > CREATE DEFAULT INDEX ON mv
  2248. > DROP SOURCE upsert CASCADE
  2249. > CREATE SOURCE upsert
  2250. IN CLUSTER ${arg.single-replica-cluster}
  2251. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2252. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2253. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2254. ENVELOPE DEBEZIUM
  2255. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2256. > CREATE DEFAULT INDEX ON mv
  2257. > DROP SOURCE upsert CASCADE
  2258. > CREATE SOURCE upsert
  2259. IN CLUSTER ${arg.single-replica-cluster}
  2260. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2261. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2262. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2263. ENVELOPE DEBEZIUM
  2264. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2265. > CREATE DEFAULT INDEX ON mv
  2266. > DROP SOURCE upsert CASCADE
  2267. > CREATE SOURCE upsert
  2268. IN CLUSTER ${arg.single-replica-cluster}
  2269. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2270. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2271. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2272. ENVELOPE DEBEZIUM
  2273. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2274. > CREATE DEFAULT INDEX ON mv
  2275. > DROP SOURCE upsert CASCADE
  2276. > CREATE SOURCE upsert
  2277. IN CLUSTER ${arg.single-replica-cluster}
  2278. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2279. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2280. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2281. ENVELOPE DEBEZIUM
  2282. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2283. > CREATE DEFAULT INDEX ON mv
  2284. > DROP SOURCE upsert CASCADE
  2285. > CREATE SOURCE upsert
  2286. IN CLUSTER ${arg.single-replica-cluster}
  2287. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2288. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2289. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2290. ENVELOPE DEBEZIUM
  2291. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2292. > CREATE DEFAULT INDEX ON mv
  2293. > DROP SOURCE upsert CASCADE
  2294. > CREATE SOURCE upsert
  2295. IN CLUSTER ${arg.single-replica-cluster}
  2296. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-dbzupsert-${testdrive.seed}')
  2297. > CREATE TABLE upsert_tbl FROM SOURCE upsert (REFERENCE "testdrive-dbzupsert-${testdrive.seed}")
  2298. FORMAT AVRO USING CONFLUENT SCHEMA REGISTRY CONNECTION csr_conn
  2299. ENVELOPE DEBEZIUM
  2300. > CREATE MATERIALIZED VIEW mv AS SELECT * FROM upsert_tbl
  2301. > CREATE DEFAULT INDEX ON mv