| summary | Try it free Book Demo Your Jira Cloud administrator should grant you Administer Jira permissions to create, edit, view, and export connectors. Users with Administer Jira permissions always have access to app configurations. Lorem ipsum dolor Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt. Create Service Account Key To authenticate in BigQuery, the service account key is required. Therefore, before exporting Jira data to BigQuery, create the service account key in the Google Cloud Platform. See how to create service account key Create Data Source A data source is the primary source of data sets containing tables and fields for further analysis. It represents the data selected by the user for export to BigQuery. See how to create data source Export from Jira to BigQuery Exporting data from Jira to BigQuery involves connecting to BigQuery using a previously created service account key and transferring the datasets included in the data source. See how to export data History The History module has been implemented as a separate tab of the BigQuery Connector. The module includes the following submodules: Data sources historyExport history Learn more about History Data Schema BigQuery Connector for Jira automatically builds relations between tables and fields in the BigQuery. When you upload your Jira data into BigQuery, all tables will be connected in relations based on the logical key field. Thus, users don’t need to relate tables, which is time-consuming manually. View complete data schema Have experience with BigQuery Connector for Jira? We’d love to hear your thoughts! Please leave us a review on the Marketplace! Leave review |
|---|
| page | {"name":"page","children":[{"id":"AnyRuKcQaaaUEyZJJATz0","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":18,"gap":10},"children":[{"id":"E7qpCG-2J5Tf0scaZgOho","name":"row","children":[{"id":"MTmHAvoKuZjXEj5AVmaEE","name":"column","children":[{"name":"card","templateId":"plain white","params":{"gap":10,"padding":24,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":{"light":"#5C02CF1f","dark":"#15171A"},"hover":"none","isMediaFullSize":true},"children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Your Jira Cloud administrator should grant you ","lineHeight":"22px","color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"fontFamily":"Montserrat, sans-serif"},{"lineHeight":"22px","text":"Administer Jira","fontWeight":700,"color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"fontFamily":"Montserrat, sans-serif"},{"lineHeight":"22px","text":" permissions to create, edit, view, and export connectors. Users with ","color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"fontFamily":"Montserrat, sans-serif"},{"lineHeight":"22px","text":"Administer Jira","fontWeight":700,"color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"fontFamily":"Montserrat, sans-serif"},{"lineHeight":"22px","color":{"type":"solid","light":"#000000","gradient":{"light":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]},"dark":{"angle":135,"colors":["#000000","#00000099"],"stops":[0,100]}}},"fontSize":15,"text":" permissions always have access to app configurations.","fontFamily":"Montserrat, sans-serif"}],"align":"left"}]},"children":[],"id":"H4ZuRKdeYCMxnZJ6qtboV"}],"id":"kTAk8weCMuE24Y_IqUcdr"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"lTkFJhlMyvjiQIs6z2h1d","name":"column","children":[{"name":"card","templateId":"plain white","params":{"gap":10,"padding":24,"borderRadius":{"all":0,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":{"light":"#ffffff","dark":"#15171A"},"boxShadows":[{"y":0,"blur":15,"spread":-3,"color":"#00000019"},{"y":4,"blur":6,"spread":-4,"color":"#00000019"}],"hover":"elevate","isMediaFullSize":true},"children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Lorem ipsum dolor","fontFamily":"Montserrat, sans-serif","fontWeight":700,"fontSize":24,"color":{"light":"#202022","dark":"#ffffff"}}],"align":"left"}]},"children":[],"id":"MA8LwDnv6MaU9aP4OENlL"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt.","fontSize":14,"lineHeight":"22px","fontFamily":"Open Sans, sans-serif","color":"#818181"}],"align":"left"}]},"children":[],"id":"h9YL4b-6A4n5ttKiQgrK8"}],"id":"ejmifu2J3GRi5wd3fSU_o"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"7hzxuj6tUSsW7neNoWgGx","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"IGQkYtNL1FWWvP1WL-QhH","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"kcoGYw4qzjlPI3x1b2tqk","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"JxrHOyRYXL28UUrEfUxFa","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":100,"padding":10,"borderRadius":0}},{"id":"PRoEWt24DyZLmvpNeVHKn","name":"row","children":[{"id":"gipJBYyjKYW87_KVIeE_s","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"UZ2b5npukyyvyeLG4tASH","name":"column","children":[{"name":"button","params":{"templateId":"regular outline","label":"Try it free","size":"large","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"outline":{"type":"solid","light":"#FFC067"},"label":{"type":"solid","light":"#000000"}}},"hover":{"colors":{"outline":{"type":"solid","light":"#393A3A"}}}},"link":{"value":"https://marketplace.atlassian.com/apps/1221749/bigquery-connector-for-jira?tab=overview&hosting=cloud","target":"_blank","type":"link"}},"children":[],"id":"zzRC9kojwOzVr2O7w7HBt"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"Yw8WSHzMVEeSQMv60vqOJ","name":"column","children":[{"name":"button","params":{"templateId":"large button","label":"Book Demo","size":"large","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"background":{"type":"solid","light":"#D9EDF8"},"label":{"type":"solid","light":"#000000"}}},"hover":{"colors":{"outline":{"type":"solid","light":"#393A3A"}}}},"link":{"value":"https://calendly.com/demo-alpha-serve/jira-apps-demo-and-q-a?utm_source=aserve_doc&utm_medium=referral&utm_campaign=bigquery_jira&utm_term=book_demo&utm_content=user_guide&month=2024-10","target":"_blank","type":"link"}},"children":[],"id":"MviJWI9_mx7lrUb6vkuss"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"lSSTUUBPwTGED4dtxW1H_","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"4EUZV3MZmbydCAystYQwd","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"7QuGTd6HAfXpCM2tY3SPe","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1,1,1,1],"gap":95,"minHeight":100,"padding":10,"borderRadius":0}},{"id":"ZPQYYbJgK_RpeoQnRPONV","name":"row","children":[{"id":"xii3twbE_Pz4mPZ28Uhyr","name":"column","children":[{"name":"card","templateId":"white with icon","params":{"gap":10,"padding":28,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#D9EDF842","boxShadows":[{"y":0,"blur":15,"spread":-3,"color":"#00000019"},{"y":4,"blur":6,"spread":-4,"color":"#00000019"}],"hover":"elevate"},"children":[{"name":"icon","params":{"size":32,"color":{"light":"#ffffff","dark":"#15171A"},"alignment":"start","icon":"key","shape":"circular","background":{"type":"solid","light":"#202022"}},"children":[],"id":"POuIrdGjuIUndCw4RmCvb"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Create Service Account Key","fontFamily":"Montserrat, sans-serif","fontWeight":700,"fontSize":24,"color":{"light":"#202022","dark":"#ffffff"}}],"align":"left"}]},"children":[],"id":"I_75dFytoRTr_GsR7RVyW"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"To authenticate in BigQuery, the ","fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"}},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"service account key","fontWeight":700},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":" is required. Therefore, before exporting Jira data to BigQuery, create the service account key in the "},{"type":"link","link":{"value":"https://console.cloud.google.com/welcome/new?pli=1","target":"_blank","type":"link"},"children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","text":"Google Cloud Platform","color":"#0091FF"}]},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"."}]},{"type":"paragraph","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":""}]},{"type":"paragraph","children":[{"text":""},{"type":"link","link":{"value":"https://aserve.atlassian.net/wiki/spaces/BCFJC/pages/2230649800/How+to+Create+Service+Account+Key","target":"_blank","type":"link"},"children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","text":"See how to create service account key","color":"#0091FF","underline":true}]},{"text":""}]}]},"children":[],"id":"nDUXJ1YGTAdauUAiZAdhu"}],"id":"WVdLYDMMt_n6rxSzOcM2O"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"03Vxas3KHI2TEoA8S0RX5","name":"column","children":[{"name":"card","templateId":"white with icon","params":{"gap":10,"padding":28,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":{"type":"solid","light":"#FFFF"},"boxShadows":[{"y":0,"blur":15,"spread":-3,"color":"#00000019"},{"y":4,"blur":6,"spread":-4,"color":"#00000019"}],"hover":"elevate"},"children":[{"name":"icon","params":{"size":32,"color":{"light":"#ffffff","dark":"#15171A"},"alignment":"start","icon":"table","shape":"circular","background":{"type":"solid","light":"#000000"}},"children":[],"id":"w1gvR_xLI0y8NnZ4Faji7"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Create Data Source","fontFamily":"Montserrat, sans-serif","fontWeight":700,"fontSize":24,"color":{"light":"#202022","dark":"#ffffff"}}],"align":"left"}]},"children":[],"id":"qhbRvd-DO5BHKdElcsl9U"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"A "},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"data source","fontWeight":700},{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":" is the primary source of data sets containing tables and fields for further analysis. It represents the data selected by the user for export to BigQuery."}]},{"type":"paragraph","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":""}]},{"type":"paragraph","children":[{"text":""},{"type":"link","link":{"value":"https://aserve.atlassian.net/wiki/spaces/BCFJC/pages/2857467966/How+to+Create+Data+Source","target":"_blank","type":"link"},"children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","text":"See how to create data source","color":"#0091FF","underline":true}]},{"text":""}]}]},"children":[],"id":"hVTHMJJTZScCt4Hhgplwu"}],"id":"AuHfaBUcq9NTNyxr0HeWk"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"uyHbT8DahSgMBsyzjqksF","name":"column","children":[{"name":"card","templateId":"white with icon","params":{"gap":10,"padding":28,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#D9EDF840","boxShadows":[{"y":0,"blur":15,"spread":-3,"color":"#00000019"},{"y":4,"blur":6,"spread":-4,"color":"#00000019"}],"hover":"elevate"},"children":[{"name":"icon","params":{"size":32,"color":{"light":"#ffffff","dark":"#15171A"},"alignment":"start","icon":"arrow-up-from-bracket","shape":"circular","background":{"type":"solid","light":"#000000"}},"children":[],"id":"Wg-hGsAkjI6zDBYfJbKrU"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Export from Jira to BigQuery","fontFamily":"Montserrat, sans-serif","fontWeight":700,"fontSize":24,"color":{"light":"#202022","dark":"#ffffff"}}],"align":"left"}]},"children":[],"id":"FW-1B0ieqOYoz3UUlnIXi"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Exporting data from Jira to BigQuery involves connecting to BigQuery using a previously created service account key and transferring the datasets included in the data source.","fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"}}]},{"type":"paragraph","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":""}]},{"type":"paragraph","children":[{"text":""},{"type":"link","link":{"value":"https://aserve.atlassian.net/wiki/spaces/BCFJC/pages/2857762820/How+to+Export+Data+into+BigQuery","target":"_blank","type":"link"},"children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","text":"See how to export data","color":"#0091FF","underline":true}]},{"text":""}]}]},"children":[],"id":"_gi_Ufl7Kx6XmMbIilO6u"}],"id":"vGSdnwiKhQ_9_TyfqCYnC"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"fT4OwH4_rfrW_VOq5Mtsh","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"Szx6dsxeB_P2-VtD5N-fr","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"cgiEwJwkvy1SiQkirzWHM","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1,1,1],"gap":15,"minHeight":200,"padding":10,"borderRadius":0}},{"id":"e3DZRH2rRrFBIdDuxQnup","name":"row","children":[{"id":"IDsOFYjSSjX4h1emEhj84","name":"column","children":[{"name":"divider","params":{"templateId":"solid long","color":{"light":"#9E9E9E","dark":"#ffffff"},"alignment":"start","fontSize":24,"fontColor":{"light":"#000000","dark":"#ffffff"},"height":1,"borderStyle":"solid"},"children":[],"id":"5AFW9ZnVeyiTzFf9U7iva"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"IUzwT3ks9pW1m53DbCFWg","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"tCtdR6KRG-i0CR3m-1g3r","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"wU5s8D7BaA3xi0T2uUQKD","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"5HSDPlSEUJ_FyIoDZylEQ","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"PpfRMWdZ0Pcugf1VPPHl1","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":50,"padding":10,"borderRadius":0}},{"id":"4y70IB1DtX3pBylpgE590","name":"row","children":[{"id":"oX8Jrt8chjPj9wMpsrg0-","name":"column","children":[{"name":"card","templateId":"white with icon","params":{"gap":10,"padding":28,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":{"type":"solid","light":"#FFFF"},"boxShadows":[{"y":0,"blur":15,"spread":-3,"color":"#00000019"},{"y":4,"blur":6,"spread":-4,"color":"#00000019"}],"hover":"elevate"},"children":[{"name":"icon","params":{"size":32,"color":{"light":"#ffffff","dark":"#15171A"},"alignment":"start","icon":"list-ul","shape":"circular","background":{"type":"solid","light":"#000000"}},"children":[],"id":"Bq4OwWki87JXn-8Mv8SRs"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"History","fontFamily":"Montserrat, sans-serif","fontWeight":700,"fontSize":24,"color":{"light":"#202022","dark":"#ffffff"}}],"align":"left"}]},"children":[],"id":"xtqZJJPQb0yyXMOFETJT4"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"The History module has been implemented as a separate tab of the BigQuery Connector. The module includes the following submodules:","fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"}}]},{"type":"bulleted-list","children":[{"type":"list-item","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"Data sources history"}]},{"type":"list-item","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":"Export history"}]}]},{"type":"paragraph","children":[{"text":""},{"type":"link","link":{"value":"https://aserve.atlassian.net/wiki/spaces/BCFJC/pages/3288137738/History","target":"_blank","type":"link"},"children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","text":"Learn more about History","color":"#0091FF","underline":true}]},{"text":""}]}]},"children":[],"id":"MhEz9IBY0w-5wIKUhZAvr"}],"id":"QiNzBU2boPpE06ikFBybB"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"M6NfFw7P8vpBcKneTY1QT","name":"column","children":[{"name":"card","templateId":"white with icon","params":{"gap":10,"padding":28,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#D9EDF842","boxShadows":[{"y":0,"blur":15,"spread":-3,"color":"#00000019"},{"y":4,"blur":6,"spread":-4,"color":"#00000019"}],"hover":"elevate"},"children":[{"name":"icon","params":{"size":32,"color":{"light":"#ffffff","dark":"#15171A"},"alignment":"start","icon":"diagram-project","shape":"circular","background":{"type":"solid","light":"#000000"}},"children":[],"id":"4S1oHDY63qAZR3Hnyuk4B"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Data Schema","fontFamily":"Montserrat, sans-serif","fontWeight":700,"fontSize":24,"color":{"light":"#202022","dark":"#ffffff"}}],"align":"left"}]},"children":[],"id":"Z80_fuBDOQBrKQKBuLDI9"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"BigQuery Connector for Jira automatically builds relations between tables and fields in the BigQuery. When you upload your Jira data into BigQuery, all tables will be connected in relations based on the logical key field. Thus, users don’t need to relate tables, which is time-consuming manually.","fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"}}]},{"type":"paragraph","children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","color":{"light":"#202022cc","dark":"#ddddddcc"},"text":""}]},{"type":"paragraph","children":[{"text":""},{"type":"link","link":{"value":"https://aserve.atlassian.net/wiki/spaces/PBCFJC/pages/2381905929/Data+Schema","target":"_blank","type":"link"},"children":[{"fontFamily":"Montserrat, sans-serif","fontSize":14,"lineHeight":"22px","text":"View complete data schema","color":"#0091FF"}]},{"text":""}]},{"type":"paragraph","children":[{"text":""}]}]},"children":[],"id":"_nfMWZvjvokLkwd3o3mdV"}],"id":"oEH58-vcFuvKOlETmUUas"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"qsQ1Sq6rv-WNbIH8Ud0V9","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"yRNW2oxo-Z5Ax_Qrtnwix","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"Hoir1-0CflBj1vnLcWYj0","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"JTWTXp0FyJ_thFgbRLn27","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1,1,1],"gap":15,"minHeight":200,"padding":10,"borderRadius":0}},{"id":"wJqJIYWCKmMCWriajTO_-","name":"row","children":[{"id":"7UyYhmvX6rSI5WN6kVhG7","name":"column","children":[{"name":"divider","params":{"templateId":"solid long","color":{"light":"#9E9E9E","dark":"#ffffff"},"alignment":"start","fontSize":24,"fontColor":{"light":"#000000","dark":"#ffffff"},"height":1,"borderStyle":"solid"},"children":[],"id":"Gs96uuniPtPFrz5nMBVgy"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"hglLOmU3ZnbSg6t4ox-S6","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"EZWHXw2i2eyC_rILuwwaJ","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"-_5tY2qbc4dNjI0LFLODw","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"e8KbTAGy6jLAANgaCze3D","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"NU_pcMKklgczVmVDP1K0y","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":50,"padding":10,"borderRadius":0}},{"id":"oUf9ai6t3HohhgdfrfEIK","name":"row","children":[{"id":"cvzfFiMiUmYyaUgo97_sz","name":"column","children":[{"name":"card","templateId":"plain white","params":{"gap":10,"padding":24,"borderRadius":{"all":20,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#C1E1C199","hover":"none","isMediaFullSize":true},"children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Have experience with ","lineHeight":"22px","fontSize":15,"fontFamily":"Montserrat, sans-serif","color":{"type":"solid","light":"#000000"}},{"lineHeight":"22px","fontSize":15,"fontFamily":"Montserrat, sans-serif","color":{"type":"solid","light":"#000000"},"text":"BigQuery Connector for Jira","fontWeight":700},{"lineHeight":"22px","fontSize":15,"fontFamily":"Montserrat, sans-serif","color":{"type":"solid","light":"#000000"},"text":"? We’d love to hear your thoughts! Please leave us a "},{"lineHeight":"22px","fontSize":15,"fontFamily":"Montserrat, sans-serif","text":"review on the Marketplace"},{"lineHeight":"22px","fontSize":15,"fontFamily":"Montserrat, sans-serif","color":{"type":"solid","light":"#000000"},"text":"! "}],"align":"center"}]},"children":[],"id":"B2EToxneCyRB03Jw2RzXQ"},{"name":"button","params":{"templateId":"large button","label":"Leave review","size":"large","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"background":{"type":"solid","light":"#FFC067"}}},"hover":{"colors":{"outline":{"type":"solid","light":"#393A3A"}}}},"link":{"value":"https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=reviews","target":"_blank","type":"link"}},"children":[],"id":"-ncy8OLEsSBzAN_OOwwR5"}],"id":"OV0bFpbKpIGgg3MYuNKLG"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"OvFwP5JoKnCEuiJnKlOUp","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"m5wbtfhsw42XOhTE36slD","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"FPnOYFbAJIB8IT4FY1jFU","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"Otq5bQlHHoGuitp3Dp_aV","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"plrDtJFNlB9iod-zAAa_e","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":100,"padding":10,"borderRadius":0}}],"name":"section"}],"id":"R2H3bHDsvi-2rDfUfaD3n"} |
|---|
|
.gif?version=1&modificationDate=1708941833536&cacheVersion=1&api=v2&width=98)
