Wrappers.constants.ts 118 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491349234933494349534963497349834993500350135023503350435053506350735083509351035113512351335143515351635173518351935203521352235233524352535263527352835293530353135323533353435353536353735383539354035413542354335443545354635473548354935503551355235533554355535563557355835593560356135623563356435653566356735683569357035713572357335743575357635773578357935803581358235833584358535863587358835893590359135923593359435953596359735983599360036013602360336043605360636073608360936103611361236133614361536163617361836193620362136223623362436253626362736283629363036313632363336343635363636373638363936403641364236433644364536463647364836493650365136523653365436553656365736583659366036613662366336643665366636673668366936703671367236733674367536763677367836793680368136823683368436853686368736883689369036913692369336943695369636973698369937003701370237033704370537063707370837093710371137123713371437153716371737183719372037213722372337243725372637273728372937303731373237333734373537363737373837393740374137423743374437453746374737483749375037513752375337543755375637573758375937603761376237633764376537663767376837693770377137723773377437753776377737783779378037813782378337843785378637873788378937903791379237933794379537963797379837993800380138023803380438053806380738083809381038113812381338143815381638173818381938203821382238233824382538263827382838293830383138323833383438353836383738383839384038413842384338443845384638473848384938503851385238533854385538563857385838593860386138623863386438653866386738683869387038713872387338743875387638773878387938803881388238833884388538863887388838893890389138923893389438953896389738983899390039013902390339043905390639073908390939103911391239133914391539163917391839193920392139223923392439253926392739283929393039313932393339343935393639373938393939403941394239433944394539463947394839493950395139523953395439553956395739583959396039613962396339643965396639673968396939703971397239733974397539763977397839793980398139823983398439853986398739883989399039913992399339943995399639973998399940004001400240034004400540064007400840094010401140124013401440154016401740184019402040214022402340244025402640274028402940304031403240334034403540364037403840394040404140424043404440454046404740484049405040514052405340544055405640574058405940604061406240634064406540664067406840694070407140724073407440754076407740784079408040814082408340844085408640874088408940904091409240934094409540964097409840994100410141024103410441054106410741084109411041114112411341144115411641174118411941204121412241234124412541264127412841294130413141324133413441354136413741384139414041414142414341444145414641474148414941504151415241534154415541564157415841594160416141624163416441654166416741684169417041714172417341744175417641774178417941804181418241834184418541864187418841894190419141924193419441954196419741984199420042014202420342044205420642074208420942104211421242134214421542164217421842194220422142224223422442254226422742284229423042314232423342344235423642374238423942404241424242434244424542464247424842494250425142524253425442554256425742584259426042614262426342644265426642674268426942704271427242734274427542764277427842794280428142824283428442854286428742884289429042914292429342944295429642974298429943004301430243034304430543064307430843094310431143124313431443154316431743184319432043214322432343244325432643274328432943304331433243334334433543364337433843394340434143424343434443454346434743484349435043514352435343544355435643574358435943604361436243634364436543664367436843694370437143724373437443754376437743784379438043814382438343844385438643874388438943904391439243934394439543964397439843994400440144024403440444054406440744084409441044114412441344144415441644174418441944204421442244234424442544264427442844294430443144324433443444354436443744384439444044414442444344444445444644474448444944504451445244534454445544564457445844594460446144624463446444654466446744684469447044714472447344744475447644774478447944804481448244834484448544864487448844894490449144924493449444954496449744984499450045014502450345044505450645074508450945104511451245134514451545164517451845194520452145224523452445254526452745284529453045314532453345344535453645374538453945404541454245434544454545464547454845494550455145524553455445554556455745584559456045614562456345644565456645674568456945704571457245734574457545764577457845794580458145824583458445854586458745884589459045914592459345944595459645974598459946004601460246034604460546064607460846094610461146124613
  1. import type { ServerOption, WrapperMeta } from './Wrappers.types'
  2. import { BASE_PATH, DOCS_URL } from '@/lib/constants'
  3. export const WRAPPER_HANDLERS = {
  4. STRIPE: 'stripe_fdw_handler',
  5. FIREBASE: 'firebase_fdw_handler',
  6. S3: 's3_fdw_handler',
  7. S3_VECTORS: 's3_vectors_fdw_handler',
  8. CLICK_HOUSE: 'click_house_fdw_handler',
  9. BIG_QUERY: 'big_query_fdw_handler',
  10. AIRTABLE: 'airtable_fdw_handler',
  11. LOGFLARE: 'logflare_fdw_handler',
  12. AUTH0: 'auth0_fdw_handler',
  13. COGNITO: 'cognito_fdw_handler',
  14. MSSQL: 'mssql_fdw_handler',
  15. REDIS: 'redis_fdw_handler',
  16. ICEBERG: 'iceberg_fdw_handler',
  17. PADDLE: 'wasm_fdw_handler',
  18. SNOWFLAKE: 'wasm_fdw_handler',
  19. CAL: 'wasm_fdw_handler',
  20. CALENDLY: 'wasm_fdw_handler',
  21. CLERK: 'wasm_fdw_handler',
  22. NOTION: 'wasm_fdw_handler',
  23. SLACK: 'wasm_fdw_handler',
  24. CLOUDFLARE_D1: 'wasm_fdw_handler',
  25. HUBSPOT: 'wasm_fdw_handler',
  26. ORB: 'wasm_fdw_handler',
  27. }
  28. export const BRIVEN_TARGET_SCHEMA_OPTION: ServerOption = {
  29. name: 'briven_target_schema',
  30. label: 'Target Schema',
  31. required: false,
  32. encrypted: false,
  33. secureEntry: false,
  34. readOnly: true,
  35. hidden: true,
  36. }
  37. export const WRAPPERS: WrapperMeta[] = [
  38. {
  39. name: 'stripe_wrapper',
  40. handlerName: WRAPPER_HANDLERS.STRIPE,
  41. validatorName: 'stripe_fdw_validator',
  42. icon: `${BASE_PATH}/img/icons/stripe-icon.svg`,
  43. description: 'Payment processing and subscription management',
  44. extensionName: 'StripeFdw',
  45. label: 'Stripe',
  46. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/stripe`,
  47. server: {
  48. options: [
  49. {
  50. name: 'api_key_id',
  51. label: 'Stripe Secret Key',
  52. required: true,
  53. encrypted: true,
  54. secureEntry: true,
  55. urlHelper: 'https://stripe.com/docs/keys',
  56. },
  57. {
  58. name: 'api_url',
  59. label: 'Stripe API URL',
  60. defaultValue: 'https://api.stripe.com/v1',
  61. required: false,
  62. encrypted: false,
  63. secureEntry: false,
  64. },
  65. BRIVEN_TARGET_SCHEMA_OPTION,
  66. ],
  67. },
  68. tables: [
  69. {
  70. label: 'Accounts',
  71. description: 'List of accounts on your Stripe account',
  72. availableColumns: [
  73. {
  74. name: 'id',
  75. type: 'text',
  76. },
  77. {
  78. name: 'business_type',
  79. type: 'text',
  80. },
  81. {
  82. name: 'country',
  83. type: 'text',
  84. },
  85. {
  86. name: 'email',
  87. type: 'text',
  88. },
  89. {
  90. name: 'type',
  91. type: 'text',
  92. },
  93. {
  94. name: 'created',
  95. type: 'timestamp',
  96. },
  97. {
  98. name: 'attrs',
  99. type: 'jsonb',
  100. },
  101. ],
  102. options: [
  103. {
  104. name: 'object',
  105. defaultValue: 'accounts',
  106. editable: false,
  107. required: true,
  108. type: 'text',
  109. },
  110. {
  111. name: 'rowid_column',
  112. label: 'Row ID Column',
  113. defaultValue: 'id',
  114. editable: true,
  115. required: true,
  116. type: 'text',
  117. },
  118. ],
  119. },
  120. {
  121. label: 'Balance',
  122. description: 'The balance currently on your Stripe account',
  123. availableColumns: [
  124. {
  125. name: 'balance_type',
  126. type: 'text',
  127. },
  128. {
  129. name: 'amount',
  130. type: 'bigint',
  131. },
  132. {
  133. name: 'currency',
  134. type: 'text',
  135. },
  136. {
  137. name: 'attrs',
  138. type: 'jsonb',
  139. },
  140. ],
  141. options: [
  142. {
  143. name: 'object',
  144. defaultValue: 'balance',
  145. editable: false,
  146. required: true,
  147. type: 'text',
  148. },
  149. ],
  150. },
  151. {
  152. label: 'Balance Transactions',
  153. description: 'Transactions that have contributed to the balance on your Stripe account',
  154. availableColumns: [
  155. {
  156. name: 'id',
  157. type: 'text',
  158. },
  159. {
  160. name: 'amount',
  161. type: 'bigint',
  162. },
  163. {
  164. name: 'currency',
  165. type: 'text',
  166. },
  167. {
  168. name: 'description',
  169. type: 'text',
  170. },
  171. {
  172. name: 'fee',
  173. type: 'bigint',
  174. },
  175. {
  176. name: 'net',
  177. type: 'bigint',
  178. },
  179. {
  180. name: 'status',
  181. type: 'text',
  182. },
  183. {
  184. name: 'type',
  185. type: 'text',
  186. },
  187. {
  188. name: 'created',
  189. type: 'timestamp',
  190. },
  191. {
  192. name: 'attrs',
  193. type: 'jsonb',
  194. },
  195. ],
  196. options: [
  197. {
  198. name: 'object',
  199. defaultValue: 'balance_transactions',
  200. editable: false,
  201. required: true,
  202. type: 'text',
  203. },
  204. ],
  205. },
  206. {
  207. label: 'Charges',
  208. description: 'Charges made on your Stripe account',
  209. availableColumns: [
  210. {
  211. name: 'id',
  212. type: 'text',
  213. },
  214. {
  215. name: 'amount',
  216. type: 'bigint',
  217. },
  218. {
  219. name: 'currency',
  220. type: 'text',
  221. },
  222. {
  223. name: 'customer',
  224. type: 'text',
  225. },
  226. {
  227. name: 'description',
  228. type: 'text',
  229. },
  230. {
  231. name: 'invoice',
  232. type: 'text',
  233. },
  234. {
  235. name: 'payment_intent',
  236. type: 'text',
  237. },
  238. {
  239. name: 'status',
  240. type: 'text',
  241. },
  242. {
  243. name: 'created',
  244. type: 'timestamp',
  245. },
  246. {
  247. name: 'attrs',
  248. type: 'jsonb',
  249. },
  250. ],
  251. options: [
  252. {
  253. name: 'object',
  254. defaultValue: 'charges',
  255. editable: false,
  256. required: true,
  257. type: 'text',
  258. },
  259. ],
  260. },
  261. {
  262. label: 'Checkout Sessions',
  263. description:
  264. "Customer's session as they pay for one-time purchases or subscriptions through Checkout or Payment Links",
  265. availableColumns: [
  266. {
  267. name: 'id',
  268. type: 'text',
  269. },
  270. {
  271. name: 'customer',
  272. type: 'text',
  273. },
  274. {
  275. name: 'payment_intent',
  276. type: 'text',
  277. },
  278. {
  279. name: 'subscription',
  280. type: 'text',
  281. },
  282. {
  283. name: 'attrs',
  284. type: 'jsonb',
  285. },
  286. ],
  287. options: [
  288. {
  289. name: 'object',
  290. defaultValue: 'checkout/sessions',
  291. editable: false,
  292. required: true,
  293. type: 'text',
  294. },
  295. {
  296. name: 'rowid_column',
  297. label: 'Row ID Column',
  298. defaultValue: 'id',
  299. editable: true,
  300. required: true,
  301. type: 'text',
  302. },
  303. ],
  304. },
  305. {
  306. label: 'Customers',
  307. description: 'Customers on your Stripe account',
  308. availableColumns: [
  309. {
  310. name: 'id',
  311. type: 'text',
  312. },
  313. {
  314. name: 'email',
  315. type: 'text',
  316. },
  317. {
  318. name: 'name',
  319. type: 'text',
  320. },
  321. {
  322. name: 'description',
  323. type: 'text',
  324. },
  325. {
  326. name: 'created',
  327. type: 'timestamp',
  328. },
  329. {
  330. name: 'attrs',
  331. type: 'jsonb',
  332. },
  333. ],
  334. options: [
  335. {
  336. name: 'object',
  337. defaultValue: 'customers',
  338. editable: false,
  339. required: true,
  340. type: 'text',
  341. },
  342. {
  343. name: 'rowid_column',
  344. label: 'Row ID Column',
  345. defaultValue: 'id',
  346. editable: true,
  347. required: true,
  348. type: 'text',
  349. },
  350. ],
  351. },
  352. {
  353. label: 'Disputes',
  354. description: 'When a customer questions your charge with their card issuer',
  355. availableColumns: [
  356. {
  357. name: 'id',
  358. type: 'text',
  359. },
  360. {
  361. name: 'amount',
  362. type: 'bigint',
  363. },
  364. {
  365. name: 'currency',
  366. type: 'text',
  367. },
  368. {
  369. name: 'charge',
  370. type: 'text',
  371. },
  372. {
  373. name: 'payment_intent',
  374. type: 'text',
  375. },
  376. {
  377. name: 'reason',
  378. type: 'text',
  379. },
  380. {
  381. name: 'status',
  382. type: 'text',
  383. },
  384. {
  385. name: 'created',
  386. type: 'timestamp',
  387. },
  388. {
  389. name: 'attrs',
  390. type: 'jsonb',
  391. },
  392. ],
  393. options: [
  394. {
  395. name: 'object',
  396. defaultValue: 'disputes',
  397. editable: false,
  398. required: true,
  399. type: 'text',
  400. },
  401. ],
  402. },
  403. {
  404. label: 'Events',
  405. description:
  406. "Stripe's way of letting you know when something interesting happens in your account",
  407. availableColumns: [
  408. {
  409. name: 'id',
  410. type: 'text',
  411. },
  412. {
  413. name: 'type',
  414. type: 'text',
  415. },
  416. {
  417. name: 'api_version',
  418. type: 'text',
  419. },
  420. {
  421. name: 'created',
  422. type: 'timestamp',
  423. },
  424. {
  425. name: 'attrs',
  426. type: 'jsonb',
  427. },
  428. ],
  429. options: [
  430. {
  431. name: 'object',
  432. defaultValue: 'events',
  433. editable: false,
  434. required: true,
  435. type: 'text',
  436. },
  437. ],
  438. },
  439. {
  440. label: 'Files',
  441. description: "Files that are hosted on Stripe's servers",
  442. availableColumns: [
  443. {
  444. name: 'id',
  445. type: 'text',
  446. },
  447. {
  448. name: 'filename',
  449. type: 'text',
  450. },
  451. {
  452. name: 'purpose',
  453. type: 'text',
  454. },
  455. {
  456. name: 'title',
  457. type: 'text',
  458. },
  459. {
  460. name: 'size',
  461. type: 'bigint',
  462. },
  463. {
  464. name: 'type',
  465. type: 'text',
  466. },
  467. {
  468. name: 'url',
  469. type: 'text',
  470. },
  471. {
  472. name: 'created',
  473. type: 'timestamp',
  474. },
  475. {
  476. name: 'expires_at',
  477. type: 'timestamp',
  478. },
  479. {
  480. name: 'attrs',
  481. type: 'jsonb',
  482. },
  483. ],
  484. options: [
  485. {
  486. name: 'object',
  487. defaultValue: 'files',
  488. editable: false,
  489. required: true,
  490. type: 'text',
  491. },
  492. ],
  493. },
  494. {
  495. label: 'File Links',
  496. description: 'For sharing contents of a File object with non-Stripe users',
  497. availableColumns: [
  498. {
  499. name: 'id',
  500. type: 'text',
  501. },
  502. {
  503. name: 'file',
  504. type: 'text',
  505. },
  506. {
  507. name: 'url',
  508. type: 'text',
  509. },
  510. {
  511. name: 'created',
  512. type: 'timestamp',
  513. },
  514. {
  515. name: 'expired',
  516. type: 'bool',
  517. },
  518. {
  519. name: 'expires_at',
  520. type: 'timestamp',
  521. },
  522. {
  523. name: 'attrs',
  524. type: 'jsonb',
  525. },
  526. ],
  527. options: [
  528. {
  529. name: 'object',
  530. defaultValue: 'file_links',
  531. editable: false,
  532. required: true,
  533. type: 'text',
  534. },
  535. ],
  536. },
  537. {
  538. label: 'Invoices',
  539. description: 'Invoices on your Stripe account',
  540. availableColumns: [
  541. {
  542. name: 'id',
  543. type: 'text',
  544. },
  545. {
  546. name: 'customer',
  547. type: 'text',
  548. },
  549. {
  550. name: 'subscription',
  551. type: 'text',
  552. },
  553. {
  554. name: 'status',
  555. type: 'text',
  556. },
  557. {
  558. name: 'total',
  559. type: 'bigint',
  560. },
  561. {
  562. name: 'currency',
  563. type: 'text',
  564. },
  565. {
  566. name: 'period_start',
  567. type: 'timestamp',
  568. },
  569. {
  570. name: 'period_end',
  571. type: 'timestamp',
  572. },
  573. {
  574. name: 'attrs',
  575. type: 'jsonb',
  576. },
  577. ],
  578. options: [
  579. {
  580. name: 'object',
  581. defaultValue: 'invoices',
  582. editable: false,
  583. required: true,
  584. type: 'text',
  585. },
  586. ],
  587. },
  588. {
  589. label: 'Mandates',
  590. description:
  591. 'Records of the permission a customer has given you to debit their payment method',
  592. availableColumns: [
  593. {
  594. name: 'id',
  595. type: 'text',
  596. },
  597. {
  598. name: 'payment_method',
  599. type: 'text',
  600. },
  601. {
  602. name: 'status',
  603. type: 'text',
  604. },
  605. {
  606. name: 'type',
  607. type: 'text',
  608. },
  609. {
  610. name: 'attrs',
  611. type: 'jsonb',
  612. },
  613. ],
  614. options: [
  615. {
  616. name: 'object',
  617. defaultValue: 'mandates',
  618. editable: false,
  619. required: true,
  620. type: 'text',
  621. },
  622. ],
  623. },
  624. {
  625. label: 'Meters',
  626. description: 'Records for tracking event usage in billing',
  627. availableColumns: [
  628. {
  629. name: 'id',
  630. type: 'text',
  631. },
  632. {
  633. name: 'display_name',
  634. type: 'text',
  635. },
  636. {
  637. name: 'event_name',
  638. type: 'text',
  639. },
  640. {
  641. name: 'event_time_window',
  642. type: 'text',
  643. },
  644. {
  645. name: 'status',
  646. type: 'text',
  647. },
  648. {
  649. name: 'attrs',
  650. type: 'jsonb',
  651. },
  652. ],
  653. options: [
  654. {
  655. name: 'object',
  656. defaultValue: 'billing/meters',
  657. editable: false,
  658. required: true,
  659. type: 'text',
  660. },
  661. ],
  662. },
  663. {
  664. label: 'Payment Intents',
  665. description: 'Payment Intents on your Stripe account',
  666. availableColumns: [
  667. {
  668. name: 'id',
  669. type: 'text',
  670. },
  671. {
  672. name: 'customer',
  673. type: 'text',
  674. },
  675. {
  676. name: 'amount',
  677. type: 'bigint',
  678. },
  679. {
  680. name: 'currency',
  681. type: 'text',
  682. },
  683. {
  684. name: 'payment_method',
  685. type: 'text',
  686. },
  687. {
  688. name: 'created',
  689. type: 'timestamp',
  690. },
  691. {
  692. name: 'attrs',
  693. type: 'jsonb',
  694. },
  695. ],
  696. options: [
  697. {
  698. name: 'object',
  699. defaultValue: 'payment_intents',
  700. editable: false,
  701. required: true,
  702. type: 'text',
  703. },
  704. ],
  705. },
  706. {
  707. label: 'Payouts',
  708. description:
  709. 'Created when you receive funds from Stripe, or when you initiate a payout to either a bank account or debit card',
  710. availableColumns: [
  711. {
  712. name: 'id',
  713. type: 'text',
  714. },
  715. {
  716. name: 'amount',
  717. type: 'bigint',
  718. },
  719. {
  720. name: 'currency',
  721. type: 'text',
  722. },
  723. {
  724. name: 'arrival_date',
  725. type: 'timestamp',
  726. },
  727. {
  728. name: 'description',
  729. type: 'text',
  730. },
  731. {
  732. name: 'statement_descriptor',
  733. type: 'text',
  734. },
  735. {
  736. name: 'status',
  737. type: 'text',
  738. },
  739. {
  740. name: 'created',
  741. type: 'timestamp',
  742. },
  743. {
  744. name: 'attrs',
  745. type: 'jsonb',
  746. },
  747. ],
  748. options: [
  749. {
  750. name: 'object',
  751. defaultValue: 'payouts',
  752. editable: false,
  753. required: true,
  754. type: 'text',
  755. },
  756. ],
  757. },
  758. {
  759. label: 'Prices',
  760. description:
  761. 'A Price object is needed for all your products to facilitate multiple currencies and pricing options',
  762. availableColumns: [
  763. {
  764. name: 'id',
  765. type: 'text',
  766. },
  767. {
  768. name: 'active',
  769. type: 'bool',
  770. },
  771. {
  772. name: 'currency',
  773. type: 'text',
  774. },
  775. {
  776. name: 'product',
  777. type: 'text',
  778. },
  779. {
  780. name: 'unit_amount',
  781. type: 'bigint',
  782. },
  783. {
  784. name: 'type',
  785. type: 'text',
  786. },
  787. {
  788. name: 'created',
  789. type: 'timestamp',
  790. },
  791. {
  792. name: 'attrs',
  793. type: 'jsonb',
  794. },
  795. ],
  796. options: [
  797. {
  798. name: 'object',
  799. defaultValue: 'prices',
  800. editable: false,
  801. required: true,
  802. type: 'text',
  803. },
  804. ],
  805. },
  806. {
  807. label: 'Products',
  808. description: 'Products on your Stripe account',
  809. availableColumns: [
  810. {
  811. name: 'id',
  812. type: 'text',
  813. },
  814. {
  815. name: 'name',
  816. type: 'text',
  817. },
  818. {
  819. name: 'active',
  820. type: 'bool',
  821. },
  822. {
  823. name: 'default_price',
  824. type: 'text',
  825. },
  826. {
  827. name: 'description',
  828. type: 'text',
  829. },
  830. {
  831. name: 'created',
  832. type: 'timestamp',
  833. },
  834. {
  835. name: 'updated',
  836. type: 'timestamp',
  837. },
  838. {
  839. name: 'attrs',
  840. type: 'jsonb',
  841. },
  842. ],
  843. options: [
  844. {
  845. name: 'object',
  846. defaultValue: 'products',
  847. editable: false,
  848. required: true,
  849. type: 'text',
  850. },
  851. {
  852. name: 'rowid_column',
  853. label: 'Row ID Column',
  854. defaultValue: 'id',
  855. editable: true,
  856. required: true,
  857. type: 'text',
  858. },
  859. ],
  860. },
  861. {
  862. label: 'Refunds',
  863. description:
  864. 'Allows you to refund a charge that has previously been created but not yet refunded',
  865. availableColumns: [
  866. {
  867. name: 'id',
  868. type: 'text',
  869. },
  870. {
  871. name: 'amount',
  872. type: 'bigint',
  873. },
  874. {
  875. name: 'currency',
  876. type: 'text',
  877. },
  878. {
  879. name: 'charge',
  880. type: 'text',
  881. },
  882. {
  883. name: 'payment_intent',
  884. type: 'text',
  885. },
  886. {
  887. name: 'reason',
  888. type: 'text',
  889. },
  890. {
  891. name: 'status',
  892. type: 'text',
  893. },
  894. {
  895. name: 'created',
  896. type: 'timestamp',
  897. },
  898. {
  899. name: 'attrs',
  900. type: 'jsonb',
  901. },
  902. ],
  903. options: [
  904. {
  905. name: 'object',
  906. defaultValue: 'refunds',
  907. editable: false,
  908. required: true,
  909. type: 'text',
  910. },
  911. ],
  912. },
  913. {
  914. label: 'Setup Attempts',
  915. description: 'Attempted confirmations of a SetupIntent, either successful or unsuccessful',
  916. availableColumns: [
  917. {
  918. name: 'id',
  919. type: 'text',
  920. },
  921. {
  922. name: 'application',
  923. type: 'text',
  924. },
  925. {
  926. name: 'customer',
  927. type: 'text',
  928. },
  929. {
  930. name: 'on_behalf_of',
  931. type: 'text',
  932. },
  933. {
  934. name: 'payment_method',
  935. type: 'text',
  936. },
  937. {
  938. name: 'setup_intent',
  939. type: 'text',
  940. },
  941. {
  942. name: 'status',
  943. type: 'text',
  944. },
  945. {
  946. name: 'usage',
  947. type: 'text',
  948. },
  949. {
  950. name: 'created',
  951. type: 'timestamp',
  952. },
  953. {
  954. name: 'attrs',
  955. type: 'jsonb',
  956. },
  957. ],
  958. options: [
  959. {
  960. name: 'object',
  961. defaultValue: 'setup_attempts',
  962. editable: false,
  963. required: true,
  964. type: 'text',
  965. },
  966. ],
  967. },
  968. {
  969. label: 'Setup Intents',
  970. description:
  971. "Guides you through the process of setting up and saving a customer's payment credentials for future payments",
  972. availableColumns: [
  973. {
  974. name: 'id',
  975. type: 'text',
  976. },
  977. {
  978. name: 'client_secret',
  979. type: 'text',
  980. },
  981. {
  982. name: 'customer',
  983. type: 'text',
  984. },
  985. {
  986. name: 'description',
  987. type: 'text',
  988. },
  989. {
  990. name: 'payment_method',
  991. type: 'text',
  992. },
  993. {
  994. name: 'status',
  995. type: 'text',
  996. },
  997. {
  998. name: 'usage',
  999. type: 'text',
  1000. },
  1001. {
  1002. name: 'created',
  1003. type: 'timestamp',
  1004. },
  1005. {
  1006. name: 'attrs',
  1007. type: 'jsonb',
  1008. },
  1009. ],
  1010. options: [
  1011. {
  1012. name: 'object',
  1013. defaultValue: 'setup_intents',
  1014. editable: false,
  1015. required: true,
  1016. type: 'text',
  1017. },
  1018. ],
  1019. },
  1020. {
  1021. label: 'Subscriptions',
  1022. description: 'Subscriptions on your Stripe account',
  1023. availableColumns: [
  1024. {
  1025. name: 'id',
  1026. type: 'text',
  1027. },
  1028. {
  1029. name: 'customer',
  1030. type: 'text',
  1031. },
  1032. {
  1033. name: 'currency',
  1034. type: 'text',
  1035. },
  1036. {
  1037. name: 'current_period_start',
  1038. type: 'timestamp',
  1039. },
  1040. {
  1041. name: 'current_period_end',
  1042. type: 'timestamp',
  1043. },
  1044. {
  1045. name: 'attrs',
  1046. type: 'jsonb',
  1047. },
  1048. ],
  1049. options: [
  1050. {
  1051. name: 'object',
  1052. defaultValue: 'subscriptions',
  1053. editable: false,
  1054. required: true,
  1055. type: 'text',
  1056. },
  1057. {
  1058. name: 'rowid_column',
  1059. label: 'Row ID Column',
  1060. defaultValue: 'id',
  1061. editable: true,
  1062. required: true,
  1063. type: 'text',
  1064. },
  1065. ],
  1066. },
  1067. {
  1068. label: 'Tokens',
  1069. description:
  1070. 'Tokenization is the process Stripe uses to collect sensitive card or bank account details in a secure manner',
  1071. availableColumns: [
  1072. {
  1073. name: 'id',
  1074. type: 'text',
  1075. },
  1076. {
  1077. name: 'customer',
  1078. type: 'text',
  1079. },
  1080. {
  1081. name: 'currency',
  1082. type: 'text',
  1083. },
  1084. {
  1085. name: 'current_period_start',
  1086. type: 'timestamp',
  1087. },
  1088. {
  1089. name: 'current_period_end',
  1090. type: 'timestamp',
  1091. },
  1092. {
  1093. name: 'attrs',
  1094. type: 'jsonb',
  1095. },
  1096. ],
  1097. options: [
  1098. {
  1099. name: 'object',
  1100. defaultValue: 'tokens',
  1101. editable: false,
  1102. required: true,
  1103. type: 'text',
  1104. },
  1105. ],
  1106. },
  1107. {
  1108. label: 'Top-ups',
  1109. description: 'To top up your Stripe balance',
  1110. availableColumns: [
  1111. {
  1112. name: 'id',
  1113. type: 'text',
  1114. },
  1115. {
  1116. name: 'amount',
  1117. type: 'bigint',
  1118. },
  1119. {
  1120. name: 'currency',
  1121. type: 'text',
  1122. },
  1123. {
  1124. name: 'description',
  1125. type: 'text',
  1126. },
  1127. {
  1128. name: 'status',
  1129. type: 'text',
  1130. },
  1131. {
  1132. name: 'created',
  1133. type: 'timestamp',
  1134. },
  1135. {
  1136. name: 'attrs',
  1137. type: 'jsonb',
  1138. },
  1139. ],
  1140. options: [
  1141. {
  1142. name: 'object',
  1143. defaultValue: 'topups',
  1144. editable: false,
  1145. required: true,
  1146. type: 'text',
  1147. },
  1148. ],
  1149. },
  1150. {
  1151. label: 'Transfers',
  1152. description: 'When moving funds between Stripe accounts as part of Connect',
  1153. availableColumns: [
  1154. {
  1155. name: 'id',
  1156. type: 'text',
  1157. },
  1158. {
  1159. name: 'amount',
  1160. type: 'bigint',
  1161. },
  1162. {
  1163. name: 'currency',
  1164. type: 'text',
  1165. },
  1166. {
  1167. name: 'description',
  1168. type: 'text',
  1169. },
  1170. {
  1171. name: 'destination',
  1172. type: 'text',
  1173. },
  1174. {
  1175. name: 'created',
  1176. type: 'timestamp',
  1177. },
  1178. {
  1179. name: 'attrs',
  1180. type: 'jsonb',
  1181. },
  1182. ],
  1183. options: [
  1184. {
  1185. name: 'object',
  1186. defaultValue: 'transfers',
  1187. editable: false,
  1188. required: true,
  1189. type: 'text',
  1190. },
  1191. ],
  1192. },
  1193. ],
  1194. canTargetSchema: true,
  1195. sourceSchemaOption: {
  1196. name: 'source_schema',
  1197. label: 'Source Schema',
  1198. required: true,
  1199. encrypted: false,
  1200. secureEntry: false,
  1201. readOnly: true,
  1202. defaultValue: 'stripe',
  1203. },
  1204. },
  1205. {
  1206. name: 'firebase_wrapper',
  1207. handlerName: WRAPPER_HANDLERS.FIREBASE,
  1208. validatorName: 'firebase_fdw_validator',
  1209. icon: `${BASE_PATH}/img/icons/firebase-icon.svg`,
  1210. description: 'Backend-as-a-Service with real-time database',
  1211. extensionName: 'FirebaseFdw',
  1212. label: 'Firebase',
  1213. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/firebase`,
  1214. server: {
  1215. options: [
  1216. {
  1217. name: 'project_id',
  1218. label: 'Project ID',
  1219. required: true,
  1220. encrypted: false,
  1221. secureEntry: false,
  1222. },
  1223. {
  1224. name: 'sa_key_id',
  1225. label: 'Service Account Key',
  1226. required: true,
  1227. encrypted: true,
  1228. secureEntry: true,
  1229. isTextArea: true,
  1230. urlHelper: 'https://firebase.google.com/docs/admin/setup#initialize-sdk',
  1231. },
  1232. ],
  1233. },
  1234. tables: [
  1235. {
  1236. label: 'Users',
  1237. description: 'Shows your Firebase users',
  1238. availableColumns: [
  1239. {
  1240. name: 'uid',
  1241. type: 'text',
  1242. },
  1243. {
  1244. name: 'email',
  1245. type: 'text',
  1246. },
  1247. {
  1248. name: 'created_at',
  1249. type: 'timestamp',
  1250. },
  1251. {
  1252. name: 'attrs',
  1253. type: 'jsonb',
  1254. },
  1255. ],
  1256. options: [
  1257. {
  1258. name: 'object',
  1259. defaultValue: 'auth/users',
  1260. editable: false,
  1261. required: true,
  1262. type: 'text',
  1263. },
  1264. {
  1265. name: 'base_url',
  1266. label: 'Base URL',
  1267. defaultValue: 'https://identitytoolkit.googleapis.com/v1/projects',
  1268. editable: true,
  1269. required: true,
  1270. type: 'text',
  1271. },
  1272. {
  1273. name: 'limit',
  1274. label: 'Limit',
  1275. defaultValue: '10000',
  1276. editable: true,
  1277. required: true,
  1278. type: 'text',
  1279. },
  1280. ],
  1281. },
  1282. {
  1283. label: 'Firestore Collection',
  1284. description: 'Map to a Firestore collection',
  1285. availableColumns: [
  1286. {
  1287. name: 'name',
  1288. type: 'text',
  1289. },
  1290. {
  1291. name: 'created_at',
  1292. type: 'timestamp',
  1293. },
  1294. {
  1295. name: 'updated_at',
  1296. type: 'timestamp',
  1297. },
  1298. {
  1299. name: 'attrs',
  1300. type: 'jsonb',
  1301. },
  1302. ],
  1303. options: [
  1304. {
  1305. name: 'object',
  1306. label: 'Object',
  1307. placeholder: 'firestore/[collection_id]',
  1308. editable: true,
  1309. required: true,
  1310. type: 'text',
  1311. },
  1312. {
  1313. name: 'base_url',
  1314. label: 'Base URL',
  1315. defaultValue: 'https://firestore.googleapis.com/v1beta1/projects',
  1316. editable: true,
  1317. required: true,
  1318. type: 'text',
  1319. },
  1320. {
  1321. name: 'limit',
  1322. label: 'Limit',
  1323. defaultValue: '10000',
  1324. editable: true,
  1325. required: true,
  1326. type: 'text',
  1327. },
  1328. ],
  1329. },
  1330. ],
  1331. },
  1332. {
  1333. name: 's3_wrapper',
  1334. handlerName: WRAPPER_HANDLERS.S3,
  1335. validatorName: 's3_fdw_validator',
  1336. icon: `${BASE_PATH}/img/icons/s3-icon.svg`,
  1337. description: 'Cloud object storage service',
  1338. extensionName: 'S3Fdw',
  1339. label: 'S3',
  1340. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/s3`,
  1341. server: {
  1342. options: [
  1343. {
  1344. name: 'vault_access_key_id',
  1345. label: 'Access Key ID',
  1346. required: true,
  1347. encrypted: true,
  1348. secureEntry: true,
  1349. },
  1350. {
  1351. name: 'vault_secret_access_key',
  1352. label: 'Access Key Secret',
  1353. required: true,
  1354. encrypted: true,
  1355. secureEntry: true,
  1356. },
  1357. {
  1358. name: 'aws_region',
  1359. label: 'AWS Region',
  1360. required: true,
  1361. encrypted: false,
  1362. secureEntry: false,
  1363. defaultValue: 'us-east-1',
  1364. },
  1365. ],
  1366. },
  1367. tables: [
  1368. {
  1369. label: 'S3 File',
  1370. description: 'Map to a file in S3 (CSV or JSON only)',
  1371. options: [
  1372. {
  1373. name: 'uri',
  1374. label: 'URI',
  1375. editable: true,
  1376. required: true,
  1377. placeholder: 's3://bucket/s3_table.csv',
  1378. type: 'text',
  1379. },
  1380. {
  1381. name: 'format',
  1382. label: 'Format',
  1383. editable: true,
  1384. required: true,
  1385. type: 'select',
  1386. defaultValue: 'csv',
  1387. options: [
  1388. { label: 'CSV', value: 'csv' },
  1389. { label: 'JSONL (JSON Lines)', value: 'jsonl' },
  1390. ],
  1391. },
  1392. {
  1393. name: 'has_header',
  1394. label: 'Has Header',
  1395. editable: true,
  1396. required: true,
  1397. type: 'select',
  1398. defaultValue: 'true',
  1399. options: [
  1400. { label: 'True', value: 'true' },
  1401. { label: 'False', value: 'false' },
  1402. ],
  1403. },
  1404. {
  1405. name: 'compress',
  1406. label: 'Compression',
  1407. editable: true,
  1408. required: false,
  1409. type: 'select',
  1410. options: [{ label: 'GZIP', value: 'gzip' }],
  1411. },
  1412. ],
  1413. },
  1414. ],
  1415. },
  1416. {
  1417. name: 's3_vectors_wrapper',
  1418. handlerName: WRAPPER_HANDLERS.S3_VECTORS,
  1419. validatorName: 's3_vectors_fdw_validator',
  1420. icon: `${BASE_PATH}/img/icons/s3-icon.svg`,
  1421. description: 'Cloud storage service for high-dimensional vectors',
  1422. extensionName: 'S3VectorsFdw',
  1423. label: 'S3 Vectors',
  1424. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/s3-vectors`,
  1425. minimumExtensionVersion: '0.5.6',
  1426. server: {
  1427. options: [
  1428. {
  1429. name: 'vault_access_key_id',
  1430. label: 'Access Key ID',
  1431. required: true,
  1432. encrypted: true,
  1433. secureEntry: true,
  1434. },
  1435. {
  1436. name: 'vault_secret_access_key',
  1437. label: 'Access Key Secret',
  1438. required: true,
  1439. encrypted: true,
  1440. secureEntry: true,
  1441. },
  1442. {
  1443. name: 'aws_region',
  1444. label: 'AWS Region',
  1445. required: true,
  1446. encrypted: false,
  1447. secureEntry: false,
  1448. defaultValue: 'us-east-1',
  1449. },
  1450. {
  1451. name: 'endpoint_url',
  1452. label: 'Endpoint URL',
  1453. required: false,
  1454. encrypted: false,
  1455. secureEntry: false,
  1456. defaultValue: '',
  1457. },
  1458. BRIVEN_TARGET_SCHEMA_OPTION,
  1459. ],
  1460. },
  1461. canTargetSchema: true,
  1462. tables: [],
  1463. },
  1464. {
  1465. name: 'clickhouse_wrapper',
  1466. handlerName: WRAPPER_HANDLERS.CLICK_HOUSE,
  1467. validatorName: 'click_house_fdw_validator',
  1468. icon: `${BASE_PATH}/img/icons/clickhouse-icon.svg`,
  1469. description: 'Column-oriented analytics database',
  1470. extensionName: 'ClickHouseFdw',
  1471. label: 'ClickHouse',
  1472. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/clickhouse`,
  1473. server: {
  1474. options: [
  1475. {
  1476. name: 'conn_string_id',
  1477. label: 'ClickHouse Connection String',
  1478. required: true,
  1479. encrypted: true,
  1480. secureEntry: true,
  1481. },
  1482. ],
  1483. },
  1484. tables: [
  1485. {
  1486. label: 'ClickHouse Table',
  1487. description: 'Map to a ClickHouse Table',
  1488. options: [
  1489. {
  1490. name: 'table',
  1491. label: 'ClickHouse Table Name',
  1492. editable: true,
  1493. required: true,
  1494. placeholder: 'my_clickhouse_table',
  1495. type: 'text',
  1496. },
  1497. {
  1498. name: 'rowid_column',
  1499. label: 'Row ID Column',
  1500. defaultValue: 'id',
  1501. editable: true,
  1502. required: true,
  1503. type: 'text',
  1504. },
  1505. ],
  1506. },
  1507. ],
  1508. },
  1509. {
  1510. name: 'bigquery_wrapper',
  1511. handlerName: WRAPPER_HANDLERS.BIG_QUERY,
  1512. validatorName: 'big_query_fdw_validator',
  1513. icon: `${BASE_PATH}/img/icons/bigquery-icon.svg`,
  1514. description: 'Serverless data warehouse and analytics',
  1515. extensionName: 'BigQueryFdw',
  1516. label: 'BigQuery',
  1517. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/bigquery`,
  1518. server: {
  1519. options: [
  1520. {
  1521. name: 'sa_key_id',
  1522. label: 'Service Account Key',
  1523. required: true,
  1524. encrypted: true,
  1525. secureEntry: true,
  1526. },
  1527. {
  1528. name: 'project_id',
  1529. label: 'Project ID',
  1530. required: true,
  1531. encrypted: false,
  1532. secureEntry: false,
  1533. },
  1534. {
  1535. name: 'dataset_id',
  1536. label: 'Dataset ID',
  1537. required: true,
  1538. encrypted: false,
  1539. secureEntry: false,
  1540. },
  1541. ],
  1542. },
  1543. tables: [
  1544. {
  1545. label: 'BigQuery Table',
  1546. description: 'Map to a BigQuery Table',
  1547. options: [
  1548. {
  1549. name: 'table',
  1550. label: 'BigQuery Table Name',
  1551. editable: true,
  1552. required: true,
  1553. placeholder: 'my_bigquery_table',
  1554. type: 'text',
  1555. },
  1556. {
  1557. name: 'location',
  1558. label: 'Location',
  1559. defaultValue: 'US',
  1560. editable: true,
  1561. required: false,
  1562. type: 'text',
  1563. },
  1564. {
  1565. name: 'timeout',
  1566. label: 'Timeout (ms)',
  1567. defaultValue: '30000',
  1568. editable: true,
  1569. required: false,
  1570. type: 'text',
  1571. },
  1572. {
  1573. name: 'rowid_column',
  1574. label: 'Row ID Column',
  1575. defaultValue: 'id',
  1576. editable: true,
  1577. required: false,
  1578. type: 'text',
  1579. },
  1580. ],
  1581. },
  1582. ],
  1583. },
  1584. {
  1585. name: 'airtable_wrapper',
  1586. handlerName: WRAPPER_HANDLERS.AIRTABLE,
  1587. validatorName: 'airtable_fdw_validator',
  1588. icon: `${BASE_PATH}/img/icons/airtable-icon.svg`,
  1589. description: 'No-code database and spreadsheet platform',
  1590. extensionName: 'airtableFdw',
  1591. label: 'Airtable',
  1592. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/airtable`,
  1593. server: {
  1594. options: [
  1595. {
  1596. name: 'api_key_id',
  1597. label: 'API Key ID',
  1598. required: true,
  1599. encrypted: true,
  1600. secureEntry: true,
  1601. },
  1602. ],
  1603. },
  1604. tables: [
  1605. {
  1606. label: 'Airtable Table',
  1607. description: 'Map to an Airtable Table',
  1608. options: [
  1609. {
  1610. name: 'base_id',
  1611. label: 'Base ID',
  1612. editable: true,
  1613. required: true,
  1614. type: 'text',
  1615. },
  1616. {
  1617. name: 'table_id',
  1618. label: 'Table ID',
  1619. editable: true,
  1620. required: true,
  1621. type: 'text',
  1622. },
  1623. ],
  1624. },
  1625. ],
  1626. },
  1627. {
  1628. name: 'logflare_wrapper',
  1629. handlerName: WRAPPER_HANDLERS.LOGFLARE,
  1630. validatorName: 'logflare_fdw_validator',
  1631. icon: `${BASE_PATH}/img/icons/logflare-icon.svg`,
  1632. description: 'Log management and analytics service',
  1633. extensionName: 'logflareFdw',
  1634. label: 'Logflare',
  1635. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/logflare`,
  1636. server: {
  1637. options: [
  1638. {
  1639. name: 'api_key_id',
  1640. label: 'API Key ID',
  1641. required: true,
  1642. encrypted: true,
  1643. secureEntry: true,
  1644. },
  1645. ],
  1646. },
  1647. tables: [
  1648. {
  1649. label: 'Logflare Table',
  1650. description: 'Map to a Logflare Table',
  1651. options: [
  1652. {
  1653. name: 'endpoint',
  1654. label: 'Endpoint',
  1655. editable: true,
  1656. required: true,
  1657. type: 'text',
  1658. },
  1659. ],
  1660. },
  1661. ],
  1662. },
  1663. {
  1664. name: 'auth0_wrapper',
  1665. handlerName: WRAPPER_HANDLERS.AUTH0,
  1666. validatorName: 'auth0_fdw_validator',
  1667. icon: `${BASE_PATH}/img/icons/auth0-icon.svg`,
  1668. description: 'Identity and access management platform',
  1669. extensionName: 'Auth0Fdw',
  1670. label: 'Auth0',
  1671. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/auth0`,
  1672. minimumExtensionVersion: '0.3.0',
  1673. server: {
  1674. options: [
  1675. {
  1676. name: 'api_key_id',
  1677. label: 'Auth0 API key or PAT',
  1678. required: true,
  1679. encrypted: true,
  1680. secureEntry: true,
  1681. },
  1682. {
  1683. name: 'url',
  1684. label: 'Auth0 API URL',
  1685. defaultValue: 'https://dev-<tenant-id>.us.auth0.com/api/v2/users',
  1686. required: false,
  1687. encrypted: false,
  1688. secureEntry: false,
  1689. },
  1690. ],
  1691. },
  1692. tables: [
  1693. {
  1694. label: 'Users',
  1695. description: 'Auth0 Users',
  1696. availableColumns: [
  1697. {
  1698. name: 'user_id',
  1699. type: 'text',
  1700. },
  1701. {
  1702. name: 'email',
  1703. type: 'text',
  1704. },
  1705. {
  1706. name: 'email_verified',
  1707. type: 'boolean',
  1708. },
  1709. {
  1710. name: 'username',
  1711. type: 'text',
  1712. },
  1713. {
  1714. name: 'phone_number',
  1715. type: 'text',
  1716. },
  1717. {
  1718. name: 'phone_verified',
  1719. type: 'boolean',
  1720. },
  1721. {
  1722. name: 'created_at',
  1723. type: 'jsonb',
  1724. },
  1725. {
  1726. name: 'updated_at',
  1727. type: 'jsonb',
  1728. },
  1729. {
  1730. name: 'identities',
  1731. type: 'jsonb',
  1732. },
  1733. {
  1734. name: 'app_metadata',
  1735. type: 'jsonb',
  1736. },
  1737. {
  1738. name: 'user_metadata',
  1739. type: 'jsonb',
  1740. },
  1741. {
  1742. name: 'picture',
  1743. type: 'text',
  1744. },
  1745. {
  1746. name: 'name',
  1747. type: 'text',
  1748. },
  1749. {
  1750. name: 'nickname',
  1751. type: 'text',
  1752. },
  1753. {
  1754. name: 'multifactor',
  1755. type: 'jsonb',
  1756. },
  1757. {
  1758. name: 'last_ip',
  1759. type: 'text',
  1760. },
  1761. {
  1762. name: 'last_login',
  1763. type: 'jsonb',
  1764. },
  1765. {
  1766. name: 'logins_count',
  1767. type: 'integer',
  1768. },
  1769. {
  1770. name: 'blocked',
  1771. type: 'boolean',
  1772. },
  1773. {
  1774. name: 'given_name',
  1775. type: 'text',
  1776. },
  1777. {
  1778. name: 'family_name',
  1779. type: 'text',
  1780. },
  1781. ],
  1782. options: [
  1783. {
  1784. name: 'object',
  1785. defaultValue: 'users',
  1786. editable: false,
  1787. required: true,
  1788. type: 'text',
  1789. },
  1790. ],
  1791. },
  1792. ],
  1793. },
  1794. {
  1795. name: 'cognito_wrapper',
  1796. handlerName: WRAPPER_HANDLERS.COGNITO,
  1797. validatorName: 'cognito_fdw_validator',
  1798. icon: `${BASE_PATH}/img/icons/cognito-icon.svg`,
  1799. description: 'AWS user authentication and authorization',
  1800. extensionName: 'CognitoFdw',
  1801. label: 'Cognito',
  1802. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/cognito`,
  1803. minimumExtensionVersion: '0.3.0',
  1804. server: {
  1805. options: [
  1806. {
  1807. name: 'aws_access_key_id',
  1808. label: 'AWS Access Key ID',
  1809. required: true,
  1810. encrypted: false,
  1811. secureEntry: false,
  1812. },
  1813. {
  1814. name: 'api_key_id',
  1815. label: 'AWS Secret Key',
  1816. required: true,
  1817. encrypted: true,
  1818. secureEntry: true,
  1819. },
  1820. {
  1821. name: 'region',
  1822. label: 'Region',
  1823. required: true,
  1824. encrypted: false,
  1825. secureEntry: false,
  1826. },
  1827. {
  1828. name: 'user_pool_id',
  1829. label: 'User Pool ID',
  1830. required: true,
  1831. encrypted: false,
  1832. secureEntry: false,
  1833. },
  1834. BRIVEN_TARGET_SCHEMA_OPTION,
  1835. ],
  1836. },
  1837. canTargetSchema: true,
  1838. sourceSchemaOption: {
  1839. name: 'source_schema',
  1840. label: 'Source Schema',
  1841. required: true,
  1842. encrypted: false,
  1843. secureEntry: false,
  1844. readOnly: true,
  1845. defaultValue: 'cognito',
  1846. },
  1847. tables: [
  1848. {
  1849. label: 'Users',
  1850. description: 'Cognito Users',
  1851. availableColumns: [
  1852. {
  1853. name: 'email',
  1854. type: 'text',
  1855. },
  1856. {
  1857. name: 'created_at',
  1858. type: 'text',
  1859. },
  1860. {
  1861. name: 'email_verified',
  1862. type: 'boolean',
  1863. },
  1864. {
  1865. name: 'identities',
  1866. type: 'jsonb',
  1867. },
  1868. {
  1869. name: 'username',
  1870. type: 'text',
  1871. },
  1872. {
  1873. name: 'status',
  1874. type: 'text',
  1875. },
  1876. ],
  1877. options: [
  1878. {
  1879. name: 'object',
  1880. defaultValue: 'users',
  1881. editable: false,
  1882. required: true,
  1883. type: 'text',
  1884. },
  1885. ],
  1886. },
  1887. ],
  1888. },
  1889. {
  1890. name: 'mssql_wrapper',
  1891. handlerName: WRAPPER_HANDLERS.MSSQL,
  1892. validatorName: 'mssql_fdw_validator',
  1893. icon: `${BASE_PATH}/img/icons/mssql-icon.svg`,
  1894. description: 'Microsoft SQL Server database',
  1895. extensionName: 'mssqlFdw',
  1896. label: 'Microsoft SQL Server',
  1897. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/mssql`,
  1898. minimumExtensionVersion: '0.3.0',
  1899. server: {
  1900. options: [
  1901. {
  1902. name: 'conn_string_id',
  1903. label: 'Connection String',
  1904. required: true,
  1905. encrypted: true,
  1906. secureEntry: true,
  1907. },
  1908. ],
  1909. },
  1910. tables: [
  1911. {
  1912. label: 'Microsoft SQL Server Table',
  1913. description: 'Map to an Microsoft SQL Server Table',
  1914. options: [
  1915. {
  1916. name: 'table',
  1917. label: 'MSSQL Table',
  1918. editable: true,
  1919. required: true,
  1920. type: 'text',
  1921. },
  1922. ],
  1923. },
  1924. ],
  1925. },
  1926. {
  1927. name: 'redis_wrapper',
  1928. handlerName: WRAPPER_HANDLERS.REDIS,
  1929. validatorName: 'redis_fdw_validator',
  1930. icon: `${BASE_PATH}/img/icons/redis-icon.svg`,
  1931. description: 'In-memory data structure store',
  1932. extensionName: 'redisFdw',
  1933. label: 'Redis',
  1934. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/redis`,
  1935. minimumExtensionVersion: '0.3.0',
  1936. server: {
  1937. options: [
  1938. {
  1939. name: 'conn_url_id',
  1940. label: 'Connection URL',
  1941. required: true,
  1942. encrypted: true,
  1943. secureEntry: true,
  1944. },
  1945. ],
  1946. },
  1947. tables: [
  1948. {
  1949. label: 'List',
  1950. description: 'Redis list data structure',
  1951. availableColumns: [
  1952. {
  1953. name: 'element',
  1954. type: 'text',
  1955. },
  1956. ],
  1957. options: [
  1958. {
  1959. name: 'src_type',
  1960. defaultValue: 'list',
  1961. editable: false,
  1962. required: true,
  1963. type: 'text',
  1964. },
  1965. {
  1966. name: 'src_key',
  1967. label: 'Source Key',
  1968. editable: true,
  1969. required: true,
  1970. type: 'text',
  1971. },
  1972. ],
  1973. },
  1974. {
  1975. label: 'Set',
  1976. description: 'Redis set data structure',
  1977. availableColumns: [
  1978. {
  1979. name: 'element',
  1980. type: 'text',
  1981. },
  1982. ],
  1983. options: [
  1984. {
  1985. name: 'src_type',
  1986. defaultValue: 'set',
  1987. editable: false,
  1988. required: true,
  1989. type: 'text',
  1990. },
  1991. {
  1992. name: 'src_key',
  1993. label: 'Source Key',
  1994. editable: true,
  1995. required: true,
  1996. type: 'text',
  1997. },
  1998. ],
  1999. },
  2000. {
  2001. label: 'Sorted Set (zset)',
  2002. description: 'Redis sorted set data structure',
  2003. availableColumns: [
  2004. {
  2005. name: 'element',
  2006. type: 'text',
  2007. },
  2008. ],
  2009. options: [
  2010. {
  2011. name: 'src_type',
  2012. defaultValue: 'zset',
  2013. editable: false,
  2014. required: true,
  2015. type: 'text',
  2016. },
  2017. {
  2018. name: 'src_key',
  2019. label: 'Source Key',
  2020. editable: true,
  2021. required: true,
  2022. type: 'text',
  2023. },
  2024. ],
  2025. },
  2026. {
  2027. label: 'Hash',
  2028. description: 'Redis hash data structure',
  2029. availableColumns: [
  2030. {
  2031. name: 'key',
  2032. type: 'text',
  2033. },
  2034. {
  2035. name: 'value',
  2036. type: 'text',
  2037. },
  2038. ],
  2039. options: [
  2040. {
  2041. name: 'src_type',
  2042. defaultValue: 'hash',
  2043. editable: false,
  2044. required: true,
  2045. type: 'text',
  2046. },
  2047. {
  2048. name: 'src_key',
  2049. label: 'Source Key',
  2050. editable: true,
  2051. required: true,
  2052. type: 'text',
  2053. },
  2054. ],
  2055. },
  2056. {
  2057. label: 'Stream',
  2058. description: 'Redis stream data structure',
  2059. availableColumns: [
  2060. {
  2061. name: 'id',
  2062. type: 'text',
  2063. },
  2064. {
  2065. name: 'items',
  2066. type: 'text',
  2067. },
  2068. ],
  2069. options: [
  2070. {
  2071. name: 'src_type',
  2072. defaultValue: 'stream',
  2073. editable: false,
  2074. required: true,
  2075. type: 'text',
  2076. },
  2077. {
  2078. name: 'src_key',
  2079. label: 'Source Key',
  2080. editable: true,
  2081. required: true,
  2082. type: 'text',
  2083. },
  2084. ],
  2085. },
  2086. {
  2087. label: 'Multi List',
  2088. description: 'Query multiple Redis lists',
  2089. availableColumns: [
  2090. {
  2091. name: 'key',
  2092. type: 'text',
  2093. },
  2094. {
  2095. name: 'items',
  2096. type: 'text',
  2097. },
  2098. ],
  2099. options: [
  2100. {
  2101. name: 'src_type',
  2102. defaultValue: 'multi_list',
  2103. editable: false,
  2104. required: true,
  2105. type: 'text',
  2106. },
  2107. ],
  2108. },
  2109. {
  2110. label: 'Multi Set',
  2111. description: 'Query multiple Redis sets',
  2112. availableColumns: [
  2113. {
  2114. name: 'key',
  2115. type: 'text',
  2116. },
  2117. {
  2118. name: 'items',
  2119. type: 'text',
  2120. },
  2121. ],
  2122. options: [
  2123. {
  2124. name: 'src_type',
  2125. defaultValue: 'multi_set',
  2126. editable: false,
  2127. required: true,
  2128. type: 'text',
  2129. },
  2130. ],
  2131. },
  2132. {
  2133. label: 'Multi Hash',
  2134. description: 'Query multiple Redis hashes',
  2135. availableColumns: [
  2136. {
  2137. name: 'key',
  2138. type: 'text',
  2139. },
  2140. {
  2141. name: 'items',
  2142. type: 'text',
  2143. },
  2144. ],
  2145. options: [
  2146. {
  2147. name: 'src_type',
  2148. defaultValue: 'multi_hash',
  2149. editable: false,
  2150. required: true,
  2151. type: 'text',
  2152. },
  2153. ],
  2154. },
  2155. {
  2156. label: 'Multi Sorted Set (multi_zset)',
  2157. description: 'Query multiple Redis sorted sets',
  2158. availableColumns: [
  2159. {
  2160. name: 'key',
  2161. type: 'text',
  2162. },
  2163. {
  2164. name: 'items',
  2165. type: 'text',
  2166. },
  2167. ],
  2168. options: [
  2169. {
  2170. name: 'src_type',
  2171. defaultValue: 'multi_zset',
  2172. editable: false,
  2173. required: true,
  2174. type: 'text',
  2175. },
  2176. ],
  2177. },
  2178. ],
  2179. },
  2180. {
  2181. name: 'paddle_wrapper',
  2182. handlerName: WRAPPER_HANDLERS.PADDLE,
  2183. validatorName: 'wasm_fdw_validator',
  2184. icon: `${BASE_PATH}/img/icons/paddle-icon.svg`,
  2185. description: 'Subscription billing and payments platform',
  2186. extensionName: 'paddleFdw',
  2187. label: 'Paddle',
  2188. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/paddle`,
  2189. minimumExtensionVersion: '0.4.0',
  2190. server: {
  2191. options: [
  2192. {
  2193. name: 'fdw_package_url',
  2194. label: 'FDW Package URL',
  2195. required: true,
  2196. encrypted: false,
  2197. secureEntry: false,
  2198. defaultValue:
  2199. 'https://github.com/briven/wrappers/releases/download/wasm_paddle_fdw_v0.1.1/paddle_fdw.wasm',
  2200. hidden: true,
  2201. },
  2202. {
  2203. name: 'fdw_package_name',
  2204. label: 'FDW Package Name',
  2205. required: true,
  2206. encrypted: false,
  2207. secureEntry: false,
  2208. defaultValue: 'briven:paddle-fdw',
  2209. hidden: true,
  2210. },
  2211. {
  2212. name: 'fdw_package_version',
  2213. label: 'FDW Package Version',
  2214. required: true,
  2215. encrypted: false,
  2216. secureEntry: false,
  2217. defaultValue: '0.1.1',
  2218. hidden: true,
  2219. },
  2220. {
  2221. name: 'fdw_package_checksum',
  2222. label: 'FDW Package Checksum',
  2223. required: true,
  2224. encrypted: false,
  2225. secureEntry: false,
  2226. defaultValue: 'c5ac70bb2eef33693787b7d4efce9a83cde8d4fa40889d2037403a51263ba657',
  2227. hidden: true,
  2228. },
  2229. {
  2230. name: 'api_url',
  2231. label: 'Paddle API URL',
  2232. defaultValue: 'https://api.paddle.com',
  2233. required: true,
  2234. encrypted: false,
  2235. secureEntry: false,
  2236. },
  2237. {
  2238. name: 'api_key_id',
  2239. label: 'Paddle API Key',
  2240. required: true,
  2241. encrypted: true,
  2242. secureEntry: true,
  2243. },
  2244. ],
  2245. },
  2246. tables: [
  2247. {
  2248. label: 'Paddle Object',
  2249. description: 'Map to an Paddle Object',
  2250. options: [
  2251. {
  2252. name: 'object',
  2253. label: 'Object',
  2254. editable: true,
  2255. required: true,
  2256. type: 'select',
  2257. defaultValue: 'products',
  2258. options: [
  2259. { label: 'Products', value: 'products' },
  2260. { label: 'Prices', value: 'prices' },
  2261. { label: 'Discounts', value: 'discounts' },
  2262. { label: 'Customers', value: 'customers' },
  2263. { label: 'Transactions', value: 'transactions' },
  2264. { label: 'Reports', value: 'reports' },
  2265. { label: 'Notification Settings', value: 'notification-settings' },
  2266. { label: 'notifications', value: 'notifications' },
  2267. ],
  2268. },
  2269. {
  2270. name: 'rowid_column',
  2271. label: 'Row ID Column',
  2272. defaultValue: 'id',
  2273. editable: true,
  2274. required: true,
  2275. type: 'text',
  2276. },
  2277. ],
  2278. },
  2279. ],
  2280. },
  2281. {
  2282. name: 'snowflake_wrapper',
  2283. handlerName: WRAPPER_HANDLERS.SNOWFLAKE,
  2284. validatorName: 'wasm_fdw_validator',
  2285. icon: `${BASE_PATH}/img/icons/snowflake-icon.svg`,
  2286. description: 'Cloud data warehouse platform',
  2287. extensionName: 'snowflakeFdw',
  2288. label: 'Snowflake',
  2289. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/snowflake`,
  2290. minimumExtensionVersion: '0.4.0',
  2291. server: {
  2292. options: [
  2293. {
  2294. name: 'fdw_package_url',
  2295. label: 'FDW Package URL',
  2296. required: true,
  2297. encrypted: false,
  2298. secureEntry: false,
  2299. defaultValue:
  2300. 'https://github.com/briven/wrappers/releases/download/wasm_snowflake_fdw_v0.1.1/snowflake_fdw.wasm',
  2301. hidden: true,
  2302. },
  2303. {
  2304. name: 'fdw_package_name',
  2305. label: 'FDW Package Name',
  2306. required: true,
  2307. encrypted: false,
  2308. secureEntry: false,
  2309. defaultValue: 'briven:snowflake-fdw',
  2310. hidden: true,
  2311. },
  2312. {
  2313. name: 'fdw_package_version',
  2314. label: 'FDW Package Version',
  2315. required: true,
  2316. encrypted: false,
  2317. secureEntry: false,
  2318. defaultValue: '0.1.1',
  2319. hidden: true,
  2320. },
  2321. {
  2322. name: 'fdw_package_checksum',
  2323. label: 'FDW Package Checksum',
  2324. required: true,
  2325. encrypted: false,
  2326. secureEntry: false,
  2327. defaultValue: '7aaafc7edc1726bc93ddc04452d41bda9e1a264a1df2ea9bf1b00b267543b860',
  2328. hidden: true,
  2329. },
  2330. {
  2331. name: 'account_identifier',
  2332. label: 'Account Identifier',
  2333. required: true,
  2334. encrypted: false,
  2335. secureEntry: false,
  2336. },
  2337. {
  2338. name: 'user',
  2339. label: 'User',
  2340. required: true,
  2341. encrypted: false,
  2342. secureEntry: false,
  2343. },
  2344. {
  2345. name: 'public_key_fingerprint',
  2346. label: 'Public Key Fingerprint',
  2347. required: true,
  2348. encrypted: false,
  2349. secureEntry: false,
  2350. },
  2351. {
  2352. name: 'private_key_id',
  2353. label: 'Private Key',
  2354. required: true,
  2355. encrypted: true,
  2356. secureEntry: true,
  2357. },
  2358. ],
  2359. },
  2360. tables: [
  2361. {
  2362. label: 'Snowflake Table',
  2363. description: 'Map to an Snowflake Table',
  2364. options: [
  2365. {
  2366. name: 'table',
  2367. label: 'Table',
  2368. editable: true,
  2369. required: true,
  2370. type: 'text',
  2371. },
  2372. {
  2373. name: 'rowid_column',
  2374. label: 'Row ID Column',
  2375. defaultValue: 'id',
  2376. editable: true,
  2377. required: true,
  2378. type: 'text',
  2379. },
  2380. ],
  2381. },
  2382. ],
  2383. },
  2384. {
  2385. name: 'iceberg_wrapper',
  2386. handlerName: WRAPPER_HANDLERS.ICEBERG,
  2387. validatorName: 'iceberg_fdw_validator',
  2388. icon: `${BASE_PATH}/img/icons/iceberg-icon.svg`,
  2389. description: 'Iceberg is a data warehouse',
  2390. extensionName: 'icebergFdw',
  2391. label: 'Iceberg',
  2392. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/iceberg`,
  2393. minimumExtensionVersion: '0.5.3',
  2394. customComponent: true,
  2395. server: {
  2396. // The fields are intentionally not required. The required flag is enforced in the create iceberg wrapper sheet.
  2397. // In the edit wrapper sheet, all fields are shown and not required.
  2398. options: [
  2399. {
  2400. name: 'vault_aws_access_key_id',
  2401. label: 'AWS Access Key ID',
  2402. required: false,
  2403. encrypted: true,
  2404. secureEntry: true,
  2405. },
  2406. {
  2407. name: 'vault_aws_secret_access_key',
  2408. label: 'AWS Secret Access Key',
  2409. required: false,
  2410. encrypted: true,
  2411. secureEntry: true,
  2412. },
  2413. {
  2414. name: 'region_name',
  2415. label: 'Region Name',
  2416. required: false,
  2417. encrypted: false,
  2418. secureEntry: false,
  2419. },
  2420. {
  2421. name: 'vault_aws_s3table_bucket_arn',
  2422. label: 'AWS S3 Table Bucket ARN',
  2423. required: false,
  2424. encrypted: true,
  2425. secureEntry: true,
  2426. },
  2427. {
  2428. name: 'vault_token',
  2429. label: 'Token',
  2430. required: false,
  2431. encrypted: true,
  2432. secureEntry: true,
  2433. },
  2434. {
  2435. name: 'warehouse',
  2436. label: 'Warehouse',
  2437. required: false,
  2438. encrypted: false,
  2439. secureEntry: false,
  2440. },
  2441. {
  2442. name: 's3.endpoint',
  2443. label: 'S3 Endpoint',
  2444. required: false,
  2445. encrypted: false,
  2446. secureEntry: false,
  2447. },
  2448. {
  2449. name: 'catalog_uri',
  2450. label: 'Catalog URI',
  2451. required: false,
  2452. encrypted: false,
  2453. secureEntry: false,
  2454. },
  2455. BRIVEN_TARGET_SCHEMA_OPTION,
  2456. ],
  2457. },
  2458. canTargetSchema: true,
  2459. sourceSchemaOption: {
  2460. name: 'source_schema',
  2461. label: 'Namespace',
  2462. description: 'It should match the namespace of the Iceberg catalog.',
  2463. required: true,
  2464. encrypted: false,
  2465. secureEntry: false,
  2466. defaultValue: '',
  2467. },
  2468. tables: [],
  2469. },
  2470. {
  2471. name: 'cal_wrapper',
  2472. description: 'Cal.com is a scheduling platform',
  2473. handlerName: WRAPPER_HANDLERS.CAL,
  2474. validatorName: 'wasm_fdw_validator',
  2475. icon: `${BASE_PATH}/img/icons/cal-com-icon.svg`,
  2476. extensionName: 'calFdw',
  2477. label: 'Cal.com',
  2478. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/cal`,
  2479. minimumExtensionVersion: '0.4.0',
  2480. server: {
  2481. options: [
  2482. {
  2483. name: 'fdw_package_url',
  2484. label: 'FDW Package URL',
  2485. required: true,
  2486. encrypted: false,
  2487. secureEntry: false,
  2488. defaultValue:
  2489. 'https://github.com/briven/wrappers/releases/download/wasm_cal_fdw_v0.1.0/cal_fdw.wasm',
  2490. hidden: true,
  2491. },
  2492. {
  2493. name: 'fdw_package_name',
  2494. label: 'FDW Package Name',
  2495. required: true,
  2496. encrypted: false,
  2497. secureEntry: false,
  2498. defaultValue: 'briven:cal-fdw',
  2499. hidden: true,
  2500. },
  2501. {
  2502. name: 'fdw_package_version',
  2503. label: 'FDW Package Version',
  2504. required: true,
  2505. encrypted: false,
  2506. secureEntry: false,
  2507. defaultValue: '0.1.0',
  2508. hidden: true,
  2509. },
  2510. {
  2511. name: 'fdw_package_checksum',
  2512. label: 'FDW Package Checksum',
  2513. required: true,
  2514. encrypted: false,
  2515. secureEntry: false,
  2516. defaultValue: 'bca8a82d6c5f8da0aa58011940c4ddb40bb2c909c02dd89b488289c4fff890c1',
  2517. hidden: true,
  2518. },
  2519. {
  2520. name: 'api_url',
  2521. label: 'API URL',
  2522. required: false,
  2523. encrypted: false,
  2524. secureEntry: false,
  2525. defaultValue: 'https://api.cal.com/v2',
  2526. },
  2527. {
  2528. name: 'api_key_id',
  2529. label: 'API Key ID',
  2530. required: true,
  2531. encrypted: true,
  2532. secureEntry: true,
  2533. },
  2534. ],
  2535. },
  2536. tables: [
  2537. {
  2538. label: 'My Profile',
  2539. description: 'Shows your Cal profile',
  2540. availableColumns: [
  2541. {
  2542. name: 'id',
  2543. type: 'bigint',
  2544. },
  2545. {
  2546. name: 'username',
  2547. type: 'text',
  2548. },
  2549. {
  2550. name: 'email',
  2551. type: 'text',
  2552. },
  2553. {
  2554. name: 'attrs',
  2555. type: 'jsonb',
  2556. },
  2557. ],
  2558. options: [
  2559. {
  2560. name: 'object',
  2561. defaultValue: 'my_profile',
  2562. editable: false,
  2563. required: true,
  2564. type: 'text',
  2565. },
  2566. ],
  2567. },
  2568. {
  2569. label: 'Event Types',
  2570. description: 'Shows your Event Types',
  2571. availableColumns: [
  2572. {
  2573. name: 'attrs',
  2574. type: 'jsonb',
  2575. },
  2576. ],
  2577. options: [
  2578. {
  2579. name: 'object',
  2580. defaultValue: 'event-types',
  2581. editable: false,
  2582. required: true,
  2583. type: 'text',
  2584. },
  2585. ],
  2586. },
  2587. {
  2588. label: 'Bookings',
  2589. description: 'Shows your Bookings',
  2590. availableColumns: [
  2591. {
  2592. name: 'attrs',
  2593. type: 'jsonb',
  2594. },
  2595. ],
  2596. options: [
  2597. {
  2598. name: 'object',
  2599. defaultValue: 'bookings',
  2600. editable: false,
  2601. required: true,
  2602. type: 'text',
  2603. },
  2604. ],
  2605. },
  2606. {
  2607. label: 'Calendars',
  2608. description: 'Shows your Calendars',
  2609. availableColumns: [
  2610. {
  2611. name: 'attrs',
  2612. type: 'jsonb',
  2613. },
  2614. ],
  2615. options: [
  2616. {
  2617. name: 'object',
  2618. defaultValue: 'calendars',
  2619. editable: false,
  2620. required: true,
  2621. type: 'text',
  2622. },
  2623. ],
  2624. },
  2625. {
  2626. label: 'Schedules',
  2627. description: 'Shows your Schedules',
  2628. availableColumns: [
  2629. {
  2630. name: 'id',
  2631. type: 'bigint',
  2632. },
  2633. {
  2634. name: 'name',
  2635. type: 'text',
  2636. },
  2637. {
  2638. name: 'attrs',
  2639. type: 'jsonb',
  2640. },
  2641. ],
  2642. options: [
  2643. {
  2644. name: 'object',
  2645. defaultValue: 'schedules',
  2646. editable: false,
  2647. required: true,
  2648. type: 'text',
  2649. },
  2650. ],
  2651. },
  2652. {
  2653. label: 'Conferencing',
  2654. description: 'Shows conferencing',
  2655. availableColumns: [
  2656. {
  2657. name: 'id',
  2658. type: 'bigint',
  2659. },
  2660. {
  2661. name: 'attrs',
  2662. type: 'jsonb',
  2663. },
  2664. ],
  2665. options: [
  2666. {
  2667. name: 'object',
  2668. defaultValue: 'conferencing',
  2669. editable: false,
  2670. required: true,
  2671. type: 'text',
  2672. },
  2673. ],
  2674. },
  2675. ],
  2676. },
  2677. {
  2678. name: 'calendly_wrapper',
  2679. description: 'Calendly is a scheduling platform',
  2680. handlerName: WRAPPER_HANDLERS.CALENDLY,
  2681. validatorName: 'wasm_fdw_validator',
  2682. icon: `${BASE_PATH}/img/icons/calendly-icon.svg`,
  2683. extensionName: 'calendlyFdw',
  2684. label: 'Calendly',
  2685. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/calendly`,
  2686. minimumExtensionVersion: '0.4.0',
  2687. server: {
  2688. options: [
  2689. {
  2690. name: 'fdw_package_url',
  2691. label: 'FDW Package URL',
  2692. required: true,
  2693. encrypted: false,
  2694. secureEntry: false,
  2695. defaultValue:
  2696. 'https://github.com/briven/wrappers/releases/download/wasm_calendly_fdw_v0.1.0/calendly_fdw.wasm',
  2697. hidden: true,
  2698. },
  2699. {
  2700. name: 'fdw_package_name',
  2701. label: 'FDW Package Name',
  2702. required: true,
  2703. encrypted: false,
  2704. secureEntry: false,
  2705. defaultValue: 'briven:calendly-fdw',
  2706. hidden: true,
  2707. },
  2708. {
  2709. name: 'fdw_package_version',
  2710. label: 'FDW Package Version',
  2711. required: true,
  2712. encrypted: false,
  2713. secureEntry: false,
  2714. defaultValue: '0.1.0',
  2715. hidden: true,
  2716. },
  2717. {
  2718. name: 'fdw_package_checksum',
  2719. label: 'FDW Package Checksum',
  2720. required: true,
  2721. encrypted: false,
  2722. secureEntry: false,
  2723. defaultValue: 'aa17f1ce2b48b5d8d6cee4f61df4d6b23e9a333c3e5c7a10cec9aae619c156b9',
  2724. hidden: true,
  2725. },
  2726. {
  2727. name: 'organization',
  2728. label: 'Organization URL',
  2729. required: true,
  2730. encrypted: false,
  2731. secureEntry: false,
  2732. defaultValue:
  2733. 'https://api.calendly.com/organizations/00000000-0000-0000-0000-000000000000',
  2734. },
  2735. {
  2736. name: 'api_url',
  2737. label: 'API URL',
  2738. required: false,
  2739. encrypted: false,
  2740. secureEntry: false,
  2741. defaultValue: 'https://api.calendly.com',
  2742. },
  2743. {
  2744. name: 'api_key_id',
  2745. label: 'API Key ID',
  2746. required: true,
  2747. encrypted: true,
  2748. secureEntry: true,
  2749. },
  2750. ],
  2751. },
  2752. tables: [
  2753. {
  2754. label: 'Current User',
  2755. description: 'Get the current user used for the API request',
  2756. availableColumns: [
  2757. {
  2758. name: 'uri',
  2759. type: 'text',
  2760. },
  2761. {
  2762. name: 'slug',
  2763. type: 'text',
  2764. },
  2765. {
  2766. name: 'created_at',
  2767. type: 'timestamp',
  2768. },
  2769. {
  2770. name: 'updated_at',
  2771. type: 'timestamp',
  2772. },
  2773. {
  2774. name: 'attrs',
  2775. type: 'jsonb',
  2776. },
  2777. ],
  2778. options: [
  2779. {
  2780. name: 'object',
  2781. defaultValue: 'current_user',
  2782. editable: false,
  2783. required: true,
  2784. type: 'text',
  2785. },
  2786. ],
  2787. },
  2788. {
  2789. label: 'Event Types',
  2790. description: 'Shows your Event Types',
  2791. availableColumns: [
  2792. {
  2793. name: 'uri',
  2794. type: 'text',
  2795. },
  2796. {
  2797. name: 'created_at',
  2798. type: 'timestamp',
  2799. },
  2800. {
  2801. name: 'updated_at',
  2802. type: 'timestamp',
  2803. },
  2804. {
  2805. name: 'attrs',
  2806. type: 'jsonb',
  2807. },
  2808. ],
  2809. options: [
  2810. {
  2811. name: 'object',
  2812. defaultValue: 'event_types',
  2813. editable: false,
  2814. required: true,
  2815. type: 'text',
  2816. },
  2817. ],
  2818. },
  2819. {
  2820. label: 'Groups',
  2821. description: 'Shows your groups',
  2822. availableColumns: [
  2823. {
  2824. name: 'uri',
  2825. type: 'text',
  2826. },
  2827. {
  2828. name: 'created_at',
  2829. type: 'timestamp',
  2830. },
  2831. {
  2832. name: 'updated_at',
  2833. type: 'timestamp',
  2834. },
  2835. {
  2836. name: 'attrs',
  2837. type: 'jsonb',
  2838. },
  2839. ],
  2840. options: [
  2841. {
  2842. name: 'object',
  2843. defaultValue: 'groups',
  2844. editable: false,
  2845. required: true,
  2846. type: 'text',
  2847. },
  2848. ],
  2849. },
  2850. {
  2851. label: 'Organization Memberships',
  2852. description: 'Shows your Organization Memberships',
  2853. availableColumns: [
  2854. {
  2855. name: 'uri',
  2856. type: 'text',
  2857. },
  2858. {
  2859. name: 'created_at',
  2860. type: 'timestamp',
  2861. },
  2862. {
  2863. name: 'updated_at',
  2864. type: 'timestamp',
  2865. },
  2866. {
  2867. name: 'attrs',
  2868. type: 'jsonb',
  2869. },
  2870. ],
  2871. options: [
  2872. {
  2873. name: 'object',
  2874. defaultValue: 'organization_memberships',
  2875. editable: false,
  2876. required: true,
  2877. type: 'text',
  2878. },
  2879. ],
  2880. },
  2881. {
  2882. label: 'Scheduled Events',
  2883. description: 'Shows your scheduled events',
  2884. availableColumns: [
  2885. {
  2886. name: 'uri',
  2887. type: 'text',
  2888. },
  2889. {
  2890. name: 'created_at',
  2891. type: 'timestamp',
  2892. },
  2893. {
  2894. name: 'updated_at',
  2895. type: 'timestamp',
  2896. },
  2897. {
  2898. name: 'attrs',
  2899. type: 'jsonb',
  2900. },
  2901. ],
  2902. options: [
  2903. {
  2904. name: 'object',
  2905. defaultValue: 'scheduled_events',
  2906. editable: false,
  2907. required: true,
  2908. type: 'text',
  2909. },
  2910. ],
  2911. },
  2912. ],
  2913. },
  2914. {
  2915. name: 'clerk_wrapper',
  2916. description: 'User Management Platform',
  2917. handlerName: WRAPPER_HANDLERS.CLERK,
  2918. validatorName: 'wasm_fdw_validator',
  2919. icon: `${BASE_PATH}/img/icons/clerk-icon.svg`,
  2920. extensionName: 'clerkFdw',
  2921. label: 'Clerk',
  2922. docsUrl: `${DOCS_URL}/guides/database/extensions/wrappers/clerk`,
  2923. minimumExtensionVersion: '0.4.0',
  2924. server: {
  2925. options: [
  2926. {
  2927. name: 'fdw_package_url',
  2928. label: 'FDW Package URL',
  2929. required: true,
  2930. encrypted: false,
  2931. secureEntry: false,
  2932. defaultValue:
  2933. 'https://github.com/briven/wrappers/releases/download/wasm_clerk_fdw_v0.1.0/clerk_fdw.wasm',
  2934. hidden: true,
  2935. },
  2936. {
  2937. name: 'fdw_package_name',
  2938. label: 'FDW Package Name',
  2939. required: true,
  2940. encrypted: false,
  2941. secureEntry: false,
  2942. defaultValue: 'briven:clerk-fdw',
  2943. hidden: true,
  2944. },
  2945. {
  2946. name: 'fdw_package_version',
  2947. label: 'FDW Package Version',
  2948. required: true,
  2949. encrypted: false,
  2950. secureEntry: false,
  2951. defaultValue: '0.1.0',
  2952. hidden: true,
  2953. },
  2954. {
  2955. name: 'fdw_package_checksum',
  2956. label: 'FDW Package Checksum',
  2957. required: true,
  2958. encrypted: false,
  2959. secureEntry: false,
  2960. defaultValue: '613be26b59fa4c074e0b93f0db617fcd7b468d4d02edece0b1f85fdb683ebdc4',
  2961. hidden: true,
  2962. },
  2963. {
  2964. name: 'api_url',
  2965. label: 'Clerk API URL',
  2966. required: false,
  2967. encrypted: false,
  2968. secureEntry: false,
  2969. defaultValue: 'https://api.clerk.com/v1',
  2970. },
  2971. {
  2972. name: 'api_key_id',
  2973. label: 'Clerk API Key',
  2974. required: true,
  2975. encrypted: true,
  2976. secureEntry: true,
  2977. },
  2978. ],
  2979. },
  2980. tables: [
  2981. {
  2982. label: 'Allow List',
  2983. description: 'List of all identifiers allowed to sign up to an instance',
  2984. availableColumns: [
  2985. { name: 'id', type: 'text' },
  2986. { name: 'invitation_id', type: 'text' },
  2987. { name: 'identifier', type: 'text' },
  2988. { name: 'identifier_type', type: 'text' },
  2989. { name: 'instance_id', type: 'text' },
  2990. { name: 'created_at', type: 'timestamp' },
  2991. { name: 'updated_at', type: 'timestamp' },
  2992. { name: 'attrs', type: 'jsonb' },
  2993. ],
  2994. options: [
  2995. {
  2996. name: 'object',
  2997. defaultValue: 'allowlist_identifiers',
  2998. editable: false,
  2999. required: true,
  3000. type: 'text',
  3001. },
  3002. ],
  3003. },
  3004. {
  3005. label: 'Block List',
  3006. description: 'List of all identifiers which are not allowed to access an instance',
  3007. availableColumns: [
  3008. { name: 'id', type: 'text' },
  3009. { name: 'identifier', type: 'text' },
  3010. { name: 'identifier_type', type: 'text' },
  3011. { name: 'instance_id', type: 'text' },
  3012. { name: 'created_at', type: 'timestamp' },
  3013. { name: 'updated_at', type: 'timestamp' },
  3014. { name: 'attrs', type: 'jsonb' },
  3015. ],
  3016. options: [
  3017. {
  3018. name: 'object',
  3019. defaultValue: 'blocklist_identifiers',
  3020. editable: false,
  3021. required: true,
  3022. type: 'text',
  3023. },
  3024. ],
  3025. },
  3026. {
  3027. label: 'Domains',
  3028. description: 'List of all domains for an instance',
  3029. availableColumns: [
  3030. { name: 'id', type: 'text' },
  3031. { name: 'name', type: 'text' },
  3032. { name: 'is_satellite', type: 'boolean' },
  3033. { name: 'frontend_api_url', type: 'text' },
  3034. { name: 'accounts_portal_url', type: 'text' },
  3035. { name: 'attrs', type: 'jsonb' },
  3036. ],
  3037. options: [
  3038. {
  3039. name: 'object',
  3040. defaultValue: 'domains',
  3041. editable: false,
  3042. required: true,
  3043. type: 'text',
  3044. },
  3045. ],
  3046. },
  3047. {
  3048. label: 'Invitations',
  3049. description: 'List of all non-revoked invitations for your application',
  3050. availableColumns: [
  3051. { name: 'id', type: 'text' },
  3052. { name: 'email_address', type: 'text' },
  3053. { name: 'url', type: 'text' },
  3054. { name: 'revoked', type: 'boolean' },
  3055. { name: 'status', type: 'text' },
  3056. { name: 'expires_at', type: 'timestamp' },
  3057. { name: 'created_at', type: 'timestamp' },
  3058. { name: 'updated_at', type: 'timestamp' },
  3059. { name: 'attrs', type: 'jsonb' },
  3060. ],
  3061. options: [
  3062. {
  3063. name: 'object',
  3064. defaultValue: 'invitations',
  3065. editable: false,
  3066. required: true,
  3067. type: 'text',
  3068. },
  3069. ],
  3070. },
  3071. {
  3072. label: 'JWT Templates',
  3073. description: 'List of all JWT templates',
  3074. availableColumns: [
  3075. { name: 'id', type: 'text' },
  3076. { name: 'name', type: 'text' },
  3077. { name: 'lifetime', type: 'bigint' },
  3078. { name: 'allowed_clock_skew', type: 'bigint' },
  3079. { name: 'custom_signing_key', type: 'boolean' },
  3080. { name: 'signing_algorithm', type: 'text' },
  3081. { name: 'created_at', type: 'timestamp' },
  3082. { name: 'updated_at', type: 'timestamp' },
  3083. { name: 'attrs', type: 'jsonb' },
  3084. ],
  3085. options: [
  3086. {
  3087. name: 'object',
  3088. defaultValue: 'jwt_templates',
  3089. editable: false,
  3090. required: true,
  3091. type: 'text',
  3092. },
  3093. ],
  3094. },
  3095. {
  3096. label: 'OAuth Applications',
  3097. description: 'List of OAuth applications for an instance',
  3098. availableColumns: [
  3099. { name: 'id', type: 'text' },
  3100. { name: 'name', type: 'text' },
  3101. { name: 'instance_id', type: 'text' },
  3102. { name: 'client_id', type: 'text' },
  3103. { name: 'public', type: 'boolean' },
  3104. { name: 'scopes', type: 'text' },
  3105. { name: 'created_at', type: 'timestamp' },
  3106. { name: 'updated_at', type: 'timestamp' },
  3107. { name: 'attrs', type: 'jsonb' },
  3108. ],
  3109. options: [
  3110. {
  3111. name: 'object',
  3112. defaultValue: 'oauth_applications',
  3113. editable: false,
  3114. required: true,
  3115. type: 'text',
  3116. },
  3117. ],
  3118. },
  3119. {
  3120. label: 'Organizations',
  3121. description: 'List of organizations for an instance',
  3122. availableColumns: [
  3123. { name: 'id', type: 'text' },
  3124. { name: 'name', type: 'text' },
  3125. { name: 'slug', type: 'text' },
  3126. { name: 'created_at', type: 'timestamp' },
  3127. { name: 'updated_at', type: 'timestamp' },
  3128. { name: 'attrs', type: 'jsonb' },
  3129. ],
  3130. options: [
  3131. {
  3132. name: 'object',
  3133. defaultValue: 'organizations',
  3134. editable: false,
  3135. required: true,
  3136. type: 'text',
  3137. },
  3138. ],
  3139. },
  3140. {
  3141. label: 'Organization Invitations',
  3142. description: 'List of organization invitations for an instance',
  3143. availableColumns: [
  3144. { name: 'id', type: 'text' },
  3145. { name: 'email_address', type: 'text' },
  3146. { name: 'role', type: 'text' },
  3147. { name: 'role_name', type: 'text' },
  3148. { name: 'organization_id', type: 'text' },
  3149. { name: 'status', type: 'text' },
  3150. { name: 'created_at', type: 'timestamp' },
  3151. { name: 'updated_at', type: 'timestamp' },
  3152. { name: 'attrs', type: 'jsonb' },
  3153. ],
  3154. options: [
  3155. {
  3156. name: 'object',
  3157. defaultValue: 'organization_invitations',
  3158. editable: false,
  3159. required: true,
  3160. type: 'text',
  3161. },
  3162. ],
  3163. },
  3164. {
  3165. label: 'Organization Memberships',
  3166. description: 'List of organization user memberships for an instance',
  3167. availableColumns: [
  3168. { name: 'id', type: 'text' },
  3169. { name: 'role', type: 'text' },
  3170. { name: 'role_name', type: 'text' },
  3171. { name: 'created_at', type: 'timestamp' },
  3172. { name: 'updated_at', type: 'timestamp' },
  3173. { name: 'attrs', type: 'jsonb' },
  3174. ],
  3175. options: [
  3176. {
  3177. name: 'object',
  3178. defaultValue: 'organization_memberships',
  3179. editable: false,
  3180. required: true,
  3181. type: 'text',
  3182. },
  3183. ],
  3184. },
  3185. {
  3186. label: 'Redirect URLs',
  3187. description: 'List of all whitelisted redirect urls for the instance',
  3188. availableColumns: [
  3189. { name: 'id', type: 'text' },
  3190. { name: 'url', type: 'text' },
  3191. { name: 'created_at', type: 'timestamp' },
  3192. { name: 'updated_at', type: 'timestamp' },
  3193. { name: 'attrs', type: 'jsonb' },
  3194. ],
  3195. options: [
  3196. {
  3197. name: 'object',
  3198. defaultValue: 'redirect_urls',
  3199. editable: false,
  3200. required: true,
  3201. type: 'text',
  3202. },
  3203. ],
  3204. },
  3205. {
  3206. label: 'SAML Connections',
  3207. description: 'List of SAML Connections for an instance',
  3208. availableColumns: [
  3209. { name: 'id', type: 'text' },
  3210. { name: 'name', type: 'text' },
  3211. { name: 'domain', type: 'text' },
  3212. { name: 'active', type: 'boolean' },
  3213. { name: 'provider', type: 'text' },
  3214. { name: 'user_count', type: 'bigint' },
  3215. { name: 'created_at', type: 'timestamp' },
  3216. { name: 'updated_at', type: 'timestamp' },
  3217. { name: 'attrs', type: 'jsonb' },
  3218. ],
  3219. options: [
  3220. {
  3221. name: 'object',
  3222. defaultValue: 'saml_connections',
  3223. editable: false,
  3224. required: true,
  3225. type: 'text',
  3226. },
  3227. ],
  3228. },
  3229. {
  3230. label: 'Users',
  3231. description: 'List of all users',
  3232. availableColumns: [
  3233. { name: 'id', type: 'text' },
  3234. { name: 'external_id', type: 'text' },
  3235. { name: 'username', type: 'text' },
  3236. { name: 'first_name', type: 'text' },
  3237. { name: 'last_name', type: 'text' },
  3238. { name: 'created_at', type: 'timestamp' },
  3239. { name: 'updated_at', type: 'timestamp' },
  3240. { name: 'attrs', type: 'jsonb' },
  3241. ],
  3242. options: [
  3243. {
  3244. name: 'object',
  3245. defaultValue: 'users',
  3246. editable: false,
  3247. required: true,
  3248. type: 'text',
  3249. },
  3250. ],
  3251. },
  3252. ],
  3253. },
  3254. {
  3255. name: 'notion_wrapper',
  3256. description: 'Notion provides a versatile, ready-to-use solution for managing your data.',
  3257. handlerName: WRAPPER_HANDLERS.NOTION,
  3258. validatorName: 'wasm_fdw_validator',
  3259. icon: `${BASE_PATH}/img/icons/notion-icon.svg`,
  3260. extensionName: 'NotionFdw',
  3261. label: 'Notion',
  3262. docsUrl: 'https://fdw.dev/catalog/notion/',
  3263. minimumExtensionVersion: '0.4.0',
  3264. server: {
  3265. options: [
  3266. {
  3267. name: 'fdw_package_url',
  3268. label: 'FDW Package URL',
  3269. required: true,
  3270. encrypted: false,
  3271. secureEntry: false,
  3272. defaultValue:
  3273. 'https://github.com/briven/wrappers/releases/download/wasm_notion_fdw_v0.1.1/notion_fdw.wasm',
  3274. hidden: true,
  3275. },
  3276. {
  3277. name: 'fdw_package_name',
  3278. label: 'FDW Package Name',
  3279. required: true,
  3280. encrypted: false,
  3281. secureEntry: false,
  3282. defaultValue: 'briven:notion-fdw',
  3283. hidden: true,
  3284. },
  3285. {
  3286. name: 'fdw_package_version',
  3287. label: 'FDW Package Version',
  3288. required: true,
  3289. encrypted: false,
  3290. secureEntry: false,
  3291. defaultValue: '0.1.1',
  3292. hidden: true,
  3293. },
  3294. {
  3295. name: 'fdw_package_checksum',
  3296. label: 'FDW Package Checksum',
  3297. required: true,
  3298. encrypted: false,
  3299. secureEntry: false,
  3300. defaultValue: '6dea3014f462aafd0c051c37d163fe326e7650c26a7eb5d8017a30634b5a46de',
  3301. hidden: true,
  3302. },
  3303. {
  3304. name: 'api_url',
  3305. label: 'API URL',
  3306. required: false,
  3307. encrypted: false,
  3308. secureEntry: false,
  3309. defaultValue: 'https://api.notion.com/v1',
  3310. },
  3311. {
  3312. name: 'api_key_id',
  3313. label: 'Notion API Key',
  3314. required: true,
  3315. encrypted: true,
  3316. secureEntry: true,
  3317. },
  3318. ],
  3319. },
  3320. tables: [
  3321. {
  3322. label: 'Blocks',
  3323. description: 'Notion Block content',
  3324. availableColumns: [
  3325. { name: 'id', type: 'text' },
  3326. { name: 'page_id', type: 'text' },
  3327. { name: 'type', type: 'text' },
  3328. { name: 'created_time', type: 'timestamp' },
  3329. { name: 'last_edited_time', type: 'timestamp' },
  3330. { name: 'archived', type: 'boolean' },
  3331. { name: 'attrs', type: 'jsonb' },
  3332. ],
  3333. options: [
  3334. {
  3335. name: 'object',
  3336. defaultValue: 'block',
  3337. editable: false,
  3338. required: true,
  3339. type: 'text',
  3340. },
  3341. ],
  3342. },
  3343. {
  3344. label: 'Pages',
  3345. description: 'Notion Pages',
  3346. availableColumns: [
  3347. { name: 'id', type: 'text' },
  3348. { name: 'url', type: 'text' },
  3349. { name: 'created_time', type: 'timestamp' },
  3350. { name: 'last_edited_time', type: 'timestamp' },
  3351. { name: 'archived', type: 'boolean' },
  3352. { name: 'attrs', type: 'jsonb' },
  3353. ],
  3354. options: [
  3355. {
  3356. name: 'object',
  3357. defaultValue: 'page',
  3358. editable: false,
  3359. required: true,
  3360. type: 'text',
  3361. },
  3362. ],
  3363. },
  3364. {
  3365. label: 'Databases',
  3366. description: 'Notion Databases',
  3367. availableColumns: [
  3368. { name: 'id', type: 'text' },
  3369. { name: 'url', type: 'text' },
  3370. { name: 'created_time', type: 'timestamp' },
  3371. { name: 'last_edited_time', type: 'timestamp' },
  3372. { name: 'archived', type: 'boolean' },
  3373. { name: 'attrs', type: 'jsonb' },
  3374. ],
  3375. options: [
  3376. {
  3377. name: 'object',
  3378. defaultValue: 'database',
  3379. editable: false,
  3380. required: true,
  3381. type: 'text',
  3382. },
  3383. ],
  3384. },
  3385. {
  3386. label: 'Users',
  3387. description: 'Notion Users',
  3388. availableColumns: [
  3389. { name: 'id', type: 'text' },
  3390. { name: 'name', type: 'text' },
  3391. { name: 'type', type: 'text' },
  3392. { name: 'avatar_url', type: 'text' },
  3393. { name: 'attrs', type: 'jsonb' },
  3394. ],
  3395. options: [
  3396. {
  3397. name: 'object',
  3398. defaultValue: 'user',
  3399. editable: false,
  3400. required: true,
  3401. type: 'text',
  3402. },
  3403. ],
  3404. },
  3405. ],
  3406. },
  3407. {
  3408. name: 'slack_wrapper',
  3409. description:
  3410. 'Query Slack workspaces, channels, messages, users, files, and more via the Slack API.',
  3411. handlerName: WRAPPER_HANDLERS.SLACK,
  3412. validatorName: 'wasm_fdw_validator',
  3413. icon: `${BASE_PATH}/img/icons/slack-icon.svg`,
  3414. extensionName: 'SlackFdw',
  3415. label: 'Slack',
  3416. docsUrl: 'https://fdw.dev/catalog/slack/',
  3417. minimumExtensionVersion: '0.4.0',
  3418. server: {
  3419. options: [
  3420. {
  3421. name: 'fdw_package_url',
  3422. label: 'FDW Package URL',
  3423. required: true,
  3424. encrypted: false,
  3425. secureEntry: false,
  3426. defaultValue:
  3427. 'https://github.com/briven/wrappers/releases/download/wasm_slack_fdw_v0.1.0/slack_fdw.wasm',
  3428. hidden: true,
  3429. },
  3430. {
  3431. name: 'fdw_package_name',
  3432. label: 'FDW Package Name',
  3433. required: true,
  3434. encrypted: false,
  3435. secureEntry: false,
  3436. defaultValue: 'briven:slack-fdw',
  3437. hidden: true,
  3438. },
  3439. {
  3440. name: 'fdw_package_version',
  3441. label: 'FDW Package Version',
  3442. required: true,
  3443. encrypted: false,
  3444. secureEntry: false,
  3445. defaultValue: '0.1.0',
  3446. hidden: true,
  3447. },
  3448. {
  3449. name: 'fdw_package_checksum',
  3450. label: 'FDW Package Checksum',
  3451. required: true,
  3452. encrypted: false,
  3453. secureEntry: false,
  3454. defaultValue: '5b022b441c0007e31d792ecb1341bfffed1c29cb865eb0c7969989dff0e8fdc3',
  3455. hidden: true,
  3456. },
  3457. {
  3458. name: 'api_token_id',
  3459. label: 'Slack Bot User OAuth Token',
  3460. required: true,
  3461. encrypted: true,
  3462. secureEntry: true,
  3463. urlHelper: 'https://api.slack.com/apps',
  3464. },
  3465. {
  3466. name: 'workspace',
  3467. label: 'Workspace',
  3468. required: false,
  3469. encrypted: false,
  3470. secureEntry: false,
  3471. },
  3472. ],
  3473. },
  3474. tables: [
  3475. {
  3476. label: 'Channels',
  3477. description: 'All channels in the workspace',
  3478. availableColumns: [
  3479. { name: 'id', type: 'text' },
  3480. { name: 'name', type: 'text' },
  3481. { name: 'is_private', type: 'boolean' },
  3482. { name: 'created', type: 'timestamp' },
  3483. { name: 'creator', type: 'text' },
  3484. ],
  3485. options: [
  3486. {
  3487. name: 'resource',
  3488. defaultValue: 'channels',
  3489. editable: false,
  3490. required: true,
  3491. type: 'text',
  3492. },
  3493. ],
  3494. },
  3495. {
  3496. label: 'Messages',
  3497. description: 'Messages from channels, DMs, and group messages',
  3498. availableColumns: [
  3499. { name: 'ts', type: 'text' },
  3500. { name: 'user_id', type: 'text' },
  3501. { name: 'channel_id', type: 'text' },
  3502. { name: 'text', type: 'text' },
  3503. { name: 'thread_ts', type: 'text' },
  3504. { name: 'reply_count', type: 'integer' },
  3505. ],
  3506. options: [
  3507. {
  3508. name: 'resource',
  3509. defaultValue: 'messages',
  3510. editable: false,
  3511. required: true,
  3512. type: 'text',
  3513. },
  3514. ],
  3515. },
  3516. {
  3517. label: 'Users',
  3518. description: 'All users in the workspace',
  3519. availableColumns: [
  3520. { name: 'id', type: 'text' },
  3521. { name: 'name', type: 'text' },
  3522. { name: 'real_name', type: 'text' },
  3523. { name: 'display_name', type: 'text' },
  3524. { name: 'display_name_normalized', type: 'text' },
  3525. { name: 'real_name_normalized', type: 'text' },
  3526. { name: 'email', type: 'text' },
  3527. { name: 'phone', type: 'text' },
  3528. { name: 'skype', type: 'text' },
  3529. { name: 'is_admin', type: 'boolean' },
  3530. { name: 'is_owner', type: 'boolean' },
  3531. { name: 'is_primary_owner', type: 'boolean' },
  3532. { name: 'is_bot', type: 'boolean' },
  3533. { name: 'is_app_user', type: 'boolean' },
  3534. { name: 'is_restricted', type: 'boolean' },
  3535. { name: 'is_ultra_restricted', type: 'boolean' },
  3536. { name: 'deleted', type: 'boolean' },
  3537. { name: 'status_text', type: 'text' },
  3538. { name: 'status_emoji', type: 'text' },
  3539. { name: 'status_expiration', type: 'bigint' },
  3540. { name: 'title', type: 'text' },
  3541. { name: 'team_id', type: 'text' },
  3542. { name: 'team', type: 'text' },
  3543. { name: 'tz', type: 'text' },
  3544. { name: 'tz_label', type: 'text' },
  3545. { name: 'tz_offset', type: 'integer' },
  3546. { name: 'locale', type: 'text' },
  3547. { name: 'image_24', type: 'text' },
  3548. { name: 'image_48', type: 'text' },
  3549. { name: 'image_72', type: 'text' },
  3550. { name: 'image_192', type: 'text' },
  3551. { name: 'image_512', type: 'text' },
  3552. { name: 'color', type: 'text' },
  3553. { name: 'updated', type: 'bigint' },
  3554. ],
  3555. options: [
  3556. {
  3557. name: 'resource',
  3558. defaultValue: 'users',
  3559. editable: false,
  3560. required: true,
  3561. type: 'text',
  3562. },
  3563. ],
  3564. },
  3565. {
  3566. label: 'User Groups',
  3567. description: 'User groups in the workspace',
  3568. availableColumns: [
  3569. { name: 'id', type: 'text' },
  3570. { name: 'team_id', type: 'text' },
  3571. { name: 'name', type: 'text' },
  3572. { name: 'handle', type: 'text' },
  3573. { name: 'description', type: 'text' },
  3574. { name: 'is_external', type: 'boolean' },
  3575. { name: 'date_create', type: 'bigint' },
  3576. { name: 'date_update', type: 'bigint' },
  3577. { name: 'date_delete', type: 'bigint' },
  3578. { name: 'auto_type', type: 'text' },
  3579. { name: 'created_by', type: 'text' },
  3580. { name: 'updated_by', type: 'text' },
  3581. { name: 'deleted_by', type: 'text' },
  3582. { name: 'user_count', type: 'integer' },
  3583. { name: 'channel_count', type: 'integer' },
  3584. ],
  3585. options: [
  3586. {
  3587. name: 'resource',
  3588. defaultValue: 'usergroups',
  3589. editable: false,
  3590. required: true,
  3591. type: 'text',
  3592. },
  3593. ],
  3594. },
  3595. {
  3596. label: 'User Group Members',
  3597. description: 'Membership relation between users and user groups',
  3598. availableColumns: [
  3599. { name: 'usergroup_id', type: 'text' },
  3600. { name: 'usergroup_name', type: 'text' },
  3601. { name: 'usergroup_handle', type: 'text' },
  3602. { name: 'user_id', type: 'text' },
  3603. ],
  3604. options: [
  3605. {
  3606. name: 'resource',
  3607. defaultValue: 'usergroup_members',
  3608. editable: false,
  3609. required: true,
  3610. type: 'text',
  3611. },
  3612. ],
  3613. },
  3614. {
  3615. label: 'Files',
  3616. description: 'Files shared in the workspace',
  3617. availableColumns: [
  3618. { name: 'id', type: 'text' },
  3619. { name: 'name', type: 'text' },
  3620. { name: 'title', type: 'text' },
  3621. { name: 'mimetype', type: 'text' },
  3622. { name: 'size', type: 'bigint' },
  3623. { name: 'url_private', type: 'text' },
  3624. { name: 'user_id', type: 'text' },
  3625. { name: 'created', type: 'timestamp' },
  3626. ],
  3627. options: [
  3628. {
  3629. name: 'resource',
  3630. defaultValue: 'files',
  3631. editable: false,
  3632. required: true,
  3633. type: 'text',
  3634. },
  3635. ],
  3636. },
  3637. {
  3638. label: 'Team Info',
  3639. description: 'Information about the Slack team/workspace',
  3640. availableColumns: [
  3641. { name: 'id', type: 'text' },
  3642. { name: 'name', type: 'text' },
  3643. { name: 'domain', type: 'text' },
  3644. { name: 'email_domain', type: 'text' },
  3645. ],
  3646. options: [
  3647. {
  3648. name: 'resource',
  3649. defaultValue: 'team-info',
  3650. editable: false,
  3651. required: true,
  3652. type: 'text',
  3653. },
  3654. ],
  3655. },
  3656. ],
  3657. },
  3658. {
  3659. name: 'cfd1_wrapper',
  3660. description: 'Read and write data from Cloudflare D1 databases using the Wasm FDW.',
  3661. handlerName: WRAPPER_HANDLERS.CLOUDFLARE_D1,
  3662. validatorName: 'wasm_fdw_validator',
  3663. icon: `${BASE_PATH}/img/icons/cloudflare-icon.svg`,
  3664. extensionName: 'Cfd1Fdw',
  3665. label: 'Cloudflare D1',
  3666. docsUrl: 'https://fdw.dev/catalog/cfd1/',
  3667. minimumExtensionVersion: '0.4.0',
  3668. server: {
  3669. options: [
  3670. {
  3671. name: 'fdw_package_url',
  3672. label: 'FDW Package URL',
  3673. required: true,
  3674. encrypted: false,
  3675. secureEntry: false,
  3676. defaultValue:
  3677. 'https://github.com/briven/wrappers/releases/download/wasm_cfd1_fdw_v0.1.0/cfd1_fdw.wasm',
  3678. hidden: true,
  3679. },
  3680. {
  3681. name: 'fdw_package_name',
  3682. label: 'FDW Package Name',
  3683. required: true,
  3684. encrypted: false,
  3685. secureEntry: false,
  3686. defaultValue: 'briven:cfd1-fdw',
  3687. hidden: true,
  3688. },
  3689. {
  3690. name: 'fdw_package_version',
  3691. label: 'FDW Package Version',
  3692. required: true,
  3693. encrypted: false,
  3694. secureEntry: false,
  3695. defaultValue: '0.1.0',
  3696. hidden: true,
  3697. },
  3698. {
  3699. name: 'fdw_package_checksum',
  3700. label: 'FDW Package Checksum',
  3701. required: true,
  3702. encrypted: false,
  3703. secureEntry: false,
  3704. defaultValue: '783232834bb29dbd3ee6b09618c16f8a847286e63d05c54397d56c3e703fad31',
  3705. hidden: true,
  3706. },
  3707. {
  3708. name: 'api_url',
  3709. label: 'API URL',
  3710. required: false,
  3711. encrypted: false,
  3712. secureEntry: false,
  3713. defaultValue: 'https://api.cloudflare.com/client/v4/accounts/<account_id>/d1/database',
  3714. },
  3715. {
  3716. name: 'account_id',
  3717. label: 'Account ID',
  3718. required: true,
  3719. encrypted: false,
  3720. secureEntry: false,
  3721. },
  3722. {
  3723. name: 'database_id',
  3724. label: 'Database ID',
  3725. required: true,
  3726. encrypted: false,
  3727. secureEntry: false,
  3728. },
  3729. {
  3730. name: 'api_token_id',
  3731. label: 'Cloudflare D1 API Token',
  3732. required: true,
  3733. encrypted: true,
  3734. secureEntry: true,
  3735. urlHelper: 'https://dash.cloudflare.com/profile/api-tokens',
  3736. },
  3737. ],
  3738. },
  3739. tables: [
  3740. {
  3741. label: 'D1 Databases',
  3742. description: 'D1 databases in your Cloudflare account',
  3743. availableColumns: [
  3744. { name: 'uuid', type: 'text' },
  3745. { name: 'name', type: 'text' },
  3746. { name: 'version', type: 'text' },
  3747. { name: 'num_tables', type: 'bigint' },
  3748. { name: 'file_size', type: 'bigint' },
  3749. { name: 'created_at', type: 'text' },
  3750. { name: '_attrs', type: 'jsonb' },
  3751. ],
  3752. options: [
  3753. {
  3754. name: 'table',
  3755. defaultValue: '_meta_databases',
  3756. editable: false,
  3757. required: true,
  3758. type: 'text',
  3759. },
  3760. ],
  3761. },
  3762. {
  3763. label: 'D1 Table',
  3764. description: 'A table in your D1 database (define columns to match your D1 schema)',
  3765. availableColumns: [
  3766. { name: 'id', type: 'bigint' },
  3767. { name: 'name', type: 'text' },
  3768. { name: 'amount', type: 'double precision' },
  3769. { name: 'metadata', type: 'text' },
  3770. { name: '_attrs', type: 'jsonb' },
  3771. ],
  3772. options: [
  3773. {
  3774. label: 'Table',
  3775. name: 'table',
  3776. placeholder: 'mytable',
  3777. editable: true,
  3778. required: true,
  3779. type: 'text',
  3780. },
  3781. {
  3782. label: 'Row ID Column',
  3783. name: 'rowid_column',
  3784. placeholder: 'id',
  3785. defaultValue: 'id',
  3786. editable: true,
  3787. required: false,
  3788. type: 'text',
  3789. },
  3790. ],
  3791. },
  3792. ],
  3793. },
  3794. {
  3795. name: 'hubspot_wrapper',
  3796. description: 'Query and sync HubSpot CRM data using the Wasm FDW.',
  3797. handlerName: WRAPPER_HANDLERS.HUBSPOT,
  3798. validatorName: 'wasm_fdw_validator',
  3799. icon: `${BASE_PATH}/img/icons/hubspot-icon.svg`,
  3800. extensionName: 'HubspotFdw',
  3801. label: 'HubSpot',
  3802. docsUrl: 'https://fdw.dev/catalog/hubspot/',
  3803. minimumExtensionVersion: '0.4.0',
  3804. server: {
  3805. options: [
  3806. {
  3807. name: 'fdw_package_url',
  3808. label: 'FDW Package URL',
  3809. required: true,
  3810. encrypted: false,
  3811. secureEntry: false,
  3812. defaultValue:
  3813. 'https://github.com/briven/wrappers/releases/download/wasm_hubspot_fdw_v0.1.0/hubspot_fdw.wasm',
  3814. hidden: true,
  3815. },
  3816. {
  3817. name: 'fdw_package_name',
  3818. label: 'FDW Package Name',
  3819. required: true,
  3820. encrypted: false,
  3821. secureEntry: false,
  3822. defaultValue: 'briven:hubspot-fdw',
  3823. hidden: true,
  3824. },
  3825. {
  3826. name: 'fdw_package_version',
  3827. label: 'FDW Package Version',
  3828. required: true,
  3829. encrypted: false,
  3830. secureEntry: false,
  3831. defaultValue: '0.1.0',
  3832. hidden: true,
  3833. },
  3834. {
  3835. name: 'fdw_package_checksum',
  3836. label: 'FDW Package Checksum',
  3837. required: true,
  3838. encrypted: false,
  3839. secureEntry: false,
  3840. defaultValue: '2cbf39e9e28aa732a225db09b2186a2342c44697d4fa047652d358e292ba5521',
  3841. hidden: true,
  3842. },
  3843. {
  3844. name: 'api_url',
  3845. label: 'API URL',
  3846. required: false,
  3847. encrypted: false,
  3848. secureEntry: false,
  3849. defaultValue: 'https://api.hubapi.com/crm/v3',
  3850. },
  3851. {
  3852. name: 'api_key_id',
  3853. label: 'HubSpot API Key',
  3854. required: true,
  3855. encrypted: true,
  3856. secureEntry: true,
  3857. urlHelper:
  3858. 'https://developers.hubspot.com/docs/guides/apps/authentication/intro-to-auth#private-app-access-tokens',
  3859. },
  3860. ],
  3861. },
  3862. tables: [
  3863. {
  3864. label: 'Companies',
  3865. description: 'Companies and organizations in your HubSpot CRM',
  3866. availableColumns: [
  3867. { name: 'id', type: 'text' },
  3868. { name: 'name', type: 'text' },
  3869. { name: 'domain', type: 'text' },
  3870. { name: 'created_at', type: 'timestamp' },
  3871. { name: 'updated_at', type: 'timestamp' },
  3872. { name: 'attrs', type: 'jsonb' },
  3873. ],
  3874. options: [
  3875. {
  3876. name: 'object',
  3877. defaultValue: 'objects/companies',
  3878. editable: false,
  3879. required: true,
  3880. type: 'text',
  3881. },
  3882. ],
  3883. },
  3884. {
  3885. label: 'Contacts',
  3886. description: 'Contacts in your HubSpot CRM',
  3887. availableColumns: [
  3888. { name: 'id', type: 'text' },
  3889. { name: 'email', type: 'text' },
  3890. { name: 'firstname', type: 'text' },
  3891. { name: 'lastname', type: 'text' },
  3892. { name: 'created_at', type: 'timestamp' },
  3893. { name: 'updated_at', type: 'timestamp' },
  3894. { name: 'attrs', type: 'jsonb' },
  3895. ],
  3896. options: [
  3897. {
  3898. name: 'object',
  3899. defaultValue: 'objects/contacts',
  3900. editable: false,
  3901. required: true,
  3902. type: 'text',
  3903. },
  3904. ],
  3905. },
  3906. {
  3907. label: 'Deals',
  3908. description: 'Deals and transactions in your HubSpot CRM',
  3909. availableColumns: [
  3910. { name: 'id', type: 'text' },
  3911. { name: 'created_at', type: 'timestamp' },
  3912. { name: 'updated_at', type: 'timestamp' },
  3913. { name: 'attrs', type: 'jsonb' },
  3914. ],
  3915. options: [
  3916. {
  3917. name: 'object',
  3918. defaultValue: 'objects/deals',
  3919. editable: false,
  3920. required: true,
  3921. type: 'text',
  3922. },
  3923. ],
  3924. },
  3925. {
  3926. label: 'Tickets',
  3927. description: 'Customer service requests in your HubSpot CRM',
  3928. availableColumns: [
  3929. { name: 'id', type: 'text' },
  3930. { name: 'subject', type: 'text' },
  3931. { name: 'created_at', type: 'timestamp' },
  3932. { name: 'updated_at', type: 'timestamp' },
  3933. { name: 'attrs', type: 'jsonb' },
  3934. ],
  3935. options: [
  3936. {
  3937. name: 'object',
  3938. defaultValue: 'objects/tickets',
  3939. editable: false,
  3940. required: true,
  3941. type: 'text',
  3942. },
  3943. ],
  3944. },
  3945. {
  3946. label: 'Products',
  3947. description: 'Products offered by your company in HubSpot',
  3948. availableColumns: [
  3949. { name: 'id', type: 'text' },
  3950. { name: 'name', type: 'text' },
  3951. { name: 'created_at', type: 'timestamp' },
  3952. { name: 'updated_at', type: 'timestamp' },
  3953. { name: 'attrs', type: 'jsonb' },
  3954. ],
  3955. options: [
  3956. {
  3957. name: 'object',
  3958. defaultValue: 'objects/products',
  3959. editable: false,
  3960. required: true,
  3961. type: 'text',
  3962. },
  3963. ],
  3964. },
  3965. {
  3966. label: 'Leads',
  3967. description: 'Potential customers in your HubSpot CRM',
  3968. availableColumns: [
  3969. { name: 'id', type: 'text' },
  3970. { name: 'created_at', type: 'timestamp' },
  3971. { name: 'updated_at', type: 'timestamp' },
  3972. { name: 'attrs', type: 'jsonb' },
  3973. ],
  3974. options: [
  3975. {
  3976. name: 'object',
  3977. defaultValue: 'objects/leads',
  3978. editable: false,
  3979. required: true,
  3980. type: 'text',
  3981. },
  3982. ],
  3983. },
  3984. {
  3985. label: 'Partner Clients',
  3986. description: 'Partner clients managed by your company in HubSpot',
  3987. availableColumns: [
  3988. { name: 'id', type: 'text' },
  3989. { name: 'created_at', type: 'timestamp' },
  3990. { name: 'updated_at', type: 'timestamp' },
  3991. { name: 'attrs', type: 'jsonb' },
  3992. ],
  3993. options: [
  3994. {
  3995. name: 'object',
  3996. defaultValue: 'objects/partner_clients',
  3997. editable: false,
  3998. required: true,
  3999. type: 'text',
  4000. },
  4001. ],
  4002. },
  4003. {
  4004. label: 'Feedback Submissions',
  4005. description: 'Feedback submissions from NPS, CSAT, CES, and custom surveys',
  4006. availableColumns: [
  4007. { name: 'id', type: 'text' },
  4008. { name: 'created_at', type: 'timestamp' },
  4009. { name: 'updated_at', type: 'timestamp' },
  4010. { name: 'attrs', type: 'jsonb' },
  4011. ],
  4012. options: [
  4013. {
  4014. name: 'object',
  4015. defaultValue: 'objects/feedback_submissions',
  4016. editable: false,
  4017. required: true,
  4018. type: 'text',
  4019. },
  4020. ],
  4021. },
  4022. {
  4023. label: 'Goals',
  4024. description: 'User-specific quotas for sales and services teams',
  4025. availableColumns: [
  4026. { name: 'id', type: 'text' },
  4027. { name: 'created_at', type: 'timestamp' },
  4028. { name: 'updated_at', type: 'timestamp' },
  4029. { name: 'attrs', type: 'jsonb' },
  4030. ],
  4031. options: [
  4032. {
  4033. name: 'object',
  4034. defaultValue: 'objects/goal_targets',
  4035. editable: false,
  4036. required: true,
  4037. type: 'text',
  4038. },
  4039. ],
  4040. },
  4041. {
  4042. label: 'Partner Clients',
  4043. description: 'Customers that Solutions Partners have a sold or managed relationship with',
  4044. availableColumns: [
  4045. { name: 'id', type: 'text' },
  4046. { name: 'created_at', type: 'timestamp' },
  4047. { name: 'updated_at', type: 'timestamp' },
  4048. { name: 'attrs', type: 'jsonb' },
  4049. ],
  4050. options: [
  4051. {
  4052. name: 'object',
  4053. defaultValue: 'objects/partner_clients',
  4054. editable: false,
  4055. required: true,
  4056. type: 'text',
  4057. },
  4058. ],
  4059. },
  4060. {
  4061. label: 'Custom Object',
  4062. description: 'Custom objects managed by your company in HubSpot',
  4063. availableColumns: [
  4064. { name: 'id', type: 'text' },
  4065. { name: 'created_at', type: 'timestamp' },
  4066. { name: 'updated_at', type: 'timestamp' },
  4067. { name: 'attrs', type: 'jsonb' },
  4068. ],
  4069. options: [
  4070. {
  4071. label: 'Object',
  4072. name: 'object',
  4073. placeholder: 'objects/<objectType> e.g. `objects/2-3508482`',
  4074. defaultValue: 'objects/<objectType>',
  4075. editable: true,
  4076. required: true,
  4077. type: 'text',
  4078. },
  4079. ],
  4080. },
  4081. ],
  4082. },
  4083. {
  4084. name: 'orb_wrapper',
  4085. handlerName: WRAPPER_HANDLERS.ORB,
  4086. validatorName: 'wasm_fdw_validator',
  4087. icon: `${BASE_PATH}/img/icons/orb-icon.svg`,
  4088. description: 'Usage-based billing and metering platform',
  4089. extensionName: 'OrbFdw',
  4090. minimumExtensionVersion: '0.4.0',
  4091. label: 'Orb',
  4092. docsUrl: 'https://fdw.dev/catalog/orb/',
  4093. server: {
  4094. options: [
  4095. {
  4096. name: 'fdw_package_url',
  4097. label: 'FDW Package URL',
  4098. required: true,
  4099. encrypted: false,
  4100. secureEntry: false,
  4101. defaultValue:
  4102. 'https://github.com/briven/wrappers/releases/download/wasm_orb_fdw_v0.1.0/orb_fdw.wasm',
  4103. hidden: true,
  4104. },
  4105. {
  4106. name: 'fdw_package_name',
  4107. label: 'FDW Package Name',
  4108. required: true,
  4109. encrypted: false,
  4110. secureEntry: false,
  4111. defaultValue: 'briven:orb-fdw',
  4112. hidden: true,
  4113. },
  4114. {
  4115. name: 'fdw_package_version',
  4116. label: 'FDW Package Version',
  4117. required: true,
  4118. encrypted: false,
  4119. secureEntry: false,
  4120. defaultValue: '0.1.0',
  4121. hidden: true,
  4122. },
  4123. {
  4124. name: 'fdw_package_checksum',
  4125. label: 'FDW Package Checksum',
  4126. required: true,
  4127. encrypted: false,
  4128. secureEntry: false,
  4129. defaultValue: '89153a0a570257c231b78561cc909766731c828324585a5b6e2aa553902cb73a',
  4130. hidden: true,
  4131. },
  4132. {
  4133. name: 'api_url',
  4134. label: 'Orb API URL',
  4135. required: false,
  4136. encrypted: false,
  4137. secureEntry: false,
  4138. defaultValue: 'https://api.withorb.com/v1',
  4139. },
  4140. {
  4141. name: 'api_key_id',
  4142. label: 'Orb API Key ID',
  4143. required: true,
  4144. encrypted: true,
  4145. secureEntry: true,
  4146. },
  4147. ],
  4148. },
  4149. tables: [
  4150. {
  4151. label: 'Alerts',
  4152. description: 'Alerts in Orb',
  4153. availableColumns: [
  4154. { name: 'id', type: 'text' },
  4155. { name: 'type', type: 'text' },
  4156. { name: 'enabled', type: 'boolean' },
  4157. { name: 'customer_id', type: 'text' },
  4158. { name: 'external_customer_id', type: 'text' },
  4159. { name: 'subscription_id', type: 'text' },
  4160. { name: 'created_at', type: 'timestamp' },
  4161. { name: 'attrs', type: 'jsonb' },
  4162. ],
  4163. options: [
  4164. {
  4165. name: 'object',
  4166. label: 'Object',
  4167. defaultValue: 'alerts',
  4168. editable: false,
  4169. required: true,
  4170. type: 'text',
  4171. },
  4172. {
  4173. name: 'rowid_column',
  4174. label: 'Row ID Column',
  4175. placeholder: 'id',
  4176. editable: true,
  4177. required: false,
  4178. type: 'text',
  4179. },
  4180. ],
  4181. },
  4182. {
  4183. label: 'Coupons',
  4184. description: 'Coupons in Orb',
  4185. availableColumns: [
  4186. { name: 'id', type: 'text' },
  4187. { name: 'redemption_code', type: 'text' },
  4188. { name: 'times_redeemed', type: 'bigint' },
  4189. { name: 'duration_in_months', type: 'bigint' },
  4190. { name: 'archived_at', type: 'timestamp' },
  4191. { name: 'attrs', type: 'jsonb' },
  4192. ],
  4193. options: [
  4194. {
  4195. name: 'object',
  4196. label: 'Object',
  4197. defaultValue: 'coupons',
  4198. editable: false,
  4199. required: true,
  4200. type: 'text',
  4201. },
  4202. {
  4203. name: 'rowid_column',
  4204. label: 'Row ID Column',
  4205. placeholder: 'id',
  4206. editable: true,
  4207. required: false,
  4208. type: 'text',
  4209. },
  4210. ],
  4211. },
  4212. {
  4213. label: 'Credit Notes',
  4214. description: 'Credit notes in Orb',
  4215. availableColumns: [
  4216. { name: 'id', type: 'text' },
  4217. { name: 'type', type: 'text' },
  4218. { name: 'total', type: 'numeric(18,2)' },
  4219. { name: 'created_at', type: 'timestamp' },
  4220. { name: 'attrs', type: 'jsonb' },
  4221. ],
  4222. options: [
  4223. {
  4224. name: 'object',
  4225. label: 'Object',
  4226. defaultValue: 'credit_notes',
  4227. editable: false,
  4228. required: true,
  4229. type: 'text',
  4230. },
  4231. {
  4232. name: 'rowid_column',
  4233. label: 'Row ID Column',
  4234. placeholder: 'id',
  4235. editable: true,
  4236. required: false,
  4237. type: 'text',
  4238. },
  4239. ],
  4240. },
  4241. {
  4242. label: 'Customers',
  4243. description: 'Customers in Orb',
  4244. availableColumns: [
  4245. { name: 'id', type: 'text' },
  4246. { name: 'name', type: 'text' },
  4247. { name: 'email', type: 'text' },
  4248. { name: 'created_at', type: 'timestamp' },
  4249. { name: 'auto_collection', type: 'boolean' },
  4250. { name: 'attrs', type: 'jsonb' },
  4251. ],
  4252. options: [
  4253. {
  4254. name: 'object',
  4255. label: 'Object',
  4256. defaultValue: 'customers',
  4257. editable: false,
  4258. required: true,
  4259. type: 'text',
  4260. },
  4261. {
  4262. name: 'rowid_column',
  4263. label: 'Row ID Column',
  4264. placeholder: 'id',
  4265. editable: true,
  4266. required: false,
  4267. type: 'text',
  4268. },
  4269. ],
  4270. },
  4271. {
  4272. label: 'Credits',
  4273. description: 'Credits in Orb',
  4274. availableColumns: [
  4275. { name: 'id', type: 'text' },
  4276. { name: 'customer_id', type: 'text' },
  4277. { name: 'external_customer_id', type: 'text' },
  4278. { name: 'balance', type: 'numeric(18,2)' },
  4279. { name: 'status', type: 'text' },
  4280. { name: 'effective_date', type: 'timestamp' },
  4281. { name: 'expiry_date', type: 'timestamp' },
  4282. { name: 'attrs', type: 'jsonb' },
  4283. ],
  4284. options: [
  4285. {
  4286. name: 'object',
  4287. label: 'Object',
  4288. defaultValue: 'credits',
  4289. editable: false,
  4290. required: true,
  4291. type: 'text',
  4292. },
  4293. {
  4294. name: 'rowid_column',
  4295. label: 'Row ID Column',
  4296. placeholder: 'id',
  4297. editable: true,
  4298. required: false,
  4299. type: 'text',
  4300. },
  4301. ],
  4302. },
  4303. {
  4304. label: 'Credits Ledger',
  4305. description: 'Credits ledger in Orb',
  4306. availableColumns: [
  4307. { name: 'id', type: 'text' },
  4308. { name: 'customer_id', type: 'text' },
  4309. { name: 'external_customer_id', type: 'text' },
  4310. { name: 'amount', type: 'numeric(18,2)' },
  4311. { name: 'created_at', type: 'timestamp' },
  4312. { name: 'attrs', type: 'jsonb' },
  4313. ],
  4314. options: [
  4315. {
  4316. name: 'object',
  4317. label: 'Object',
  4318. defaultValue: 'credits_ledger',
  4319. editable: false,
  4320. required: true,
  4321. type: 'text',
  4322. },
  4323. {
  4324. name: 'rowid_column',
  4325. label: 'Row ID Column',
  4326. placeholder: 'id',
  4327. editable: true,
  4328. required: false,
  4329. type: 'text',
  4330. },
  4331. ],
  4332. },
  4333. {
  4334. label: 'Dimensional Price Groups',
  4335. description: 'Dimensional price groups in Orb',
  4336. availableColumns: [
  4337. { name: 'id', type: 'text' },
  4338. { name: 'name', type: 'text' },
  4339. { name: 'attrs', type: 'jsonb' },
  4340. ],
  4341. options: [
  4342. {
  4343. name: 'object',
  4344. label: 'Object',
  4345. defaultValue: 'dimensional_price_groups',
  4346. editable: false,
  4347. required: true,
  4348. type: 'text',
  4349. },
  4350. {
  4351. name: 'rowid_column',
  4352. label: 'Row ID Column',
  4353. placeholder: 'id',
  4354. editable: true,
  4355. required: false,
  4356. type: 'text',
  4357. },
  4358. ],
  4359. },
  4360. {
  4361. label: 'Events Backfills',
  4362. description: 'Events backfills in Orb',
  4363. availableColumns: [
  4364. { name: 'id', type: 'text' },
  4365. { name: 'status', type: 'text' },
  4366. { name: 'events_ingested', type: 'bigint' },
  4367. { name: 'created_at', type: 'timestamp' },
  4368. { name: 'attrs', type: 'jsonb' },
  4369. ],
  4370. options: [
  4371. {
  4372. name: 'object',
  4373. label: 'Object',
  4374. defaultValue: 'events_backfills',
  4375. editable: false,
  4376. required: true,
  4377. type: 'text',
  4378. },
  4379. {
  4380. name: 'rowid_column',
  4381. label: 'Row ID Column',
  4382. placeholder: 'id',
  4383. editable: true,
  4384. required: false,
  4385. type: 'text',
  4386. },
  4387. ],
  4388. },
  4389. {
  4390. label: 'Events Volume',
  4391. description: 'Events volume in Orb',
  4392. availableColumns: [
  4393. { name: 'count', type: 'bigint' },
  4394. { name: 'timeframe_start', type: 'timestamp' },
  4395. { name: 'timeframe_end', type: 'timestamp' },
  4396. { name: 'attrs', type: 'jsonb' },
  4397. ],
  4398. options: [
  4399. {
  4400. name: 'object',
  4401. label: 'Object',
  4402. defaultValue: 'events_volume',
  4403. editable: false,
  4404. required: true,
  4405. type: 'text',
  4406. },
  4407. {
  4408. name: 'rowid_column',
  4409. label: 'Row ID Column',
  4410. placeholder: 'id',
  4411. editable: true,
  4412. required: false,
  4413. type: 'text',
  4414. },
  4415. ],
  4416. },
  4417. {
  4418. label: 'Invoices',
  4419. description: 'Invoices in Orb',
  4420. availableColumns: [
  4421. { name: 'id', type: 'text' },
  4422. { name: 'invoice_number', type: 'text' },
  4423. { name: 'customer_id', type: 'text' },
  4424. { name: 'external_customer_id', type: 'text' },
  4425. { name: 'subscription_id', type: 'text' },
  4426. { name: 'status', type: 'text' },
  4427. { name: 'amount_due', type: 'numeric(18,2)' },
  4428. { name: 'currency', type: 'text' },
  4429. { name: 'due_date', type: 'timestamp' },
  4430. { name: 'issued_at', type: 'timestamp' },
  4431. { name: 'created_at', type: 'timestamp' },
  4432. { name: 'attrs', type: 'jsonb' },
  4433. ],
  4434. options: [
  4435. {
  4436. name: 'object',
  4437. label: 'Object',
  4438. defaultValue: 'invoices',
  4439. editable: false,
  4440. required: true,
  4441. type: 'text',
  4442. },
  4443. {
  4444. name: 'rowid_column',
  4445. label: 'Row ID Column',
  4446. placeholder: 'id',
  4447. editable: true,
  4448. required: false,
  4449. type: 'text',
  4450. },
  4451. ],
  4452. },
  4453. {
  4454. label: 'Items',
  4455. description: 'Items in Orb',
  4456. availableColumns: [
  4457. { name: 'id', type: 'text' },
  4458. { name: 'name', type: 'text' },
  4459. { name: 'created_at', type: 'timestamp' },
  4460. { name: 'attrs', type: 'jsonb' },
  4461. ],
  4462. options: [
  4463. {
  4464. name: 'object',
  4465. label: 'Object',
  4466. defaultValue: 'items',
  4467. editable: false,
  4468. required: true,
  4469. type: 'text',
  4470. },
  4471. {
  4472. name: 'rowid_column',
  4473. label: 'Row ID Column',
  4474. placeholder: 'id',
  4475. editable: true,
  4476. required: false,
  4477. type: 'text',
  4478. },
  4479. ],
  4480. },
  4481. {
  4482. label: 'Metrics',
  4483. description: 'Metrics in Orb',
  4484. availableColumns: [
  4485. { name: 'id', type: 'text' },
  4486. { name: 'name', type: 'text' },
  4487. { name: 'description', type: 'text' },
  4488. { name: 'status', type: 'text' },
  4489. { name: 'created_at', type: 'timestamp' },
  4490. { name: 'attrs', type: 'jsonb' },
  4491. ],
  4492. options: [
  4493. {
  4494. name: 'object',
  4495. label: 'Object',
  4496. defaultValue: 'metrics',
  4497. editable: false,
  4498. required: true,
  4499. type: 'text',
  4500. },
  4501. {
  4502. name: 'rowid_column',
  4503. label: 'Row ID Column',
  4504. placeholder: 'id',
  4505. editable: true,
  4506. required: false,
  4507. type: 'text',
  4508. },
  4509. ],
  4510. },
  4511. {
  4512. label: 'Plans',
  4513. description: 'Plans in Orb',
  4514. availableColumns: [
  4515. { name: 'id', type: 'text' },
  4516. { name: 'name', type: 'text' },
  4517. { name: 'description', type: 'text' },
  4518. { name: 'status', type: 'text' },
  4519. { name: 'maximum_amount', type: 'numeric(18,2)' },
  4520. { name: 'minimum_amount', type: 'numeric(18,2)' },
  4521. { name: 'created_at', type: 'timestamp' },
  4522. { name: 'attrs', type: 'jsonb' },
  4523. ],
  4524. options: [
  4525. {
  4526. name: 'object',
  4527. label: 'Object',
  4528. defaultValue: 'plans',
  4529. editable: false,
  4530. required: true,
  4531. type: 'text',
  4532. },
  4533. {
  4534. name: 'rowid_column',
  4535. label: 'Row ID Column',
  4536. placeholder: 'id',
  4537. editable: true,
  4538. required: false,
  4539. type: 'text',
  4540. },
  4541. ],
  4542. },
  4543. {
  4544. label: 'Prices',
  4545. description: 'Prices in Orb',
  4546. availableColumns: [
  4547. { name: 'id', type: 'text' },
  4548. { name: 'name', type: 'text' },
  4549. { name: 'external_price_id', type: 'text' },
  4550. { name: 'price_type', type: 'text' },
  4551. { name: 'maximum_amount', type: 'numeric(18,2)' },
  4552. { name: 'minimum_amount', type: 'numeric(18,2)' },
  4553. { name: 'created_at', type: 'timestamp' },
  4554. { name: 'attrs', type: 'jsonb' },
  4555. ],
  4556. options: [
  4557. {
  4558. name: 'object',
  4559. label: 'Object',
  4560. defaultValue: 'prices',
  4561. editable: false,
  4562. required: true,
  4563. type: 'text',
  4564. },
  4565. {
  4566. name: 'rowid_column',
  4567. label: 'Row ID Column',
  4568. placeholder: 'id',
  4569. editable: true,
  4570. required: false,
  4571. type: 'text',
  4572. },
  4573. ],
  4574. },
  4575. {
  4576. label: 'Subscriptions',
  4577. description: 'Subscriptions in Orb',
  4578. availableColumns: [
  4579. { name: 'id', type: 'text' },
  4580. { name: 'customer_id', type: 'text' },
  4581. { name: 'external_customer_id', type: 'text' },
  4582. { name: 'billing_cycle_day', type: 'bigint' },
  4583. { name: 'status', type: 'text' },
  4584. { name: 'start_date', type: 'timestamp' },
  4585. { name: 'end_date', type: 'timestamp' },
  4586. { name: 'created_at', type: 'timestamp' },
  4587. { name: 'attrs', type: 'jsonb' },
  4588. ],
  4589. options: [
  4590. {
  4591. name: 'object',
  4592. label: 'Object',
  4593. defaultValue: 'subscriptions',
  4594. editable: false,
  4595. required: true,
  4596. type: 'text',
  4597. },
  4598. {
  4599. name: 'rowid_column',
  4600. label: 'Row ID Column',
  4601. placeholder: 'id',
  4602. editable: true,
  4603. required: false,
  4604. type: 'text',
  4605. },
  4606. ],
  4607. },
  4608. ],
  4609. },
  4610. ]