For the purpose of this quickstart, we will use the same invoice PDF file as invoice.pdf file in the invoice-extraction-example dataset. Go to that dataset and download the file first. Then upload to the default dataset.
Click on the Workspace tab to go to ROE SQL workspace.
A default table called dataset_default has been created for you. Any new
files uploaded to the default dataset will automatically be added to this table as well. You can check the table by clicking dataset_default table in the table list.
Or you can run the following SQL query to view the data in a new worksheet tab:
Now that you have uploaded your data, you can start processing it using the
built-in functions. For example, you can extract information from the invoice
PDF with the following SQL query:
-- You're shown three example worksheets for three different use cases. Take a moment to read through each one!-- This worksheet extracts information from the invoice PDF as specified by the return format requested. Try running it!SELECT name, file, extract_from( 'returns following structure: { from: <from company name>, recipient: <recipient company name>, line_items: [ { name: <item name> quantity: <item quantity> cost: <item total cost> }, <more line items> ], subtotal: <amount before tax> tax: <tax amount> total: <total amount due> }', -- extract_from() uses the Default Extraction agent, so you don't need to specify an agent file) FROM dataset_examples WHERE dataset='invoice-extraction-example'; -- You can run on all datasets in the table or a specific one (what we do here)
The result of the extract_from function is a reference to the async job. Once
the job is completed, you can view the extracted data in the worksheet by clicking on the Job ID.
We are based on clickhouse dialect, learn more about clickhouse SQL dialect in their official
documentation.Also check out our examples to see how you
can use SQL to process your data.
extract_from is just one of the many functions you can use to process your
data. We have a variety of functions available to help you process your data
with Roe Agents. You can learn more about the functions available in the
Functions section.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Roe Documentation","colors":{"primary":"#FF6619","light":"#FF8C5A","dark":"#D9530F"},"logo":{"light":"https://mintcdn.com/roeai/fwCD8GI-1nfdsPAX/logo/light.svg?fit=max\u0026auto=format\u0026n=fwCD8GI-1nfdsPAX\u0026q=85\u0026s=d7b4fe21f708298b16c7b5b7af65cdbb","dark":"https://mintcdn.com/roeai/fwCD8GI-1nfdsPAX/logo/dark.svg?fit=max\u0026auto=format\u0026n=fwCD8GI-1nfdsPAX\u0026q=85\u0026s=f3eab0bc8f0dc6aa2bcd39722374dc62"},"favicon":"https://mintcdn.com/roeai/fwCD8GI-1nfdsPAX/favicon.svg?fit=max\u0026auto=format\u0026n=fwCD8GI-1nfdsPAX\u0026q=85\u0026s=f95b26cc8189388c848892e9d8871685","api":{"openapi":["api-reference/openapi.yml"]},"appearance":{"default":"light"},"navbar":{"links":[{"href":"mailto:support@roe-ai.com","label":"Support"}],"primary":{"type":"button","label":"Workspace","href":"https://app.roe-ai.com"}},"footer":{"socials":{"x":"https://x.com/try_roe_ai","github":"https://github.com/roe-ai","linkedin":"https://www.linkedin.com/company/roe-ai"}},"contextual":{"options":["copy","view","chatgpt","claude"],"display":"header"},"styling":{"latex":true},"navigation":{"global":{"anchors":[{"anchor":"Community","icon":"slack","href":"https://join.slack.com/t/roeaiusers/shared_invite/zt-2m0oa9kj4-wltD91LCeJJR~cN1y1R7JQ"},{"anchor":"Blog","icon":"newspaper","href":"https://roeai.substack.com/"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"roeai","hasAudioNarration":false,"actualSubdomain":"roeai","customDomains":["docs.roe-ai.com"],"gitSource":{"type":"github","owner":"roe-ai","repo":"roe-docs-mintlify","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6ae62419cf4408c768288cf5","collectionId":"f4f544e9-e5a9-4a1b-9a59-8895cea3ee7b","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ae62419cf4408c768288cf5"},"entitlements":{},"buildId":"6ae62419cf4408c768288cf5","clientVersion":"0.0.4067","searchFilterCounts":[{"language":"default","tag":"Documentation","count":77},{"language":"default","tag":"API Reference","count":44},{"language":"default","tag":"Agents","count":38},{"language":"default","tag":"Release Notes","count":21},{"language":"default","tag":"Engines","count":12},{"language":"default","tag":"SDK integration","count":10},{"language":"default","tag":"Policies","count":10},{"language":"default","tag":"Webhooks","count":9},{"language":"default","tag":"Data Resources","count":9},{"language":"default","tag":"SQL Workspace","count":9}]},"assistantConfig":{},"basePath":"","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":[{"filePath":"style.css","content":".prose ul:has(>li>.rn-tag),ul:has(>li>.rn-tag){list-style:none;padding:0!important;padding-inline-start:0!important;margin-top:1rem;margin-left:0!important}.prose ul>li:has(>.rn-tag),li:has(>.rn-tag){display:grid;grid-template-columns:7.5rem minmax(0, 1fr);column-gap:0.875rem;row-gap:0.5rem;align-items:baseline;justify-items:start;list-style:none;padding:0!important;padding-left:0!important;padding-inline-start:0!important;margin-left:0!important;margin-bottom:1.25rem;font-size:1.0625rem;line-height:1.5;letter-spacing:-0.005em;text-align:left}li:has(>.rn-tag):last-child{margin-bottom:0}li:has(>.rn-tag)::before{content:none}li:has(>.rn-tag)>.rn-tag{justify-self:start}.rn-tag{display:inline-block;box-sizing:border-box;width:fit-content;max-width:7.5rem;padding:0.1875rem 0.625rem;border-radius:9999px;font-size:0.65625rem;font-weight:600;line-height:1.45;letter-spacing:0.09em;text-transform:uppercase;text-align:left;white-space:nowrap;vertical-align:baseline}@media (max-width: 640px){li:has(>.rn-tag){grid-template-columns:1fr;row-gap:0.375rem}.rn-tag{max-width:none}}.rn-tag-agents{background:#FFE6DE;color:#A23B1E}.rn-tag-platform{background:#E3E8F2;color:#2F4868}.rn-tag-integrations{background:#D6EEEA;color:#1F5F58}.rn-tag-sops{background:#E5E1F5;color:#443B85}.rn-tag-qa{background:#DDEEDA;color:#2C6230}.rn-tag-deployment{background:#D9E8F5;color:#1E4D77}.rn-tag-dashboard{background:#F8DEEB;color:#8A3A66}.rn-tag-api{background:#F6EAC9;color:#7A5614}.rn-tag-models{background:#EBDEEF;color:#5E2A7A}.rn-tag-security{background:#F5DCDC;color:#8C2A2A}.rn-tag-workflows{background:#E4EED1;color:#4D6622}"}],"page":{"pagePath":"database/quickstart","slug":"/database/quickstart","pageMetadata":{"title":"Quickstart","description":"Work with your unstructured data at scale in under 5 minutes","href":"/database/quickstart"},"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: \"Work with your unstructured data at scale in under 5 minutes\"\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={a:`a`,code:`code`,p:`p`,pre:`pre`,span:`span`,..._provideComponents(),...props.components},{CodeBlock,Frame,Heading,OptimizedImage,Step,Steps}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Step)_missingMdxReference(`Step`,true);if(!Steps)_missingMdxReference(`Steps`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`upload-your-unstructured-data`,children:`Upload Your Unstructured Data`}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Navigate to the Roe Dataset page`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-roe-dataset.png?fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=4ccc25162b10902a2ee5d08e2f0433df`,\"data-og-width\":`1926`,width:`1926`,\"data-og-height\":`858`,height:`858`,\"data-path\":`images/database-quickstart-roe-dataset.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-roe-dataset.png?w=280\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=2d57e78078d209143306e02e22b23655 280w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-roe-dataset.png?w=560\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=2d29b24c618b03da68dd97596bd8ce94 560w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-roe-dataset.png?w=840\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=9216b7cdf9686dea0dd2cf214b94273a 840w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-roe-dataset.png?w=1100\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=324a0d71ba02a45e4596add958179eb6 1100w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-roe-dataset.png?w=1650\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=1e1b8e92a9b8e600a30e890754dd14b5 1650w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-roe-dataset.png?w=2500\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=48be931fe5b12775672213803a9920ba 2500w`})})}),_jsxs(Step,{title:`Upload a file to the default dataset`,children:[_jsxs(_components.p,{children:[`For the purpose of this quickstart, we will use the same invoice PDF file as `,_jsx(_components.code,{children:`invoice.pdf`}),` file in the `,_jsx(_components.code,{children:`invoice-extraction-example`}),` dataset. Go to that dataset and download the file first. Then upload to the `,_jsx(_components.code,{children:`default`}),` dataset.`]}),_jsx(Frame,{caption:`View the default dataset`,children:_jsx(OptimizedImage,{src:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-1.png?fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=a91a0e4573f47661b5927b1ea7f5747d`,\"data-og-width\":`1990`,width:`1990`,\"data-og-height\":`162`,height:`162`,\"data-path\":`images/database-quickstart-upload-file-1.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-1.png?w=280\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=c7cdc371c09e1326904a0e1a0277f6b4 280w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-1.png?w=560\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=cd4cba735f5a7858bae9d621579cae1f 560w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-1.png?w=840\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=fec40fc16311e8e5af595ff679d43250 840w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-1.png?w=1100\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=e0e28f402e3c40db8b67d1226996af7e 1100w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-1.png?w=1650\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=57f5668fc70a1dd5c9339b13999a2625 1650w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-1.png?w=2500\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=9a185bca2b14b596c84128a63f1e64aa 2500w`})}),_jsx(`br`,{}),_jsx(Frame,{caption:`Upload your files`,children:_jsx(OptimizedImage,{src:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-2.png?fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=59d2612e60e2dfc9078d8bcde4cf1ff9`,\"data-og-width\":`1982`,width:`1982`,\"data-og-height\":`136`,height:`136`,\"data-path\":`images/database-quickstart-upload-file-2.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-2.png?w=280\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=86a0c173ee3b53775de8dfc8f8e21b4d 280w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-2.png?w=560\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=bfb878a302261de12427f7e87a38d00f 560w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-2.png?w=840\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=849b1b73cae9d7f191aacc2af79758f8 840w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-2.png?w=1100\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=0a37983228579baf7650213fb89db1b8 1100w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-2.png?w=1650\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=d0373cc04b97a12826bdb83d0eda2d81 1650w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-upload-file-2.png?w=2500\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=1f57af171815fc7c904f231186bb8e25 2500w`})})]}),_jsx(Step,{title:`View your uploaded files`,children:_jsx(Frame,{caption:`Once uploaded, your files will be listed here`,children:_jsx(OptimizedImage,{src:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-uploaded-file.png?fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=9faf17833fd58f832389305de3c85075`,\"data-og-width\":`1988`,width:`1988`,\"data-og-height\":`382`,height:`382`,\"data-path\":`images/database-quickstart-uploaded-file.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-uploaded-file.png?w=280\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=c565913c4cbd1f384dce9a841fb1aea4 280w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-uploaded-file.png?w=560\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=56e5a7a430528c3be5956f8ececd015d 560w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-uploaded-file.png?w=840\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=c952e57aeb95f6dc57a34cfa610df403 840w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-uploaded-file.png?w=1100\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=49199dcb30e9e5f05334e174ad48b94e 1100w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-uploaded-file.png?w=1650\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=05a2aed36a9fa9fb8a8b06a6166de406 1650w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-uploaded-file.png?w=2500\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=0565ae57b9b162c997b77037eb8df36d 2500w`})})})]}),`\n`,_jsx(Heading,{level:`2`,id:`view-your-data`,children:`View Your Data`}),`\n`,_jsxs(_components.p,{children:[`Click on the Workspace tab to go to ROE SQL workspace.\nA default table called `,_jsx(_components.code,{children:`dataset_default`}),` has been created for you. Any new\nfiles uploaded to the `,_jsx(_components.code,{children:`default`}),` dataset will automatically be added to this table as well. You can check the table by clicking `,_jsx(_components.code,{children:`dataset_default`}),` table in the table list.`]}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-default-table.png?fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=70e6ceee0372a7df46c004e0705edc58`,\"data-og-width\":`2454`,width:`2454`,\"data-og-height\":`836`,height:`836`,\"data-path\":`images/database-quickstart-default-table.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-default-table.png?w=280\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=f3623e76b69ca043e423c067bf2fcfa0 280w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-default-table.png?w=560\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=b4c400d5ffc84b227f43d5950421efea 560w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-default-table.png?w=840\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=76c9484e14db3293dd462085a2d22be1 840w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-default-table.png?w=1100\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=6bc19866264cdad3ac8ff007b376969c 1100w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-default-table.png?w=1650\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=12c47edd68c369091026b67e7335fc58 1650w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-default-table.png?w=2500\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=70f5c9a0e6e929b5ed2bf1a63f492aca 2500w`})}),`\n`,_jsx(_components.p,{children:`Or you can run the following SQL query to view the data in a new worksheet tab:`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` *`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` dataset_default;`})]}),`\n`]})})}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-select-default-table.png?fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=f52256bc9c1637710013b1b427185c77`,\"data-og-width\":`2458`,width:`2458`,\"data-og-height\":`1148`,height:`1148`,\"data-path\":`images/database-quickstart-select-default-table.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-select-default-table.png?w=280\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=f9009ac98b08379991f81fd8034fa34d 280w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-select-default-table.png?w=560\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=8b953c8e21f9b866cb9b4c3a0e97d348 560w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-select-default-table.png?w=840\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=d60548b7d3e2f5b15717f131fb8a4443 840w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-select-default-table.png?w=1100\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=ea8c4f69037ad5908a208c0600f57af8 1100w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-select-default-table.png?w=1650\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=f6b313c2f59b562be054ce3e234373a7 1650w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-select-default-table.png?w=2500\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=e013e2ee167b4f918452adee699ace50 2500w`})}),`\n`,_jsx(Heading,{level:`2`,id:`process-your-data`,children:`Process Your Data`}),`\n`,_jsx(_components.p,{children:`Now that you have uploaded your data, you can start processing it using the\nbuilt-in functions. For example, you can extract information from the invoice\nPDF with the following SQL query:`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`21`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`21`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- You're shown three example worksheets for three different use cases. Take a moment to read through each one!`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- This worksheet extracts information from the invoice PDF as specified by the return format requested. Try running it!`})}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`file`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, extract_from(`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'returns following structure: {`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` from: \u003cfrom company name>,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` recipient: \u003crecipient company name>,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` line_items: [`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` {`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` name: \u003citem name>`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` quantity: \u003citem quantity>`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` cost: \u003citem total cost>`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` },`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \u003cmore line items>`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` ],`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` subtotal: \u003camount before tax>`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` tax: \u003ctax amount>`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` total: \u003ctotal amount due>`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` }'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- extract_from() uses the Default Extraction agent, so you don't need to specify an agent`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` file`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` dataset_examples `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`WHERE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` dataset`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'invoice-extraction-example'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`; `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- You can run on all datasets in the table or a specific one (what we do here)`})]}),`\n`]})})}),`\n`,_jsxs(_components.p,{children:[`The result of the `,_jsx(_components.code,{children:`extract_from`}),` function is a reference to the async job. Once\nthe job is completed, you can view the extracted data in the worksheet by clicking on the Job ID.`]}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-result.png?fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=a0c091864094aaf1d89a507bb5e07f30`,\"data-og-width\":`2004`,width:`2004`,\"data-og-height\":`636`,height:`636`,\"data-path\":`images/database-quickstart-result.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-result.png?w=280\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=6424240453f2ae9ca733ee93a82e9ec2 280w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-result.png?w=560\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=ec395a96bd8ea77eefd6baadcd8d4442 560w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-result.png?w=840\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=e726325555bde48d55b67ede8882fd27 840w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-result.png?w=1100\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=edc4bfe07dc501eec7b08b6b14969e07 1100w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-result.png?w=1650\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=0b32d70c72a90d636332649cfbad73df 1650w, https://mintcdn.com/roeai/wyVOyeWPONjXHsrt/images/database-quickstart-result.png?w=2500\u0026fit=max\u0026auto=format\u0026n=wyVOyeWPONjXHsrt\u0026q=85\u0026s=24401126fbc3ae3286b99c20fc8efe14 2500w`})}),`\n`,_jsx(Heading,{level:`2`,id:`next-steps`,children:`Next Steps`}),`\n`,_jsx(Heading,{level:`3`,id:`learn-more-about-roe-sql`,children:`Learn More About Roe SQL`}),`\n`,_jsxs(_components.p,{children:[`We are based on clickhouse dialect, learn more about clickhouse SQL dialect in their official\n`,_jsx(_components.a,{href:`https://clickhouse.com/docs`,children:`documentation`}),`.`]}),`\n`,_jsxs(_components.p,{children:[`Also check out our `,_jsx(_components.a,{href:`/database/examples/introduction`,children:`examples`}),` to see how you\ncan use SQL to process your data.`]}),`\n`,_jsx(Heading,{level:`3`,id:`learn-more-about-roe-sql-functions`,children:`Learn More About Roe SQL Functions`}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`extract_from`}),` is just one of the many functions you can use to process your\ndata. We have a variety of functions available to help you process your data\nwith Roe Agents. You can learn more about the functions available in the\n`,_jsx(_components.a,{href:`/database/functions/introduction`,children:`Functions`}),` section.`]})]})}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":{"config":{},"pageMetadata":{"title":"Quickstart","description":"Work with your unstructured data at scale in under 5 minutes","href":"/database/quickstart"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Upload Your Unstructured Data","slug":"upload-your-unstructured-data","depth":2,"children":[]},{"title":"View Your Data","slug":"view-your-data","depth":2,"children":[]},{"title":"Process Your Data","slug":"process-your-data","depth":2,"children":[]},{"title":"Next Steps","slug":"next-steps","depth":2,"children":[{"title":"Learn More About Roe SQL","slug":"learn-more-about-roe-sql","depth":3,"children":[]},{"title":"Learn More About Roe SQL Functions","slug":"learn-more-about-roe-sql-functions","depth":3,"children":[]}]}],"codeExamples":{}},"jsLinks":[],"subdomain":"roeai","siteName":"Roe Documentation","title":"Quickstart - Roe Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-06-04T20:19:35.775Z","originalFileLocation":"database/quickstart.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=\"light\"}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=\"Work with your unstructured data at scale in under 5 minutes\">\u003cmeta data-mint-head name=\"application-name\" content=\"Roe Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/roeai/fPmAFS4J5dj6_hvQ/_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/roeai/fPmAFS4J5dj6_hvQ/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/roeai/fPmAFS4J5dj6_hvQ/_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/roeai/fPmAFS4J5dj6_hvQ/_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/roeai/fPmAFS4J5dj6_hvQ/_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/roeai/fPmAFS4J5dj6_hvQ/_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/roeai/fPmAFS4J5dj6_hvQ/_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/roeai/fPmAFS4J5dj6_hvQ/_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/roeai/fPmAFS4J5dj6_hvQ/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Quickstart - Roe Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Work with your unstructured data at scale in under 5 minutes\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Roe Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.roe-ai.com/database/quickstart\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://roeai.mintlify.app/_mintlify/api/og/v2?division=SQL+Workspace\u0026amp;title=Quickstart\u0026amp;description=Work+with+your+unstructured+data+at+scale+in+under+5+minutes\u0026amp;theme=71393da4931c813a27fda74c\u0026amp;signature=3f48c5a2609e3821b549a057d6b9eb5467de707a2ee2265266aa1b463972fb20\">\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=\"Quickstart - Roe Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Work with your unstructured data at scale in under 5 minutes\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://roeai.mintlify.app/_mintlify/api/og/v2?division=SQL+Workspace\u0026amp;title=Quickstart\u0026amp;description=Work+with+your+unstructured+data+at+scale+in+under+5+minutes\u0026amp;theme=71393da4931c813a27fda74c\u0026amp;signature=3f48c5a2609e3821b549a057d6b9eb5467de707a2ee2265266aa1b463972fb20\">\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/roeai/fPmAFS4J5dj6_hvQ/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Roe Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#FF6619\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.roe-ai.com/database/quickstart\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/database/quickstart.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.roe-ai.com/#organization\",\"name\":\"Roe Documentation\",\"url\":\"https://docs.roe-ai.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/roeai/fwCD8GI-1nfdsPAX/logo/light.svg?fit=max\u0026auto=format\u0026n=fwCD8GI-1nfdsPAX\u0026q=85\u0026s=d7b4fe21f708298b16c7b5b7af65cdbb\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.roe-ai.com#website\",\"name\":\"Roe Documentation\",\"url\":\"https://docs.roe-ai.com\",\"publisher\":{\"@id\":\"https://docs.roe-ai.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.roe-ai.com/database/quickstart#webpage\",\"url\":\"https://docs.roe-ai.com/database/quickstart\",\"name\":\"Quickstart\",\"description\":\"Work with your unstructured data at scale in under 5 minutes\",\"dateModified\":\"2026-06-04T20:19:35.775Z\",\"isPartOf\":{\"@id\":\"https://docs.roe-ai.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.roe-ai.com/database/quickstart#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.roe-ai.com/database/quickstart#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SQL Workspace\",\"item\":\"https://docs.roe-ai.com/database/introduction\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Quickstart\",\"item\":\"https://docs.roe-ai.com/database/quickstart\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.roe-ai.com/database/quickstart#article\",\"headline\":\"Quickstart\",\"name\":\"Quickstart\",\"description\":\"Work with your unstructured data at scale in under 5 minutes\",\"url\":\"https://docs.roe-ai.com/database/quickstart\",\"mainEntityOfPage\":{\"@id\":\"https://docs.roe-ai.com/database/quickstart#webpage\"},\"dateModified\":\"2026-06-04T20:19:35.775Z\",\"publisher\":{\"@id\":\"https://docs.roe-ai.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.roe-ai.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Roe Documentation\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Roe Documentation","nav":{"global":{"anchors":[{"anchor":"Community","icon":"slack","href":"https://join.slack.com/t/roeaiusers/shared_invite/zt-2m0oa9kj4-wltD91LCeJJR~cN1y1R7JQ"},{"anchor":"Blog","icon":"newspaper","href":"https://roeai.substack.com/"}]},"tabs":[{"tab":"Documentation","groups":[{"group":"Get Started","pages":[{"title":"Introduction","href":"/introduction"},{"title":"Quickstart","href":"/quickstart"}]},{"group":"Agents","pages":[{"title":"Introduction","href":"/agents/introduction"},{"title":"Quickstart","href":"/agents/quickstart"},{"title":"Input Definitions","href":"/agents/input-definition"},{"title":"Prompt Engineering Guide","href":"/agents/prompt-engineering"},{"title":"JSON Output Schema","href":"/agents/output-schema-json"},{"group":"Engines","pages":[{"title":"Introduction","href":"/agents/engines/introduction"},{"title":"Document Segmentation","href":"/agents/engines/document-segmentation"},{"title":"Google Maps Insights","href":"/agents/engines/google-maps"},{"title":"Interactive Web Insights","href":"/agents/engines/interactive-web"},{"title":"Marketplace Storefront Analysis","href":"/agents/engines/marketplace-storefront"},{"title":"Merchant Risk Analysis","href":"/agents/engines/merchant-risk"},{"title":"Multimodal Insights","href":"/agents/engines/multimodal-extraction"},{"title":"Document Insights","href":"/agents/engines/pdf-extraction"},{"title":"Research Agent","href":"/agents/engines/research"},{"title":"Social Media Crawler","href":"/agents/engines/social-media-crawler"},{"title":"Web Insights","href":"/agents/engines/url-extraction"},{"title":"URL Finder","href":"/agents/engines/url-finder"}]},{"group":"Agentic Workflows","pages":[{"title":"Introduction","href":"/agents/agentic-workflows/introduction"},{"title":"AML Investigation","href":"/agents/engines/aml-investigation"},{"title":"Data Analysis","href":"/agents/engines/data-analysis"},{"title":"Fraud Investigation","href":"/agents/engines/fraud-investigation"},{"title":"Merchant Underwriting","href":"/agents/engines/merchant-underwriting"},{"title":"Product Policy","href":"/agents/engines/product-policy"}]}]},{"group":"SQL Workspace","pages":[{"title":"Introduction","description":"Index, search, and analyze unstructured data with SQL, no matter the scale.","href":"/database/introduction"},{"title":"Quickstart","href":"/database/quickstart"},{"group":"Functions","pages":[{"title":"Introduction","description":"A set of functions dedicated to working with unstructured data","href":"/database/functions/introduction"},{"title":"run_agent","href":"/database/functions/run-agent"},{"title":"run_agent_sync","href":"/database/functions/run-agent-sync"},{"title":"job_status","href":"/database/functions/job-status"},{"title":"job_result | resolve","href":"/database/functions/job-result"},{"title":"keep_pages","href":"/database/functions/keep-pages"}]},{"group":"Examples","pages":[{"title":"Introduction","href":"/database/examples/introduction"}]}]},{"group":"Data Resources","pages":[{"title":"Introduction","href":"/data-resources/introduction"},{"title":"Context Sources","href":"/data-resources/context-sources"},{"group":"Roe Datasets","pages":[{"title":"Introduction","href":"/data-resources/roe-datasets/introduction"}]},{"group":"Connectors","pages":[{"title":"Introduction","href":"/data-resources/connectors/introduction"},{"title":"Custom API Connector","href":"/data-resources/connectors/custom-api"},{"title":"AWS S3 Connector","href":"/data-resources/connectors/s3"},{"title":"Snowflake Connector","href":"/data-resources/connectors/snowflake"},{"title":"SharePoint Connector","href":"/data-resources/connectors/sharepoint"},{"title":"Zendesk Connector","href":"/data-resources/connectors/zendesk"}]}]},{"group":"Policies","pages":[{"title":"Policies","href":"/policies/introduction"}]},{"group":"Webhooks","pages":[{"title":"Webhooks","href":"/webhooks/introduction"}]},{"group":"MCP Server","pages":[{"title":"Introduction","href":"/mcp/introduction"},{"group":"Skills","pages":[{"title":"Roe MCP Basics","href":"/mcp/skills/roe-mcp-basics"},{"title":"Workflow Builder","href":"/mcp/skills/workflow-builder"}]},{"title":"MCP tools reference","href":"/mcp/tools"}]},{"group":"Enterprise","pages":[{"group":"Single sign-on (SSO)","pages":[{"group":"OIDC","pages":[{"title":"OIDC Single Sign-On (SSO) Integration","href":"/enterprise/sso"},{"title":"Microsoft Entra ID (Azure AD) OIDC SSO Integration","href":"/enterprise/sso-entraid"},{"title":"Okta OIDC SSO Integration Guide","href":"/enterprise/sso-okta"},{"title":"ADFS OIDC SSO Integration Guide","href":"/enterprise/sso-adfs"}]},{"group":"SAML","pages":[{"title":"SAML Single Sign-On (SSO) Integration","href":"/enterprise/sso-saml"},{"title":"Microsoft Entra ID (Azure AD) SAML SSO Integration","href":"/enterprise/sso-saml-entraid"}]}]}]},{"group":"Use Cases","pages":[{"title":"Introduction","href":"/use-cases/finance"}]},{"group":"Release Notes","pages":[{"title":"Release 1.1.4","href":"/release-notes/release-1-1-4"},{"title":"Release 1.1.3","href":"/release-notes/release-1-1-3"},{"title":"Release 1.1.2","href":"/release-notes/release-1-1-2"},{"title":"Release 1.1.1","href":"/release-notes/release-1-1-1"},{"title":"Release 1.1.0","href":"/release-notes/release-1-1-0"},{"title":"Release 1.0.99","href":"/release-notes/release-1-0-99"},{"title":"Release 1.0.98","href":"/release-notes/release-1-0-98"},{"title":"Release 1.0.97","href":"/release-notes/release-1-0-97"},{"title":"Release 1.0.96","href":"/release-notes/release-1-0-96"},{"title":"Release 1.0.95","href":"/release-notes/release-1-0-95"},{"title":"Release 1.0.94","href":"/release-notes/release-1-0-94"},{"title":"Release 1.0.93","href":"/release-notes/release-1-0-93"},{"title":"Release 1.0.92","href":"/release-notes/release-1-0-92"},{"title":"Release 1.0.91","href":"/release-notes/release-1-0-91"},{"title":"Release 1.0.90","href":"/release-notes/release-1-0-90"},{"title":"Release 1.0.89","href":"/release-notes/release-1-0-89"},{"title":"Release 1.0.88","href":"/release-notes/release-1-0-88"},{"title":"Release 1.0.87","href":"/release-notes/release-1-0-87"},{"title":"Release 1.0.86","href":"/release-notes/release-1-0-86"},{"title":"Release 1.0.85","href":"/release-notes/release-1-0-85"},{"title":"Release 1.0.84","href":"/release-notes/release-1-0-84"}]}]},{"tab":"SDK integration","pages":[{"title":"SDK integration","href":"/api-reference/sdk-integration"}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/api-reference/introduction"}]},{"tab":"SQL Reference","pages":[{"title":"SQL Reference","href":"/sql-reference/introduction"}]}]},"basePath":"","title":"Quickstart - Roe Documentation","buildId":"dpl_9VVk5y1P8k1ATeJguVngy9Q3cmbD","deploymentId":"dpl_9VVk5y1P8k1ATeJguVngy9Q3cmbD","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-BdiBGm0H.js","DynamicMarkdown-CbqEDjbV.js","zoom-image-lightbox-CvtNkYOX.js","lightbox-handle-r17bVUz3.js"]}