CINXE.COM

<!DOCTYPE html><html lang="en" class="dark"><head><meta charSet="utf-8"/><meta name="viewport" content="width=device-width"/><link rel="apple-touch-icon" type="image/png" sizes="180x180" href="https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/apple-touch-icon.png?v=3"/><link rel="icon" type="image/png" sizes="32x32" href="https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/favicon-32x32.png?v=3"/><link rel="icon" type="image/png" sizes="16x16" href="https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/favicon-16x16.png?v=3"/><link rel="shortcut icon" type="image/x-icon" href="https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/favicon.ico?v=3"/><meta name="msapplication-config" content="https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/browserconfig.xml?v=3"/><meta name="apple-mobile-web-app-title" content="Docs"/><meta name="application-name" content="Docs"/><meta name="msapplication-TileColor" content="#111827"/><meta name="theme-color" content="#ffffff"/><link rel="sitemap" type="application/xml" href="/sitemap.xml"/><meta name="charset" content="utf-8"/><meta name="og:type" content="website"/><meta name="og:site_name" content="Docs"/><meta name="twitter:card" content="summary_large_image"/><meta name="og:title" content="Build with SQL & Python - Docs"/><meta name="twitter:title" content="Build with SQL & Python - Docs"/><meta name="image" property="og:image" content="https://mintlify.com/docs/api/og?division=Documentation&title=Build+with+SQL+%26+Python&logoLight=https%3A%2F%2Fmintlify.s3.us-west-1.amazonaws.com%2Fqueue-4c50ebb3%2Fassets%2Fimages%2Fmorph_logo_svg.svg&logoDark=https%3A%2F%2Fmintlify.s3.us-west-1.amazonaws.com%2Fqueue-4c50ebb3%2Fassets%2Fimages%2Fmorph_logo_svg_w.svg&primaryColor=%23111827&lightColor=%23d1d5db&darkColor=%23111827"/><meta property="og:image:width" content="1200"/><meta property="og:image:height" content="630"/><meta name="twitter:image" property="twitter:image" content="https://mintlify.com/docs/api/og?division=Documentation&title=Build+with+SQL+%26+Python&logoLight=https%3A%2F%2Fmintlify.s3.us-west-1.amazonaws.com%2Fqueue-4c50ebb3%2Fassets%2Fimages%2Fmorph_logo_svg.svg&logoDark=https%3A%2F%2Fmintlify.s3.us-west-1.amazonaws.com%2Fqueue-4c50ebb3%2Fassets%2Fimages%2Fmorph_logo_svg_w.svg&primaryColor=%23111827&lightColor=%23d1d5db&darkColor=%23111827"/><meta property="twitter:image:width" content="1200"/><meta property="twitter:image:height" content="630"/><title>Build with SQL & Python - Docs</title><meta name="og:url" content="/docs/en/workspace/sql-python"/><link rel="canonical" href="/docs/en/workspace/sql-python"/><meta name="robots" content="noindex"/><meta name="next-head-count" content="28"/><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/katex@0.16.0/dist/katex.min.css" integrity="sha384-Xi8rHCmBmhbuyyhbI88391ZKP2dmfnOl4rT9ZfRI7mLTdk1wblIUnrIq35nqwEvC" crossorigin="anonymous"/><link rel="preload" href="/_next/static/media/a34f9d1faa5f3315-s.p.woff2" as="font" type="font/woff2" crossorigin="anonymous" data-next-font="size-adjust"/><link rel="preload" href="/_next/static/media/bb3ef058b751a6ad-s.p.woff2" as="font" type="font/woff2" crossorigin="anonymous" data-next-font="size-adjust"/><script id="mode-toggle" data-nscript="beforeInteractive"> try { if (localStorage.isDarkMode === 'true') { document.documentElement.classList.add('dark'); } else if (localStorage.isDarkMode === 'false') { document.documentElement.classList.remove('dark'); } else if ((true && !('isDarkMode' in localStorage) && window.matchMedia('(prefers-color-scheme: dark)').matches) || false) { document.documentElement.classList.add('dark'); } else { document.documentElement.classList.remove('dark'); } } catch (_) {}</script><link rel="preload" href="/_next/static/css/445ed91d55e2c99f.css" as="style"/><link rel="stylesheet" href="/_next/static/css/445ed91d55e2c99f.css" data-n-g=""/><noscript data-n-css=""></noscript><script defer="" nomodule="" src="/_next/static/chunks/polyfills-42372ed130431b0a.js"></script><script src="/_next/static/chunks/webpack-dedccb098e30a6ab.js" defer=""></script><script src="/_next/static/chunks/framework-9ae01a5f4ade81f5.js" defer=""></script><script src="/_next/static/chunks/main-cf327937a0d9f14c.js" defer=""></script><script src="/_next/static/chunks/pages/_app-59c3d8b0cbe3b397.js" defer=""></script><script src="/_next/static/chunks/2edb282b-a83f7ffd007bccf0.js" defer=""></script><script src="/_next/static/chunks/e893f787-f6a1094a35763a0d.js" defer=""></script><script src="/_next/static/chunks/086d643d-6f7196a364073d16.js" defer=""></script><script src="/_next/static/chunks/9097-53b32b020063004a.js" defer=""></script><script src="/_next/static/chunks/7669-b7b6e74eb838f0fc.js" defer=""></script><script src="/_next/static/chunks/7610-e463a3dc6ba2cbb8.js" defer=""></script><script src="/_next/static/chunks/40-6e3b34f65970aa65.js" defer=""></script><script src="/_next/static/chunks/pages/_sites/%5Bsubdomain%5D/%5B%5B...slug%5D%5D-79e8424968849281.js" defer=""></script><script src="/_next/static/4bmdERr2JNq_C8xBoD2SZ/_buildManifest.js" defer=""></script><script src="/_next/static/4bmdERr2JNq_C8xBoD2SZ/_ssgManifest.js" defer=""></script><style id="__jsx-4145347147">:root{--font-inter:'__Inter_e5ab12', '__Inter_Fallback_e5ab12';--font-jetbrains-mono:'__JetBrains_Mono_3c557b', '__JetBrains_Mono_Fallback_3c557b'}</style></head><div id="__next"><main class="jsx-4145347147"><style>:root { --primary: 17 24 39; --primary-light: 209 213 219; --primary-dark: 17 24 39; --background-light: 255 255 255; --background-dark: 13 13 15; --gray-50: 243 243 244; --gray-100: 238 238 239; --gray-200: 223 223 223; --gray-300: 206 206 207; --gray-400: 159 159 159; --gray-500: 112 112 113; --gray-600: 80 80 81; --gray-700: 63 63 63; --gray-800: 37 38 38; --gray-900: 23 23 23; --gray-950: 10 10 11; }</style><span class="fixed inset-0 bg-background-light dark:bg-background-dark -z-10"></span><div class="relative antialiased text-gray-500 dark:text-gray-400"><div id="navbar" class="z-30 fixed lg:sticky top-0 w-full"><div id="navbar-transition" class="absolute w-full h-full backdrop-blur flex-none transition-colors duration-500 border-b border-gray-500/5 dark:border-gray-300/[0.06] supports-backdrop-blur:bg-background-light/60 dark:bg-transparent"></div><div class="max-w-8xl mx-auto relative"><div class=""><div class="relative"><div class="flex items-center lg:px-12 h-16 min-w-0 mx-4 lg:mx-0"><div class="h-full relative flex-1 flex items-center gap-x-4 min-w-0 border-b border-gray-500/5 dark:border-gray-300/[0.06]"><div class="flex-1 flex items-center gap-x-4"><a href="/"><span class="sr-only">Docs home page</span><img class="w-auto h-7 relative object-contain block dark:hidden" src="https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg.svg" alt="light logo"/><img class="w-auto h-7 relative object-contain hidden dark:block" src="https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg_w.svg" alt="dark logo"/></a><div class="flex items-center gap-x-2"><button type="button" id="radix-:Rcarcql6:" aria-haspopup="menu" aria-expanded="false" data-state="closed" class="group bg-background-light dark:bg-background-dark disabled:pointer-events-none [&>span]:line-clamp-1 overflow-hidden group outline-none group-hover:text-gray-950/70 dark:group-hover:text-white/70 text-xs gap-1.5 text-gray-500 dark:text-gray-400 leading-5 font-semibold border border-gray-200 dark:border-gray-800 hover:border-gray-300 dark:hover:border-gray-700 rounded-full py-1 px-3 flex items-center space-x-2 whitespace-nowrap">English<svg xmlns="http://www.w3.org/2000/svg" width="12" height="12" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2.5" stroke-linecap="round" stroke-linejoin="round" class="lucide lucide-chevron-down"><path d="m6 9 6 6 6-6"></path></svg></button></div></div><button type="button" class="hidden lg:flex relative flex-1 pointer-events-auto rounded-xl w-full items-center text-sm leading-6 py-1.5 pl-3.5 pr-3 text-gray-400 dark:text-white/50 bg-background-light dark:bg-background-dark dark:brightness-[1.1] dark:ring-1 dark:hover:brightness-[1.25] ring-1 ring-gray-400/20 hover:ring-gray-600/25 dark:ring-gray-600/30 dark:hover:ring-gray-500/30 focus:outline-primary justify-between truncate gap-2 min-w-[43px] mx-px" id="search-bar-entry"><div class="flex items-center gap-3 min-w-[42px]"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="lucide lucide-search min-w-4 flex-none text-gray-700 hover:text-gray-800 dark:text-gray-300 hover:dark:text-gray-200"><circle cx="11" cy="11" r="8"></circle><path d="m21 21-4.3-4.3"></path></svg><div class="truncate min-w-0">Search...</div></div></button><div class="flex-1 relative hidden lg:flex items-center ml-auto justify-end space-x-4"><nav class="text-sm"><ul class="flex space-x-6 items-center"><li><a href="https://www.morphdb.io/blogs" class="whitespace-nowrap font-medium text-gray-600 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" target="_blank">Blog</a></li><li class="block lg:hidden"><a class="whitespace-nowrap font-medium text-gray-600 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" href="https://www.morphdb.io">Website</a></li><li class="whitespace-nowrap hidden lg:flex" id="topbar-cta-button"><a target="_blank" class="group px-4 py-1.5 relative inline-flex items-center text-sm font-medium" href="https://www.morphdb.io"><span class="absolute inset-0 bg-primary-dark rounded-full group-hover:opacity-[0.9]"></span><div class="mr-0.5 space-x-2.5 flex items-center"><span class="z-10 text-white">Website</span><svg width="3" height="24" viewBox="0 -9 3 24" class="h-5 rotate-0 overflow-visible text-white/90"><path d="M0 0L3 3L0 6" fill="none" stroke="currentColor" stroke-width="1.5" stroke-linecap="round"></path></svg></div></a></li></ul></nav><div class="flex items-center"><button class="group p-2 flex items-center justify-center" aria-label="Toggle dark mode"><svg width="16" height="16" viewBox="0 0 16 16" fill="none" stroke="currentColor" xmlns="http://www.w3.org/2000/svg" class="h-4 w-4 block text-gray-400 dark:hidden group-hover:text-gray-600"><g clip-path="url(#clip0_2880_7340)"><path d="M8 1.11133V2.00022" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path><path d="M12.8711 3.12891L12.2427 3.75735" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path><path d="M14.8889 8H14" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path><path d="M12.8711 12.8711L12.2427 12.2427" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path><path d="M8 14.8889V14" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path><path d="M3.12891 12.8711L3.75735 12.2427" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path><path d="M1.11133 8H2.00022" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path><path d="M3.12891 3.12891L3.75735 3.75735" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path><path d="M8.00043 11.7782C10.0868 11.7782 11.7782 10.0868 11.7782 8.00043C11.7782 5.91402 10.0868 4.22266 8.00043 4.22266C5.91402 4.22266 4.22266 5.91402 4.22266 8.00043C4.22266 10.0868 5.91402 11.7782 8.00043 11.7782Z" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path></g><defs><clipPath id="clip0_2880_7340"><rect width="16" height="16" fill="white"></rect></clipPath></defs></svg><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="lucide lucide-moon h-4 w-4 hidden dark:block text-gray-500 dark:group-hover:text-gray-300"><path d="M12 3a6 6 0 0 0 9 9 9 9 0 1 1-9-9Z"></path></svg></button></div></div><div class="flex lg:hidden items-center gap-2"><button type="button" class="text-gray-500 w-8 h-8 flex items-center justify-center hover:text-gray-600 dark:text-gray-400 dark:hover:text-gray-300" id="search-bar-entry-mobile"><span class="sr-only">Search...</span><svg class="h-4 w-4 bg-gray-500 dark:bg-gray-400 hover:bg-gray-600 dark:hover:bg-gray-300" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/solid/magnifying-glass.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/solid/magnifying-glass.svg);mask-repeat:no-repeat;mask-position:center"></svg></button><button aria-label="More actions" class="h-7 w-5 flex items-center justify-end"><svg class="h-4 w-4 bg-gray-500 dark:bg-gray-400 hover:bg-gray-600 dark:hover:bg-gray-300" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/solid/ellipsis-vertical.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/solid/ellipsis-vertical.svg);mask-repeat:no-repeat;mask-position:center"></svg></button></div></div></div><div class="flex items-center h-14 py-4 px-5 lg:hidden"><button type="button" class="text-gray-500 hover:text-gray-600 dark:text-gray-400 dark:hover:text-gray-300"><span class="sr-only">Navigation</span><svg class="h-4" fill="currentColor" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 448 512"><path d="M0 96C0 78.3 14.3 64 32 64H416c17.7 0 32 14.3 32 32s-14.3 32-32 32H32C14.3 128 0 113.7 0 96zM0 256c0-17.7 14.3-32 32-32H416c17.7 0 32 14.3 32 32s-14.3 32-32 32H32c-17.7 0-32-14.3-32-32zM448 416c0 17.7-14.3 32-32 32H32c-17.7 0-32-14.3-32-32s14.3-32 32-32H416c17.7 0 32 14.3 32 32z"></path></svg></button><div class="ml-4 flex text-sm leading-6 whitespace-nowrap min-w-0 space-x-3"><div class="font-semibold text-gray-900 truncate dark:text-gray-200">Build with SQL & Python</div></div></div></div><div class="hidden lg:flex px-12 h-12"><div class="h-full flex text-sm space-x-6"><a class="group relative h-full flex items-center text-gray-800 dark:text-gray-200 font-semibold" href="/docs/en/getting-started/why-morph">Guides<div class="absolute bottom-0 h-[1.5px] w-full bg-primary dark:bg-primary-light"></div></a><a class="group relative h-full flex items-center font-medium text-gray-600 dark:text-gray-400 group-hover:text-gray-800 dark:group-hover:text-gray-300" href="/reference/en/framework/morph-project">Reference<div class="absolute bottom-0 h-[1.5px] w-full group-hover:bg-gray-200 dark:group-hover:bg-gray-700"></div></a><a class="group relative h-full flex items-center font-medium text-gray-600 dark:text-gray-400 group-hover:text-gray-800 dark:group-hover:text-gray-300" href="/data-application/en/ai-component-chat">Components<div class="absolute bottom-0 h-[1.5px] w-full group-hover:bg-gray-200 dark:group-hover:bg-gray-700"></div></a><a class="group relative h-full flex items-center font-medium text-gray-600 dark:text-gray-400 group-hover:text-gray-800 dark:group-hover:text-gray-300" href="/troubleshooting/en/cli/deployment-issues">Troubleshooting<div class="absolute bottom-0 h-[1.5px] w-full group-hover:bg-gray-200 dark:group-hover:bg-gray-700"></div></a></div></div></div></div></div><div class="max-w-8xl px-4 mx-auto lg:px-8"><div class="z-20 hidden lg:block fixed bottom-0 right-auto w-[18rem] top-[7.1rem]" id="sidebar"><div class="absolute inset-0 z-10 stable-scrollbar-gutter overflow-auto pr-8 pb-10" id="sidebar-content"><div class="relative lg:text-sm lg:leading-6"><div class="sticky top-0 h-8 bg-gradient-to-b from-background-light dark:from-background-dark"></div><div id="navigation-items"><li class="list-none"><a href="https://www.morph-data.io/changelog" target="_blank" rel="noreferrer" class="pl-4 group flex items-center lg:text-sm lg:leading-6 mb-5 sm:mb-4 font-medium text-gray-600 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300"><div class="mr-4 rounded-md p-1 zinc-box group-hover:brightness-100 group-hover:ring-0 ring-1 ring-gray-950/5 dark:ring-gray-700/40"><svg class="h-4 w-4 secondary-opacity group-hover:fill-primary-dark group-hover:bg-white bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/duotone/rss.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/duotone/rss.svg);mask-repeat:no-repeat;mask-position:center"></svg></div>Changelog</a></li><li class="list-none"><a href="https://www.morph-data.io/tools/connectors/database" target="_blank" rel="noreferrer" class="pl-4 group flex items-center lg:text-sm lg:leading-6 mb-5 sm:mb-4 font-medium text-gray-600 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300"><div class="mr-4 rounded-md p-1 zinc-box group-hover:brightness-100 group-hover:ring-0 ring-1 ring-gray-950/5 dark:ring-gray-700/40"><svg class="h-4 w-4 secondary-opacity group-hover:fill-primary-dark group-hover:bg-white bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/duotone/plug.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/duotone/plug.svg);mask-repeat:no-repeat;mask-position:center"></svg></div>Connectors</a></li><li class="list-none"><a href="https://www.morph-data.io/tools/snippets/undefined" target="_blank" rel="noreferrer" class="pl-4 group flex items-center lg:text-sm lg:leading-6 mb-5 sm:mb-4 font-medium text-gray-600 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300"><div class="mr-4 rounded-md p-1 zinc-box group-hover:brightness-100 group-hover:ring-0 ring-1 ring-gray-950/5 dark:ring-gray-700/40"><svg class="h-4 w-4 secondary-opacity group-hover:fill-primary-dark group-hover:bg-white bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/duotone/brackets-curly.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/duotone/brackets-curly.svg);mask-repeat:no-repeat;mask-position:center"></svg></div>Code Snippets</a></li><div class="mt-12 lg:mt-8"><h5 class="pl-4 mb-3.5 lg:mb-2.5 font-semibold text-gray-900 dark:text-gray-200">Getting Started</h5><ul><li id="/docs/en/getting-started/why-morph" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/getting-started/why-morph"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/lightbulb.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/lightbulb.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Introduction</div></div></a></li><li id="/docs/en/getting-started/installation" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/getting-started/installation"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/wrench.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/wrench.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Installation</div></div></a></li></ul></div><div class="mt-12 lg:mt-8"><h5 class="pl-4 mb-3.5 lg:mb-2.5 font-semibold text-gray-900 dark:text-gray-200">Quick Start</h5><ul><li id="/docs/en/quickstart/building-app" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/quickstart/building-app"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/rocket.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/rocket.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Building AI App</div></div></a></li><li><div class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/link.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/link.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="">How to Deploy</div><svg width="8" height="24" viewBox="0 -9 3 24" class="transition-transform text-gray-400 overflow-visible group-hover:text-gray-600 dark:text-gray-600 dark:group-hover:text-gray-400 -mr-0.5"><path d="M0 0L3 3L0 6" fill="none" stroke="currentColor" stroke-width="1.5" stroke-linecap="round"></path></svg></div></li></ul></div><div class="mt-12 lg:mt-8"><h5 class="pl-4 mb-3.5 lg:mb-2.5 font-semibold text-gray-900 dark:text-gray-200">Framework</h5><ul><li id="/docs/en/develop/guides/framework" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/framework"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/eye.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/eye.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Framework Overview</div></div></a></li><li id="/docs/en/develop/guides/alias" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/alias"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/shuffle.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/shuffle.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Alias</div></div></a></li><li id="/docs/en/develop/guides/building-backend" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/building-backend"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/brackets-curly.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/brackets-curly.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Building the Backend</div></div></a></li><li id="/docs/en/develop/guides/building-frontend" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/building-frontend"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/brands/markdown.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/brands/markdown.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Building the Frontend</div></div></a></li><li id="/docs/en/develop/guides/environment-variables" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/environment-variables"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/square-terminal.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/square-terminal.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Environment Variables</div></div></a></li><li id="/docs/en/develop/guides/integration" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/integration"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/database.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/database.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Data Connector</div></div></a></li><li id="/docs/en/develop/guides/variables" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/variables"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/code.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/code.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Variables</div></div></a></li><li id="/docs/en/develop/guides/user-role" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/user-role"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/user.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/user.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Role-based Access Control</div></div></a></li><li id="/docs/en/develop/guides/updating-project" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/guides/updating-project"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/rotate.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/rotate.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Updating the Project</div></div></a></li></ul></div><div class="mt-12 lg:mt-8"><h5 class="pl-4 mb-3.5 lg:mb-2.5 font-semibold text-gray-900 dark:text-gray-200">Deployment</h5><ul><li id="/docs/en/deploy/customize-dockerfile" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/deploy/customize-dockerfile"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/server.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/server.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Customizing the Runtime Environment</div></div></a></li><li id="/docs/en/deploy/environment-variables" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/deploy/environment-variables"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/square-terminal.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/square-terminal.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Environment Variables</div></div></a></li><li id="/docs/en/deploy/public" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/deploy/public"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/link.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/link.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Enable Public Access</div></div></a></li></ul></div><div class="mt-12 lg:mt-8"><h5 class="pl-4 mb-3.5 lg:mb-2.5 font-semibold text-gray-900 dark:text-gray-200">Tutorials: Data Analysis</h5><ul><li id="/docs/en/develop/tutorials/pygwalker" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/tutorials/pygwalker"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/chart-user.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/chart-user.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Build a BI app using Pygwalker</div></div></a></li><li id="/docs/en/develop/tutorials/plotly" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/tutorials/plotly"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/chart-bar.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/chart-bar.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Build a sophisticated dashboard using Plotly</div></div></a></li></ul></div><div class="mt-12 lg:mt-8"><h5 class="pl-4 mb-3.5 lg:mb-2.5 font-semibold text-gray-900 dark:text-gray-200">Tutorials: LLM Apps</h5><ul><li id="/docs/en/develop/tutorials/chatbot" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/tutorials/chatbot"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/message-dots.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/message-dots.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Create a chat app</div></div></a></li><li id="/docs/en/develop/tutorials/chat_sidebyside" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/develop/tutorials/chat_sidebyside"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/code.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/code.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>AI Chat generates and executes code</div></div></a></li></ul></div><div class="mt-12 lg:mt-8"><h5 class="pl-4 mb-3.5 lg:mb-2.5 font-semibold text-gray-900 dark:text-gray-200">Advanced</h5><ul><li id="/docs/en/advanced/api_key" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/advanced/api_key"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/key.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/key.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>API Key</div></div></a></li><li id="/docs/en/advanced/builtin-postgres" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/advanced/builtin-postgres"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/database.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/database.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Built-in PostgreSQL</div></div></a></li><li id="/docs/en/advanced/migration-guide" class="scroll-m-4 first:scroll-m-20"><a class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem" href="/docs/en/advanced/migration-guide"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/arrows-turn-to-dots.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/arrows-turn-to-dots.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="flex-1 flex items-center space-x-2.5"><div>Version Migration Guide</div></div></a></li><li><div class="group mt-2 lg:mt-0 flex items-center pr-3 py-1.5 cursor-pointer focus:outline-primary dark:focus:outline-primary-light gap-x-3 rounded-xl hover:bg-gray-600/5 dark:hover:bg-gray-200/5 text-gray-700 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300" style="padding-left:1rem"><svg class="h-4 w-4 bg-gray-400 dark:bg-gray-500" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/plug.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/regular/plug.svg);mask-repeat:no-repeat;mask-position:center"></svg><div class="">Connectors</div><svg width="8" height="24" viewBox="0 -9 3 24" class="transition-transform text-gray-400 overflow-visible group-hover:text-gray-600 dark:text-gray-600 dark:group-hover:text-gray-400 -mr-0.5"><path d="M0 0L3 3L0 6" fill="none" stroke="currentColor" stroke-width="1.5" stroke-linecap="round"></path></svg></div></li></ul></div></div></div></div></div><div class="" id="content-container"><div class="flex flex-row gap-12 box-border w-full pt-40 lg:pt-10"><div class="relative grow box-border flex-col w-full mx-auto px-1 lg:pl-[23.7rem] lg:-ml-12 xl:w-[calc(100%-28rem)]" id="content-area"><header id="header" class="relative"><div class="mt-0.5 space-y-2.5"><div class="flex items-center"><h1 class="inline-block text-2xl sm:text-3xl font-bold text-gray-900 tracking-tight dark:text-gray-200">Build with SQL & Python</h1></div></div></header><div class="flex flex-col gap-8"></div><div class="relative mt-8 prose prose-gray dark:prose-invert"><p>The workspace allows data analysis using SQL and Python.</p> <p>When you open the workspace, a <code>src</code> directory exists in the project root. Place and run SQL and Python files in this <code>src</code> directory.</p> <div class="my-4 px-5 py-4 overflow-hidden rounded-2xl flex gap-3 border border-emerald-500/20 bg-emerald-50/50 dark:border-emerald-500/30 dark:bg-emerald-500/10"><div class="mt-0.5 w-4"><svg width="11" height="14" viewBox="0 0 11 14" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="text-emerald-600 dark:text-emerald-400/80 w-3.5 h-auto" aria-label="Tip"><path d="M3.12794 12.4232C3.12794 12.5954 3.1776 12.7634 3.27244 12.907L3.74114 13.6095C3.88471 13.8248 4.21067 14 4.46964 14H6.15606C6.41415 14 6.74017 13.825 6.88373 13.6095L7.3508 12.9073C7.43114 12.7859 7.49705 12.569 7.49705 12.4232L7.50055 11.3513H3.12521L3.12794 12.4232ZM5.31288 0C2.52414 0.00875889 0.5 2.26889 0.5 4.78826C0.5 6.00188 0.949566 7.10829 1.69119 7.95492C2.14321 8.47011 2.84901 9.54727 3.11919 10.4557C3.12005 10.4625 3.12175 10.4698 3.12261 10.4771H7.50342C7.50427 10.4698 7.50598 10.463 7.50684 10.4557C7.77688 9.54727 8.48281 8.47011 8.93484 7.95492C9.67728 7.13181 10.1258 6.02703 10.1258 4.78826C10.1258 2.15486 7.9709 0.000106649 5.31288 0ZM7.94902 7.11267C7.52078 7.60079 6.99082 8.37878 6.6077 9.18794H4.02051C3.63739 8.37878 3.10743 7.60079 2.67947 7.11294C2.11997 6.47551 1.8126 5.63599 1.8126 4.78826C1.8126 3.09829 3.12794 1.31944 5.28827 1.3126C7.2435 1.3126 8.81315 2.88226 8.81315 4.78826C8.81315 5.63599 8.50688 6.47551 7.94902 7.11267ZM4.87534 2.18767C3.66939 2.18767 2.68767 3.16939 2.68767 4.37534C2.68767 4.61719 2.88336 4.81288 3.12521 4.81288C3.36705 4.81288 3.56274 4.61599 3.56274 4.37534C3.56274 3.6515 4.1515 3.06274 4.87534 3.06274C5.11719 3.06274 5.31288 2.86727 5.31288 2.62548C5.31288 2.38369 5.11599 2.18767 4.87534 2.18767Z"></path></svg></div><div class="text-sm prose min-w-0 text-emerald-900 dark:text-emerald-200">The <code>morph_project.yml</code> file is set to <code>source_paths: src</code>. It is possible to change the directory where the source code is placed by changing this value.</div></div>  <h3 class="flex whitespace-pre-wrap group font-semibold" id="execution-of-source-code"><div class="absolute"><a href="#execution-of-source-code" class="-ml-10 flex items-center opacity-0 border-0 group-hover:opacity-100" aria-label="Navigate to header"><div class="w-6 h-6 text-gray-400 rounded-md flex items-center justify-center zinc-box bg-white ring-1 ring-gray-400/30 dark:ring-gray-700/25 hover:ring-gray-400/60 dark:hover:ring-white/20"><svg xmlns="http://www.w3.org/2000/svg" fill="gray" height="12px" viewBox="0 0 576 512"><path d="M0 256C0 167.6 71.6 96 160 96h72c13.3 0 24 10.7 24 24s-10.7 24-24 24H160C98.1 144 48 194.1 48 256s50.1 112 112 112h72c13.3 0 24 10.7 24 24s-10.7 24-24 24H160C71.6 416 0 344.4 0 256zm576 0c0 88.4-71.6 160-160 160H344c-13.3 0-24-10.7-24-24s10.7-24 24-24h72c61.9 0 112-50.1 112-112s-50.1-112-112-112H344c-13.3 0-24-10.7-24-24s10.7-24 24-24h72c88.4 0 160 71.6 160 160zM184 232H392c13.3 0 24 10.7 24 24s-10.7 24-24 24H184c-13.3 0-24-10.7-24-24s10.7-24 24-24z"></path></svg></div></a></div><span class="cursor-pointer">Execution of source code</span></h3> <p>The SQL or Python you have written can be executed using the ‘RUN’ button located in the top right-hand corner of the editor, as shown in the image below.</p> <p>When executed, the corresponding Morph CLI log is output in the terminal and the data from the execution is displayed in the ‘Result’ tab in the right sidebar.</p>  <h2 class="flex whitespace-pre-wrap group font-semibold" id="implementing-source-code"><div class="absolute"><a href="#implementing-source-code" class="-ml-10 flex items-center opacity-0 border-0 group-hover:opacity-100" aria-label="Navigate to header"><div class="w-6 h-6 text-gray-400 rounded-md flex items-center justify-center zinc-box bg-white ring-1 ring-gray-400/30 dark:ring-gray-700/25 hover:ring-gray-400/60 dark:hover:ring-white/20"><svg xmlns="http://www.w3.org/2000/svg" fill="gray" height="12px" viewBox="0 0 576 512"><path d="M0 256C0 167.6 71.6 96 160 96h72c13.3 0 24 10.7 24 24s-10.7 24-24 24H160C98.1 144 48 194.1 48 256s50.1 112 112 112h72c13.3 0 24 10.7 24 24s-10.7 24-24 24H160C71.6 416 0 344.4 0 256zm576 0c0 88.4-71.6 160-160 160H344c-13.3 0-24-10.7-24-24s10.7-24 24-24h72c61.9 0 112-50.1 112-112s-50.1-112-112-112H344c-13.3 0-24-10.7-24-24s10.7-24 24-24h72c88.4 0 160 71.6 160 160zM184 232H392c13.3 0 24 10.7 24 24s-10.7 24-24 24H184c-13.3 0-24-10.7-24-24s10.7-24 24-24z"></path></svg></div></a></div><span class="cursor-pointer">Implementing source code</span></h2> <p>SQL and Python on Morph is run by the Morph CLI installed on a VM on the workspace. It builds on the DB and standard Python scripts used, and provides extensions to allow more powerful data analysis by the user.</p> <p>In addition, in Morph, files for analysis are named at runtime. Naming makes it easier to access the results of that file from other files. This mechanism is a very important part of the Morph framework.</p> <p>Note that duplicate names of this name at runtime will result in a compile error.</p> <h3 class="flex whitespace-pre-wrap group font-semibold" id="sql"><div class="absolute"><a href="#sql" class="-ml-10 flex items-center opacity-0 border-0 group-hover:opacity-100" aria-label="Navigate to header"><div class="w-6 h-6 text-gray-400 rounded-md flex items-center justify-center zinc-box bg-white ring-1 ring-gray-400/30 dark:ring-gray-700/25 hover:ring-gray-400/60 dark:hover:ring-white/20"><svg xmlns="http://www.w3.org/2000/svg" fill="gray" height="12px" viewBox="0 0 576 512"><path d="M0 256C0 167.6 71.6 96 160 96h72c13.3 0 24 10.7 24 24s-10.7 24-24 24H160C98.1 144 48 194.1 48 256s50.1 112 112 112h72c13.3 0 24 10.7 24 24s-10.7 24-24 24H160C71.6 416 0 344.4 0 256zm576 0c0 88.4-71.6 160-160 160H344c-13.3 0-24-10.7-24-24s10.7-24 24-24h72c61.9 0 112-50.1 112-112s-50.1-112-112-112H344c-13.3 0-24-10.7-24-24s10.7-24 24-24h72c88.4 0 160 71.6 160 160zM184 232H392c13.3 0 24 10.7 24 24s-10.7 24-24 24H184c-13.3 0-24-10.7-24-24s10.7-24 24-24z"></path></svg></div></a></div><span class="cursor-pointer">SQL</span></h3> <p>You can use jinja2 to write SQL, and within jinja you can use Morph’s own config, a function for writing metadata. In config, you can describe the processing of the function. This allows you to leave the processing details for team members and for the Morph AI to interpret the developer’s intentions in detail.</p> <p>In the SQL below, the config function is used to name and describe the process in detail. Using jinja in this way allows metadata to be written directly in the SQL.</p> <div class="mt-5 mb-8 not-prose rounded-2xl relative text-gray-50 bg-[#0F1117] dark:bg-codeblock border border-transparent dark:border-gray-800/50 codeblock-dark"><div class="min-w-full relative text-sm leading-6 children:!my-0 children:!shadow-none children:!bg-transparent transition-[height] duration-300 ease-in-out" style="font-variant-ligatures:none;height:auto"><div class="overflow-x-auto h-full p-5 overflow-y-hidden scrollbar-thin scrollbar-thumb-rounded scrollbar-thumb-white/20 dark:scrollbar-thumb-white/20 hover:scrollbar-thumb-white/25 dark:hover:scrollbar-thumb-white/25 active:scrollbar-thumb-white/25 dark:active:scrollbar-thumb-white/25"><pre class="language-sql"><code class="language-sql"><span class="">{{</span> <span class=""> config<span class="token punctuation">(</span></span> <span class=""> name<span class="token operator">=</span><span class="token string">"example_sql_cell"</span><span class="token punctuation">,</span></span> <span class=""> description<span class="token operator">=</span><span class="token string">"Example SQL cell"</span><span class="token punctuation">,</span></span> <span class=""> <span class="token punctuation">)</span></span> <span class="">}}</span>  <span class=""><span class="token keyword">select</span> <span class="token operator">*</span> <span class="token keyword">from</span> customers <span class="token keyword">limit</span> <span class="token number">10</span></span> </code></pre></div></div></div> <div class="my-4 px-5 py-4 overflow-hidden rounded-2xl flex gap-3 border border-sky-500/20 bg-sky-50/50 dark:border-sky-500/30 dark:bg-sky-500/10"><div class="mt-0.5 w-4"><svg width="14" height="14" viewBox="0 0 14 14" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="w-4 h-4 text-sky-500" aria-label="Note"><path fill-rule="evenodd" clip-rule="evenodd" d="M7 1.3C10.14 1.3 12.7 3.86 12.7 7C12.7 10.14 10.14 12.7 7 12.7C5.48908 12.6974 4.0408 12.096 2.97241 11.0276C1.90403 9.9592 1.30264 8.51092 1.3 7C1.3 3.86 3.86 1.3 7 1.3ZM7 0C3.14 0 0 3.14 0 7C0 10.86 3.14 14 7 14C10.86 14 14 10.86 14 7C14 3.14 10.86 0 7 0ZM8 3H6V8H8V3ZM8 9H6V11H8V9Z"></path></svg></div><div class="text-sm prose min-w-0 text-sky-900 dark:text-sky-200"><p>If the config function is undefined or not named by name, the sql file name is used as the name. Example: example_sql_cell.sql, in which case example_sql_cell is used as the name.</p></div></div> <div class="my-4 px-5 py-4 overflow-hidden rounded-2xl flex gap-3 border border-amber-500/20 bg-amber-50/50 dark:border-amber-500/30 dark:bg-amber-500/10"><div class="mt-0.5 w-4"><svg class="flex-none w-5 h-5 text-amber-400 dark:text-amber-300/80" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2" aria-label="Warning"><path stroke-linecap="round" stroke-linejoin="round" d="M12 9v2m0 4h.01m-6.938 4h13.856c1.54 0 2.502-1.667 1.732-3L13.732 4c-.77-1.333-2.694-1.333-3.464 0L3.34 16c-.77 1.333.192 3 1.732 3z"></path></svg></div><div class="text-sm prose min-w-0 text-amber-900 dark:text-amber-200"><p>In Morph, it is forbidden to write a semicolon at the end of SQL to prevent multiple SQLs in one SQL file. If you have written one, an error message will be displayed, so delete the semi-colon and run the program again.</p></div></div> <p>For detailed config settings and other grammar rules, see the following detailed pages:</p> <div class="not-prose grid gap-x-4 sm:grid-cols-1"><a class="card block not-prose font-normal group relative my-2 ring-2 ring-transparent rounded-2xl bg-white dark:bg-background-dark border border-gray-950/10 dark:border-white/10 overflow-hidden w-full cursor-pointer hover:!border-primary dark:hover:!border-primary-light" href="/sql-python/en/sql/quickstart-sql"><div class="px-6 py-5"><div><h2 class="font-semibold text-base text-gray-800 dark:text-white">Quick start: SQL</h2><div class="mt-1 font-normal text-sm leading-6 text-gray-600 dark:text-gray-400"><p>Describes how to run SQL on Morph.</p></div></div></div></a></div> <h3 class="flex whitespace-pre-wrap group font-semibold" id="python"><div class="absolute"><a href="#python" class="-ml-10 flex items-center opacity-0 border-0 group-hover:opacity-100" aria-label="Navigate to header"><div class="w-6 h-6 text-gray-400 rounded-md flex items-center justify-center zinc-box bg-white ring-1 ring-gray-400/30 dark:ring-gray-700/25 hover:ring-gray-400/60 dark:hover:ring-white/20"><svg xmlns="http://www.w3.org/2000/svg" fill="gray" height="12px" viewBox="0 0 576 512"><path d="M0 256C0 167.6 71.6 96 160 96h72c13.3 0 24 10.7 24 24s-10.7 24-24 24H160C98.1 144 48 194.1 48 256s50.1 112 112 112h72c13.3 0 24 10.7 24 24s-10.7 24-24 24H160C71.6 416 0 344.4 0 256zm576 0c0 88.4-71.6 160-160 160H344c-13.3 0-24-10.7-24-24s10.7-24 24-24h72c61.9 0 112-50.1 112-112s-50.1-112-112-112H344c-13.3 0-24-10.7-24-24s10.7-24 24-24h72c88.4 0 160 71.6 160 160zM184 232H392c13.3 0 24 10.7 24 24s-10.7 24-24 24H184c-13.3 0-24-10.7-24-24s10.7-24 24-24z"></path></svg></div></a></div><span class="cursor-pointer">Python</span></h3> <p>In Python files, functions can be registered as functions that can be executed on Morph by adding the annotation <code>@morph.func</code> to the function. This mechanism allows Python files to contain and execute multiple functions in a single file.</p> <p>As with SQL, Python files can describe the name and description of a function by setting name and description to the arguments of this <code>@morph.func</code> annotation.</p> <p>In addition, <code>@morph.load_data</code> can be used to load the results of other SQL/Python executions directly into variables. The loaded variables can be referenced from within the <code>context</code> argument. In the following example, the result of an SQL execution called example_sql_cell is read in by a Python function called example_python_cell, which returns the accessed result as is.</p> <p>The <code>context</code> variable contains data in a dictionary type with the same name as the name of the read target.</p> <div class="mt-5 mb-8 not-prose rounded-2xl relative text-gray-50 bg-[#0F1117] dark:bg-codeblock border border-transparent dark:border-gray-800/50 codeblock-dark"><div class="min-w-full relative text-sm leading-6 children:!my-0 children:!shadow-none children:!bg-transparent transition-[height] duration-300 ease-in-out" style="font-variant-ligatures:none;height:auto"><div class="overflow-x-auto h-full p-5 overflow-y-hidden scrollbar-thin scrollbar-thumb-rounded scrollbar-thumb-white/20 dark:scrollbar-thumb-white/20 hover:scrollbar-thumb-white/25 dark:hover:scrollbar-thumb-white/25 active:scrollbar-thumb-white/25 dark:active:scrollbar-thumb-white/25"><pre class="language-python"><code class="language-python"><span class=""><span class="token keyword">import</span> pandas <span class="token keyword">as</span> pd</span>  <span class=""><span class="token keyword">import</span> morph</span> <span class=""><span class="token keyword">from</span> morph <span class="token keyword">import</span> MorphGlobalContext</span>  <span class=""><span class="token decorator annotation punctuation">@morph<span class="token punctuation">.</span>func</span><span class="token punctuation">(</span></span> <span class=""> name<span class="token operator">=</span><span class="token string">"example_python_cell"</span><span class="token punctuation">,</span></span> <span class=""> description<span class="token operator">=</span><span class="token string">"Example Python cell"</span><span class="token punctuation">,</span></span> <span class=""><span class="token punctuation">)</span></span> <span class=""><span class="token decorator annotation punctuation">@morph<span class="token punctuation">.</span>load_data</span><span class="token punctuation">(</span><span class="token string">"example_sql_cell"</span><span class="token punctuation">)</span></span> <span class=""><span class="token keyword">def</span> <span class="token function">main</span><span class="token punctuation">(</span>context<span class="token punctuation">:</span> MorphGlobalContext<span class="token punctuation">)</span> <span class="token operator">-</span><span class="token operator">></span> pd<span class="token punctuation">.</span>DataFrame<span class="token punctuation">:</span></span> <span class=""> sql_result_df <span class="token operator">=</span> context<span class="token punctuation">.</span>data<span class="token punctuation">[</span><span class="token string">"example_sql_cell"</span><span class="token punctuation">]</span></span> <span class=""> <span class="token keyword">return</span> sql_result_df</span>  </code></pre></div></div></div> <div class="my-4 px-5 py-4 overflow-hidden rounded-2xl flex gap-3 border border-sky-500/20 bg-sky-50/50 dark:border-sky-500/30 dark:bg-sky-500/10"><div class="mt-0.5 w-4"><svg width="14" height="14" viewBox="0 0 14 14" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="w-4 h-4 text-sky-500" aria-label="Note"><path fill-rule="evenodd" clip-rule="evenodd" d="M7 1.3C10.14 1.3 12.7 3.86 12.7 7C12.7 10.14 10.14 12.7 7 12.7C5.48908 12.6974 4.0408 12.096 2.97241 11.0276C1.90403 9.9592 1.30264 8.51092 1.3 7C1.3 3.86 3.86 1.3 7 1.3ZM7 0C3.14 0 0 3.14 0 7C0 10.86 3.14 14 7 14C10.86 14 14 10.86 14 7C14 3.14 10.86 0 7 0ZM8 3H6V8H8V3ZM8 9H6V11H8V9Z"></path></svg></div><div class="text-sm prose min-w-0 text-sky-900 dark:text-sky-200"><p>Python functions must always be given <code>@morph.func</code>, but arguments such as name are not required. If not specified, the function name is used as-is as the name.</p></div></div> <p>For more information on convenience functions, including detailed settings for <code>@morph.func</code> / <code>@morph.load_data</code> and other annotations, see the details page below:</p> <div class="not-prose grid gap-x-4 sm:grid-cols-1"><a class="card block not-prose font-normal group relative my-2 ring-2 ring-transparent rounded-2xl bg-white dark:bg-background-dark border border-gray-950/10 dark:border-white/10 overflow-hidden w-full cursor-pointer hover:!border-primary dark:hover:!border-primary-light" href="/sql-python/en/python/quickstart-python"><div class="px-6 py-5"><div><h2 class="font-semibold text-base text-gray-800 dark:text-white">Quick start: Python</h2><div class="mt-1 font-normal text-sm leading-6 text-gray-600 dark:text-gray-400"><p>This section explains how to run Python on Morph.</p></div></div></div></a></div></div><div class="leading-6 mt-14"><footer id="footer" class="flex gap-12 justify-between pt-10 border-t border-gray-100 sm:flex dark:border-gray-800/50 pb-28"><div class="flex gap-6 flex-wrap"><a href="https://x.com/morphdbHQ" target="_blank"><span class="sr-only">x</span><svg class="w-5 h-5 bg-gray-400 dark:bg-gray-500 hover:bg-gray-500 dark:hover:bg-gray-400" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/brands/x-twitter.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/brands/x-twitter.svg);mask-repeat:no-repeat;mask-position:center"></svg></a><a href="https://github.com/useMorph" target="_blank"><span class="sr-only">github</span><svg class="w-5 h-5 bg-gray-400 dark:bg-gray-500 hover:bg-gray-500 dark:hover:bg-gray-400" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/brands/github.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/brands/github.svg);mask-repeat:no-repeat;mask-position:center"></svg></a><a href="https://www.linkedin.com/company/morphdbhq" target="_blank"><span class="sr-only">linkedin</span><svg class="w-5 h-5 bg-gray-400 dark:bg-gray-500 hover:bg-gray-500 dark:hover:bg-gray-400" style="-webkit-mask-image:url(https://mintlify.b-cdn.net/v6.6.0/brands/linkedin.svg);-webkit-mask-repeat:no-repeat;-webkit-mask-position:center;mask-image:url(https://mintlify.b-cdn.net/v6.6.0/brands/linkedin.svg);mask-repeat:no-repeat;mask-position:center"></svg></a></div><div class="flex items-center justify-between"><div class="sm:flex"><a href="https://mintlify.com/preview-request?utm_campaign=poweredBy&utm_medium=docs&utm_source=docs.morph-data.io" target="_blank" rel="noreferrer" class="text-sm text-gray-500 dark:text-gray-400 hover:text-gray-700 dark:hover:text-gray-300 text-nowrap">Powered by Mintlify</a></div></div></footer></div></div><div class="hidden xl:flex self-start sticky h-[calc(100vh-8rem-1.5rem-1.5rem)] top-[calc(8rem+1.5rem)]" id="content-side-layout"><div class="z-10 hidden xl:flex pl-10 box-border w-[19rem]" id="table-of-contents"><div id="table-of-contents-content" class="text-gray-600 text-sm leading-6 w-[16.5rem] overflow-y-auto space-y-2"><div class="text-gray-700 dark:text-gray-300 font-medium flex items-center space-x-2"><svg width="16" height="16" viewBox="0 0 16 16" fill="none" stroke="currentColor" stroke-width="2" xmlns="http://www.w3.org/2000/svg" class="h-3 w-3"><path d="M2.44434 12.6665H13.5554" stroke-linecap="round" stroke-linejoin="round"></path><path d="M2.44434 3.3335H13.5554" stroke-linecap="round" stroke-linejoin="round"></path><path d="M2.44434 8H7.33323" stroke-linecap="round" stroke-linejoin="round"></path></svg><span>On this page</span></div><ul><li><a href="#execution-of-source-code" class="py-1 block font-medium hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300">Execution of source code</a></li><li><a href="#implementing-source-code" class="py-1 block font-medium hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300">Implementing source code</a></li><li class=""><a style="margin-left:1rem" href="#sql" class="group flex items-start py-1 whitespace-pre-wrap text-gray-500 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300">SQL</a></li><li class=""><a style="margin-left:1rem" href="#python" class="group flex items-start py-1 whitespace-pre-wrap text-gray-500 hover:text-gray-900 dark:text-gray-400 dark:hover:text-gray-300">Python</a></li></ul></div></div></div></div></div></div></div></main></div><script id="__NEXT_DATA__" type="application/json">{"props":{"pageProps":{"mdxSource":{"compiledSource":"\"use strict\";\nconst {Fragment: _Fragment, jsx: _jsx, jsxs: _jsxs} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n code: \"code\",\n p: \"p\",\n pre: \"pre\",\n span: \"span\",\n ..._provideComponents(),\n ...props.components\n }, {Card, CardGroup, CodeBlock, Heading, Note, Tip, Warning, ZoomImage} = _components;\n if (!Card) _missingMdxReference(\"Card\", true);\n if (!CardGroup) _missingMdxReference(\"CardGroup\", true);\n if (!CodeBlock) _missingMdxReference(\"CodeBlock\", true);\n if (!Heading) _missingMdxReference(\"Heading\", true);\n if (!Note) _missingMdxReference(\"Note\", true);\n if (!Tip) _missingMdxReference(\"Tip\", true);\n if (!Warning) _missingMdxReference(\"Warning\", true);\n if (!ZoomImage) _missingMdxReference(\"ZoomImage\", true);\n return _jsxs(_Fragment, {\n children: [_jsx(_components.p, {\n children: \"The workspace allows data analysis using SQL and Python.\"\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"When you open the workspace, a \", _jsx(_components.code, {\n children: \"src\"\n }), \" directory exists in the project root. Place and run SQL and Python files in this \", _jsx(_components.code, {\n children: \"src\"\n }), \" directory.\"]\n }), \"\\n\", _jsxs(Tip, {\n children: [\"The \", _jsx(_components.code, {\n children: \"morph_project.yml\"\n }), \" file is set to \", _jsx(_components.code, {\n children: \"source_paths: src\"\n }), \". It is possible to change the directory where the source code is placed by changing this value.\"]\n }), \"\\n\", _jsx(ZoomImage, {\n children: _jsx(\"img\", {\n src: \"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/docs/workspace-editor-sql.png\",\n alt: \"Workspace Editor SQL\"\n })\n }), \"\\n\", _jsx(Heading, {\n level: \"3\",\n id: \"execution-of-source-code\",\n children: \"Execution of source code\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"The SQL or Python you have written can be executed using the ‘RUN’ button located in the top right-hand corner of the editor, as shown in the image below.\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"When executed, the corresponding Morph CLI log is output in the terminal and the data from the execution is displayed in the ‘Result’ tab in the right sidebar.\"\n }), \"\\n\", _jsx(ZoomImage, {\n children: _jsx(\"img\", {\n src: \"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/docs/workspace-editor-sql-run.png\",\n alt: \"Workspace Editor SQL Run\"\n })\n }), \"\\n\", _jsx(Heading, {\n level: \"2\",\n id: \"implementing-source-code\",\n children: \"Implementing source code\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"SQL and Python on Morph is run by the Morph CLI installed on a VM on the workspace. It builds on the DB and standard Python scripts used, and provides extensions to allow more powerful data analysis by the user.\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"In addition, in Morph, files for analysis are named at runtime. Naming makes it easier to access the results of that file from other files.\\nThis mechanism is a very important part of the Morph framework.\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"Note that duplicate names of this name at runtime will result in a compile error.\"\n }), \"\\n\", _jsx(Heading, {\n level: \"3\",\n id: \"sql\",\n children: \"SQL\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"You can use jinja2 to write SQL, and within jinja you can use Morph’s own config, a function for writing metadata.\\nIn config, you can describe the processing of the function. This allows you to leave the processing details for team members and for the Morph AI to interpret the developer’s intentions in detail.\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"In the SQL below, the config function is used to name and describe the process in detail. Using jinja in this way allows metadata to be written directly in the SQL.\"\n }), \"\\n\", _jsx(CodeBlock, {\n filename: \"\",\n expandable: \"false\",\n children: _jsx(_components.pre, {\n className: \"language-sql\",\n children: _jsxs(_components.code, {\n className: \"language-sql\",\n children: [_jsx(_components.span, {\n className: \"\",\n children: \"{{\"\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\"\\tconfig\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"(\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\"\\t\\tname\", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"example_sql_cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \",\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\"\\t\\tdescription\", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"Example SQL cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \",\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\"\\t\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \")\"\n })]\n }), \"\\n\", _jsx(_components.span, {\n className: \"\",\n children: \"}}\"\n }), \"\\n\", \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"select\"\n }), \" \", _jsx(_components.span, {\n className: \"token operator\",\n children: \"*\"\n }), \" \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"from\"\n }), \" customers \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"limit\"\n }), \" \", _jsx(_components.span, {\n className: \"token number\",\n children: \"10\"\n })]\n }), \"\\n\"]\n })\n })\n }), \"\\n\", _jsx(Note, {\n children: _jsx(_components.p, {\n children: \"If the config function is undefined or not named by name, the sql file name is used as the name.\\nExample: example_sql_cell.sql, in which case example_sql_cell is used as the name.\"\n })\n }), \"\\n\", _jsx(Warning, {\n children: _jsx(_components.p, {\n children: \"In Morph, it is forbidden to write a semicolon at the end of SQL to prevent multiple SQLs in one SQL file. If you have written one, an error message will be displayed, so delete the semi-colon and run the program again.\"\n })\n }), \"\\n\", _jsx(_components.p, {\n children: \"For detailed config settings and other grammar rules, see the following detailed pages:\"\n }), \"\\n\", _jsx(CardGroup, {\n cols: 1,\n children: _jsx(Card, {\n title: \"Quick start: SQL\",\n href: \"/sql-python/en/sql/quickstart-sql\",\n children: _jsx(_components.p, {\n children: \"Describes how to run SQL on Morph.\"\n })\n })\n }), \"\\n\", _jsx(Heading, {\n level: \"3\",\n id: \"python\",\n children: \"Python\"\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"In Python files, functions can be registered as functions that can be executed on Morph by adding the annotation \", _jsx(_components.code, {\n children: \"@morph.func\"\n }), \" to the function. This mechanism allows Python files to contain and execute multiple functions in a single file.\"]\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"As with SQL, Python files can describe the name and description of a function by setting name and description to the arguments of this \", _jsx(_components.code, {\n children: \"@morph.func\"\n }), \" annotation.\"]\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"In addition, \", _jsx(_components.code, {\n children: \"@morph.load_data\"\n }), \" can be used to load the results of other SQL/Python executions directly into variables. The loaded variables can be referenced from within the \", _jsx(_components.code, {\n children: \"context\"\n }), \" argument.\\nIn the following example, the result of an SQL execution called example_sql_cell is read in by a Python function called example_python_cell, which returns the accessed result as is.\"]\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"The \", _jsx(_components.code, {\n children: \"context\"\n }), \" variable contains data in a dictionary type with the same name as the name of the read target.\"]\n }), \"\\n\", _jsx(CodeBlock, {\n filename: \"\",\n expandable: \"false\",\n children: _jsx(_components.pre, {\n className: \"language-python\",\n children: _jsxs(_components.code, {\n className: \"language-python\",\n children: [_jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"import\"\n }), \" pandas \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"as\"\n }), \" pd\"]\n }), \"\\n\", \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"import\"\n }), \" morph\"]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"from\"\n }), \" morph \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"import\"\n }), \" MorphGlobalContext\"]\n }), \"\\n\", \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsxs(_components.span, {\n className: \"token decorator annotation punctuation\",\n children: [\"@morph\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \".\"\n }), \"func\"]\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"(\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\" name\", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"example_python_cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \",\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\" description\", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"Example Python cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \",\"\n })]\n }), \"\\n\", _jsx(_components.span, {\n className: \"\",\n children: _jsx(_components.span, {\n className: \"token punctuation\",\n children: \")\"\n })\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsxs(_components.span, {\n className: \"token decorator annotation punctuation\",\n children: [\"@morph\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \".\"\n }), \"load_data\"]\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"(\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"example_sql_cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \")\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"def\"\n }), \" \", _jsx(_components.span, {\n className: \"token function\",\n children: \"main\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"(\"\n }), \"context\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \":\"\n }), \" MorphGlobalContext\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \")\"\n }), \" \", _jsx(_components.span, {\n className: \"token operator\",\n children: \"-\"\n }), _jsx(_components.span, {\n className: \"token operator\",\n children: \"\u003e\"\n }), \" pd\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \".\"\n }), \"DataFrame\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \":\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\" sql_result_df \", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), \" context\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \".\"\n }), \"data\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"[\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"example_sql_cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"]\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\" \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"return\"\n }), \" sql_result_df\"]\n }), \"\\n\", \"\\n\"]\n })\n })\n }), \"\\n\", _jsx(Note, {\n children: _jsxs(_components.p, {\n children: [\"Python functions must always be given \", _jsx(_components.code, {\n children: \"@morph.func\"\n }), \", but arguments such as name are not required. If not specified, the function name is used as-is as the name.\"]\n })\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"For more information on convenience functions, including detailed settings for \", _jsx(_components.code, {\n children: \"@morph.func\"\n }), \" / \", _jsx(_components.code, {\n children: \"@morph.load_data\"\n }), \" and other annotations, see the details page below:\"]\n }), \"\\n\", _jsx(CardGroup, {\n cols: 1,\n children: _jsx(Card, {\n title: \"Quick start: Python\",\n href: \"/sql-python/en/python/quickstart-python\",\n children: _jsx(_components.p, {\n children: \"This section explains how to run Python on Morph.\"\n })\n })\n })]\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\nfunction _missingMdxReference(id, component) {\n throw new Error(\"Expected \" + (component ? \"component\" : \"object\") + \" `\" + id + \"` to be defined: you likely forgot to import, pass, or provide it.\");\n}\n","frontmatter":{},"scope":{"config":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"Docs","colors":{"primary":"#111827","light":"#d1d5db","dark":"#111827"},"favicon":"/favicon.svg","navigation":{"versions":[{"version":"English","tabs":[{"tab":"Guides","groups":[{"group":"Getting Started","pages":["docs/en/getting-started/why-morph","docs/en/getting-started/installation"]},{"group":"Quick Start","pages":["docs/en/quickstart/building-app",{"group":"How to Deploy","icon":"link","pages":["docs/en/quickstart/dashboard-setup","docs/en/quickstart/deploy"]}]},{"group":"Framework","pages":["docs/en/develop/guides/framework","docs/en/develop/guides/alias","docs/en/develop/guides/building-backend","docs/en/develop/guides/building-frontend","docs/en/develop/guides/environment-variables","docs/en/develop/guides/integration","docs/en/develop/guides/variables","docs/en/develop/guides/user-role","docs/en/develop/guides/updating-project"]},{"group":"Deployment","pages":["docs/en/deploy/customize-dockerfile","docs/en/deploy/environment-variables","docs/en/deploy/public"]},{"group":"Tutorials: Data Analysis","pages":["docs/en/develop/tutorials/pygwalker","docs/en/develop/tutorials/plotly"]},{"group":"Tutorials: LLM Apps","pages":["docs/en/develop/tutorials/chatbot","docs/en/develop/tutorials/chat_sidebyside"]},{"group":"Advanced","pages":["docs/en/advanced/api_key","docs/en/advanced/builtin-postgres","docs/en/advanced/migration-guide",{"group":"Connectors","icon":"plug","pages":["docs/en/advanced/connectors/mysql","docs/en/advanced/connectors/postgresql","docs/en/advanced/connectors/bigquery","docs/en/advanced/connectors/snowflake","docs/en/advanced/connectors/redshift","docs/en/advanced/connectors/mssql","docs/en/advanced/connectors/athena","docs/en/advanced/connectors/salesforce","docs/en/advanced/connectors/hubspot","docs/en/advanced/connectors/stripe","docs/en/advanced/connectors/linear","docs/en/advanced/connectors/airtable","docs/en/advanced/connectors/attio","docs/en/advanced/connectors/intercom","docs/en/advanced/connectors/notion","docs/en/advanced/connectors/mailchimp","docs/en/advanced/connectors/freee"]}]}]},{"tab":"Reference","groups":[{"group":"Framework","pages":["reference/en/framework/morph-project"]},{"group":"SQL","pages":["reference/en/sql/config","reference/en/sql/load_data"]},{"group":"Python","pages":["reference/en/python/morph-global-context","reference/en/python/morph-func","reference/en/python/morph-load_data","reference/en/python/morph-variables"]},{"group":"morph_lib","pages":[{"group":"AI","pages":["reference/en/morph_lib/ai/text_to_sql","reference/en/morph_lib/ai/text_to_plotly","reference/en/morph_lib/ai/text_to_matplotlib","reference/en/morph_lib/ai/text_to_markdown","reference/en/morph_lib/ai/text_to_html"]},{"group":"Database","pages":["reference/en/morph_lib/database/execute_sql","reference/en/morph_lib/database/insert_records","reference/en/morph_lib/database/update_records","reference/en/morph_lib/database/insert_or_update_records","reference/en/morph_lib/database/delete_records"]},{"group":"API","pages":["reference/en/morph_lib/api/get_auth_token"]},{"group":"Stream","pages":["reference/en/morph_lib/stream/create_chunk"]}]},{"group":"CLI","pages":["reference/en/cli-commands/version","reference/en/cli-commands/run","reference/en/cli-commands/compile","reference/en/cli-commands/clean","reference/en/cli-commands/init","reference/en/cli-commands/new","reference/en/cli-commands/config","reference/en/cli-commands/deploy","reference/en/cli-commands/serve","reference/en/cli-commands/context"]}]},{"tab":"Components","groups":[{"group":"AI Components","pages":["data-application/en/ai-component-chat","data-application/en/ai-component-llm"]},{"group":"Data Components","pages":["data-application/en/data-component-table","data-application/en/data-component-embed","data-application/en/data-component-metrics"]},{"group":"Input Components","pages":["data-application/en/input-component-input","data-application/en/input-component-date-picker","data-application/en/input-component-date-range-picker","data-application/en/input-component-select"]},{"group":"Layout Components","pages":["data-application/en/layout-component-accordion","data-application/en/layout-component-callout","data-application/en/layout-component-card","data-application/en/layout-component-grid","data-application/en/layout-component-panel"]},{"group":"State \u0026 Data","pages":["data-application/en/morph-data-state","data-application/en/advanced-morph-data-basic"]},{"group":"MDX Deep Dive","pages":["data-application/en/mdx/mdx-1-basic","data-application/en/mdx/mdx-2-styling","data-application/en/mdx/mdx-3-js"]},{"group":"Deprecated","pages":["data-application/en/morph-data-getjson","data-application/en/morph-data-variables"]}]},{"tab":"Troubleshooting","groups":[{"group":"Morph CLI","pages":["troubleshooting/en/cli/deployment-issues"]},{"group":"Support","pages":["troubleshooting/en/support/contact-support"]}]}]},{"version":"日本語","tabs":[{"tab":"Guides","groups":[{"group":"Getting Started","pages":["docs/ja/getting-started/why-morph","docs/ja/getting-started/installation"]},{"group":"クイックスタート","pages":["docs/ja/quickstart/building-app",{"group":"デプロイ手順","icon":"link","pages":["docs/ja/quickstart/dashboard-setup","docs/ja/quickstart/deploy"]}]},{"group":"フレームワーク","pages":["docs/ja/develop/guides/framework","docs/ja/develop/guides/alias","docs/ja/develop/guides/building-backend","docs/ja/develop/guides/building-frontend","docs/ja/develop/guides/environment-variables","docs/ja/develop/guides/integration","docs/ja/develop/guides/variables","docs/ja/develop/guides/user-role","docs/ja/develop/guides/updating-project"]},{"group":"デプロイ","pages":["docs/ja/deploy/customize-dockerfile","docs/ja/deploy/environment-variables","docs/ja/deploy/public"]},{"group":"チュートリアル: データ分析","pages":["docs/ja/develop/tutorials/pygwalker","docs/ja/develop/tutorials/plotly"]},{"group":"チュートリアル: AIアプリ","pages":["docs/ja/develop/tutorials/chatbot","docs/ja/develop/tutorials/chat_sidebyside"]},{"group":"Advanced","pages":["docs/ja/advanced/api_key","docs/ja/advanced/builtin-postgres","docs/ja/advanced/migration-guide",{"group":"Connectors","icon":"plug","pages":["docs/ja/advanced/connectors/mysql","docs/ja/advanced/connectors/postgresql","docs/ja/advanced/connectors/bigquery","docs/ja/advanced/connectors/snowflake","docs/ja/advanced/connectors/redshift","docs/ja/advanced/connectors/mssql","docs/ja/advanced/connectors/athena","docs/ja/advanced/connectors/salesforce","docs/ja/advanced/connectors/hubspot","docs/ja/advanced/connectors/stripe","docs/ja/advanced/connectors/linear","docs/ja/advanced/connectors/airtable","docs/ja/advanced/connectors/attio","docs/ja/advanced/connectors/intercom","docs/ja/advanced/connectors/notion","docs/ja/advanced/connectors/mailchimp","docs/ja/advanced/connectors/freee"]}]}]},{"tab":"Reference","groups":[{"group":"フレームワーク","pages":["reference/ja/framework/morph-project"]},{"group":"SQL","pages":["reference/ja/sql/config","reference/ja/sql/load_data"]},{"group":"Python","pages":["reference/ja/python/morph-global-context","reference/ja/python/morph-func","reference/ja/python/morph-load_data","reference/ja/python/morph-variables"]},{"group":"morph_lib","pages":[{"group":"AI","pages":["reference/ja/morph_lib/ai/text_to_sql","reference/ja/morph_lib/ai/text_to_plotly","reference/ja/morph_lib/ai/text_to_matplotlib","reference/ja/morph_lib/ai/text_to_markdown","reference/ja/morph_lib/ai/text_to_html"]},{"group":"Database","pages":["reference/ja/morph_lib/database/execute_sql","reference/ja/morph_lib/database/insert_records","reference/ja/morph_lib/database/update_records","reference/ja/morph_lib/database/insert_or_update_records","reference/ja/morph_lib/database/delete_records"]},{"group":"API","pages":["reference/ja/morph_lib/api/get_auth_token"]},{"group":"Stream","pages":["reference/ja/morph_lib/stream/create_chunk"]}]},{"group":"CLI","pages":["reference/ja/cli-commands/version","reference/ja/cli-commands/run","reference/ja/cli-commands/compile","reference/ja/cli-commands/clean","reference/ja/cli-commands/init","reference/ja/cli-commands/new","reference/ja/cli-commands/config","reference/ja/cli-commands/deploy","reference/ja/cli-commands/serve","reference/ja/cli-commands/context"]}]},{"tab":"Components","groups":[{"group":"AIコンポーネント","pages":["data-application/ja/ai-component-chat","data-application/ja/ai-component-llm"]},{"group":"データコンポーネント","pages":["data-application/ja/data-component-table","data-application/ja/data-component-embed","data-application/ja/data-component-metrics"]},{"group":"入力コンポーネント","pages":["data-application/ja/input-component-input","data-application/ja/input-component-date-picker","data-application/ja/input-component-date-range-picker","data-application/ja/input-component-select"]},{"group":"レイアウトコンポーネント","pages":["data-application/ja/layout-component-accordion","data-application/ja/layout-component-callout","data-application/ja/layout-component-card","data-application/ja/layout-component-grid","data-application/ja/layout-component-panel"]},{"group":"状態管理とデータ","pages":["data-application/ja/morph-data-state","data-application/ja/advanced-morph-data-basic"]},{"group":"MDX 詳解","pages":["data-application/ja/mdx/mdx-1-basic","data-application/ja/mdx/mdx-2-styling","data-application/ja/mdx/mdx-3-js"]},{"group":"廃止された仕様","pages":["data-application/ja/morph-data-getjson","data-application/ja/morph-data-variables"]}]},{"tab":"Troubleshooting","groups":[{"group":"Morph CLI","pages":["troubleshooting/ja/cli/deployment-issues"]},{"group":"サポート","pages":["troubleshooting/ja/support/contact-support"]}]}]}],"global":{"anchors":[{"anchor":"Changelog","href":"https://www.morph-data.io/changelog","icon":"rss"},{"anchor":"Connectors","href":"https://www.morph-data.io/tools/connectors/database","icon":"plug"},{"anchor":"Code Snippets","href":"https://www.morph-data.io/tools/snippets/undefined","icon":"brackets-curly"}]}},"styling":{"codeblocks":"dark"},"logo":{"light":"https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg.svg","dark":"https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg_w.svg"},"navbar":{"links":[{"label":"Blog","href":"https://www.morphdb.io/blogs"}],"primary":{"type":"button","label":"Website","href":"https://www.morphdb.io"}},"footer":{"socials":{"x":"https://x.com/morphdbHQ","github":"https://github.com/useMorph","linkedin":"https://www.linkedin.com/company/morphdbhq"}}},"pageMetadata":{"title":"Build with SQL \u0026 Python","description":null,"href":"/docs/en/workspace/sql-python"}}},"mdxExtracts":{"tableOfContents":[{"title":"Execution of source code","slug":"execution-of-source-code","depth":3,"children":[]},{"title":"Implementing source code","slug":"implementing-source-code","depth":2,"children":[{"title":"SQL","slug":"sql","depth":3,"children":[]},{"title":"Python","slug":"python","depth":3,"children":[]}]}],"codeExamples":{}},"description":null,"pageData":{"navWithMetadata":[{"group":"Getting Started","version":"English","pages":[{"title":"Introduction","description":"Convert AI workflows and agents developed in Python into web applications","icon":"lightbulb","href":"/docs/en/getting-started/why-morph"},{"title":"Installation","description":"Python 3.9 or higher and Node.js 18 or higher are required to use Morph.","icon":"wrench","href":"/docs/en/getting-started/installation"}]},{"group":"Quick Start","version":"English","pages":[{"title":"Building AI App","description":"Complete your first AI app in 3 minutes.","icon":"rocket","href":"/docs/en/quickstart/building-app"},{"group":"How to Deploy","icon":"link","pages":[{"title":"Dashboard Setup","description":null,"icon":"","href":"/docs/en/quickstart/dashboard-setup"},{"title":"Deploy to the Cloud","description":null,"icon":"","href":"/docs/en/quickstart/deploy"}]}]},{"group":"Framework","version":"English","pages":[{"title":"Framework Overview","description":null,"icon":"eye","href":"/docs/en/develop/guides/framework"},{"title":"Alias","description":null,"icon":"shuffle","href":"/docs/en/develop/guides/alias"},{"title":"Building the Backend","description":null,"icon":"brackets-curly","href":"/docs/en/develop/guides/building-backend"},{"title":"Building the Frontend","description":null,"icon":"markdown","href":"/docs/en/develop/guides/building-frontend"},{"title":"Environment Variables","description":null,"icon":"square-terminal","href":"/docs/en/develop/guides/environment-variables"},{"title":"Data Connector","description":null,"icon":"database","href":"/docs/en/develop/guides/integration"},{"title":"Variables","description":null,"icon":"code","href":"/docs/en/develop/guides/variables"},{"title":"Role-based Access Control","description":null,"icon":"user","href":"/docs/en/develop/guides/user-role"},{"title":"Updating the Project","description":null,"icon":"rotate","href":"/docs/en/develop/guides/updating-project"}]},{"group":"Deployment","version":"English","pages":[{"title":"Customizing the Runtime Environment","description":null,"icon":"server","href":"/docs/en/deploy/customize-dockerfile"},{"title":"Environment Variables","description":null,"icon":"square-terminal","href":"/docs/en/deploy/environment-variables"},{"title":"Enable Public Access","description":null,"icon":"link","href":"/docs/en/deploy/public"}]},{"group":"Tutorials: Data Analysis","version":"English","pages":[{"title":"Build a BI app using Pygwalker","description":null,"icon":"chart-user","href":"/docs/en/develop/tutorials/pygwalker"},{"title":"Build a sophisticated dashboard using Plotly","description":null,"icon":"chart-bar","href":"/docs/en/develop/tutorials/plotly"}]},{"group":"Tutorials: LLM Apps","version":"English","pages":[{"title":"Create a chat app","description":null,"icon":"message-dots","href":"/docs/en/develop/tutorials/chatbot"},{"title":"AI Chat generates and executes code","description":null,"icon":"code","href":"/docs/en/develop/tutorials/chat_sidebyside"}]},{"group":"Advanced","version":"English","pages":[{"title":"API Key","description":null,"icon":"key","href":"/docs/en/advanced/api_key"},{"title":"Built-in PostgreSQL","description":null,"icon":"database","href":"/docs/en/advanced/builtin-postgres"},{"title":"Version Migration Guide","description":null,"icon":"arrows-turn-to-dots","href":"/docs/en/advanced/migration-guide"},{"group":"Connectors","icon":"plug","pages":[{"title":"MySQL","description":null,"href":"/docs/en/advanced/connectors/mysql"},{"title":"PostgreSQL","description":null,"href":"/docs/en/advanced/connectors/postgresql"},{"title":"BigQuery","description":null,"href":"/docs/en/advanced/connectors/bigquery"},{"title":"Snowflake","description":null,"href":"/docs/en/advanced/connectors/snowflake"},{"title":"Redshift","description":null,"href":"/docs/en/advanced/connectors/redshift"},{"title":"SQLServer","description":null,"href":"/docs/en/advanced/connectors/mssql"},{"title":"Athena","description":null,"href":"/docs/en/advanced/connectors/athena"},{"title":"Salesforce","description":null,"href":"/docs/en/advanced/connectors/salesforce"},{"title":"HubSpot","description":null,"href":"/docs/en/advanced/connectors/hubspot"},{"title":"Stripe","description":null,"href":"/docs/en/advanced/connectors/stripe"},{"title":"Linear","description":null,"href":"/docs/en/advanced/connectors/linear"},{"title":"Airtable","description":null,"href":"/docs/en/advanced/connectors/airtable"},{"title":"Attio","description":null,"href":"/docs/en/advanced/connectors/attio"},{"title":"Intercom","description":null,"href":"/docs/en/advanced/connectors/intercom"},{"title":"Notion","description":null,"href":"/docs/en/advanced/connectors/notion"},{"title":"Mailchimp","description":null,"href":"/docs/en/advanced/connectors/mailchimp"},{"title":"Freee","description":null,"href":"/docs/en/advanced/connectors/freee"}]}]},{"group":"Framework","version":"English","pages":[{"title":"morph_project.yml","description":null,"href":"/reference/en/framework/morph-project"}]},{"group":"SQL","version":"English","pages":[{"title":"config","description":null,"href":"/reference/en/sql/config"},{"title":"load_data","description":null,"href":"/reference/en/sql/load_data"}]},{"group":"Python","version":"English","pages":[{"title":"MorphGlobalContext","description":null,"href":"/reference/en/python/morph-global-context"},{"title":"@morph.func","description":null,"href":"/reference/en/python/morph-func"},{"title":"@morph.load_data","description":null,"href":"/reference/en/python/morph-load_data"},{"title":"@morph.variables","description":null,"href":"/reference/en/python/morph-variables"}]},{"group":"morph_lib","version":"English","pages":[{"group":"AI","pages":[{"title":"text_to_sql","description":null,"href":"/reference/en/morph_lib/ai/text_to_sql"},{"title":"text_to_plotly","description":null,"href":"/reference/en/morph_lib/ai/text_to_plotly"},{"title":"text_to_matplotlib","description":null,"href":"/reference/en/morph_lib/ai/text_to_matplotlib"},{"title":"text_to_markdown","description":null,"href":"/reference/en/morph_lib/ai/text_to_markdown"},{"title":"text_to_html","description":null,"href":"/reference/en/morph_lib/ai/text_to_html"}]},{"group":"Database","pages":[{"title":"execute_sql","description":null,"href":"/reference/en/morph_lib/database/execute_sql"},{"title":"insert_records","description":null,"href":"/reference/en/morph_lib/database/insert_records"},{"title":"update_records","description":null,"href":"/reference/en/morph_lib/database/update_records"},{"title":"insert_or_update_records","description":null,"href":"/reference/en/morph_lib/database/insert_or_update_records"},{"title":"delete_records","description":null,"href":"/reference/en/morph_lib/database/delete_records"}]},{"group":"API","pages":[{"title":"get_auth_token","description":null,"href":"/reference/en/morph_lib/api/get_auth_token"}]},{"group":"Stream","pages":[{"title":"create_chunk","description":null,"href":"/reference/en/morph_lib/stream/create_chunk"}]}]},{"group":"CLI","version":"English","pages":[{"title":"--version","description":null,"href":"/reference/en/cli-commands/version"},{"title":"run","description":null,"href":"/reference/en/cli-commands/run"},{"title":"compile","description":null,"href":"/reference/en/cli-commands/compile"},{"title":"clean","description":null,"href":"/reference/en/cli-commands/clean"},{"title":"init","description":null,"href":"/reference/en/cli-commands/init"},{"title":"new","description":null,"href":"/reference/en/cli-commands/new"},{"title":"config","description":null,"href":"/reference/en/cli-commands/config"},{"title":"deploy","description":null,"href":"/reference/en/cli-commands/deploy"},{"title":"serve","description":null,"href":"/reference/en/cli-commands/serve"},{"title":"context","description":null,"href":"/reference/en/cli-commands/context"}]},{"group":"AI Components","version":"English","pages":[{"title":"\u003cChat /\u003e","description":null,"icon":"messages","href":"/data-application/en/ai-component-chat"},{"title":"\u003cLLM /\u003e","description":null,"icon":"message-dots","href":"/data-application/en/ai-component-llm"}]},{"group":"Data Components","version":"English","pages":[{"title":"\u003cDataTable /\u003e","description":null,"icon":"table-cells","href":"/data-application/en/data-component-table"},{"title":"\u003cEmbed /\u003e","description":null,"icon":"code","href":"/data-application/en/data-component-embed"},{"title":"\u003cMetrics /\u003e","description":null,"icon":"00","href":"/data-application/en/data-component-metrics"}]},{"group":"Input Components","version":"English","pages":[{"title":"\u003cInput /\u003e","description":null,"icon":"input-pipe","href":"/data-application/en/input-component-input"},{"title":"\u003cDatePicker /\u003e","description":null,"icon":"calendar-day","href":"/data-application/en/input-component-date-picker"},{"title":"\u003cDateRangePicker /\u003e","description":null,"icon":"calendar-week","href":"/data-application/en/input-component-date-range-picker"},{"title":"\u003cSelect /\u003e","description":null,"icon":"caret-down","href":"/data-application/en/input-component-select"}]},{"group":"Layout Components","version":"English","pages":[{"title":"\u003cAccordion /\u003e","description":null,"href":"/data-application/en/layout-component-accordion"},{"title":"\u003cCallout /\u003e","description":null,"href":"/data-application/en/layout-component-callout"},{"title":"\u003cCard /\u003e","description":null,"href":"/data-application/en/layout-component-card"},{"title":"\u003cGrid /\u003e","description":null,"href":"/data-application/en/layout-component-grid"},{"title":"\u003cPanel /\u003e","description":null,"href":"/data-application/en/layout-component-panel"}]},{"group":"State \u0026 Data","version":"English","pages":[{"title":"State Management - defineState()","description":null,"href":"/data-application/en/morph-data-state"},{"title":"How data fetching works","description":null,"href":"/data-application/en/advanced-morph-data-basic"}]},{"group":"MDX Deep Dive","version":"English","pages":[{"title":"Basic Usage","description":null,"href":"/data-application/en/mdx/mdx-1-basic"},{"title":"Styling","description":null,"href":"/data-application/en/mdx/mdx-2-styling"},{"title":"Using React and JavaScript","description":null,"href":"/data-application/en/mdx/mdx-3-js"}]},{"group":"Deprecated","version":"English","pages":[{"title":"getJson()","description":null,"href":"/data-application/en/morph-data-getjson"},{"title":"Using Variables","description":null,"href":"/data-application/en/morph-data-variables"}]},{"group":"Morph CLI","version":"English","pages":[{"title":"Deploy","description":null,"href":"/troubleshooting/en/cli/deployment-issues"}]},{"group":"Support","version":"English","pages":[{"title":"Contact Support","description":null,"href":"/troubleshooting/en/support/contact-support"}]},{"group":"Getting Started","version":"日本語","pages":[{"title":"導入","description":"Pythonで開発したAIワークフローやエージェントを、Webアプリケーションに変換","icon":"lightbulb","href":"/docs/ja/getting-started/why-morph"},{"title":"インストール","description":"Morphを使用するためには、Python 3.9以上、Node.js 18以上が必要です。","icon":"wrench","href":"/docs/ja/getting-started/installation"}]},{"group":"クイックスタート","version":"日本語","pages":[{"title":"AIアプリの構築","description":"3分ではじめてのAIアプリを完成させましょう。","icon":"rocket","href":"/docs/ja/quickstart/building-app"},{"group":"デプロイ手順","icon":"link","pages":[{"title":"事前準備","description":null,"icon":"","href":"/docs/ja/quickstart/dashboard-setup"},{"title":"デプロイ","description":null,"icon":"","href":"/docs/ja/quickstart/deploy"}]}]},{"group":"フレームワーク","version":"日本語","pages":[{"title":"フレームワークの概要","description":null,"icon":"eye","href":"/docs/ja/develop/guides/framework"},{"title":"エイリアス","description":null,"icon":"shuffle","href":"/docs/ja/develop/guides/alias"},{"title":"バックエンドを構築する","description":null,"icon":"brackets-curly","href":"/docs/ja/develop/guides/building-backend"},{"title":"フロントエンドを構築する","description":null,"icon":"markdown","href":"/docs/ja/develop/guides/building-frontend"},{"title":"環境変数","description":null,"icon":"square-terminal","href":"/docs/ja/develop/guides/environment-variables"},{"title":"データコネクター","description":null,"icon":"database","href":"/docs/ja/develop/guides/integration"},{"title":"変数を使う","description":null,"icon":"code","href":"/docs/ja/develop/guides/variables"},{"title":"ロールベースのアクセス制御","description":null,"icon":"user","href":"/docs/ja/develop/guides/user-role"},{"title":"プロジェクトをアップデートする","description":null,"icon":"rotate","href":"/docs/ja/develop/guides/updating-project"}]},{"group":"デプロイ","version":"日本語","pages":[{"title":"実行環境のカスタマイズ","description":null,"icon":"server","href":"/docs/ja/deploy/customize-dockerfile"},{"title":"環境変数","description":null,"icon":"square-terminal","href":"/docs/ja/deploy/environment-variables"},{"title":"公開する","description":null,"icon":"link","href":"/docs/ja/deploy/public"}]},{"group":"チュートリアル: データ分析","version":"日本語","pages":[{"title":"PYGWALKERを埋め込んだBIアプリ構築","description":null,"icon":"chart-user","href":"/docs/ja/develop/tutorials/pygwalker"},{"title":"Plotlyを用いた高度なダッシュボードアプリ構築","description":null,"icon":"chart-bar","href":"/docs/ja/develop/tutorials/plotly"}]},{"group":"チュートリアル: AIアプリ","version":"日本語","pages":[{"title":"チャットアプリを作成する","description":null,"icon":"message-dots","href":"/docs/ja/develop/tutorials/chatbot"},{"title":"コード生成・実行を行うAIアプリを作成する","description":null,"icon":"code","href":"/docs/ja/develop/tutorials/chat_sidebyside"}]},{"group":"Advanced","version":"日本語","pages":[{"title":"API Key","description":null,"icon":"key","href":"/docs/ja/advanced/api_key"},{"title":"ビルトインPostgreSQL","description":null,"icon":"database","href":"/docs/ja/advanced/builtin-postgres"},{"title":"バージョンマイグレーションガイド","description":null,"icon":"arrows-turn-to-dots","href":"/docs/ja/advanced/migration-guide"},{"group":"Connectors","icon":"plug","pages":[{"title":"MySQL","description":null,"href":"/docs/ja/advanced/connectors/mysql"},{"title":"PostgreSQL","description":null,"href":"/docs/ja/advanced/connectors/postgresql"},{"title":"BigQuery","description":null,"href":"/docs/ja/advanced/connectors/bigquery"},{"title":"Snowflake","description":null,"href":"/docs/ja/advanced/connectors/snowflake"},{"title":"Redshift","description":null,"href":"/docs/ja/advanced/connectors/redshift"},{"title":"SQLServer","description":null,"href":"/docs/ja/advanced/connectors/mssql"},{"title":"Athena","description":null,"href":"/docs/ja/advanced/connectors/athena"},{"title":"Salesforce","description":null,"href":"/docs/ja/advanced/connectors/salesforce"},{"title":"HubSpot","description":null,"href":"/docs/ja/advanced/connectors/hubspot"},{"title":"Stripe","description":null,"href":"/docs/ja/advanced/connectors/stripe"},{"title":"Linear","description":null,"href":"/docs/ja/advanced/connectors/linear"},{"title":"Airtable","description":null,"href":"/docs/ja/advanced/connectors/airtable"},{"title":"Attio","description":null,"href":"/docs/ja/advanced/connectors/attio"},{"title":"Intercom","description":null,"href":"/docs/ja/advanced/connectors/intercom"},{"title":"Notion","description":null,"href":"/docs/ja/advanced/connectors/notion"},{"title":"Mailchimp","description":null,"href":"/docs/ja/advanced/connectors/mailchimp"},{"title":"Freee","description":null,"href":"/docs/ja/advanced/connectors/freee"}]}]},{"group":"フレームワーク","version":"日本語","pages":[{"title":"morph_project.yml","description":null,"href":"/reference/ja/framework/morph-project"}]},{"group":"SQL","version":"日本語","pages":[{"title":"config","description":null,"href":"/reference/ja/sql/config"},{"title":"load_data","description":null,"href":"/reference/ja/sql/load_data"}]},{"group":"Python","version":"日本語","pages":[{"title":"MorphGlobalContext","description":null,"href":"/reference/ja/python/morph-global-context"},{"title":"@morph.func","description":null,"href":"/reference/ja/python/morph-func"},{"title":"@morph.load_data","description":null,"href":"/reference/ja/python/morph-load_data"},{"title":"@morph.variables","description":null,"href":"/reference/ja/python/morph-variables"}]},{"group":"morph_lib","version":"日本語","pages":[{"group":"AI","pages":[{"title":"text_to_sql","description":null,"href":"/reference/ja/morph_lib/ai/text_to_sql"},{"title":"text_to_plotly","description":null,"href":"/reference/ja/morph_lib/ai/text_to_plotly"},{"title":"text_to_matplotlib","description":null,"href":"/reference/ja/morph_lib/ai/text_to_matplotlib"},{"title":"text_to_markdown","description":null,"href":"/reference/ja/morph_lib/ai/text_to_markdown"},{"title":"text_to_html","description":null,"href":"/reference/ja/morph_lib/ai/text_to_html"}]},{"group":"Database","pages":[{"title":"execute_sql","description":null,"href":"/reference/ja/morph_lib/database/execute_sql"},{"title":"insert_records","description":null,"href":"/reference/ja/morph_lib/database/insert_records"},{"title":"update_records","description":null,"href":"/reference/ja/morph_lib/database/update_records"},{"title":"insert_or_update_records","description":null,"href":"/reference/ja/morph_lib/database/insert_or_update_records"},{"title":"delete_records","description":null,"href":"/reference/ja/morph_lib/database/delete_records"}]},{"group":"API","pages":[{"title":"get_auth_token","description":null,"href":"/reference/ja/morph_lib/api/get_auth_token"}]},{"group":"Stream","pages":[{"title":"create_chunk","description":null,"href":"/reference/ja/morph_lib/stream/create_chunk"}]}]},{"group":"CLI","version":"日本語","pages":[{"title":"--version","description":null,"href":"/reference/ja/cli-commands/version"},{"title":"run","description":null,"href":"/reference/ja/cli-commands/run"},{"title":"compile","description":null,"href":"/reference/ja/cli-commands/compile"},{"title":"clean","description":null,"href":"/reference/ja/cli-commands/clean"},{"title":"init","description":null,"href":"/reference/ja/cli-commands/init"},{"title":"new","description":null,"href":"/reference/ja/cli-commands/new"},{"title":"config","description":null,"href":"/reference/ja/cli-commands/config"},{"title":"deploy","description":null,"href":"/reference/ja/cli-commands/deploy"},{"title":"serve","description":null,"href":"/reference/ja/cli-commands/serve"},{"title":"context","description":null,"href":"/reference/ja/cli-commands/context"}]},{"group":"AIコンポーネント","version":"日本語","pages":[{"title":"\u003cChat /\u003e","description":null,"icon":"messages","href":"/data-application/ja/ai-component-chat"},{"title":"\u003cLLM /\u003e","description":null,"icon":"message-dots","href":"/data-application/ja/ai-component-llm"}]},{"group":"データコンポーネント","version":"日本語","pages":[{"title":"\u003cDataTable /\u003e","description":null,"icon":"table-cells","href":"/data-application/ja/data-component-table"},{"title":"\u003cEmbed /\u003e","description":null,"icon":"code","href":"/data-application/ja/data-component-embed"},{"title":"\u003cMetrics /\u003e","description":null,"icon":"00","href":"/data-application/ja/data-component-metrics"}]},{"group":"入力コンポーネント","version":"日本語","pages":[{"title":"\u003cInput /\u003e","description":null,"icon":"input-pipe","href":"/data-application/ja/input-component-input"},{"title":"\u003cDatePicker /\u003e","description":null,"icon":"calendar-day","href":"/data-application/ja/input-component-date-picker"},{"title":"\u003cDateRangePicker /\u003e","description":null,"icon":"calendar-week","href":"/data-application/ja/input-component-date-range-picker"},{"title":"\u003cSelect /\u003e","description":null,"icon":"caret-down","href":"/data-application/ja/input-component-select"}]},{"group":"レイアウトコンポーネント","version":"日本語","pages":[{"title":"\u003cAccordion /\u003e","description":null,"href":"/data-application/ja/layout-component-accordion"},{"title":"\u003cCallout /\u003e","description":null,"href":"/data-application/ja/layout-component-callout"},{"title":"\u003cCard /\u003e","description":null,"href":"/data-application/ja/layout-component-card"},{"title":"\u003cGrid /\u003e","description":null,"href":"/data-application/ja/layout-component-grid"},{"title":"\u003cPanel /\u003e","description":null,"href":"/data-application/ja/layout-component-panel"}]},{"group":"状態管理とデータ","version":"日本語","pages":[{"title":"状態管理 - defineState()","description":null,"href":"/data-application/ja/morph-data-state"},{"title":"データ取得の仕組み","description":null,"href":"/data-application/ja/advanced-morph-data-basic"}]},{"group":"MDX 詳解","version":"日本語","pages":[{"title":"基本的な書き方","description":null,"href":"/data-application/ja/mdx/mdx-1-basic"},{"title":"スタイリング","description":null,"href":"/data-application/ja/mdx/mdx-2-styling"},{"title":"React, JavaScriptの使用","description":null,"href":"/data-application/ja/mdx/mdx-3-js"}]},{"group":"廃止された仕様","version":"日本語","pages":[{"title":"getJson()","description":null,"href":"/data-application/ja/morph-data-getjson"},{"title":"変数を使う (variable関数)","description":null,"href":"/data-application/ja/morph-data-variables"}]},{"group":"Morph CLI","version":"日本語","pages":[{"title":"Deploy","description":null,"href":"/troubleshooting/ja/cli/deployment-issues"}]},{"group":"サポート","version":"日本語","pages":[{"title":"サポートに連絡する","description":null,"href":"/troubleshooting/ja/support/contact-support"}]}],"docsNavWithMetadata":{"global":{"anchors":[{"anchor":"Changelog","href":"https://www.morph-data.io/changelog","icon":"rss"},{"anchor":"Connectors","href":"https://www.morph-data.io/tools/connectors/database","icon":"plug"},{"anchor":"Code Snippets","href":"https://www.morph-data.io/tools/snippets/undefined","icon":"brackets-curly"}]},"versions":[{"version":"English","tabs":[{"tab":"Guides","groups":[{"group":"Getting Started","pages":[{"title":"Introduction","description":"Convert AI workflows and agents developed in Python into web applications","icon":"lightbulb","href":"/docs/en/getting-started/why-morph"},{"title":"Installation","description":"Python 3.9 or higher and Node.js 18 or higher are required to use Morph.","icon":"wrench","href":"/docs/en/getting-started/installation"}]},{"group":"Quick Start","pages":[{"title":"Building AI App","description":"Complete your first AI app in 3 minutes.","icon":"rocket","href":"/docs/en/quickstart/building-app"},{"group":"How to Deploy","icon":"link","pages":[{"title":"Dashboard Setup","description":null,"icon":"","href":"/docs/en/quickstart/dashboard-setup"},{"title":"Deploy to the Cloud","description":null,"icon":"","href":"/docs/en/quickstart/deploy"}]}]},{"group":"Framework","pages":[{"title":"Framework Overview","description":null,"icon":"eye","href":"/docs/en/develop/guides/framework"},{"title":"Alias","description":null,"icon":"shuffle","href":"/docs/en/develop/guides/alias"},{"title":"Building the Backend","description":null,"icon":"brackets-curly","href":"/docs/en/develop/guides/building-backend"},{"title":"Building the Frontend","description":null,"icon":"markdown","href":"/docs/en/develop/guides/building-frontend"},{"title":"Environment Variables","description":null,"icon":"square-terminal","href":"/docs/en/develop/guides/environment-variables"},{"title":"Data Connector","description":null,"icon":"database","href":"/docs/en/develop/guides/integration"},{"title":"Variables","description":null,"icon":"code","href":"/docs/en/develop/guides/variables"},{"title":"Role-based Access Control","description":null,"icon":"user","href":"/docs/en/develop/guides/user-role"},{"title":"Updating the Project","description":null,"icon":"rotate","href":"/docs/en/develop/guides/updating-project"}]},{"group":"Deployment","pages":[{"title":"Customizing the Runtime Environment","description":null,"icon":"server","href":"/docs/en/deploy/customize-dockerfile"},{"title":"Environment Variables","description":null,"icon":"square-terminal","href":"/docs/en/deploy/environment-variables"},{"title":"Enable Public Access","description":null,"icon":"link","href":"/docs/en/deploy/public"}]},{"group":"Tutorials: Data Analysis","pages":[{"title":"Build a BI app using Pygwalker","description":null,"icon":"chart-user","href":"/docs/en/develop/tutorials/pygwalker"},{"title":"Build a sophisticated dashboard using Plotly","description":null,"icon":"chart-bar","href":"/docs/en/develop/tutorials/plotly"}]},{"group":"Tutorials: LLM Apps","pages":[{"title":"Create a chat app","description":null,"icon":"message-dots","href":"/docs/en/develop/tutorials/chatbot"},{"title":"AI Chat generates and executes code","description":null,"icon":"code","href":"/docs/en/develop/tutorials/chat_sidebyside"}]},{"group":"Advanced","pages":[{"title":"API Key","description":null,"icon":"key","href":"/docs/en/advanced/api_key"},{"title":"Built-in PostgreSQL","description":null,"icon":"database","href":"/docs/en/advanced/builtin-postgres"},{"title":"Version Migration Guide","description":null,"icon":"arrows-turn-to-dots","href":"/docs/en/advanced/migration-guide"},{"group":"Connectors","icon":"plug","pages":[{"title":"MySQL","description":null,"href":"/docs/en/advanced/connectors/mysql"},{"title":"PostgreSQL","description":null,"href":"/docs/en/advanced/connectors/postgresql"},{"title":"BigQuery","description":null,"href":"/docs/en/advanced/connectors/bigquery"},{"title":"Snowflake","description":null,"href":"/docs/en/advanced/connectors/snowflake"},{"title":"Redshift","description":null,"href":"/docs/en/advanced/connectors/redshift"},{"title":"SQLServer","description":null,"href":"/docs/en/advanced/connectors/mssql"},{"title":"Athena","description":null,"href":"/docs/en/advanced/connectors/athena"},{"title":"Salesforce","description":null,"href":"/docs/en/advanced/connectors/salesforce"},{"title":"HubSpot","description":null,"href":"/docs/en/advanced/connectors/hubspot"},{"title":"Stripe","description":null,"href":"/docs/en/advanced/connectors/stripe"},{"title":"Linear","description":null,"href":"/docs/en/advanced/connectors/linear"},{"title":"Airtable","description":null,"href":"/docs/en/advanced/connectors/airtable"},{"title":"Attio","description":null,"href":"/docs/en/advanced/connectors/attio"},{"title":"Intercom","description":null,"href":"/docs/en/advanced/connectors/intercom"},{"title":"Notion","description":null,"href":"/docs/en/advanced/connectors/notion"},{"title":"Mailchimp","description":null,"href":"/docs/en/advanced/connectors/mailchimp"},{"title":"Freee","description":null,"href":"/docs/en/advanced/connectors/freee"}]}]}]},{"tab":"Reference","groups":[{"group":"Framework","pages":[{"title":"morph_project.yml","description":null,"href":"/reference/en/framework/morph-project"}]},{"group":"SQL","pages":[{"title":"config","description":null,"href":"/reference/en/sql/config"},{"title":"load_data","description":null,"href":"/reference/en/sql/load_data"}]},{"group":"Python","pages":[{"title":"MorphGlobalContext","description":null,"href":"/reference/en/python/morph-global-context"},{"title":"@morph.func","description":null,"href":"/reference/en/python/morph-func"},{"title":"@morph.load_data","description":null,"href":"/reference/en/python/morph-load_data"},{"title":"@morph.variables","description":null,"href":"/reference/en/python/morph-variables"}]},{"group":"morph_lib","pages":[{"group":"AI","pages":[{"title":"text_to_sql","description":null,"href":"/reference/en/morph_lib/ai/text_to_sql"},{"title":"text_to_plotly","description":null,"href":"/reference/en/morph_lib/ai/text_to_plotly"},{"title":"text_to_matplotlib","description":null,"href":"/reference/en/morph_lib/ai/text_to_matplotlib"},{"title":"text_to_markdown","description":null,"href":"/reference/en/morph_lib/ai/text_to_markdown"},{"title":"text_to_html","description":null,"href":"/reference/en/morph_lib/ai/text_to_html"}]},{"group":"Database","pages":[{"title":"execute_sql","description":null,"href":"/reference/en/morph_lib/database/execute_sql"},{"title":"insert_records","description":null,"href":"/reference/en/morph_lib/database/insert_records"},{"title":"update_records","description":null,"href":"/reference/en/morph_lib/database/update_records"},{"title":"insert_or_update_records","description":null,"href":"/reference/en/morph_lib/database/insert_or_update_records"},{"title":"delete_records","description":null,"href":"/reference/en/morph_lib/database/delete_records"}]},{"group":"API","pages":[{"title":"get_auth_token","description":null,"href":"/reference/en/morph_lib/api/get_auth_token"}]},{"group":"Stream","pages":[{"title":"create_chunk","description":null,"href":"/reference/en/morph_lib/stream/create_chunk"}]}]},{"group":"CLI","pages":[{"title":"--version","description":null,"href":"/reference/en/cli-commands/version"},{"title":"run","description":null,"href":"/reference/en/cli-commands/run"},{"title":"compile","description":null,"href":"/reference/en/cli-commands/compile"},{"title":"clean","description":null,"href":"/reference/en/cli-commands/clean"},{"title":"init","description":null,"href":"/reference/en/cli-commands/init"},{"title":"new","description":null,"href":"/reference/en/cli-commands/new"},{"title":"config","description":null,"href":"/reference/en/cli-commands/config"},{"title":"deploy","description":null,"href":"/reference/en/cli-commands/deploy"},{"title":"serve","description":null,"href":"/reference/en/cli-commands/serve"},{"title":"context","description":null,"href":"/reference/en/cli-commands/context"}]}]},{"tab":"Components","groups":[{"group":"AI Components","pages":[{"title":"\u003cChat /\u003e","description":null,"icon":"messages","href":"/data-application/en/ai-component-chat"},{"title":"\u003cLLM /\u003e","description":null,"icon":"message-dots","href":"/data-application/en/ai-component-llm"}]},{"group":"Data Components","pages":[{"title":"\u003cDataTable /\u003e","description":null,"icon":"table-cells","href":"/data-application/en/data-component-table"},{"title":"\u003cEmbed /\u003e","description":null,"icon":"code","href":"/data-application/en/data-component-embed"},{"title":"\u003cMetrics /\u003e","description":null,"icon":"00","href":"/data-application/en/data-component-metrics"}]},{"group":"Input Components","pages":[{"title":"\u003cInput /\u003e","description":null,"icon":"input-pipe","href":"/data-application/en/input-component-input"},{"title":"\u003cDatePicker /\u003e","description":null,"icon":"calendar-day","href":"/data-application/en/input-component-date-picker"},{"title":"\u003cDateRangePicker /\u003e","description":null,"icon":"calendar-week","href":"/data-application/en/input-component-date-range-picker"},{"title":"\u003cSelect /\u003e","description":null,"icon":"caret-down","href":"/data-application/en/input-component-select"}]},{"group":"Layout Components","pages":[{"title":"\u003cAccordion /\u003e","description":null,"href":"/data-application/en/layout-component-accordion"},{"title":"\u003cCallout /\u003e","description":null,"href":"/data-application/en/layout-component-callout"},{"title":"\u003cCard /\u003e","description":null,"href":"/data-application/en/layout-component-card"},{"title":"\u003cGrid /\u003e","description":null,"href":"/data-application/en/layout-component-grid"},{"title":"\u003cPanel /\u003e","description":null,"href":"/data-application/en/layout-component-panel"}]},{"group":"State \u0026 Data","pages":[{"title":"State Management - defineState()","description":null,"href":"/data-application/en/morph-data-state"},{"title":"How data fetching works","description":null,"href":"/data-application/en/advanced-morph-data-basic"}]},{"group":"MDX Deep Dive","pages":[{"title":"Basic Usage","description":null,"href":"/data-application/en/mdx/mdx-1-basic"},{"title":"Styling","description":null,"href":"/data-application/en/mdx/mdx-2-styling"},{"title":"Using React and JavaScript","description":null,"href":"/data-application/en/mdx/mdx-3-js"}]},{"group":"Deprecated","pages":[{"title":"getJson()","description":null,"href":"/data-application/en/morph-data-getjson"},{"title":"Using Variables","description":null,"href":"/data-application/en/morph-data-variables"}]}]},{"tab":"Troubleshooting","groups":[{"group":"Morph CLI","pages":[{"title":"Deploy","description":null,"href":"/troubleshooting/en/cli/deployment-issues"}]},{"group":"Support","pages":[{"title":"Contact Support","description":null,"href":"/troubleshooting/en/support/contact-support"}]}]}]},{"version":"日本語","tabs":[{"tab":"Guides","groups":[{"group":"Getting Started","pages":[{"title":"導入","description":"Pythonで開発したAIワークフローやエージェントを、Webアプリケーションに変換","icon":"lightbulb","href":"/docs/ja/getting-started/why-morph"},{"title":"インストール","description":"Morphを使用するためには、Python 3.9以上、Node.js 18以上が必要です。","icon":"wrench","href":"/docs/ja/getting-started/installation"}]},{"group":"クイックスタート","pages":[{"title":"AIアプリの構築","description":"3分ではじめてのAIアプリを完成させましょう。","icon":"rocket","href":"/docs/ja/quickstart/building-app"},{"group":"デプロイ手順","icon":"link","pages":[{"title":"事前準備","description":null,"icon":"","href":"/docs/ja/quickstart/dashboard-setup"},{"title":"デプロイ","description":null,"icon":"","href":"/docs/ja/quickstart/deploy"}]}]},{"group":"フレームワーク","pages":[{"title":"フレームワークの概要","description":null,"icon":"eye","href":"/docs/ja/develop/guides/framework"},{"title":"エイリアス","description":null,"icon":"shuffle","href":"/docs/ja/develop/guides/alias"},{"title":"バックエンドを構築する","description":null,"icon":"brackets-curly","href":"/docs/ja/develop/guides/building-backend"},{"title":"フロントエンドを構築する","description":null,"icon":"markdown","href":"/docs/ja/develop/guides/building-frontend"},{"title":"環境変数","description":null,"icon":"square-terminal","href":"/docs/ja/develop/guides/environment-variables"},{"title":"データコネクター","description":null,"icon":"database","href":"/docs/ja/develop/guides/integration"},{"title":"変数を使う","description":null,"icon":"code","href":"/docs/ja/develop/guides/variables"},{"title":"ロールベースのアクセス制御","description":null,"icon":"user","href":"/docs/ja/develop/guides/user-role"},{"title":"プロジェクトをアップデートする","description":null,"icon":"rotate","href":"/docs/ja/develop/guides/updating-project"}]},{"group":"デプロイ","pages":[{"title":"実行環境のカスタマイズ","description":null,"icon":"server","href":"/docs/ja/deploy/customize-dockerfile"},{"title":"環境変数","description":null,"icon":"square-terminal","href":"/docs/ja/deploy/environment-variables"},{"title":"公開する","description":null,"icon":"link","href":"/docs/ja/deploy/public"}]},{"group":"チュートリアル: データ分析","pages":[{"title":"PYGWALKERを埋め込んだBIアプリ構築","description":null,"icon":"chart-user","href":"/docs/ja/develop/tutorials/pygwalker"},{"title":"Plotlyを用いた高度なダッシュボードアプリ構築","description":null,"icon":"chart-bar","href":"/docs/ja/develop/tutorials/plotly"}]},{"group":"チュートリアル: AIアプリ","pages":[{"title":"チャットアプリを作成する","description":null,"icon":"message-dots","href":"/docs/ja/develop/tutorials/chatbot"},{"title":"コード生成・実行を行うAIアプリを作成する","description":null,"icon":"code","href":"/docs/ja/develop/tutorials/chat_sidebyside"}]},{"group":"Advanced","pages":[{"title":"API Key","description":null,"icon":"key","href":"/docs/ja/advanced/api_key"},{"title":"ビルトインPostgreSQL","description":null,"icon":"database","href":"/docs/ja/advanced/builtin-postgres"},{"title":"バージョンマイグレーションガイド","description":null,"icon":"arrows-turn-to-dots","href":"/docs/ja/advanced/migration-guide"},{"group":"Connectors","icon":"plug","pages":[{"title":"MySQL","description":null,"href":"/docs/ja/advanced/connectors/mysql"},{"title":"PostgreSQL","description":null,"href":"/docs/ja/advanced/connectors/postgresql"},{"title":"BigQuery","description":null,"href":"/docs/ja/advanced/connectors/bigquery"},{"title":"Snowflake","description":null,"href":"/docs/ja/advanced/connectors/snowflake"},{"title":"Redshift","description":null,"href":"/docs/ja/advanced/connectors/redshift"},{"title":"SQLServer","description":null,"href":"/docs/ja/advanced/connectors/mssql"},{"title":"Athena","description":null,"href":"/docs/ja/advanced/connectors/athena"},{"title":"Salesforce","description":null,"href":"/docs/ja/advanced/connectors/salesforce"},{"title":"HubSpot","description":null,"href":"/docs/ja/advanced/connectors/hubspot"},{"title":"Stripe","description":null,"href":"/docs/ja/advanced/connectors/stripe"},{"title":"Linear","description":null,"href":"/docs/ja/advanced/connectors/linear"},{"title":"Airtable","description":null,"href":"/docs/ja/advanced/connectors/airtable"},{"title":"Attio","description":null,"href":"/docs/ja/advanced/connectors/attio"},{"title":"Intercom","description":null,"href":"/docs/ja/advanced/connectors/intercom"},{"title":"Notion","description":null,"href":"/docs/ja/advanced/connectors/notion"},{"title":"Mailchimp","description":null,"href":"/docs/ja/advanced/connectors/mailchimp"},{"title":"Freee","description":null,"href":"/docs/ja/advanced/connectors/freee"}]}]}]},{"tab":"Reference","groups":[{"group":"フレームワーク","pages":[{"title":"morph_project.yml","description":null,"href":"/reference/ja/framework/morph-project"}]},{"group":"SQL","pages":[{"title":"config","description":null,"href":"/reference/ja/sql/config"},{"title":"load_data","description":null,"href":"/reference/ja/sql/load_data"}]},{"group":"Python","pages":[{"title":"MorphGlobalContext","description":null,"href":"/reference/ja/python/morph-global-context"},{"title":"@morph.func","description":null,"href":"/reference/ja/python/morph-func"},{"title":"@morph.load_data","description":null,"href":"/reference/ja/python/morph-load_data"},{"title":"@morph.variables","description":null,"href":"/reference/ja/python/morph-variables"}]},{"group":"morph_lib","pages":[{"group":"AI","pages":[{"title":"text_to_sql","description":null,"href":"/reference/ja/morph_lib/ai/text_to_sql"},{"title":"text_to_plotly","description":null,"href":"/reference/ja/morph_lib/ai/text_to_plotly"},{"title":"text_to_matplotlib","description":null,"href":"/reference/ja/morph_lib/ai/text_to_matplotlib"},{"title":"text_to_markdown","description":null,"href":"/reference/ja/morph_lib/ai/text_to_markdown"},{"title":"text_to_html","description":null,"href":"/reference/ja/morph_lib/ai/text_to_html"}]},{"group":"Database","pages":[{"title":"execute_sql","description":null,"href":"/reference/ja/morph_lib/database/execute_sql"},{"title":"insert_records","description":null,"href":"/reference/ja/morph_lib/database/insert_records"},{"title":"update_records","description":null,"href":"/reference/ja/morph_lib/database/update_records"},{"title":"insert_or_update_records","description":null,"href":"/reference/ja/morph_lib/database/insert_or_update_records"},{"title":"delete_records","description":null,"href":"/reference/ja/morph_lib/database/delete_records"}]},{"group":"API","pages":[{"title":"get_auth_token","description":null,"href":"/reference/ja/morph_lib/api/get_auth_token"}]},{"group":"Stream","pages":[{"title":"create_chunk","description":null,"href":"/reference/ja/morph_lib/stream/create_chunk"}]}]},{"group":"CLI","pages":[{"title":"--version","description":null,"href":"/reference/ja/cli-commands/version"},{"title":"run","description":null,"href":"/reference/ja/cli-commands/run"},{"title":"compile","description":null,"href":"/reference/ja/cli-commands/compile"},{"title":"clean","description":null,"href":"/reference/ja/cli-commands/clean"},{"title":"init","description":null,"href":"/reference/ja/cli-commands/init"},{"title":"new","description":null,"href":"/reference/ja/cli-commands/new"},{"title":"config","description":null,"href":"/reference/ja/cli-commands/config"},{"title":"deploy","description":null,"href":"/reference/ja/cli-commands/deploy"},{"title":"serve","description":null,"href":"/reference/ja/cli-commands/serve"},{"title":"context","description":null,"href":"/reference/ja/cli-commands/context"}]}]},{"tab":"Components","groups":[{"group":"AIコンポーネント","pages":[{"title":"\u003cChat /\u003e","description":null,"icon":"messages","href":"/data-application/ja/ai-component-chat"},{"title":"\u003cLLM /\u003e","description":null,"icon":"message-dots","href":"/data-application/ja/ai-component-llm"}]},{"group":"データコンポーネント","pages":[{"title":"\u003cDataTable /\u003e","description":null,"icon":"table-cells","href":"/data-application/ja/data-component-table"},{"title":"\u003cEmbed /\u003e","description":null,"icon":"code","href":"/data-application/ja/data-component-embed"},{"title":"\u003cMetrics /\u003e","description":null,"icon":"00","href":"/data-application/ja/data-component-metrics"}]},{"group":"入力コンポーネント","pages":[{"title":"\u003cInput /\u003e","description":null,"icon":"input-pipe","href":"/data-application/ja/input-component-input"},{"title":"\u003cDatePicker /\u003e","description":null,"icon":"calendar-day","href":"/data-application/ja/input-component-date-picker"},{"title":"\u003cDateRangePicker /\u003e","description":null,"icon":"calendar-week","href":"/data-application/ja/input-component-date-range-picker"},{"title":"\u003cSelect /\u003e","description":null,"icon":"caret-down","href":"/data-application/ja/input-component-select"}]},{"group":"レイアウトコンポーネント","pages":[{"title":"\u003cAccordion /\u003e","description":null,"href":"/data-application/ja/layout-component-accordion"},{"title":"\u003cCallout /\u003e","description":null,"href":"/data-application/ja/layout-component-callout"},{"title":"\u003cCard /\u003e","description":null,"href":"/data-application/ja/layout-component-card"},{"title":"\u003cGrid /\u003e","description":null,"href":"/data-application/ja/layout-component-grid"},{"title":"\u003cPanel /\u003e","description":null,"href":"/data-application/ja/layout-component-panel"}]},{"group":"状態管理とデータ","pages":[{"title":"状態管理 - defineState()","description":null,"href":"/data-application/ja/morph-data-state"},{"title":"データ取得の仕組み","description":null,"href":"/data-application/ja/advanced-morph-data-basic"}]},{"group":"MDX 詳解","pages":[{"title":"基本的な書き方","description":null,"href":"/data-application/ja/mdx/mdx-1-basic"},{"title":"スタイリング","description":null,"href":"/data-application/ja/mdx/mdx-2-styling"},{"title":"React, JavaScriptの使用","description":null,"href":"/data-application/ja/mdx/mdx-3-js"}]},{"group":"廃止された仕様","pages":[{"title":"getJson()","description":null,"href":"/data-application/ja/morph-data-getjson"},{"title":"変数を使う (variable関数)","description":null,"href":"/data-application/ja/morph-data-variables"}]}]},{"tab":"Troubleshooting","groups":[{"group":"Morph CLI","pages":[{"title":"Deploy","description":null,"href":"/troubleshooting/ja/cli/deployment-issues"}]},{"group":"サポート","pages":[{"title":"サポートに連絡する","description":null,"href":"/troubleshooting/ja/support/contact-support"}]}]}]}]},"pageMetadata":{"title":"Build with SQL \u0026 Python","description":null,"href":"/docs/en/workspace/sql-python"},"mintConfig":{"layout":"topnav","sidebar":{"items":"container"},"topbar":{"style":"default"},"search":{"location":"top"},"rounded":"default","codeBlock":{"mode":"dark"},"topbarCtaButton":{"name":"Website","url":"https://www.morphdb.io","style":"pill","arrow":true},"$schema":"https://mintlify.com/schema.json","name":"Docs","logo":{"light":"https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg.svg","dark":"https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg_w.svg"},"favicon":"/favicon.svg","versions":["English","日本語"],"colors":{"primary":"#111827","light":"#d1d5db","dark":"#111827","anchors":{"from":"#0D9373","to":"#07C983"}},"topbarLinks":[{"url":"https://www.morphdb.io/blogs","name":"Blog","_id":"67b4a82e19ea22a6baa0198d"}],"navigation":[{"group":"Getting Started","version":"English","pages":["docs/en/getting-started/why-morph","docs/en/getting-started/installation"]},{"group":"Quick Start","version":"English","pages":["docs/en/quickstart/building-app",{"group":"How to Deploy","icon":"link","pages":["docs/en/quickstart/dashboard-setup","docs/en/quickstart/deploy"]}]},{"group":"Framework","version":"English","pages":["docs/en/develop/guides/framework","docs/en/develop/guides/alias","docs/en/develop/guides/building-backend","docs/en/develop/guides/building-frontend","docs/en/develop/guides/environment-variables","docs/en/develop/guides/integration","docs/en/develop/guides/variables","docs/en/develop/guides/user-role","docs/en/develop/guides/updating-project"]},{"group":"Deployment","version":"English","pages":["docs/en/deploy/customize-dockerfile","docs/en/deploy/environment-variables","docs/en/deploy/public"]},{"group":"Tutorials: Data Analysis","version":"English","pages":["docs/en/develop/tutorials/pygwalker","docs/en/develop/tutorials/plotly"]},{"group":"Tutorials: LLM Apps","version":"English","pages":["docs/en/develop/tutorials/chatbot","docs/en/develop/tutorials/chat_sidebyside"]},{"group":"Advanced","version":"English","pages":["docs/en/advanced/api_key","docs/en/advanced/builtin-postgres","docs/en/advanced/migration-guide",{"group":"Connectors","icon":"plug","pages":["docs/en/advanced/connectors/mysql","docs/en/advanced/connectors/postgresql","docs/en/advanced/connectors/bigquery","docs/en/advanced/connectors/snowflake","docs/en/advanced/connectors/redshift","docs/en/advanced/connectors/mssql","docs/en/advanced/connectors/athena","docs/en/advanced/connectors/salesforce","docs/en/advanced/connectors/hubspot","docs/en/advanced/connectors/stripe","docs/en/advanced/connectors/linear","docs/en/advanced/connectors/airtable","docs/en/advanced/connectors/attio","docs/en/advanced/connectors/intercom","docs/en/advanced/connectors/notion","docs/en/advanced/connectors/mailchimp","docs/en/advanced/connectors/freee"]}]},{"group":"Framework","version":"English","pages":["reference/en/framework/morph-project"]},{"group":"SQL","version":"English","pages":["reference/en/sql/config","reference/en/sql/load_data"]},{"group":"Python","version":"English","pages":["reference/en/python/morph-global-context","reference/en/python/morph-func","reference/en/python/morph-load_data","reference/en/python/morph-variables"]},{"group":"morph_lib","version":"English","pages":[{"group":"AI","pages":["reference/en/morph_lib/ai/text_to_sql","reference/en/morph_lib/ai/text_to_plotly","reference/en/morph_lib/ai/text_to_matplotlib","reference/en/morph_lib/ai/text_to_markdown","reference/en/morph_lib/ai/text_to_html"]},{"group":"Database","pages":["reference/en/morph_lib/database/execute_sql","reference/en/morph_lib/database/insert_records","reference/en/morph_lib/database/update_records","reference/en/morph_lib/database/insert_or_update_records","reference/en/morph_lib/database/delete_records"]},{"group":"API","pages":["reference/en/morph_lib/api/get_auth_token"]},{"group":"Stream","pages":["reference/en/morph_lib/stream/create_chunk"]}]},{"group":"CLI","version":"English","pages":["reference/en/cli-commands/version","reference/en/cli-commands/run","reference/en/cli-commands/compile","reference/en/cli-commands/clean","reference/en/cli-commands/init","reference/en/cli-commands/new","reference/en/cli-commands/config","reference/en/cli-commands/deploy","reference/en/cli-commands/serve","reference/en/cli-commands/context"]},{"group":"AI Components","version":"English","pages":["data-application/en/ai-component-chat","data-application/en/ai-component-llm"]},{"group":"Data Components","version":"English","pages":["data-application/en/data-component-table","data-application/en/data-component-embed","data-application/en/data-component-metrics"]},{"group":"Input Components","version":"English","pages":["data-application/en/input-component-input","data-application/en/input-component-date-picker","data-application/en/input-component-date-range-picker","data-application/en/input-component-select"]},{"group":"Layout Components","version":"English","pages":["data-application/en/layout-component-accordion","data-application/en/layout-component-callout","data-application/en/layout-component-card","data-application/en/layout-component-grid","data-application/en/layout-component-panel"]},{"group":"State \u0026 Data","version":"English","pages":["data-application/en/morph-data-state","data-application/en/advanced-morph-data-basic"]},{"group":"MDX Deep Dive","version":"English","pages":["data-application/en/mdx/mdx-1-basic","data-application/en/mdx/mdx-2-styling","data-application/en/mdx/mdx-3-js"]},{"group":"Deprecated","version":"English","pages":["data-application/en/morph-data-getjson","data-application/en/morph-data-variables"]},{"group":"Morph CLI","version":"English","pages":["troubleshooting/en/cli/deployment-issues"]},{"group":"Support","version":"English","pages":["troubleshooting/en/support/contact-support"]},{"group":"Getting Started","version":"日本語","pages":["docs/ja/getting-started/why-morph","docs/ja/getting-started/installation"]},{"group":"クイックスタート","version":"日本語","pages":["docs/ja/quickstart/building-app",{"group":"デプロイ手順","icon":"link","pages":["docs/ja/quickstart/dashboard-setup","docs/ja/quickstart/deploy"]}]},{"group":"フレームワーク","version":"日本語","pages":["docs/ja/develop/guides/framework","docs/ja/develop/guides/alias","docs/ja/develop/guides/building-backend","docs/ja/develop/guides/building-frontend","docs/ja/develop/guides/environment-variables","docs/ja/develop/guides/integration","docs/ja/develop/guides/variables","docs/ja/develop/guides/user-role","docs/ja/develop/guides/updating-project"]},{"group":"デプロイ","version":"日本語","pages":["docs/ja/deploy/customize-dockerfile","docs/ja/deploy/environment-variables","docs/ja/deploy/public"]},{"group":"チュートリアル: データ分析","version":"日本語","pages":["docs/ja/develop/tutorials/pygwalker","docs/ja/develop/tutorials/plotly"]},{"group":"チュートリアル: AIアプリ","version":"日本語","pages":["docs/ja/develop/tutorials/chatbot","docs/ja/develop/tutorials/chat_sidebyside"]},{"group":"Advanced","version":"日本語","pages":["docs/ja/advanced/api_key","docs/ja/advanced/builtin-postgres","docs/ja/advanced/migration-guide",{"group":"Connectors","icon":"plug","pages":["docs/ja/advanced/connectors/mysql","docs/ja/advanced/connectors/postgresql","docs/ja/advanced/connectors/bigquery","docs/ja/advanced/connectors/snowflake","docs/ja/advanced/connectors/redshift","docs/ja/advanced/connectors/mssql","docs/ja/advanced/connectors/athena","docs/ja/advanced/connectors/salesforce","docs/ja/advanced/connectors/hubspot","docs/ja/advanced/connectors/stripe","docs/ja/advanced/connectors/linear","docs/ja/advanced/connectors/airtable","docs/ja/advanced/connectors/attio","docs/ja/advanced/connectors/intercom","docs/ja/advanced/connectors/notion","docs/ja/advanced/connectors/mailchimp","docs/ja/advanced/connectors/freee"]}]},{"group":"フレームワーク","version":"日本語","pages":["reference/ja/framework/morph-project"]},{"group":"SQL","version":"日本語","pages":["reference/ja/sql/config","reference/ja/sql/load_data"]},{"group":"Python","version":"日本語","pages":["reference/ja/python/morph-global-context","reference/ja/python/morph-func","reference/ja/python/morph-load_data","reference/ja/python/morph-variables"]},{"group":"morph_lib","version":"日本語","pages":[{"group":"AI","pages":["reference/ja/morph_lib/ai/text_to_sql","reference/ja/morph_lib/ai/text_to_plotly","reference/ja/morph_lib/ai/text_to_matplotlib","reference/ja/morph_lib/ai/text_to_markdown","reference/ja/morph_lib/ai/text_to_html"]},{"group":"Database","pages":["reference/ja/morph_lib/database/execute_sql","reference/ja/morph_lib/database/insert_records","reference/ja/morph_lib/database/update_records","reference/ja/morph_lib/database/insert_or_update_records","reference/ja/morph_lib/database/delete_records"]},{"group":"API","pages":["reference/ja/morph_lib/api/get_auth_token"]},{"group":"Stream","pages":["reference/ja/morph_lib/stream/create_chunk"]}]},{"group":"CLI","version":"日本語","pages":["reference/ja/cli-commands/version","reference/ja/cli-commands/run","reference/ja/cli-commands/compile","reference/ja/cli-commands/clean","reference/ja/cli-commands/init","reference/ja/cli-commands/new","reference/ja/cli-commands/config","reference/ja/cli-commands/deploy","reference/ja/cli-commands/serve","reference/ja/cli-commands/context"]},{"group":"AIコンポーネント","version":"日本語","pages":["data-application/ja/ai-component-chat","data-application/ja/ai-component-llm"]},{"group":"データコンポーネント","version":"日本語","pages":["data-application/ja/data-component-table","data-application/ja/data-component-embed","data-application/ja/data-component-metrics"]},{"group":"入力コンポーネント","version":"日本語","pages":["data-application/ja/input-component-input","data-application/ja/input-component-date-picker","data-application/ja/input-component-date-range-picker","data-application/ja/input-component-select"]},{"group":"レイアウトコンポーネント","version":"日本語","pages":["data-application/ja/layout-component-accordion","data-application/ja/layout-component-callout","data-application/ja/layout-component-card","data-application/ja/layout-component-grid","data-application/ja/layout-component-panel"]},{"group":"状態管理とデータ","version":"日本語","pages":["data-application/ja/morph-data-state","data-application/ja/advanced-morph-data-basic"]},{"group":"MDX 詳解","version":"日本語","pages":["data-application/ja/mdx/mdx-1-basic","data-application/ja/mdx/mdx-2-styling","data-application/ja/mdx/mdx-3-js"]},{"group":"廃止された仕様","version":"日本語","pages":["data-application/ja/morph-data-getjson","data-application/ja/morph-data-variables"]},{"group":"Morph CLI","version":"日本語","pages":["troubleshooting/ja/cli/deployment-issues"]},{"group":"サポート","version":"日本語","pages":["troubleshooting/ja/support/contact-support"]}],"anchors":[{"name":"Changelog","url":"https://www.morph-data.io/changelog","icon":"rss","_id":"67b4a82e19ea22a6baa0198a"},{"name":"Connectors","url":"https://www.morph-data.io/tools/connectors/database","icon":"plug","_id":"67b4a82e19ea22a6baa0198b"},{"name":"Code Snippets","url":"https://www.morph-data.io/tools/snippets/undefined","icon":"brackets-curly","_id":"67b4a82e19ea22a6baa0198c"}],"tabs":[{"name":"Guides","url":"docs","_id":"67b4a82e19ea22a6baa01984"},{"name":"Reference","url":"reference","_id":"67b4a82e19ea22a6baa01985"},{"name":"Components","url":"data-application","_id":"67b4a82e19ea22a6baa01986"},{"name":"Integrations","url":"integrations","_id":"67b4a82e19ea22a6baa01987"},{"name":"Sample Data Apps","url":"sample-data-app","_id":"67b4a82e19ea22a6baa01988"},{"name":"Troubleshooting","url":"troubleshooting","_id":"67b4a82e19ea22a6baa01989"}],"footerSocials":{"x":"https://x.com/morphdbHQ","github":"https://github.com/useMorph","linkedin":"https://www.linkedin.com/company/morphdbhq"}},"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"Docs","colors":{"primary":"#111827","light":"#d1d5db","dark":"#111827"},"favicon":"/favicon.svg","navigation":{"versions":[{"version":"English","tabs":[{"tab":"Guides","groups":[{"group":"Getting Started","pages":["docs/en/getting-started/why-morph","docs/en/getting-started/installation"]},{"group":"Quick Start","pages":["docs/en/quickstart/building-app",{"group":"How to Deploy","icon":"link","pages":["docs/en/quickstart/dashboard-setup","docs/en/quickstart/deploy"]}]},{"group":"Framework","pages":["docs/en/develop/guides/framework","docs/en/develop/guides/alias","docs/en/develop/guides/building-backend","docs/en/develop/guides/building-frontend","docs/en/develop/guides/environment-variables","docs/en/develop/guides/integration","docs/en/develop/guides/variables","docs/en/develop/guides/user-role","docs/en/develop/guides/updating-project"]},{"group":"Deployment","pages":["docs/en/deploy/customize-dockerfile","docs/en/deploy/environment-variables","docs/en/deploy/public"]},{"group":"Tutorials: Data Analysis","pages":["docs/en/develop/tutorials/pygwalker","docs/en/develop/tutorials/plotly"]},{"group":"Tutorials: LLM Apps","pages":["docs/en/develop/tutorials/chatbot","docs/en/develop/tutorials/chat_sidebyside"]},{"group":"Advanced","pages":["docs/en/advanced/api_key","docs/en/advanced/builtin-postgres","docs/en/advanced/migration-guide",{"group":"Connectors","icon":"plug","pages":["docs/en/advanced/connectors/mysql","docs/en/advanced/connectors/postgresql","docs/en/advanced/connectors/bigquery","docs/en/advanced/connectors/snowflake","docs/en/advanced/connectors/redshift","docs/en/advanced/connectors/mssql","docs/en/advanced/connectors/athena","docs/en/advanced/connectors/salesforce","docs/en/advanced/connectors/hubspot","docs/en/advanced/connectors/stripe","docs/en/advanced/connectors/linear","docs/en/advanced/connectors/airtable","docs/en/advanced/connectors/attio","docs/en/advanced/connectors/intercom","docs/en/advanced/connectors/notion","docs/en/advanced/connectors/mailchimp","docs/en/advanced/connectors/freee"]}]}]},{"tab":"Reference","groups":[{"group":"Framework","pages":["reference/en/framework/morph-project"]},{"group":"SQL","pages":["reference/en/sql/config","reference/en/sql/load_data"]},{"group":"Python","pages":["reference/en/python/morph-global-context","reference/en/python/morph-func","reference/en/python/morph-load_data","reference/en/python/morph-variables"]},{"group":"morph_lib","pages":[{"group":"AI","pages":["reference/en/morph_lib/ai/text_to_sql","reference/en/morph_lib/ai/text_to_plotly","reference/en/morph_lib/ai/text_to_matplotlib","reference/en/morph_lib/ai/text_to_markdown","reference/en/morph_lib/ai/text_to_html"]},{"group":"Database","pages":["reference/en/morph_lib/database/execute_sql","reference/en/morph_lib/database/insert_records","reference/en/morph_lib/database/update_records","reference/en/morph_lib/database/insert_or_update_records","reference/en/morph_lib/database/delete_records"]},{"group":"API","pages":["reference/en/morph_lib/api/get_auth_token"]},{"group":"Stream","pages":["reference/en/morph_lib/stream/create_chunk"]}]},{"group":"CLI","pages":["reference/en/cli-commands/version","reference/en/cli-commands/run","reference/en/cli-commands/compile","reference/en/cli-commands/clean","reference/en/cli-commands/init","reference/en/cli-commands/new","reference/en/cli-commands/config","reference/en/cli-commands/deploy","reference/en/cli-commands/serve","reference/en/cli-commands/context"]}]},{"tab":"Components","groups":[{"group":"AI Components","pages":["data-application/en/ai-component-chat","data-application/en/ai-component-llm"]},{"group":"Data Components","pages":["data-application/en/data-component-table","data-application/en/data-component-embed","data-application/en/data-component-metrics"]},{"group":"Input Components","pages":["data-application/en/input-component-input","data-application/en/input-component-date-picker","data-application/en/input-component-date-range-picker","data-application/en/input-component-select"]},{"group":"Layout Components","pages":["data-application/en/layout-component-accordion","data-application/en/layout-component-callout","data-application/en/layout-component-card","data-application/en/layout-component-grid","data-application/en/layout-component-panel"]},{"group":"State \u0026 Data","pages":["data-application/en/morph-data-state","data-application/en/advanced-morph-data-basic"]},{"group":"MDX Deep Dive","pages":["data-application/en/mdx/mdx-1-basic","data-application/en/mdx/mdx-2-styling","data-application/en/mdx/mdx-3-js"]},{"group":"Deprecated","pages":["data-application/en/morph-data-getjson","data-application/en/morph-data-variables"]}]},{"tab":"Troubleshooting","groups":[{"group":"Morph CLI","pages":["troubleshooting/en/cli/deployment-issues"]},{"group":"Support","pages":["troubleshooting/en/support/contact-support"]}]}]},{"version":"日本語","tabs":[{"tab":"Guides","groups":[{"group":"Getting Started","pages":["docs/ja/getting-started/why-morph","docs/ja/getting-started/installation"]},{"group":"クイックスタート","pages":["docs/ja/quickstart/building-app",{"group":"デプロイ手順","icon":"link","pages":["docs/ja/quickstart/dashboard-setup","docs/ja/quickstart/deploy"]}]},{"group":"フレームワーク","pages":["docs/ja/develop/guides/framework","docs/ja/develop/guides/alias","docs/ja/develop/guides/building-backend","docs/ja/develop/guides/building-frontend","docs/ja/develop/guides/environment-variables","docs/ja/develop/guides/integration","docs/ja/develop/guides/variables","docs/ja/develop/guides/user-role","docs/ja/develop/guides/updating-project"]},{"group":"デプロイ","pages":["docs/ja/deploy/customize-dockerfile","docs/ja/deploy/environment-variables","docs/ja/deploy/public"]},{"group":"チュートリアル: データ分析","pages":["docs/ja/develop/tutorials/pygwalker","docs/ja/develop/tutorials/plotly"]},{"group":"チュートリアル: AIアプリ","pages":["docs/ja/develop/tutorials/chatbot","docs/ja/develop/tutorials/chat_sidebyside"]},{"group":"Advanced","pages":["docs/ja/advanced/api_key","docs/ja/advanced/builtin-postgres","docs/ja/advanced/migration-guide",{"group":"Connectors","icon":"plug","pages":["docs/ja/advanced/connectors/mysql","docs/ja/advanced/connectors/postgresql","docs/ja/advanced/connectors/bigquery","docs/ja/advanced/connectors/snowflake","docs/ja/advanced/connectors/redshift","docs/ja/advanced/connectors/mssql","docs/ja/advanced/connectors/athena","docs/ja/advanced/connectors/salesforce","docs/ja/advanced/connectors/hubspot","docs/ja/advanced/connectors/stripe","docs/ja/advanced/connectors/linear","docs/ja/advanced/connectors/airtable","docs/ja/advanced/connectors/attio","docs/ja/advanced/connectors/intercom","docs/ja/advanced/connectors/notion","docs/ja/advanced/connectors/mailchimp","docs/ja/advanced/connectors/freee"]}]}]},{"tab":"Reference","groups":[{"group":"フレームワーク","pages":["reference/ja/framework/morph-project"]},{"group":"SQL","pages":["reference/ja/sql/config","reference/ja/sql/load_data"]},{"group":"Python","pages":["reference/ja/python/morph-global-context","reference/ja/python/morph-func","reference/ja/python/morph-load_data","reference/ja/python/morph-variables"]},{"group":"morph_lib","pages":[{"group":"AI","pages":["reference/ja/morph_lib/ai/text_to_sql","reference/ja/morph_lib/ai/text_to_plotly","reference/ja/morph_lib/ai/text_to_matplotlib","reference/ja/morph_lib/ai/text_to_markdown","reference/ja/morph_lib/ai/text_to_html"]},{"group":"Database","pages":["reference/ja/morph_lib/database/execute_sql","reference/ja/morph_lib/database/insert_records","reference/ja/morph_lib/database/update_records","reference/ja/morph_lib/database/insert_or_update_records","reference/ja/morph_lib/database/delete_records"]},{"group":"API","pages":["reference/ja/morph_lib/api/get_auth_token"]},{"group":"Stream","pages":["reference/ja/morph_lib/stream/create_chunk"]}]},{"group":"CLI","pages":["reference/ja/cli-commands/version","reference/ja/cli-commands/run","reference/ja/cli-commands/compile","reference/ja/cli-commands/clean","reference/ja/cli-commands/init","reference/ja/cli-commands/new","reference/ja/cli-commands/config","reference/ja/cli-commands/deploy","reference/ja/cli-commands/serve","reference/ja/cli-commands/context"]}]},{"tab":"Components","groups":[{"group":"AIコンポーネント","pages":["data-application/ja/ai-component-chat","data-application/ja/ai-component-llm"]},{"group":"データコンポーネント","pages":["data-application/ja/data-component-table","data-application/ja/data-component-embed","data-application/ja/data-component-metrics"]},{"group":"入力コンポーネント","pages":["data-application/ja/input-component-input","data-application/ja/input-component-date-picker","data-application/ja/input-component-date-range-picker","data-application/ja/input-component-select"]},{"group":"レイアウトコンポーネント","pages":["data-application/ja/layout-component-accordion","data-application/ja/layout-component-callout","data-application/ja/layout-component-card","data-application/ja/layout-component-grid","data-application/ja/layout-component-panel"]},{"group":"状態管理とデータ","pages":["data-application/ja/morph-data-state","data-application/ja/advanced-morph-data-basic"]},{"group":"MDX 詳解","pages":["data-application/ja/mdx/mdx-1-basic","data-application/ja/mdx/mdx-2-styling","data-application/ja/mdx/mdx-3-js"]},{"group":"廃止された仕様","pages":["data-application/ja/morph-data-getjson","data-application/ja/morph-data-variables"]}]},{"tab":"Troubleshooting","groups":[{"group":"Morph CLI","pages":["troubleshooting/ja/cli/deployment-issues"]},{"group":"サポート","pages":["troubleshooting/ja/support/contact-support"]}]}]}],"global":{"anchors":[{"anchor":"Changelog","href":"https://www.morph-data.io/changelog","icon":"rss"},{"anchor":"Connectors","href":"https://www.morph-data.io/tools/connectors/database","icon":"plug"},{"anchor":"Code Snippets","href":"https://www.morph-data.io/tools/snippets/undefined","icon":"brackets-curly"}]}},"styling":{"codeblocks":"dark"},"logo":{"light":"https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg.svg","dark":"https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg_w.svg"},"navbar":{"links":[{"label":"Blog","href":"https://www.morphdb.io/blogs"}],"primary":{"type":"button","label":"Website","href":"https://www.morphdb.io"}},"footer":{"socials":{"x":"https://x.com/morphdbHQ","github":"https://github.com/useMorph","linkedin":"https://www.linkedin.com/company/morphdbhq"}}},"apiReferenceData":{}},"favicons":{"icons":[{"rel":"apple-touch-icon","sizes":"180x180","href":"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/apple-touch-icon.png?v=3","type":"image/png"},{"rel":"icon","sizes":"32x32","href":"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/favicon-32x32.png?v=3","type":"image/png"},{"rel":"icon","sizes":"16x16","href":"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/favicon-16x16.png?v=3","type":"image/png"},{"rel":"shortcut icon","href":"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/favicon.ico?v=3","type":"image/x-icon"}],"browserconfig":"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/_generated/favicon/browserconfig.xml?v=3"},"subdomain":"docs.morph-data.io","actualSubdomain":"queue-4c50ebb3","internalAnalyticsWriteKey":"phc_TXdpocbGVeZVm5VJmAsHTMrCofBQu3e0kN8HGMNGTVW","trieve":{"datasetId":"677378ce-aec4-4e4e-b2d7-054bbf68d662","chatEnabled":true},"shouldIndex":false,"org":{"createdAt":"2024-09-30T05:26:19.425Z"},"cssFiles":[],"jsFiles":[],"mdxSourceWithNoJs":{"compiledSource":"\"use strict\";\nconst {Fragment: _Fragment, jsx: _jsx, jsxs: _jsxs} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n code: \"code\",\n p: \"p\",\n pre: \"pre\",\n span: \"span\",\n ..._provideComponents(),\n ...props.components\n }, {Card, CardGroup, CodeBlock, Heading, Note, Tip, Warning, ZoomImage} = _components;\n if (!Card) _missingMdxReference(\"Card\", true);\n if (!CardGroup) _missingMdxReference(\"CardGroup\", true);\n if (!CodeBlock) _missingMdxReference(\"CodeBlock\", true);\n if (!Heading) _missingMdxReference(\"Heading\", true);\n if (!Note) _missingMdxReference(\"Note\", true);\n if (!Tip) _missingMdxReference(\"Tip\", true);\n if (!Warning) _missingMdxReference(\"Warning\", true);\n if (!ZoomImage) _missingMdxReference(\"ZoomImage\", true);\n return _jsxs(_Fragment, {\n children: [_jsx(_components.p, {\n children: \"The workspace allows data analysis using SQL and Python.\"\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"When you open the workspace, a \", _jsx(_components.code, {\n children: \"src\"\n }), \" directory exists in the project root. Place and run SQL and Python files in this \", _jsx(_components.code, {\n children: \"src\"\n }), \" directory.\"]\n }), \"\\n\", _jsxs(Tip, {\n children: [\"The \", _jsx(_components.code, {\n children: \"morph_project.yml\"\n }), \" file is set to \", _jsx(_components.code, {\n children: \"source_paths: src\"\n }), \". It is possible to change the directory where the source code is placed by changing this value.\"]\n }), \"\\n\", _jsx(ZoomImage, {\n children: _jsx(\"img\", {\n src: \"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/docs/workspace-editor-sql.png\",\n alt: \"Workspace Editor SQL\"\n })\n }), \"\\n\", _jsx(Heading, {\n level: \"3\",\n id: \"execution-of-source-code\",\n children: \"Execution of source code\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"The SQL or Python you have written can be executed using the ‘RUN’ button located in the top right-hand corner of the editor, as shown in the image below.\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"When executed, the corresponding Morph CLI log is output in the terminal and the data from the execution is displayed in the ‘Result’ tab in the right sidebar.\"\n }), \"\\n\", _jsx(ZoomImage, {\n children: _jsx(\"img\", {\n src: \"https://mintlify.s3-us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/docs/workspace-editor-sql-run.png\",\n alt: \"Workspace Editor SQL Run\"\n })\n }), \"\\n\", _jsx(Heading, {\n level: \"2\",\n id: \"implementing-source-code\",\n children: \"Implementing source code\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"SQL and Python on Morph is run by the Morph CLI installed on a VM on the workspace. It builds on the DB and standard Python scripts used, and provides extensions to allow more powerful data analysis by the user.\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"In addition, in Morph, files for analysis are named at runtime. Naming makes it easier to access the results of that file from other files.\\nThis mechanism is a very important part of the Morph framework.\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"Note that duplicate names of this name at runtime will result in a compile error.\"\n }), \"\\n\", _jsx(Heading, {\n level: \"3\",\n id: \"sql\",\n children: \"SQL\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"You can use jinja2 to write SQL, and within jinja you can use Morph’s own config, a function for writing metadata.\\nIn config, you can describe the processing of the function. This allows you to leave the processing details for team members and for the Morph AI to interpret the developer’s intentions in detail.\"\n }), \"\\n\", _jsx(_components.p, {\n children: \"In the SQL below, the config function is used to name and describe the process in detail. Using jinja in this way allows metadata to be written directly in the SQL.\"\n }), \"\\n\", _jsx(CodeBlock, {\n filename: \"\",\n expandable: \"false\",\n children: _jsx(_components.pre, {\n className: \"language-sql\",\n children: _jsxs(_components.code, {\n className: \"language-sql\",\n children: [_jsx(_components.span, {\n className: \"\",\n children: \"{{\"\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\"\\tconfig\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"(\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\"\\t\\tname\", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"example_sql_cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \",\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\"\\t\\tdescription\", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"Example SQL cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \",\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\"\\t\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \")\"\n })]\n }), \"\\n\", _jsx(_components.span, {\n className: \"\",\n children: \"}}\"\n }), \"\\n\", \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"select\"\n }), \" \", _jsx(_components.span, {\n className: \"token operator\",\n children: \"*\"\n }), \" \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"from\"\n }), \" customers \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"limit\"\n }), \" \", _jsx(_components.span, {\n className: \"token number\",\n children: \"10\"\n })]\n }), \"\\n\"]\n })\n })\n }), \"\\n\", _jsx(Note, {\n children: _jsx(_components.p, {\n children: \"If the config function is undefined or not named by name, the sql file name is used as the name.\\nExample: example_sql_cell.sql, in which case example_sql_cell is used as the name.\"\n })\n }), \"\\n\", _jsx(Warning, {\n children: _jsx(_components.p, {\n children: \"In Morph, it is forbidden to write a semicolon at the end of SQL to prevent multiple SQLs in one SQL file. If you have written one, an error message will be displayed, so delete the semi-colon and run the program again.\"\n })\n }), \"\\n\", _jsx(_components.p, {\n children: \"For detailed config settings and other grammar rules, see the following detailed pages:\"\n }), \"\\n\", _jsx(CardGroup, {\n cols: 1,\n children: _jsx(Card, {\n title: \"Quick start: SQL\",\n href: \"/sql-python/en/sql/quickstart-sql\",\n children: _jsx(_components.p, {\n children: \"Describes how to run SQL on Morph.\"\n })\n })\n }), \"\\n\", _jsx(Heading, {\n level: \"3\",\n id: \"python\",\n children: \"Python\"\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"In Python files, functions can be registered as functions that can be executed on Morph by adding the annotation \", _jsx(_components.code, {\n children: \"@morph.func\"\n }), \" to the function. This mechanism allows Python files to contain and execute multiple functions in a single file.\"]\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"As with SQL, Python files can describe the name and description of a function by setting name and description to the arguments of this \", _jsx(_components.code, {\n children: \"@morph.func\"\n }), \" annotation.\"]\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"In addition, \", _jsx(_components.code, {\n children: \"@morph.load_data\"\n }), \" can be used to load the results of other SQL/Python executions directly into variables. The loaded variables can be referenced from within the \", _jsx(_components.code, {\n children: \"context\"\n }), \" argument.\\nIn the following example, the result of an SQL execution called example_sql_cell is read in by a Python function called example_python_cell, which returns the accessed result as is.\"]\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"The \", _jsx(_components.code, {\n children: \"context\"\n }), \" variable contains data in a dictionary type with the same name as the name of the read target.\"]\n }), \"\\n\", _jsx(CodeBlock, {\n filename: \"\",\n expandable: \"false\",\n children: _jsx(_components.pre, {\n className: \"language-python\",\n children: _jsxs(_components.code, {\n className: \"language-python\",\n children: [_jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"import\"\n }), \" pandas \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"as\"\n }), \" pd\"]\n }), \"\\n\", \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"import\"\n }), \" morph\"]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"from\"\n }), \" morph \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"import\"\n }), \" MorphGlobalContext\"]\n }), \"\\n\", \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsxs(_components.span, {\n className: \"token decorator annotation punctuation\",\n children: [\"@morph\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \".\"\n }), \"func\"]\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"(\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\" name\", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"example_python_cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \",\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\" description\", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"Example Python cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \",\"\n })]\n }), \"\\n\", _jsx(_components.span, {\n className: \"\",\n children: _jsx(_components.span, {\n className: \"token punctuation\",\n children: \")\"\n })\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsxs(_components.span, {\n className: \"token decorator annotation punctuation\",\n children: [\"@morph\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \".\"\n }), \"load_data\"]\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"(\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"example_sql_cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \")\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [_jsx(_components.span, {\n className: \"token keyword\",\n children: \"def\"\n }), \" \", _jsx(_components.span, {\n className: \"token function\",\n children: \"main\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"(\"\n }), \"context\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \":\"\n }), \" MorphGlobalContext\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \")\"\n }), \" \", _jsx(_components.span, {\n className: \"token operator\",\n children: \"-\"\n }), _jsx(_components.span, {\n className: \"token operator\",\n children: \"\u003e\"\n }), \" pd\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \".\"\n }), \"DataFrame\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \":\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\" sql_result_df \", _jsx(_components.span, {\n className: \"token operator\",\n children: \"=\"\n }), \" context\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \".\"\n }), \"data\", _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"[\"\n }), _jsx(_components.span, {\n className: \"token string\",\n children: \"\\\"example_sql_cell\\\"\"\n }), _jsx(_components.span, {\n className: \"token punctuation\",\n children: \"]\"\n })]\n }), \"\\n\", _jsxs(_components.span, {\n className: \"\",\n children: [\" \", _jsx(_components.span, {\n className: \"token keyword\",\n children: \"return\"\n }), \" sql_result_df\"]\n }), \"\\n\", \"\\n\"]\n })\n })\n }), \"\\n\", _jsx(Note, {\n children: _jsxs(_components.p, {\n children: [\"Python functions must always be given \", _jsx(_components.code, {\n children: \"@morph.func\"\n }), \", but arguments such as name are not required. If not specified, the function name is used as-is as the name.\"]\n })\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"For more information on convenience functions, including detailed settings for \", _jsx(_components.code, {\n children: \"@morph.func\"\n }), \" / \", _jsx(_components.code, {\n children: \"@morph.load_data\"\n }), \" and other annotations, see the details page below:\"]\n }), \"\\n\", _jsx(CardGroup, {\n cols: 1,\n children: _jsx(Card, {\n title: \"Quick start: Python\",\n href: \"/sql-python/en/python/quickstart-python\",\n children: _jsx(_components.p, {\n children: \"This section explains how to run Python on Morph.\"\n })\n })\n })]\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\nfunction _missingMdxReference(id, component) {\n throw new Error(\"Expected \" + (component ? \"component\" : \"object\") + \" `\" + id + \"` to be defined: you likely forgot to import, pass, or provide it.\");\n}\n","frontmatter":{},"scope":{"config":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"Docs","colors":{"primary":"#111827","light":"#d1d5db","dark":"#111827"},"favicon":"/favicon.svg","navigation":{"versions":[{"version":"English","tabs":[{"tab":"Guides","groups":[{"group":"Getting Started","pages":["docs/en/getting-started/why-morph","docs/en/getting-started/installation"]},{"group":"Quick Start","pages":["docs/en/quickstart/building-app",{"group":"How to Deploy","icon":"link","pages":["docs/en/quickstart/dashboard-setup","docs/en/quickstart/deploy"]}]},{"group":"Framework","pages":["docs/en/develop/guides/framework","docs/en/develop/guides/alias","docs/en/develop/guides/building-backend","docs/en/develop/guides/building-frontend","docs/en/develop/guides/environment-variables","docs/en/develop/guides/integration","docs/en/develop/guides/variables","docs/en/develop/guides/user-role","docs/en/develop/guides/updating-project"]},{"group":"Deployment","pages":["docs/en/deploy/customize-dockerfile","docs/en/deploy/environment-variables","docs/en/deploy/public"]},{"group":"Tutorials: Data Analysis","pages":["docs/en/develop/tutorials/pygwalker","docs/en/develop/tutorials/plotly"]},{"group":"Tutorials: LLM Apps","pages":["docs/en/develop/tutorials/chatbot","docs/en/develop/tutorials/chat_sidebyside"]},{"group":"Advanced","pages":["docs/en/advanced/api_key","docs/en/advanced/builtin-postgres","docs/en/advanced/migration-guide",{"group":"Connectors","icon":"plug","pages":["docs/en/advanced/connectors/mysql","docs/en/advanced/connectors/postgresql","docs/en/advanced/connectors/bigquery","docs/en/advanced/connectors/snowflake","docs/en/advanced/connectors/redshift","docs/en/advanced/connectors/mssql","docs/en/advanced/connectors/athena","docs/en/advanced/connectors/salesforce","docs/en/advanced/connectors/hubspot","docs/en/advanced/connectors/stripe","docs/en/advanced/connectors/linear","docs/en/advanced/connectors/airtable","docs/en/advanced/connectors/attio","docs/en/advanced/connectors/intercom","docs/en/advanced/connectors/notion","docs/en/advanced/connectors/mailchimp","docs/en/advanced/connectors/freee"]}]}]},{"tab":"Reference","groups":[{"group":"Framework","pages":["reference/en/framework/morph-project"]},{"group":"SQL","pages":["reference/en/sql/config","reference/en/sql/load_data"]},{"group":"Python","pages":["reference/en/python/morph-global-context","reference/en/python/morph-func","reference/en/python/morph-load_data","reference/en/python/morph-variables"]},{"group":"morph_lib","pages":[{"group":"AI","pages":["reference/en/morph_lib/ai/text_to_sql","reference/en/morph_lib/ai/text_to_plotly","reference/en/morph_lib/ai/text_to_matplotlib","reference/en/morph_lib/ai/text_to_markdown","reference/en/morph_lib/ai/text_to_html"]},{"group":"Database","pages":["reference/en/morph_lib/database/execute_sql","reference/en/morph_lib/database/insert_records","reference/en/morph_lib/database/update_records","reference/en/morph_lib/database/insert_or_update_records","reference/en/morph_lib/database/delete_records"]},{"group":"API","pages":["reference/en/morph_lib/api/get_auth_token"]},{"group":"Stream","pages":["reference/en/morph_lib/stream/create_chunk"]}]},{"group":"CLI","pages":["reference/en/cli-commands/version","reference/en/cli-commands/run","reference/en/cli-commands/compile","reference/en/cli-commands/clean","reference/en/cli-commands/init","reference/en/cli-commands/new","reference/en/cli-commands/config","reference/en/cli-commands/deploy","reference/en/cli-commands/serve","reference/en/cli-commands/context"]}]},{"tab":"Components","groups":[{"group":"AI Components","pages":["data-application/en/ai-component-chat","data-application/en/ai-component-llm"]},{"group":"Data Components","pages":["data-application/en/data-component-table","data-application/en/data-component-embed","data-application/en/data-component-metrics"]},{"group":"Input Components","pages":["data-application/en/input-component-input","data-application/en/input-component-date-picker","data-application/en/input-component-date-range-picker","data-application/en/input-component-select"]},{"group":"Layout Components","pages":["data-application/en/layout-component-accordion","data-application/en/layout-component-callout","data-application/en/layout-component-card","data-application/en/layout-component-grid","data-application/en/layout-component-panel"]},{"group":"State \u0026 Data","pages":["data-application/en/morph-data-state","data-application/en/advanced-morph-data-basic"]},{"group":"MDX Deep Dive","pages":["data-application/en/mdx/mdx-1-basic","data-application/en/mdx/mdx-2-styling","data-application/en/mdx/mdx-3-js"]},{"group":"Deprecated","pages":["data-application/en/morph-data-getjson","data-application/en/morph-data-variables"]}]},{"tab":"Troubleshooting","groups":[{"group":"Morph CLI","pages":["troubleshooting/en/cli/deployment-issues"]},{"group":"Support","pages":["troubleshooting/en/support/contact-support"]}]}]},{"version":"日本語","tabs":[{"tab":"Guides","groups":[{"group":"Getting Started","pages":["docs/ja/getting-started/why-morph","docs/ja/getting-started/installation"]},{"group":"クイックスタート","pages":["docs/ja/quickstart/building-app",{"group":"デプロイ手順","icon":"link","pages":["docs/ja/quickstart/dashboard-setup","docs/ja/quickstart/deploy"]}]},{"group":"フレームワーク","pages":["docs/ja/develop/guides/framework","docs/ja/develop/guides/alias","docs/ja/develop/guides/building-backend","docs/ja/develop/guides/building-frontend","docs/ja/develop/guides/environment-variables","docs/ja/develop/guides/integration","docs/ja/develop/guides/variables","docs/ja/develop/guides/user-role","docs/ja/develop/guides/updating-project"]},{"group":"デプロイ","pages":["docs/ja/deploy/customize-dockerfile","docs/ja/deploy/environment-variables","docs/ja/deploy/public"]},{"group":"チュートリアル: データ分析","pages":["docs/ja/develop/tutorials/pygwalker","docs/ja/develop/tutorials/plotly"]},{"group":"チュートリアル: AIアプリ","pages":["docs/ja/develop/tutorials/chatbot","docs/ja/develop/tutorials/chat_sidebyside"]},{"group":"Advanced","pages":["docs/ja/advanced/api_key","docs/ja/advanced/builtin-postgres","docs/ja/advanced/migration-guide",{"group":"Connectors","icon":"plug","pages":["docs/ja/advanced/connectors/mysql","docs/ja/advanced/connectors/postgresql","docs/ja/advanced/connectors/bigquery","docs/ja/advanced/connectors/snowflake","docs/ja/advanced/connectors/redshift","docs/ja/advanced/connectors/mssql","docs/ja/advanced/connectors/athena","docs/ja/advanced/connectors/salesforce","docs/ja/advanced/connectors/hubspot","docs/ja/advanced/connectors/stripe","docs/ja/advanced/connectors/linear","docs/ja/advanced/connectors/airtable","docs/ja/advanced/connectors/attio","docs/ja/advanced/connectors/intercom","docs/ja/advanced/connectors/notion","docs/ja/advanced/connectors/mailchimp","docs/ja/advanced/connectors/freee"]}]}]},{"tab":"Reference","groups":[{"group":"フレームワーク","pages":["reference/ja/framework/morph-project"]},{"group":"SQL","pages":["reference/ja/sql/config","reference/ja/sql/load_data"]},{"group":"Python","pages":["reference/ja/python/morph-global-context","reference/ja/python/morph-func","reference/ja/python/morph-load_data","reference/ja/python/morph-variables"]},{"group":"morph_lib","pages":[{"group":"AI","pages":["reference/ja/morph_lib/ai/text_to_sql","reference/ja/morph_lib/ai/text_to_plotly","reference/ja/morph_lib/ai/text_to_matplotlib","reference/ja/morph_lib/ai/text_to_markdown","reference/ja/morph_lib/ai/text_to_html"]},{"group":"Database","pages":["reference/ja/morph_lib/database/execute_sql","reference/ja/morph_lib/database/insert_records","reference/ja/morph_lib/database/update_records","reference/ja/morph_lib/database/insert_or_update_records","reference/ja/morph_lib/database/delete_records"]},{"group":"API","pages":["reference/ja/morph_lib/api/get_auth_token"]},{"group":"Stream","pages":["reference/ja/morph_lib/stream/create_chunk"]}]},{"group":"CLI","pages":["reference/ja/cli-commands/version","reference/ja/cli-commands/run","reference/ja/cli-commands/compile","reference/ja/cli-commands/clean","reference/ja/cli-commands/init","reference/ja/cli-commands/new","reference/ja/cli-commands/config","reference/ja/cli-commands/deploy","reference/ja/cli-commands/serve","reference/ja/cli-commands/context"]}]},{"tab":"Components","groups":[{"group":"AIコンポーネント","pages":["data-application/ja/ai-component-chat","data-application/ja/ai-component-llm"]},{"group":"データコンポーネント","pages":["data-application/ja/data-component-table","data-application/ja/data-component-embed","data-application/ja/data-component-metrics"]},{"group":"入力コンポーネント","pages":["data-application/ja/input-component-input","data-application/ja/input-component-date-picker","data-application/ja/input-component-date-range-picker","data-application/ja/input-component-select"]},{"group":"レイアウトコンポーネント","pages":["data-application/ja/layout-component-accordion","data-application/ja/layout-component-callout","data-application/ja/layout-component-card","data-application/ja/layout-component-grid","data-application/ja/layout-component-panel"]},{"group":"状態管理とデータ","pages":["data-application/ja/morph-data-state","data-application/ja/advanced-morph-data-basic"]},{"group":"MDX 詳解","pages":["data-application/ja/mdx/mdx-1-basic","data-application/ja/mdx/mdx-2-styling","data-application/ja/mdx/mdx-3-js"]},{"group":"廃止された仕様","pages":["data-application/ja/morph-data-getjson","data-application/ja/morph-data-variables"]}]},{"tab":"Troubleshooting","groups":[{"group":"Morph CLI","pages":["troubleshooting/ja/cli/deployment-issues"]},{"group":"サポート","pages":["troubleshooting/ja/support/contact-support"]}]}]}],"global":{"anchors":[{"anchor":"Changelog","href":"https://www.morph-data.io/changelog","icon":"rss"},{"anchor":"Connectors","href":"https://www.morph-data.io/tools/connectors/database","icon":"plug"},{"anchor":"Code Snippets","href":"https://www.morph-data.io/tools/snippets/undefined","icon":"brackets-curly"}]}},"styling":{"codeblocks":"dark"},"logo":{"light":"https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg.svg","dark":"https://mintlify.s3.us-west-1.amazonaws.com/queue-4c50ebb3/assets/images/morph_logo_svg_w.svg"},"navbar":{"links":[{"label":"Blog","href":"https://www.morphdb.io/blogs"}],"primary":{"type":"button","label":"Website","href":"https://www.morphdb.io"}},"footer":{"socials":{"x":"https://x.com/morphdbHQ","github":"https://github.com/useMorph","linkedin":"https://www.linkedin.com/company/morphdbhq"}}},"pageMetadata":{"title":"Build with SQL \u0026 Python","description":null,"href":"/docs/en/workspace/sql-python"}}},"gitSource":{"type":"github","owner":"morph-data","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true}},"__N_SSG":true},"page":"/_sites/[subdomain]/[[...slug]]","query":{"subdomain":"docs.morph-data.io","slug":["docs","en","workspace","sql-python"]},"buildId":"4bmdERr2JNq_C8xBoD2SZ","isFallback":false,"isExperimentalCompile":false,"gsp":true,"scriptLoader":[]}</script></html></body></html>