The table's Arrow schema as a base64-encoded Arrow IPC stream carrying
only the schema message. Exactly one of schema or schema_ipc is
required. Carries any Arrow type the engine accepts, nested included,
short of the two the hosted service holds every declaration to: a
column whose values allocate more than 16384 bytes each even when
null, and a type the engine cannot write (a union, a dictionary of a
view type, a map whose entries are not a key/value pair).
Response
Table created.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Infino","description":"Infino is an open-source retrieval engine for full-text, vector, and SQL search, with your data stored as Apache Parquet on object storage.","colors":{"primary":"#d24011","light":"#e8623a","dark":"#d24011"},"logo":{"light":"https://mintcdn.com/infino-29/sXqDYmwcZ7BW4kvO/logo/infino-logo.png?fit=max\u0026auto=format\u0026n=sXqDYmwcZ7BW4kvO\u0026q=85\u0026s=6bf8ba5e6249a14bb302a90e30e5e18f","dark":"https://mintcdn.com/infino-29/sXqDYmwcZ7BW4kvO/logo/infino-logo.png?fit=max\u0026auto=format\u0026n=sXqDYmwcZ7BW4kvO\u0026q=85\u0026s=6bf8ba5e6249a14bb302a90e30e5e18f","href":"https://infino.ai"},"favicon":"https://mintcdn.com/infino-29/LrgKEC9MS1pd7XX7/favicon.png?fit=max\u0026auto=format\u0026n=LrgKEC9MS1pd7XX7\u0026q=85\u0026s=e08bd7081efa9de5d611ea206ba6e46c","navbar":{"links":[{"href":"https://infino.ai","label":"Home"},{"href":"https://infino.ai/vs","label":"Compare"},{"href":"https://infino.ai/cloud","label":"Infino Cloud"},{"href":"https://github.com/infino-ai/infino","label":"GitHub"}],"primary":{"type":"button","label":"Talk to us","href":"mailto:info@infino.ai"}},"footer":{"socials":{"github":"https://github.com/infino-ai/infino"},"links":[{"header":"Resources","items":[{"label":"GitHub","href":"https://github.com/infino-ai/infino"},{"label":"Issues","href":"https://github.com/infino-ai/infino/issues"}]}]},"search":{"prompt":"Search the Infino docs…"},"seo":{"metatags":{"canonical":"https://infino.ai/docs","og:site_name":"Infino","og:type":"website","og:image":"/images/og-card.png","twitter:card":"summary_large_image","twitter:image":"/images/og-card.png"},"indexing":"all"},"fonts":{"family":"Inter"},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"metadata":{"timestamp":true},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"infino-29","hasAudioNarration":false,"actualSubdomain":"infino-29","customDomains":["infino.ai"],"gitSource":{"type":"github","owner":"infino-ai","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"chroma":{"collectionId":"3b327719-300a-4e6d-9a77-2f4c2319b6e0","liveDeploymentHistoryId":"6ae435a8492eee9d6caa8294","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ae435a8492eee9d6caa8294"},"feedback":{"agentFeedback":true,"thumbs":true},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6ae435a8492eee9d6caa8294","clientVersion":"0.0.4064","searchFilterCounts":[{"language":"default","tag":"Documentation","count":25},{"language":"default","tag":"API Reference","count":21},{"language":"default","tag":"REST API","count":18},{"language":"default","tag":"Infino Cloud","count":9},{"language":"default","tag":"Guides","count":9},{"language":"default","tag":"Search","count":7},{"language":"default","tag":"Reference","count":4},{"language":"default","tag":"Databases","count":4},{"language":"default","tag":"Tables","count":4},{"language":"default","tag":"SDKs \u0026 CLI","count":3}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","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":"llms-txt-v2","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":"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":"vite-origin","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":"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}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"api-reference/tables/create-a-table","slug":"/api-reference/tables/create-a-table","pageMetadata":{"title":"Create a table","description":"Create a table with an Arrow schema and optional full-text and vector indexes.","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/create_table/{database}","href":"/api-reference/tables/create-a-table","autogeneratedByOpenApi":true},"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: \"Create a table with an Arrow schema and optional full-text and vector indexes.\"\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}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){return _jsx(_Fragment,{})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Create a table","description":"Create a table with an Arrow schema and optional full-text and vector indexes.","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/create_table/{database}","href":"/api-reference/tables/create-a-table","autogeneratedByOpenApi":true}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/infino-29/645d308d2f9fae79/structured-data.js","/docs/_mintlify/custom/infino-29/ec3d5239f2e7ff69/same-tab-links.js","/docs/_mintlify/custom/infino-29/cf391a6d1558677e/context7-widget.js"],"openApiReferenceData":{"operation":{"tags":["Tables"],"summary":"Create a table","description":"Create a table with an Arrow schema and optional full-text and vector indexes.","operationId":"create_table","parameters":["8e7cb1e2-90aa-437e-b29b-5d17f7a60fa7"],"requestBody":"d89799e7-a334-481e-810d-1ccf6dd1deb0","responses":{"200":"502c16ab-329f-4aa9-a240-7f4e8d460776","400":"b9a7c95a-389b-4e43-aaf3-a7b8a985ae79","401":"bf25777b-a00e-444d-a52c-95a936e25f81","409":"afe58a77-6807-4a4b-9145-f0dd9d313bb1","503":"b8eef9cf-e385-4dbc-b2b0-d72a2bb2ca65"},"security":["5fb6c634-17fc-437c-8fb4-2587582d1b35"],"method":"post","type":"path","servers":["4bd2e530-edac-43c7-abc9-75b50312caec"],"path":"/v1/create_table/{database}","baseUrlOptions":["https://api.platform.infino.ws"],"title":"Create a table","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{"8e7cb1e2-90aa-437e-b29b-5d17f7a60fa7":{"name":"database","in":"path","description":"Target database.","required":true,"schema":{"type":"string","isRequired":true,"description":"Target database.","uniqueKey":"","typeLabel":"string"}}},"requestBody":{"content":{"application/json":{"schema":{"type":"object","description":"`POST /v1/create_table/{database}`.","required":["table_name"],"properties":{"table_name":{"type":"string","isRequired":true,"uniqueKey":"table_name","typeLabel":"string"},"indexes":{"oneOf":[{"type":"null","uniqueKey":"indexes.oneOf.0","typeLabel":"null"},{"type":"object","description":"Index declarations for `create_table`.","properties":{"fts":{"oneOf":[{"type":"array","items":{"oneOf":[{"type":"string","description":"One entry in `indexes.fts`. Either a bare column name — which uses the\nengine defaults — or an options object that sets them explicitly. The bare-string\nform keeps clients that send `\"fts\": [\"body\"]` working unchanged. Options\napply per column, not per table.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.0","typeLabel":"string"},{"type":"object","description":"One entry in `indexes.fts`. Either a bare column name — which uses the\nengine defaults — or an options object that sets them explicitly. The bare-string\nform keeps clients that send `\"fts\": [\"body\"]` working unchanged. Options\napply per column, not per table.","required":["column"],"properties":{"column":{"type":"string","isRequired":true,"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.column","typeLabel":"string"},"analyzer":{"oneOf":[{"type":"string","description":"Analyzer name. `\"standard\"` — the Unicode-aware UAX #29 tokenizer —\nis the only analyzer, and what an omitted field means; any other name\nis refused.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.analyzer.oneOf.0","typeLabel":"string"},{"type":"null","description":"Analyzer name. `\"standard\"` — the Unicode-aware UAX #29 tokenizer —\nis the only analyzer, and what an omitted field means; any other name\nis refused.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.analyzer.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.analyzer","typeLabel":"string | null"},"b":{"oneOf":[{"type":"number","format":"float","description":"BM25 length normalization for this column. Omitted means the engine\ndefault. Must be given together with `k1`.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.b.oneOf.0","typeLabel":"number\u003cfloat>"},{"type":"null","format":"float","description":"BM25 length normalization for this column. Omitted means the engine\ndefault. Must be given together with `k1`.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.b.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.b","typeLabel":"number\u003cfloat> | null"},"k1":{"oneOf":[{"type":"number","format":"float","description":"BM25 term-frequency saturation for this column. Omitted means the\nengine default. Must be given together with `b`: the two interact\nthrough the length norm, so half a pair scores with a combination\nthe caller never chose.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.k1.oneOf.0","typeLabel":"number\u003cfloat>"},{"type":"null","format":"float","description":"BM25 term-frequency saturation for this column. Omitted means the\nengine default. Must be given together with `b`: the two interact\nthrough the length norm, so half a pair scores with a combination\nthe caller never chose.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.k1.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.k1","typeLabel":"number\u003cfloat> | null"},"positions":{"oneOf":[{"type":"boolean","description":"Record token positions, which exact phrase queries (`\"climate\npolicy\"`) need. Omitted means the engine default, `false`. Positions\nroughly double the column's full-text index, so they are a per-column\nopt-in. A column without them answers a phrase query with an error\nnaming the column, never a bag-of-words fallback. Recorded with the\ntable; it cannot be changed afterwards.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.positions.oneOf.0","typeLabel":"boolean"},{"type":"null","description":"Record token positions, which exact phrase queries (`\"climate\npolicy\"`) need. Omitted means the engine default, `false`. Positions\nroughly double the column's full-text index, so they are a per-column\nopt-in. A column without them answers a phrase query with an error\nnaming the column, never a bag-of-words fallback. Recorded with the\ntable; it cannot be changed afterwards.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.positions.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.positions","typeLabel":"boolean | null"},"stemmer":{"oneOf":[{"type":"string","description":"Stemmer applied at index and query time (`\"english\"`). Omitted means\nnone. Recorded with the table; it cannot be changed afterwards.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stemmer.oneOf.0","typeLabel":"string"},{"type":"null","description":"Stemmer applied at index and query time (`\"english\"`). Omitted means\nnone. Recorded with the table; it cannot be changed afterwards.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stemmer.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stemmer","typeLabel":"string | null"},"stopwords":{"oneOf":[{"type":"string","description":"Stopword set removed at index and query time (`\"english\"`). Omitted\nmeans none. Recorded with the table; it cannot be changed afterwards.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stopwords.oneOf.0","typeLabel":"string"},{"type":"null","description":"Stopword set removed at index and query time (`\"english\"`). Omitted\nmeans none. Recorded with the table; it cannot be changed afterwards.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stopwords.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stopwords","typeLabel":"string | null"},"stored":{"oneOf":[{"type":"boolean","description":"Whether the raw text is kept in the table. Omitted means the engine\ndefault, `true`. `false` declares an index-only column: the text is\nsearchable (BM25, token and phrase matching) but never stored, so it\ncannot be read back — not in SQL results, not in a search projection,\nnot in predicates. `append` and `update` batches still carry the\ncolumn; it is dropped at write time.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stored.oneOf.0","typeLabel":"boolean"},{"type":"null","description":"Whether the raw text is kept in the table. Omitted means the engine\ndefault, `true`. `false` declares an index-only column: the text is\nsearchable (BM25, token and phrase matching) but never stored, so it\ncannot be read back — not in SQL results, not in a search projection,\nnot in predicates. `append` and `update` batches still carry the\ncolumn; it is dropped at write time.","uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stored.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1.stored","typeLabel":"boolean | null"}},"additionalProperties":false,"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX].oneOf.1","typeLabel":"object"}],"uniqueKey":"indexes.oneOf.1.fts.oneOf.0.items.[INDEX]","typeLabel":"string | object"},"description":"FTS index declarations — a bare column name (engine defaults) or an\noptions object per column (see [`FtsColumn`]).","uniqueKey":"indexes.oneOf.1.fts.oneOf.0","typeLabel":"(string | object)[]"},{"type":"null","items":{"oneOf":[{"type":"string","description":"One entry in `indexes.fts`. Either a bare column name — which uses the\nengine defaults — or an options object that sets them explicitly. The bare-string\nform keeps clients that send `\"fts\": [\"body\"]` working unchanged. Options\napply per column, not per table."},{"type":"object","description":"One entry in `indexes.fts`. Either a bare column name — which uses the\nengine defaults — or an options object that sets them explicitly. The bare-string\nform keeps clients that send `\"fts\": [\"body\"]` working unchanged. Options\napply per column, not per table.","required":["column"],"properties":{"analyzer":{"oneOf":[{"type":"string","description":"Analyzer name. `\"standard\"` — the Unicode-aware UAX #29 tokenizer —\nis the only analyzer, and what an omitted field means; any other name\nis refused."},{"type":"null","description":"Analyzer name. `\"standard\"` — the Unicode-aware UAX #29 tokenizer —\nis the only analyzer, and what an omitted field means; any other name\nis refused."}]},"b":{"oneOf":[{"type":"number","format":"float","description":"BM25 length normalization for this column. Omitted means the engine\ndefault. Must be given together with `k1`."},{"type":"null","format":"float","description":"BM25 length normalization for this column. Omitted means the engine\ndefault. Must be given together with `k1`."}]},"column":{"type":"string"},"k1":{"oneOf":[{"type":"number","format":"float","description":"BM25 term-frequency saturation for this column. Omitted means the\nengine default. Must be given together with `b`: the two interact\nthrough the length norm, so half a pair scores with a combination\nthe caller never chose."},{"type":"null","format":"float","description":"BM25 term-frequency saturation for this column. Omitted means the\nengine default. Must be given together with `b`: the two interact\nthrough the length norm, so half a pair scores with a combination\nthe caller never chose."}]},"positions":{"oneOf":[{"type":"boolean","description":"Record token positions, which exact phrase queries (`\"climate\npolicy\"`) need. Omitted means the engine default, `false`. Positions\nroughly double the column's full-text index, so they are a per-column\nopt-in. A column without them answers a phrase query with an error\nnaming the column, never a bag-of-words fallback. Recorded with the\ntable; it cannot be changed afterwards."},{"type":"null","description":"Record token positions, which exact phrase queries (`\"climate\npolicy\"`) need. Omitted means the engine default, `false`. Positions\nroughly double the column's full-text index, so they are a per-column\nopt-in. A column without them answers a phrase query with an error\nnaming the column, never a bag-of-words fallback. Recorded with the\ntable; it cannot be changed afterwards."}]},"stemmer":{"oneOf":[{"type":"string","description":"Stemmer applied at index and query time (`\"english\"`). Omitted means\nnone. Recorded with the table; it cannot be changed afterwards."},{"type":"null","description":"Stemmer applied at index and query time (`\"english\"`). Omitted means\nnone. Recorded with the table; it cannot be changed afterwards."}]},"stopwords":{"oneOf":[{"type":"string","description":"Stopword set removed at index and query time (`\"english\"`). Omitted\nmeans none. Recorded with the table; it cannot be changed afterwards."},{"type":"null","description":"Stopword set removed at index and query time (`\"english\"`). Omitted\nmeans none. Recorded with the table; it cannot be changed afterwards."}]},"stored":{"oneOf":[{"type":"boolean","description":"Whether the raw text is kept in the table. Omitted means the engine\ndefault, `true`. `false` declares an index-only column: the text is\nsearchable (BM25, token and phrase matching) but never stored, so it\ncannot be read back — not in SQL results, not in a search projection,\nnot in predicates. `append` and `update` batches still carry the\ncolumn; it is dropped at write time."},{"type":"null","description":"Whether the raw text is kept in the table. Omitted means the engine\ndefault, `true`. `false` declares an index-only column: the text is\nsearchable (BM25, token and phrase matching) but never stored, so it\ncannot be read back — not in SQL results, not in a search projection,\nnot in predicates. `append` and `update` batches still carry the\ncolumn; it is dropped at write time."}]}},"additionalProperties":false}]},"description":"FTS index declarations — a bare column name (engine defaults) or an\noptions object per column (see [`FtsColumn`]).","uniqueKey":"indexes.oneOf.1.fts.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.fts","typeLabel":"(string | object)[] | null"},"vector":{"oneOf":[{"type":"array","items":{"type":"object","description":"One vector index declaration under `indexes.vector`.","required":["column","metric"],"properties":{"column":{"type":"string","isRequired":true,"uniqueKey":"indexes.oneOf.1.vector.oneOf.0.items.[INDEX].column","typeLabel":"string"},"metric":{"type":"string","description":"Vector distance metric. Accepted case-insensitively, with the aliases\n`l2` → `l2sq` and `dot` → `negdot`; serialized canonically.","enum":["cosine","l2sq","negdot"],"isRequired":true,"uniqueKey":"indexes.oneOf.1.vector.oneOf.0.items.[INDEX].metric","typeLabel":"enum\u003cstring>"},"dim":{"oneOf":[{"type":"integer","description":"Redundant with the schema column's declared width; the server resolves\nthe dimension from the schema, so this is optional and, if given, must\nagree.","minimum":0,"uniqueKey":"indexes.oneOf.1.vector.oneOf.0.items.[INDEX].dim.oneOf.0","typeLabel":"integer"},{"type":"null","description":"Redundant with the schema column's declared width; the server resolves\nthe dimension from the schema, so this is optional and, if given, must\nagree.","minimum":0,"uniqueKey":"indexes.oneOf.1.vector.oneOf.0.items.[INDEX].dim.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.vector.oneOf.0.items.[INDEX].dim","typeLabel":"integer | null"}},"additionalProperties":false,"uniqueKey":"indexes.oneOf.1.vector.oneOf.0.items.[INDEX]","typeLabel":"object"},"description":"Vector index declarations.","uniqueKey":"indexes.oneOf.1.vector.oneOf.0","typeLabel":"object[]"},{"type":"null","items":{"type":"object","description":"One vector index declaration under `indexes.vector`.","required":["column","metric"],"properties":{"column":{"type":"string"},"dim":{"oneOf":[{"type":"integer","description":"Redundant with the schema column's declared width; the server resolves\nthe dimension from the schema, so this is optional and, if given, must\nagree.","minimum":0},{"type":"null","description":"Redundant with the schema column's declared width; the server resolves\nthe dimension from the schema, so this is optional and, if given, must\nagree.","minimum":0}]},"metric":{"type":"string","description":"Vector distance metric. Accepted case-insensitively, with the aliases\n`l2` → `l2sq` and `dot` → `negdot`; serialized canonically.","enum":["cosine","l2sq","negdot"]}},"additionalProperties":false},"description":"Vector index declarations.","uniqueKey":"indexes.oneOf.1.vector.oneOf.1","typeLabel":"null"}],"uniqueKey":"indexes.oneOf.1.vector","typeLabel":"object[] | null"}},"additionalProperties":false,"uniqueKey":"indexes.oneOf.1","typeLabel":"object"}],"uniqueKey":"indexes","typeLabel":"null | object"},"schema":{"oneOf":[{"type":"array","items":{"type":"object","description":"One column in a `create_table` schema. A scalar column is `{name, type}` where `type` is one of `\"utf8\"`, `\"large_utf8\"`, `\"bool\"`, `\"i32\"`, `\"i64\"`, `\"u32\"`, `\"u64\"`, `\"f32\"`, `\"f64\"`, `\"date32\"`, `\"date64\"`, or a timezone-naive timestamp with its unit: `\"timestamp_s\"`, `\"timestamp_ms\"` (also `\"timestamp\"`), `\"timestamp_us\"`, `\"timestamp_ns\"`. A vector column is `{name, type: \"vector\", dim}`; a list column is `{name, type: \"list\", item}`. `dim` is required for `\"vector\"` and `item` for `\"list\"`. The `schema` endpoint describes every column in this same vocabulary, but what it returns is a superset of what this form accepts: a zoned timestamp carries `tz`, a decimal is `{type: \"decimal\", precision, scale}`, a struct is `{type: \"struct\", fields}`, a map is `{type: \"map\", key, value}`, and a list whose element is itself nested spells `item` as an object rather than a name. Declare any of those with `schema_ipc`, and do not hand a described column of one of those types back to `create_table` unchanged — the extra keys are rejected.","required":["name","type"],"properties":{"name":{"type":"string","description":"Column name.","isRequired":true,"uniqueKey":"schema.oneOf.0.items.[INDEX].name","typeLabel":"string"},"type":{"type":"string","description":"Scalar spelling (`\"i32\"`, `\"large_utf8\"`, `\"date32\"`, `\"timestamp_ms\"`, …),\nor `\"vector\"` / `\"list\"`.","isRequired":true,"uniqueKey":"schema.oneOf.0.items.[INDEX].type","typeLabel":"string"},"dim":{"oneOf":[{"type":"integer","description":"Fixed length, required for `type: \"vector\"`. Must be in [1, 4096].","maximum":4096,"minimum":1,"uniqueKey":"schema.oneOf.0.items.[INDEX].dim.oneOf.0","typeLabel":"integer"},{"type":"null","description":"Fixed length, required for `type: \"vector\"`. Must be in [1, 4096].","maximum":4096,"minimum":1,"uniqueKey":"schema.oneOf.0.items.[INDEX].dim.oneOf.1","typeLabel":"null"}],"uniqueKey":"schema.oneOf.0.items.[INDEX].dim","typeLabel":"integer | null"},"item":{"oneOf":[{"type":"string","description":"Element scalar type, required for `type: \"list\"`.","uniqueKey":"schema.oneOf.0.items.[INDEX].item.oneOf.0","typeLabel":"string"},{"type":"null","description":"Element scalar type, required for `type: \"list\"`.","uniqueKey":"schema.oneOf.0.items.[INDEX].item.oneOf.1","typeLabel":"null"}],"uniqueKey":"schema.oneOf.0.items.[INDEX].item","typeLabel":"string | null"},"nullable":{"oneOf":[{"type":"boolean","description":"Defaults to `true` when omitted.","uniqueKey":"schema.oneOf.0.items.[INDEX].nullable.oneOf.0","typeLabel":"boolean"},{"type":"null","description":"Defaults to `true` when omitted.","uniqueKey":"schema.oneOf.0.items.[INDEX].nullable.oneOf.1","typeLabel":"null"}],"uniqueKey":"schema.oneOf.0.items.[INDEX].nullable","typeLabel":"boolean | null"}},"additionalProperties":false,"uniqueKey":"schema.oneOf.0.items.[INDEX]","typeLabel":"object"},"description":"JSON column descriptors. Exactly one of `schema` or `schema_ipc` is\nrequired. Cannot express nested types; use `schema_ipc` for those.","uniqueKey":"schema.oneOf.0","typeLabel":"object[]"},{"type":"null","items":{"type":"object","description":"One column in a `create_table` schema. A scalar column is `{name, type}` where `type` is one of `\"utf8\"`, `\"large_utf8\"`, `\"bool\"`, `\"i32\"`, `\"i64\"`, `\"u32\"`, `\"u64\"`, `\"f32\"`, `\"f64\"`, `\"date32\"`, `\"date64\"`, or a timezone-naive timestamp with its unit: `\"timestamp_s\"`, `\"timestamp_ms\"` (also `\"timestamp\"`), `\"timestamp_us\"`, `\"timestamp_ns\"`. A vector column is `{name, type: \"vector\", dim}`; a list column is `{name, type: \"list\", item}`. `dim` is required for `\"vector\"` and `item` for `\"list\"`. The `schema` endpoint describes every column in this same vocabulary, but what it returns is a superset of what this form accepts: a zoned timestamp carries `tz`, a decimal is `{type: \"decimal\", precision, scale}`, a struct is `{type: \"struct\", fields}`, a map is `{type: \"map\", key, value}`, and a list whose element is itself nested spells `item` as an object rather than a name. Declare any of those with `schema_ipc`, and do not hand a described column of one of those types back to `create_table` unchanged — the extra keys are rejected.","required":["name","type"],"properties":{"dim":{"oneOf":[{"type":"integer","description":"Fixed length, required for `type: \"vector\"`. Must be in [1, 4096].","maximum":4096,"minimum":1},{"type":"null","description":"Fixed length, required for `type: \"vector\"`. Must be in [1, 4096].","maximum":4096,"minimum":1}]},"item":{"oneOf":[{"type":"string","description":"Element scalar type, required for `type: \"list\"`."},{"type":"null","description":"Element scalar type, required for `type: \"list\"`."}]},"name":{"type":"string","description":"Column name."},"nullable":{"oneOf":[{"type":"boolean","description":"Defaults to `true` when omitted."},{"type":"null","description":"Defaults to `true` when omitted."}]},"type":{"type":"string","description":"Scalar spelling (`\"i32\"`, `\"large_utf8\"`, `\"date32\"`, `\"timestamp_ms\"`, …),\nor `\"vector\"` / `\"list\"`."}},"additionalProperties":false},"description":"JSON column descriptors. Exactly one of `schema` or `schema_ipc` is\nrequired. Cannot express nested types; use `schema_ipc` for those.","uniqueKey":"schema.oneOf.1","typeLabel":"null"}],"uniqueKey":"schema","typeLabel":"object[] | null"},"schema_ipc":{"oneOf":[{"type":"string","description":"The table's Arrow schema as a base64-encoded Arrow IPC stream carrying\nonly the schema message. Exactly one of `schema` or `schema_ipc` is\nrequired. Carries any Arrow type the engine accepts, nested included,\nshort of the two the hosted service holds every declaration to: a\ncolumn whose values allocate more than 16384 bytes each even when\nnull, and a type the engine cannot write (a union, a dictionary of a\nview type, a map whose entries are not a key/value pair).","uniqueKey":"schema_ipc.oneOf.0","typeLabel":"string"},{"type":"null","description":"The table's Arrow schema as a base64-encoded Arrow IPC stream carrying\nonly the schema message. Exactly one of `schema` or `schema_ipc` is\nrequired. Carries any Arrow type the engine accepts, nested included,\nshort of the two the hosted service holds every declaration to: a\ncolumn whose values allocate more than 16384 bytes each even when\nnull, and a type the engine cannot write (a union, a dictionary of a\nview type, a map whose entries are not a key/value pair).","uniqueKey":"schema_ipc.oneOf.1","typeLabel":"null"}],"uniqueKey":"schema_ipc","typeLabel":"string | null"}},"additionalProperties":false,"uniqueKey":"","typeLabel":"object"},"examples":{"Example":{"title":"Example","value":{"table_name":"\u003cstring>","indexes":{"fts":["\u003cstring>"],"vector":[{"column":"\u003cstring>","dim":1}]},"schema":[{"name":"\u003cstring>","type":"\u003cstring>","dim":2048,"item":"\u003cstring>","nullable":true}],"schema_ipc":"\u003cstring>"}}},"exampleType":"generated"}},"required":true,"exampleType":"generated"},"responses":{"502c16ab-329f-4aa9-a240-7f4e8d460776":{"description":"Table created.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"b9a7c95a-389b-4e43-aaf3-a7b8a985ae79":{"description":"Invalid request body, or a malformed table name — use non-empty [A-Za-z0-9_-], at most 128 characters, not starting with '_'.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"bf25777b-a00e-444d-a52c-95a936e25f81":{"description":"Missing or invalid API key.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"afe58a77-6807-4a4b-9145-f0dd9d313bb1":{"description":"Either the table name already exists — terminal, pick another name — or another catalog change was in flight, so this one was not applied. Every table in a database is created through one catalog. The second case carries a `Retry-After`; reissue the identical request after it.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"b8eef9cf-e385-4dbc-b2b0-d72a2bb2ca65":{"description":"The database's workers are still activating, or no capacity is free to place them. Transient — retry after the `Retry-After` interval.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}}},"security":{"5fb6c634-17fc-437c-8fb4-2587582d1b35":{"api_key":{"type":"http","scheme":"bearer","scopes":[],"schemeName":"api_key"}}},"servers":{"4bd2e530-edac-43c7-abc9-75b50312caec":{"url":"https://api.platform.infino.ws","description":"Infino Cloud"}},"processedSecurityOptions":[{"schemes":[{"scheme":{"type":"http","scheme":"bearer","scopes":[],"schemeName":"api_key"},"schema":{"title":"Bearer Auth","type":"string","isRequired":true,"description":"Bearer authentication header of the form `Bearer \u003ctoken>`, where `\u003ctoken>` is your auth token.","format":"bearer","typeLabel":"string\u003cbearer>","deprecated":false},"schemeName":"api_key","name":"Authorization"}],"title":"api_key"}]},"originalFileLocation":"api-reference/openapi.json"},"subdomain":"infino-29","siteName":"Infino","title":"Create a table - Infino","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"originalFileLocation":"api-reference/tables/create-a-table.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=\"Create a table with an Arrow schema and optional full-text and vector indexes.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Infino\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_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=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Create a table - Infino\">\u003cmeta data-mint-head property=\"og:description\" content=\"Create a table with an Arrow schema and optional full-text and vector indexes.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Infino\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://infino.ai/docs/api-reference/tables/create-a-table\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://infino-29.mintlify.app/images/og-card.png\">\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=\"Create a table - Infino\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Create a table with an Arrow schema and optional full-text and vector indexes.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://infino-29.mintlify.app/images/og-card.png\">\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=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Infino\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#d24011\">\u003clink data-mint-head rel=\"canonical\" href=\"https://infino.ai/docs/api-reference/tables/create-a-table\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/api-reference/tables/create-a-table.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://infino.ai/#organization\",\"name\":\"Infino\",\"url\":\"https://infino.ai\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/infino-29/sXqDYmwcZ7BW4kvO/logo/infino-logo.png?fit=max\u0026auto=format\u0026n=sXqDYmwcZ7BW4kvO\u0026q=85\u0026s=6bf8ba5e6249a14bb302a90e30e5e18f\"}},{\"@type\":\"WebSite\",\"@id\":\"https://infino.ai/docs#website\",\"name\":\"Infino\",\"url\":\"https://infino.ai/docs\",\"publisher\":{\"@id\":\"https://infino.ai/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://infino.ai/docs/api-reference/tables/create-a-table#webpage\",\"url\":\"https://infino.ai/docs/api-reference/tables/create-a-table\",\"name\":\"Create a table\",\"description\":\"Create a table with an Arrow schema and optional full-text and vector indexes.\",\"isPartOf\":{\"@id\":\"https://infino.ai/docs#website\"},\"breadcrumb\":{\"@id\":\"https://infino.ai/docs/api-reference/tables/create-a-table#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://infino.ai/docs/api-reference/tables/create-a-table#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"REST API\",\"item\":\"https://infino.ai/docs/api-reference/rows/append-rows\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create a table\",\"item\":\"https://infino.ai/docs/api-reference/tables/create-a-table\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://infino.ai/docs/api-reference/tables/create-a-table#apireference\",\"headline\":\"Create a table\",\"name\":\"Create a table\",\"description\":\"Create a table with an Arrow schema and optional full-text and vector indexes.\",\"url\":\"https://infino.ai/docs/api-reference/tables/create-a-table\",\"mainEntityOfPage\":{\"@id\":\"https://infino.ai/docs/api-reference/tables/create-a-table#webpage\"},\"image\":\"https://infino.ai/images/og-card.png\",\"publisher\":{\"@id\":\"https://infino.ai/#organization\"},\"isPartOf\":{\"@id\":\"https://infino.ai/docs#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Infino\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Infino","nav":{"global":null,"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":""}]},{"tab":"Integrations","pages":[{"title":"Integrations","href":"/integrations/mcp"}]},{"tab":"Tutorials","pages":[{"title":"Tutorials","href":"/tutorials"}]},{"tab":"Use Cases","pages":[{"title":"Use Cases","href":"/use-cases"}]},{"tab":"Demos","pages":[{"title":"Demos","href":"/demos"}]},{"tab":"API Reference","groups":[{"group":"SDKs \u0026 CLI","pages":[{"title":"Overview","icon":"code","href":"/api-reference"},{"title":"Local vs Infino Cloud","icon":"table-columns","href":"/api-reference/parity"},{"title":"Infino CLI: create tables, ingest, and search","icon":"terminal","href":"/cli"}]},{"group":"REST API","pages":[{"group":"Rows","pages":[{"title":"Append rows","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/append/{database}","href":"/api-reference/rows/append-rows"},{"title":"Delete rows","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/delete/{database}","href":"/api-reference/rows/delete-rows"},{"title":"Update rows","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/update/{database}","href":"/api-reference/rows/update-rows"}]},{"group":"Search","pages":[{"title":"BM25 full-text search","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/bm25_search/{database}","href":"/api-reference/search/bm25-full-text-search"},{"title":"Count matches","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/count/{database}","href":"/api-reference/search/count-matches"},{"title":"Exact match","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/exact_match/{database}","href":"/api-reference/search/exact-match"},{"title":"Hybrid search","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/hybrid_search/{database}","href":"/api-reference/search/hybrid-search"},{"title":"Run a SQL query","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/query_sql/{database}","href":"/api-reference/search/run-a-sql-query"},{"title":"Token match","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/token_match/{database}","href":"/api-reference/search/token-match"},{"title":"Vector search","description":"Vector (kNN) search over a vector column, with an optional full-text pre-filter.","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/vector_search/{database}","href":"/api-reference/search/vector-search"}]},{"group":"Tables","pages":[{"title":"Create a table","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/create_table/{database}","href":"/api-reference/tables/create-a-table"},{"title":"Drop a table","description":"Drop a table from the database.","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/drop_table/{database}","href":"/api-reference/tables/drop-a-table"},{"title":"List tables","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/list_tables/{database}","href":"/api-reference/tables/list-tables"},{"title":"Describe or change a table's schema","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/schema/{database}","href":"/api-reference/tables/describe-or-change-a-tables-schema"}]},{"group":"Databases","pages":[{"title":"List databases","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json get /v1/databases","href":"/api-reference/databases/list-databases"},{"title":"Create a database","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/databases","href":"/api-reference/databases/create-a-database"},{"title":"Delete a database","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json delete /v1/databases/{name}","href":"/api-reference/databases/delete-a-database"},{"title":"Verify a storage binding","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/databases/{name}/storage/verify","href":"/api-reference/databases/verify-a-storage-binding"}]}]}]}]},"basePath":"","title":"Create a table - Infino","buildId":"dpl_F7QnsMdhpvrmhP3frsJmZHKN4aG5","deploymentId":"dpl_F7QnsMdhpvrmhP3frsJmZHKN4aG5","dynamics":["c2aa737661","2b790eda92","b0f84f53ff","a9bb46feb3"],"chunks":["OpenApiReferenceProvider-Bi1vjMzm.js","utils-Dxbft2ci.js","cloneDeep-izs3Hzxb.js","_Uint8Array-BVIqJ90l.js","isObjectLike-C8vmzPEN.js","isArray-Dcu1dQ5t.js","utils-BRD_DsmR.js","toString-BX-iyh8G.js","isSymbol-CSH9U2Gm.js","addUniqueKeysToSchema-B7yGqTiQ.js","snippetPresets-BHk1Rvlv.js","style-to-object-BY3JEAdk.js","v4-DIgz8zy6.js","ApiExamples-a1D0hXgr.js","isEqual-BfaiBbcl.js","usePlaygroundInputsStore-5VNjsO4S.js","shallow-WbJrcVFv.js","getApiPlaygroundDisplay-CBThln0f.js","CodeSnippet-DZHCcMNf.js","CodeSnippets-DQxLclOq.js","Page-CwN5IAdH.js","getPastedJson-D-bCQc0G.js","icon-C8zmyHeA.js","MethodPill-DYV2xX8H.js","DuplicateIcon-DXDl4vQf.js","createIcon-DPBsNfRz.js","DynamicMarkdown-DtfihWuo.js","SectionHeading-CKy6OzzD.js","axios-vUo_bRtp.js","Markdown-BhYti3uU.js","clsx-BUqrn7lM.js","lib-DuNMoZ05.js","lib-B8HbPgcC.js","html-void-elements-mCSPHezU.js","dist-LvaL_rdZ.js","katex-YMM-FMeD.js","marked.esm-CZWythHk.js","AssistantPageLink-CLFbqrMK.js"]}