COPY … TO: writing a query result to object storage as files.
Recent deployment versions refuse COPY over the SQL endpoint with “COPY is not
supported”. On those, export a result by reading it through a Flight SQL client
or an SDK and writing the files from your application.
COPY (SELECT id, title FROM documents) TO 's3://bucket/export/' STORED AS PARQUET
Writes a query result to object storage. This is the export path when the
consumer is another engine rather than an application: results land as files
rather than streaming to a client.
What to read next
Insert
Bringing rows in, rather than exporting them.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"LanceDB","colors":{"primary":"#FF6B35","light":"#FF8A5C","dark":"#E55A2B"},"logo":{"light":"https://mintcdn.com/lancedb-bcbb4faf/6L0IRVkfdlgMU1Pw/static/assets/logo/dark-lancedb-logo.svg?fit=max\u0026auto=format\u0026n=6L0IRVkfdlgMU1Pw\u0026q=85\u0026s=d0592e59a29df2477080a857e13e341f","dark":"https://mintcdn.com/lancedb-bcbb4faf/t0AGunBr6LulGkIJ/static/assets/logo/light-lancedb-logo.svg?fit=max\u0026auto=format\u0026n=t0AGunBr6LulGkIJ\u0026q=85\u0026s=9b508fcb8d83cbc9bd05e57227d739e9","href":"https://lancedb.com"},"favicon":"https://mintcdn.com/lancedb-bcbb4faf/0sS6vrpmM3KSVyss/static/favicon.ico?fit=max\u0026auto=format\u0026n=0sS6vrpmM3KSVyss\u0026q=85\u0026s=84b9ea3dfc312b7a4dfc99219e229b33","appearance":{"strict":false},"background":{"color":{"light":"#FAF5F0","dark":"#000000"}},"navbar":{"links":[{"href":"https://www.lancedb.com/contact","label":"Support"}]},"footer":{"socials":{"github":"https://github.com/lancedb","linkedin":"https://www.linkedin.com/company/lancedb","x":"https://x.com/lancedb","discord":"https://discord.gg/AUEWnJ7Txb"},"links":[{"items":[{"label":"Cookie settings","href":"#cookie-settings"}]}]},"fonts":{"family":"Inter"},"styling":{"codeblocks":{"theme":{"light":"vitesse-light","dark":"catppuccin-mocha"}},"latex":true},"integrations":{"ga4":{"measurementId":"G-1TMC2PR69E"}},"banner":{"content":"[AI research has outgrown the modern data stack. We raised $57.5M to rebuild it. Read our Series B story →](https://www.lancedb.com/blog/lancedb-series-b-funding?utm_campaign=series-b-funding\u0026utm_content=docs\u0026utm_medium=lancedb\u0026utm_source=banner)","dismissible":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"lancedb-bcbb4faf","hasAudioNarration":false,"actualSubdomain":"lancedb-bcbb4faf","customDomains":["docs.lancedb.com"],"gitSource":{"type":"github","owner":"lancedb","repo":"docs","deployBranch":"assembled","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":"","_id":"6af512fe0902081a53d8698c"},"feedback":{"thumbs":true,"edits":false,"issues":false},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6b008022286e5a483262aeff","clientVersion":"0.0.4227","searchFilterCounts":[{"language":"default","tag":"Documentation","count":366},{"language":"default","tag":"Enterprise","count":343},{"language":"default","tag":"Embedded","count":340},{"language":"default","tag":"API Reference","count":113},{"language":"default","tag":"REST API","count":110},{"language":"default","tag":"Feature Engineering","count":90},{"language":"default","tag":"Table","count":88},{"language":"default","tag":"Integrations","count":84},{"language":"default","tag":"SQL Reference","count":80},{"language":"default","tag":"Geneva","count":68}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"static/styles/style.css","content":":root{--banner-left: #e4d8f8;--banner-right: #e55a2b}@font-face{font-family:\"LanceDB KaTeX AMS\";src:url(\"https://cdn.jsdelivr.net/npm/katex@0.16.0/dist/fonts/KaTeX_AMS-Regular.woff2\") format(\"woff2\");font-display:swap;font-style:normal;font-weight:400}.katex .mathbb,.katex .textbb{font-family:\"LanceDB KaTeX AMS\", \"KaTeX_AMS\", serif!important}#banner,:where(.banner,[data-banner],[class*=\"Banner_banner\"]){background:linear-gradient(90deg, var(--banner-left) 0%, var(--banner-right) 100%)!important;color:#1b0f09!important;border:none!important}#banner a,:where(.banner,[data-banner],[class*=\"Banner_banner\"]) a{color:#1b0f09!important;font-size:0.9rem;font-weight:500;text-decoration-color:rgba(27, 15, 9, 0.35)}#banner button,:where(.banner,[data-banner],[class*=\"Banner_banner\"]) button{color:#1b0f09!important}"}]}
{"page":{"pagePath":"enterprise/v1-13-0/sql/dml/copy","slug":"/enterprise/v1-13-0/sql/dml/copy","pageMetadata":{"title":"Copy","sidebarTitle":"Copy","description":"COPY ... TO: writing a query result to object storage as files.","icon":"file-export","keywords":["copy","export","parquet","sql"],"href":"/enterprise/v1-13-0/sql/dml/copy"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"COPY … TO: writing a query result to object storage as files.\"\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};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,pre:`pre`,span:`span`,..._provideComponents(),...props.components},{Card,CodeBlock,CodeGroup,Heading,Warning}=_components;if(!Card)_missingMdxReference(`Card`,true);if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!CodeGroup)_missingMdxReference(`CodeGroup`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Warning,{children:_jsxs(_components.p,{children:[`Recent deployment versions refuse `,_jsx(_components.code,{children:`COPY`}),` over the SQL endpoint with “COPY is not\nsupported”. On those, export a result by reading it through a Flight SQL client\nor an SDK and writing the files from your application.`]})}),`\n`,_jsx(CodeGroup,{children:_jsx(CodeBlock,{filename:`SQL`,icon:`database`,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes vitesse-light catppuccin-mocha`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#1e1e2e`,color:`#393a34`,\"--shiki-dark\":`#cdd6f4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1E754F`,\"--shiki-dark\":`#CBA6F7`},children:`COPY`}),_jsx(_components.span,{style:{color:`#393A34`,\"--shiki-dark\":`#CDD6F4`},children:` (`}),_jsx(_components.span,{style:{color:`#1E754F`,\"--shiki-dark\":`#CBA6F7`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#393A34`,\"--shiki-dark\":`#CDD6F4`},children:` id, title `}),_jsx(_components.span,{style:{color:`#1E754F`,\"--shiki-dark\":`#CBA6F7`},children:`FROM`}),_jsx(_components.span,{style:{color:`#393A34`,\"--shiki-dark\":`#CDD6F4`},children:` documents) `}),_jsx(_components.span,{style:{color:`#1E754F`,\"--shiki-dark\":`#CBA6F7`},children:`TO`}),_jsx(_components.span,{style:{color:`#B5695977`,\"--shiki-dark\":`#A6E3A1`},children:` '`}),_jsx(_components.span,{style:{color:`#B56959`,\"--shiki-dark\":`#A6E3A1`},children:`s3://bucket/export/`}),_jsx(_components.span,{style:{color:`#B5695977`,\"--shiki-dark\":`#A6E3A1`},children:`'`}),_jsx(_components.span,{style:{color:`#393A34`,\"--shiki-dark\":`#CDD6F4`},children:` STORED `}),_jsx(_components.span,{style:{color:`#1E754F`,\"--shiki-dark\":`#CBA6F7`},children:`AS`}),_jsx(_components.span,{style:{color:`#1E754F`,\"--shiki-dark\":`#CBA6F7`},children:` PARQUET`})]}),`\n`]})})})}),`\n`,_jsx(_components.p,{children:`Writes a query result to object storage. This is the export path when the\nconsumer is another engine rather than an application: results land as files\nrather than streaming to a client.`}),`\n`,_jsx(Heading,{level:`2`,id:`next`,children:`What to read next`}),`\n`,_jsx(Card,{title:`Insert`,icon:`plus`,href:`/enterprise/v1-13-0/sql/dml/insert`,children:_jsx(_components.p,{children:`Bringing rows in, rather than exporting them.`})})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"codeStyling":{"theme":{"light":"vitesse-light","dark":"catppuccin-mocha"}},"config":{},"pageMetadata":{"title":"Copy","sidebarTitle":"Copy","description":"COPY ... TO: writing a query result to object storage as files.","icon":"file-export","keywords":["copy","export","parquet","sql"],"href":"/enterprise/v1-13-0/sql/dml/copy"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"What to read next","slug":"next","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/lancedb-bcbb4faf/17e8f66511a11582/static/scripts/cookie-consent.js"],"subdomain":"lancedb-bcbb4faf","siteName":"LanceDB","title":"Copy - LanceDB","navMaps":{"firstHrefInVersion":{"1.14.0":{"href":"/enterprise/v1-14-0/sql/dml/copy","matchLevel":1},"1.13.0":{"href":"/enterprise/v1-13-0/sql/dml/copy","matchLevel":0},"1.12.0":{"href":"/enterprise/v1-12-0/sql/dml/copy","matchLevel":1},"0.41.0":{"href":"/oss/v0-41-0","matchLevel":4}},"firstHrefInLanguage":{}},"lastModified":"2026-11-20T17:15:46.505Z","originalFileLocation":"enterprise/v1-13-0/sql/dml/copy.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"COPY ... TO: writing a query result to object storage as files.\">\u003cmeta data-mint-head name=\"application-name\" content=\"LanceDB\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Copy - LanceDB\">\u003cmeta data-mint-head property=\"og:description\" content=\"COPY ... TO: writing a query result to object storage as files.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"LanceDB\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://lancedb-bcbb4faf.mintlify.site/_mintlify/api/og/v2?division=DML\u0026amp;title=Copy\u0026amp;description=COPY+...+TO%3A+writing+a+query+result+to+object+storage+as+files.\u0026amp;theme=9d8045ca9469df4ceece463f\u0026amp;signature=744ee963a3f4dc7b46795ac40a48f347bf9822d38d5896d84f7c680d2a5cb235\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Copy - LanceDB\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"COPY ... TO: writing a query result to object storage as files.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://lancedb-bcbb4faf.mintlify.site/_mintlify/api/og/v2?division=DML\u0026amp;title=Copy\u0026amp;description=COPY+...+TO%3A+writing+a+query+result+to+object+storage+as+files.\u0026amp;theme=9d8045ca9469df4ceece463f\u0026amp;signature=744ee963a3f4dc7b46795ac40a48f347bf9822d38d5896d84f7c680d2a5cb235\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/lancedb-bcbb4faf/AJCI1CXWoYDPZbb4/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"LanceDB\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#FF6B35\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/enterprise/v1-13-0/sql/dml/copy.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.lancedb.com/#organization\",\"name\":\"LanceDB\",\"url\":\"https://docs.lancedb.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/lancedb-bcbb4faf/6L0IRVkfdlgMU1Pw/static/assets/logo/dark-lancedb-logo.svg?fit=max\u0026auto=format\u0026n=6L0IRVkfdlgMU1Pw\u0026q=85\u0026s=d0592e59a29df2477080a857e13e341f\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.lancedb.com#website\",\"name\":\"LanceDB\",\"url\":\"https://docs.lancedb.com\",\"publisher\":{\"@id\":\"https://docs.lancedb.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy#webpage\",\"url\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy\",\"name\":\"Copy\",\"description\":\"COPY ... TO: writing a query result to object storage as files.\",\"dateModified\":\"2026-11-20T17:15:46.505Z\",\"isPartOf\":{\"@id\":\"https://docs.lancedb.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SQL Reference\",\"item\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DML\",\"item\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/insert\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Copy\",\"item\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy#article\",\"headline\":\"Copy\",\"name\":\"Copy\",\"description\":\"COPY ... TO: writing a query result to object storage as files.\",\"url\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy\",\"mainEntityOfPage\":{\"@id\":\"https://docs.lancedb.com/enterprise/v1-13-0/sql/dml/copy#webpage\"},\"dateModified\":\"2026-11-20T17:15:46.505Z\",\"keywords\":\"copy, export, parquet, sql\",\"publisher\":{\"@id\":\"https://docs.lancedb.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.lancedb.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"LanceDB\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"LanceDB\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/enterprise/v1-13-0/sql/dml/copy.md","siteName":"LanceDB","nav":{"global":null,"products":[{"product":"Enterprise","icon":"server","description":"Multimodal lakehouse","versions":[{"version":"1.14.0","default":true,"tag":"Latest","pages":[{"title":"1.14.0","href":"/enterprise/v1-14-0/sql/dml/copy"}]},{"version":"1.13.0","tabs":[{"tab":"Documentation","groups":[{"group":"Introduction","pages":[{"title":"LanceDB","sidebarTitle":"LanceDB","icon":"https://mintlify.s3.us-west-1.amazonaws.com/lancedb-bcbb4faf/enterprise/v1-13-0/static/assets/logo/lancedb-icon-gray.svg","href":"/enterprise/v1-13-0"},{"title":"LanceDB Embedded","sidebarTitle":"LanceDB Embedded","icon":"cube","href":"/enterprise/v1-13-0/basics/lancedb-embedded"},{"title":"LanceDB Enterprise","sidebarTitle":"LanceDB Enterprise","icon":"server","href":"/enterprise/v1-13-0/enterprise/index"},{"title":"Embedded vs Enterprise","sidebarTitle":"Embedded vs Enterprise","icon":"scale-balanced","href":"/enterprise/v1-13-0/basics/embedded-vs-enterprise"},{"title":"About this version","icon":"circle-info","href":"/enterprise/v1-13-0/about-this-version"}]},{"group":"Getting Started","pages":[{"title":"Quickstart","sidebarTitle":"Quickstart","icon":"rocket","href":"/enterprise/v1-13-0/quickstart"},{"title":"SDKs","sidebarTitle":"SDKs","icon":"code-compare","href":"/enterprise/v1-13-0/basics/sdk"},{"title":"SQL","sidebarTitle":"SQL","icon":"table-list","href":"/enterprise/v1-13-0/basics/sql"},{"title":"Console","sidebarTitle":"Console","icon":"window","href":"/enterprise/v1-13-0/enterprise/console"},{"title":"Import a Hugging Face dataset","icon":"file-import","href":"/enterprise/v1-13-0/enterprise/sql-hugging-face"},{"title":"Agentic skills","sidebarTitle":"Agentic Skills","icon":"robot","href":"/enterprise/v1-13-0/basics/agentic-skills"},{"title":"Support","sidebarTitle":"Support","icon":"circle-question","href":"/enterprise/v1-13-0/deployment/support"}]},{"group":"Concepts","pages":[{"title":"Lance format","sidebarTitle":"Lance Format","icon":"https://mintlify.s3.us-west-1.amazonaws.com/lancedb-bcbb4faf/enterprise/v1-13-0/static/assets/logo/lance-logo-gray.png","href":"/enterprise/v1-13-0/basics/lance"},{"title":"LanceDB Lakehouse","sidebarTitle":"LanceDB Lakehouse","icon":"sitemap","href":"/enterprise/v1-13-0/basics/catalog"},{"title":"Job Framework","sidebarTitle":"Job Framework","icon":"hourglass-half","href":"/enterprise/v1-13-0/basics/jobs"},{"title":"Realtime Engine (RTE)","sidebarTitle":"Realtime Engine (RTE)","icon":"bolt","href":"/enterprise/v1-13-0/tables/realtime-engine"},{"title":"Consistency","sidebarTitle":"Consistency","icon":"water","href":"/enterprise/v1-13-0/tables/consistency"},{"title":"Guarantees","sidebarTitle":"Guarantees","icon":"shield-check","href":"/enterprise/v1-13-0/basics/guarantees"},{"title":"Limits","sidebarTitle":"Limits","icon":"ruler","href":"/enterprise/v1-13-0/basics/limits"},{"title":"Naming rules","sidebarTitle":"Naming Rules","icon":"signature","href":"/enterprise/v1-13-0/basics/naming"}]},{"group":"Data Ingestion","pages":[{"title":"Ingesting data","sidebarTitle":"Overview","icon":"inbox","href":"/enterprise/v1-13-0/ingestion/index"},{"title":"Creating a table","sidebarTitle":"Create Table","icon":"table","href":"/enterprise/v1-13-0/ingestion/create-table"},{"title":"Insert data","sidebarTitle":"Insert","icon":"plus","href":"/enterprise/v1-13-0/ingestion/insert"},{"title":"Update rows","sidebarTitle":"Update","icon":"pen","href":"/enterprise/v1-13-0/ingestion/update"},{"title":"Delete rows","sidebarTitle":"Delete","icon":"trash","href":"/enterprise/v1-13-0/ingestion/delete"},{"title":"RTE Write (Upsert)","sidebarTitle":"RTE Write (Upsert)","icon":"bolt","href":"/enterprise/v1-13-0/ingestion/realtime-write"},{"title":"Define Storage Integration","sidebarTitle":"Define Storage Integration","icon":"cloud","href":"/enterprise/v1-13-0/ingestion/define-storage-integration"},{"title":"Attach Database","sidebarTitle":"Attach Database","icon":"plug","href":"/enterprise/v1-13-0/ingestion/attach-database"},{"title":"Import Datasets","sidebarTitle":"Import Datasets","icon":"file-import","href":"/enterprise/v1-13-0/ingestion/import"},{"title":"Distributed Write","sidebarTitle":"Distributed Write","icon":"upload","href":"/enterprise/v1-13-0/enterprise/distributed-write"},{"title":"Distributed RTE Write","sidebarTitle":"Distributed RTE Write","icon":"bolt","href":"/enterprise/v1-13-0/enterprise/distributed-real-time-write"}]},{"group":"Search","pages":[{"title":"Search","sidebarTitle":"Overview","icon":"list","href":"/enterprise/v1-13-0/search/index"},{"title":"Vector Search","sidebarTitle":"Vector Search","icon":"arrow-up-right-dots","href":"/enterprise/v1-13-0/search/vector-search"},{"title":"Full-Text Search (FTS)","sidebarTitle":"Full-Text Search (FTS)","icon":"book","href":"/enterprise/v1-13-0/search/full-text-search"},{"title":"Hybrid Search","sidebarTitle":"Hybrid Search","icon":"search","href":"/enterprise/v1-13-0/search/hybrid-search"},{"title":"Metadata Filtering in LanceDB","sidebarTitle":"Filtering","icon":"filter","href":"/enterprise/v1-13-0/search/filtering"},{"title":"Reranking Search Results","sidebarTitle":"Reranking","icon":"sort-amount-down","href":"/enterprise/v1-13-0/reranking/index"},{"title":"RTE reads","sidebarTitle":"RTE Read","icon":"magnifying-glass","href":"/enterprise/v1-13-0/search/realtime-read"},{"title":"Distributed RTE Read","sidebarTitle":"Distributed RTE Read","icon":"network-wired","href":"/enterprise/v1-13-0/enterprise/distributed-real-time-read"},{"title":"Distributed Search","sidebarTitle":"Distributed Search","icon":"network-wired","href":"/enterprise/v1-13-0/enterprise/distributed-search"},{"title":"Data Page Cache","sidebarTitle":"Data Page Cache","icon":"database","href":"/enterprise/v1-13-0/enterprise/data-page-cache"},{"title":"Tiered Index Cache","sidebarTitle":"Tiered Index Cache","icon":"layer-group","href":"/enterprise/v1-13-0/enterprise/tiered-index-cache"},{"title":"Cache Prewarm","sidebarTitle":"Cache Prewarm","icon":"fire","href":"/enterprise/v1-13-0/enterprise/cache-prewarm"}]},{"group":"Data Curation","pages":[{"title":"Data curation","sidebarTitle":"Overview","icon":"filter","href":"/enterprise/v1-13-0/curation/index"},{"title":"Inspect Datasets","sidebarTitle":"Inspect Datasets","icon":"database","href":"/enterprise/v1-13-0/curation/inspect-datasets"},{"title":"Create a Function","tag":"Early access","sidebarTitle":"Create Function","icon":"code","href":"/enterprise/v1-13-0/curation/create-function"},{"title":"Choose how to compute a column","sidebarTitle":"Function authoring guidance","icon":"file-code","tag":"Early access","href":"/enterprise/v1-13-0/enterprise/function-authoring"},{"title":"Operate Function workloads","sidebarTitle":"Function Operations","icon":"gears","tag":"Early access","href":"/enterprise/v1-13-0/enterprise/function-operations"},{"title":"Function worker availability","sidebarTitle":"Function Workers","icon":"server","tag":"Early access","href":"/enterprise/v1-13-0/enterprise/deployment/function-workers"},{"title":"Chunk records into multiple rows","sidebarTitle":"Chunking","icon":"diagram-subtask","href":"/enterprise/v1-13-0/curation/chunking"},{"title":"Statistical Sampling","sidebarTitle":"Statistical Sampling","icon":"dice","href":"/enterprise/v1-13-0/curation/statistical-sampling"},{"title":"Selective Sampling","sidebarTitle":"Selective Sampling","icon":"crosshairs","href":"/enterprise/v1-13-0/curation/selective-sampling"},{"title":"Profiling a dataset","sidebarTitle":"Aggregate","icon":"chart-column","href":"/enterprise/v1-13-0/curation/aggregate"},{"title":"Joining datasets","sidebarTitle":"Join","icon":"link","href":"/enterprise/v1-13-0/curation/join"},{"title":"Blob Late Materialization","sidebarTitle":"Blob Late Materialization","icon":"clock","href":"/enterprise/v1-13-0/curation/blob-late-materialization"},{"title":"Distributed Shuffle","sidebarTitle":"Distributed Shuffle","icon":"shuffle","href":"/enterprise/v1-13-0/curation/distributed-shuffle"},{"title":"Ranking","sidebarTitle":"Ranking","icon":"chart-simple","href":"/enterprise/v1-13-0/curation/windowing"},{"title":"Cluster records by index partition","sidebarTitle":"Clustering","icon":"circle-nodes","href":"/enterprise/v1-13-0/curation/clustering"},{"title":"Deduplicate near-duplicate records","sidebarTitle":"Dedupe","icon":"clone","href":"/enterprise/v1-13-0/curation/dedupe"},{"title":"Scope curation to what changed","sidebarTitle":"Changes","icon":"clock-rotate-left","href":"/enterprise/v1-13-0/curation/changes"},{"title":"Create a view","sidebarTitle":"Create View","icon":"eye","href":"/enterprise/v1-13-0/feature-engineering/view"},{"title":"Vend a Secret to a Function","tag":"Early access","sidebarTitle":"Vend Secret","icon":"key","href":"/enterprise/v1-13-0/curation/vend-secret"},{"title":"Download S3 objects with a Function","icon":"cloud-arrow-down","tag":"Early access","href":"/enterprise/v1-13-0/enterprise/function-s3-download"},{"title":"Use Secrets with Python Functions","sidebarTitle":"Secrets walkthrough","icon":"key","tag":"Early access","href":"/enterprise/v1-13-0/enterprise/function-secrets"}]},{"group":"Feature Engineering","pages":[{"title":"Feature engineering","sidebarTitle":"Overview","icon":"layer-group","href":"/enterprise/v1-13-0/feature-engineering/index"},{"title":"Create a computed column","sidebarTitle":"Create Computed Column","icon":"table-columns","href":"/enterprise/v1-13-0/feature-engineering/add-computed-column"},{"title":"Refresh a computed column","sidebarTitle":"Refresh Computed Column","icon":"arrows-rotate","href":"/enterprise/v1-13-0/feature-engineering/refresh-column"},{"title":"Create a materialized view","sidebarTitle":"Create Materialized View","icon":"table","href":"/enterprise/v1-13-0/feature-engineering/materialized-views"},{"title":"Refresh a materialized view","sidebarTitle":"Refresh Materialized View","icon":"arrows-rotate","href":"/enterprise/v1-13-0/feature-engineering/refresh-materialized-view"},{"title":"Incremental Refresh","sidebarTitle":"Incremental Refresh","icon":"arrow-rotate-right","href":"/enterprise/v1-13-0/enterprise/incremental-refresh"},{"title":"Auto Refresh","sidebarTitle":"Auto Refresh","icon":"clock-rotate-left","href":"/enterprise/v1-13-0/enterprise/auto-refresh"},{"title":"Function Refresh Checkpointing","tag":"Early access","sidebarTitle":"Checkpointing","icon":"floppy-disk","href":"/enterprise/v1-13-0/enterprise/checkpointing"},{"title":"Adaptive Execution","tag":"Early access","sidebarTitle":"Adaptive Execution","icon":"gauge-high","href":"/enterprise/v1-13-0/enterprise/adaptive-execution"},{"group":"Geneva","icon":"layer-group","pages":[{"title":"Multimodal Feature Engineering with Geneva","sidebarTitle":"Overview","icon":"layer-group","href":"/enterprise/v1-13-0/geneva/index"},{"title":"What is Feature Engineering?","sidebarTitle":"What is feature engineering?","icon":"grip-horizontal","href":"/enterprise/v1-13-0/geneva/overview/index"},{"title":"Getting Started","sidebarTitle":"Getting Started","icon":"rocket","href":"/enterprise/v1-13-0/geneva/getting-started"},{"group":"Transforms","pages":[{"title":"Understanding Transforms","sidebarTitle":"Understanding Transforms","icon":"code-compare","href":"/enterprise/v1-13-0/geneva/udfs/index"},{"title":"User-Defined Functions (UDFs)","sidebarTitle":"UDFs","icon":"function","href":"/enterprise/v1-13-0/geneva/udfs/udfs"},{"title":"Chunkers (Scalar UDTFs)","sidebarTitle":"Chunkers","icon":"diagram-subtask","href":"/enterprise/v1-13-0/geneva/udfs/scalar-udtfs"},{"title":"Batch User-Defined Table Functions (UDTFs)","sidebarTitle":"Batch UDTFs","icon":"layer-group","href":"/enterprise/v1-13-0/geneva/udfs/batch-udtfs"},{"title":"Error Handling in Geneva UDFs","sidebarTitle":"Error Handling","icon":"exclamation","href":"/enterprise/v1-13-0/geneva/udfs/error_handling"},{"title":"Profiling Stateful UDF Memory","sidebarTitle":"Profiling Memory","icon":"chart-line","href":"/enterprise/v1-13-0/geneva/udfs/profiling-memory"},{"title":"Blob Types in Geneva UDFs","sidebarTitle":"Blobs","icon":"splotch","href":"/enterprise/v1-13-0/geneva/udfs/blobs"}]},{"group":"Built-in Transforms","pages":[{"title":"Built-in LLM and Embedding UDFs","sidebarTitle":"Overview","icon":"sparkles","href":"/enterprise/v1-13-0/geneva/udfs/providers/index"},{"title":"OpenAI","sidebarTitle":"OpenAI","icon":"brain","href":"/enterprise/v1-13-0/geneva/udfs/providers/openai"},{"title":"Gemini","sidebarTitle":"Gemini","icon":"google","href":"/enterprise/v1-13-0/geneva/udfs/providers/gemini"},{"title":"Sentence Transformers","sidebarTitle":"Sentence Transformers","icon":"microchip","href":"/enterprise/v1-13-0/geneva/udfs/providers/sentence-transformers"}]},{"group":"Running Jobs","pages":[{"title":"Geneva Jobs","sidebarTitle":"Job execution","href":"/enterprise/v1-13-0/geneva/jobs/index"},{"title":"Backfilling","sidebarTitle":"Backfilling","icon":"fill","href":"/enterprise/v1-13-0/geneva/jobs/backfilling"},{"title":"Bulk Loading \u0026 Updating Columns","sidebarTitle":"Bulk Load / Update Columns","icon":"columns-3","href":"/enterprise/v1-13-0/geneva/jobs/bulk-load-columns"},{"title":"Materialized Views with UDFs","sidebarTitle":"Materialized views","icon":"microscope","href":"/enterprise/v1-13-0/geneva/jobs/materialized-views"},{"title":"Advanced Job Configuration","sidebarTitle":"Advanced job configuration","icon":"sliders","href":"/enterprise/v1-13-0/geneva/jobs/advanced-job-configuration"},{"title":"Job Lifecycle","sidebarTitle":"Job Lifecycle","icon":"arrows-spin","href":"/enterprise/v1-13-0/geneva/jobs/lifecycle"},{"title":"Backfill Conflicts","sidebarTitle":"Backfill Conflicts","icon":"code-merge","href":"/enterprise/v1-13-0/geneva/jobs/conflicts"},{"title":"Distributed Job Performance and Cluster Sizing","sidebarTitle":"Performance and Sizing","icon":"chart-line","href":"/enterprise/v1-13-0/geneva/jobs/performance"},{"title":"Job Metrics (Diagnostics)","sidebarTitle":"Job Metrics","icon":"chart-simple","href":"/enterprise/v1-13-0/geneva/jobs/job_metrics"},{"title":"Geneva Console","sidebarTitle":"Console","icon":"computer","href":"/enterprise/v1-13-0/geneva/jobs/console"},{"title":"Troubleshooting Geneva Jobs","sidebarTitle":"Job troubleshooting","icon":"wrench","href":"/enterprise/v1-13-0/geneva/jobs/troubleshooting"},{"title":"Advanced Execution Contexts","sidebarTitle":"Advanced execution contexts","icon":"circle-nodes","href":"/enterprise/v1-13-0/geneva/jobs/contexts"}]},{"group":"Deployment","pages":[{"title":"Deploy Geneva using Helm","sidebarTitle":"Helm Deployment","icon":"cogs","href":"/enterprise/v1-13-0/geneva/deployment/helm"},{"title":"Job and Session Startup Optimizations","sidebarTitle":"Startup optimizations","icon":"engine","href":"/enterprise/v1-13-0/geneva/jobs/startup"},{"title":"Dependency Verification","sidebarTitle":"Dependency Verification","icon":"magnifying-glass-chart","href":"/enterprise/v1-13-0/geneva/deployment/dependency-verification"},{"title":"Advanced Configuration","sidebarTitle":"Advanced Configuration","icon":"flask-gear","href":"/enterprise/v1-13-0/geneva/udfs/advanced-configuration"},{"title":"Manual Deployment on Kubernetes","sidebarTitle":"Manual Deployment","icon":"cogs","href":"/enterprise/v1-13-0/geneva/deployment/index"},{"title":"Troubleshooting Geneva Deployments","sidebarTitle":"Deployment Troubleshooting","icon":"question-circle","href":"/enterprise/v1-13-0/geneva/deployment/troubleshooting"}]},{"title":"End-to-End Example","sidebarTitle":"End-to-end example","icon":"play","href":"/enterprise/v1-13-0/geneva/end-to-end"},{"title":"Geneva Python SDK","icon":"python","href":"/enterprise/v1-13-0/geneva/reference"}]}]},{"group":"Training","pages":[{"title":"PyTorch Data Loader","sidebarTitle":"PyTorch Data Loader","icon":"boxes-stacked","href":"/enterprise/v1-13-0/training/data-loading"},{"title":"Training Cache","sidebarTitle":"Training Cache","icon":"gauge-high","href":"/enterprise/v1-13-0/training/training-cache"},{"title":"Permutation","sidebarTitle":"Permutation","icon":"shuffle","href":"/enterprise/v1-13-0/training/permutation"},{"title":"Observability","sidebarTitle":"Observability","icon":"gauge","href":"/enterprise/v1-13-0/training/observability"},{"title":"Distributed Training","sidebarTitle":"Distributed Training","icon":"server","href":"/enterprise/v1-13-0/training/distributed-training"},{"title":"Checkpointing","sidebarTitle":"Checkpointing","icon":"floppy-disk","href":"/enterprise/v1-13-0/training/checkpointing"},{"title":"Resuming","sidebarTitle":"Resuming","icon":"rotate-left","href":"/enterprise/v1-13-0/training/resuming"}]},{"group":"Management","pages":[{"title":"Management","sidebarTitle":"Overview","icon":"folder-tree","href":"/enterprise/v1-13-0/management/index"},{"title":"Catalog","sidebarTitle":"Catalog","icon":"sitemap","href":"/enterprise/v1-13-0/management/catalog"},{"title":"Database","sidebarTitle":"Database","icon":"database","href":"/enterprise/v1-13-0/management/database"},{"title":"Namespaces","sidebarTitle":"Namespace","icon":"folder-tree","href":"/enterprise/v1-13-0/management/namespace"},{"title":"Tables","sidebarTitle":"Table","icon":"table","href":"/enterprise/v1-13-0/management/table"},{"title":"Compress Function output columns","icon":"compress","href":"/enterprise/v1-13-0/enterprise/function-column-compression"},{"title":"Views","sidebarTitle":"View","icon":"eye","href":"/enterprise/v1-13-0/management/view"},{"title":"Materialized view","sidebarTitle":"Materialized View","icon":"table","href":"/enterprise/v1-13-0/management/materialized-view"},{"title":"Secret","tag":"Early access","sidebarTitle":"Secret","icon":"key","href":"/enterprise/v1-13-0/management/secret"},{"title":"Functions","tag":"Early access","sidebarTitle":"Function","icon":"code","href":"/enterprise/v1-13-0/management/function"},{"title":"Handle Function failures","sidebarTitle":"Function Failures","icon":"triangle-exclamation","tag":"Early access","href":"/enterprise/v1-13-0/management/function-failures"},{"title":"Storage Integration","sidebarTitle":"Storage Integration","icon":"cloud","href":"/enterprise/v1-13-0/management/storage-integration"}]},{"group":"Maintenance","pages":[{"title":"Indexing Data","sidebarTitle":"Overview","icon":"list","href":"/enterprise/v1-13-0/indexing/index"},{"title":"Intelligent Auto-Maintenance","sidebarTitle":"Intelligent Auto-Maintenance","icon":"brain","href":"/enterprise/v1-13-0/enterprise/intelligent-auto-maintenance"},{"title":"Vector Indexing","sidebarTitle":"Vector Indexing","icon":"arrow-up-right-dots","href":"/enterprise/v1-13-0/indexing/vector-index"},{"title":"Full-Text Search (FTS) Indexing","sidebarTitle":"FTS Indexing","icon":"book","href":"/enterprise/v1-13-0/indexing/fts-index"},{"title":"Scalar Indexing","sidebarTitle":"Scalar Indexing","icon":"tree","href":"/enterprise/v1-13-0/indexing/scalar-index"},{"title":"Incremental Indexing","sidebarTitle":"Incremental Indexing","icon":"refresh","href":"/enterprise/v1-13-0/indexing/incremental-indexing"},{"title":"Distributed Indexing","sidebarTitle":"Distributed Indexing","icon":"layer-group","href":"/enterprise/v1-13-0/enterprise/distributed-indexing"},{"title":"GPU Indexing","sidebarTitle":"GPU Indexing","icon":"microchip","href":"/enterprise/v1-13-0/indexing/gpu-indexing"},{"title":"Compaction and cleanup","sidebarTitle":"Compaction","icon":"broom","href":"/enterprise/v1-13-0/maintenance/compaction"},{"title":"Realtime Engine compaction","sidebarTitle":"RTE Compaction","icon":"compress","href":"/enterprise/v1-13-0/enterprise/realtime-engine-compaction"},{"title":"Distributed Compaction","sidebarTitle":"Distributed Compaction","icon":"compress","href":"/enterprise/v1-13-0/enterprise/distributed-compaction"},{"title":"Advanced Conflict Resolution","sidebarTitle":"Advanced Conflict Resolution","icon":"shuffle","href":"/enterprise/v1-13-0/enterprise/advanced-conflict-resolution"},{"title":"Garbage Collection","sidebarTitle":"Garbage Collection","icon":"broom","href":"/enterprise/v1-13-0/maintenance/cleanup"}]},{"group":"Security","pages":[{"title":"Authentication","sidebarTitle":"Authentication","icon":"key","href":"/enterprise/v1-13-0/enterprise/authentication"},{"title":"Authorization","sidebarTitle":"Authorization","icon":"shield-halved","href":"/enterprise/v1-13-0/governance/authorization"},{"title":"Principals","sidebarTitle":"Principals","icon":"user","href":"/enterprise/v1-13-0/governance/principals"},{"title":"Privileges","sidebarTitle":"Privileges","icon":"key","href":"/enterprise/v1-13-0/governance/privileges"},{"title":"Audit Log","sidebarTitle":"Audit Log","icon":"clipboard-list","href":"/enterprise/v1-13-0/governance/audit-log"},{"title":"Compliance","sidebarTitle":"Compliance","icon":"shield-alt","href":"/enterprise/v1-13-0/enterprise/security"}]},{"group":"Deployment","pages":[{"title":"Horizontal Scaling","sidebarTitle":"Horizontal Scaling","icon":"arrows-left-right","href":"/enterprise/v1-13-0/enterprise/horizontal-scaling"},{"title":"Monitor LanceDB with OpenTelemetry","sidebarTitle":"OpenTelemetry","icon":"chart-line","href":"/enterprise/v1-13-0/deployment/opentelemetry"},{"title":"Kubernetes deployment guide","sidebarTitle":"Kubernetes","icon":"cloud","href":"/enterprise/v1-13-0/enterprise/deployment/kubernetes"},{"title":"Multicloud","sidebarTitle":"Multicloud","icon":"cloud","href":"/enterprise/v1-13-0/deployment/multicloud"},{"title":"Slurm","sidebarTitle":"Slurm","icon":"server","href":"/enterprise/v1-13-0/deployment/slurm"}]},{"group":"SQL Reference","pages":[{"title":"SQL reference","sidebarTitle":"Overview","icon":"table-list","href":"/enterprise/v1-13-0/sql/index"},{"title":"SQL identifiers and strings","sidebarTitle":"Identifier quoting","icon":"code","href":"/enterprise/v1-13-0/sql/identifiers"},{"title":"Catalog listing pagination","icon":"list-ol","href":"/enterprise/v1-13-0/sql/pagination"},{"title":"SQL data types","sidebarTitle":"Data Types","icon":"shapes","href":"/enterprise/v1-13-0/sql/data-types"},{"group":"DDL","icon":"sitemap","pages":[{"title":"Database","sidebarTitle":"Database","icon":"database","href":"/enterprise/v1-13-0/sql/ddl/database"},{"title":"Namespace","sidebarTitle":"Namespace","icon":"folder-tree","href":"/enterprise/v1-13-0/sql/ddl/namespace"},{"title":"Table","sidebarTitle":"Table","icon":"table","href":"/enterprise/v1-13-0/sql/ddl/table"},{"title":"View","sidebarTitle":"View","icon":"eye","href":"/enterprise/v1-13-0/sql/ddl/view"},{"title":"Materialized View","sidebarTitle":"Materialized View","icon":"table","href":"/enterprise/v1-13-0/sql/ddl/materialized-view"},{"title":"Secret","tag":"Early access","sidebarTitle":"Secret","icon":"key","href":"/enterprise/v1-13-0/sql/ddl/secret"},{"title":"Function","tag":"Early access","sidebarTitle":"Function","icon":"function","href":"/enterprise/v1-13-0/sql/ddl/function"},{"title":"Storage Integration","sidebarTitle":"Storage Integration","icon":"cloud","href":"/enterprise/v1-13-0/sql/ddl/storage-integration"},{"title":"Index","sidebarTitle":"Index","icon":"bolt","href":"/enterprise/v1-13-0/sql/ddl/index"},{"title":"Job","sidebarTitle":"Job","icon":"hourglass-half","href":"/enterprise/v1-13-0/sql/ddl/job"},{"title":"Grant","sidebarTitle":"Grant","icon":"user-lock","href":"/enterprise/v1-13-0/sql/ddl/grant"}]},{"group":"DML","icon":"database","pages":[{"title":"Insert","sidebarTitle":"Insert","icon":"plus","href":"/enterprise/v1-13-0/sql/dml/insert"},{"title":"Update","sidebarTitle":"Update","icon":"pen","href":"/enterprise/v1-13-0/sql/dml/update"},{"title":"Delete","sidebarTitle":"Delete","description":"DELETE FROM ... WHERE: rows are marked, not erased.","icon":"trash","href":"/enterprise/v1-13-0/sql/dml/delete"},{"title":"Copy","sidebarTitle":"Copy","icon":"file-export","href":"/enterprise/v1-13-0/sql/dml/copy"},{"title":"REFRESH COLUMN","sidebarTitle":"REFRESH COLUMN","description":"Fill computed outputs and select rows to recompute.","icon":"arrows-rotate","href":"/enterprise/v1-13-0/sql/dml/refresh-column"},{"title":"REFRESH MATERIALIZED VIEW","sidebarTitle":"REFRESH MATERIALIZED VIEW","icon":"arrows-rotate","href":"/enterprise/v1-13-0/sql/dml/refresh-materialized-view"},{"title":"REFRESH","sidebarTitle":"REFRESH","icon":"arrows-rotate","href":"/enterprise/v1-13-0/sql/dml/refresh"}]},{"group":"DQL","icon":"filter","pages":[{"title":"SELECT","sidebarTitle":"SELECT","icon":"table-columns","href":"/enterprise/v1-13-0/sql/dql/select"},{"title":"Subqueries","sidebarTitle":"Subqueries","icon":"code-branch","href":"/enterprise/v1-13-0/sql/dql/subqueries"},{"title":"Joins","sidebarTitle":"Joins","icon":"link","href":"/enterprise/v1-13-0/sql/dql/join"},{"title":"Operators and literals","sidebarTitle":"Operators","icon":"plus-minus","href":"/enterprise/v1-13-0/sql/dql/operators"},{"title":"Functions","sidebarTitle":"Functions","icon":"function","href":"/enterprise/v1-13-0/sql/dql/functions"},{"title":"Enterprise SQL function index","sidebarTitle":"Enterprise functions","icon":"square-root-variable","href":"/enterprise/v1-13-0/sql-reference/functions-all"},{"title":"Scalar functions","sidebarTitle":"Scalar Functions","icon":"calculator","href":"/enterprise/v1-13-0/sql/dql/scalar-functions"},{"title":"Aggregation","sidebarTitle":"Aggregation","icon":"layer-group","href":"/enterprise/v1-13-0/sql/dql/aggregation"},{"title":"Window functions","sidebarTitle":"Window Functions","icon":"chart-simple","href":"/enterprise/v1-13-0/sql/dql/window"},{"title":"Random sampling","sidebarTitle":"Sampling","icon":"dice","href":"/enterprise/v1-13-0/sql/dql/sampling"},{"title":"Changes since a version","sidebarTitle":"Changes","icon":"clock-rotate-left","href":"/enterprise/v1-13-0/sql/dql/changes"},{"title":"Full-Text Search","sidebarTitle":"Full-Text Search","icon":"magnifying-glass","href":"/enterprise/v1-13-0/sql/dql/fts"},{"title":"CONTAINS_TOKENS","sidebarTitle":"CONTAINS_TOKENS","icon":"magnifying-glass","href":"/enterprise/v1-13-0/sql/dql/contains-tokens"},{"title":"IVF_PARTITION","sidebarTitle":"IVF_PARTITION","icon":"circle-nodes","href":"/enterprise/v1-13-0/sql/dql/ivf-partition"},{"title":"DEDUPE","sidebarTitle":"DEDUPE","icon":"layer-group","href":"/enterprise/v1-13-0/sql/dql/dedupe"},{"title":"DUPLICATE_PAIRS","sidebarTitle":"DUPLICATE_PAIRS","icon":"clone","href":"/enterprise/v1-13-0/sql/dql/duplicate-pairs"},{"title":"MinHash SQL functions","href":"/enterprise/v1-13-0/enterprise/sql-minhash"},{"title":"Vector distance functions","sidebarTitle":"Vector Distance","icon":"ruler","href":"/enterprise/v1-13-0/sql/dql/vector-distance"},{"title":"BLOB_DESCRIPTOR","sidebarTitle":"BLOB_DESCRIPTOR","icon":"file-binary","href":"/enterprise/v1-13-0/sql/dql/blob-descriptor"},{"title":"GENERATE_SERIES","sidebarTitle":"GENERATE_SERIES","icon":"list-ol","href":"/enterprise/v1-13-0/sql/dql/generate-series"},{"title":"Explain","sidebarTitle":"Explain","icon":"map","href":"/enterprise/v1-13-0/sql/dql/explain"}]}]}]},{"tab":"Integrations","pages":[{"title":"Integrations","href":"/enterprise/v1-13-0/integrations"}]},{"tab":"Tutorials","pages":[{"title":"Tutorials","href":"/enterprise/v1-13-0/tutorials"}]},{"tab":"Demos","pages":[{"title":"Demos","href":"/enterprise/v1-13-0/demos"}]},{"tab":"Datasets","pages":[{"title":"Datasets","href":"/enterprise/v1-13-0/datasets"}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/enterprise/v1-13-0/api-reference/rest"}]}]},{"version":"1.12.0","pages":[{"title":"1.12.0","href":"/enterprise/v1-12-0/sql/dml/copy"}]}]},{"product":"Embedded","icon":"database","description":"Open-source library","pages":[{"title":"Embedded","href":"/oss/v0-41-0"}]}]},"basePath":"","title":"Copy - LanceDB","deploymentId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","buildId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","dynamics":["10e4515597"],"chunks":["BannerMarkdown-DnSAhvaM.js","dist-DIfYWxfm.js","lib-DMeTj1gb.js","lib-B8HbPgcC.js","katex-Dbtb6Wk7.js","html-void-elements-mCSPHezU.js","marked.esm-CZWythHk.js"]}