Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.
Overview
SDF DB was designed with two goals in mind:
Provide an integrated transformation layer and dependency aware database to make getting started with a data warehouse faster, more intuitive, and scalable.
Use SDF’s Executable Semantics for multiple SQL dialects to enable query acceleration for proprietary data warehouses on compute agnostic storage like Iceberg and AWS S3.
SDF DB understands time, code, and data dependencies to optimize execution across many queries in a warehouse. SDF DB only executes parts of the DAG that have changed since the last run. This intelligence is managed by
a sophisticated caching layer that fingerprints data, code, metadata to optimally recompute nodes that are out of date after a change.Use SDF to run fast, in-memory, queries on data locally or in the cloud. The physical plan, optimizer and execution is based on Apache Datafusion for which we have the greatest appreciation.
SDF DB is in alpha with breaking changes, new functionality, and more coming all the time. If you are interested in using the database product, please contact us.
Using SDF Database
It’s simple, SDF allows you to set an execution context per query. In fact, all checks and reports are executed with SDF’s builtin execution engine already!You can get started with the database in just a couple of commands.
sdf new sample_db && cd sample_dbsdf run --show all
To explicitly set the execution context and dialects, you can configure global, or even per-table settings via SDF’s defaults paradigm.If you wanted you could execute one query on Snowflake, another query on Redshift, then collect results from both locally on your laptop and then run an aggregation on the results locally on your laptop!
(We’re not sure why you would want to though…)
You can also
workspace: ... defaults: dialect: trino
What SDF DB is Not
As the line between “Database”, “Query Engine”, and “Execution Runtime” is being blurred, it’s important to note what SDF DB is not.SDF is not designed to be a Online Transactional Processing, (OLTP) and as such is not a replacement for MySQL or PostgreSQL.
Data Provider Capabilities
Data may come from many sources, either from a local file system, remote file system, or metadata storage layer.SDF DB supports the following data locations.
Feaure
SDF DB
Local File System
🟢
AWS Glue
🟢
Iceberg
🟢
AWS S3
🟢
Delta Lake
🟡
Google Cloud Storage
🔴
Azure Bulk Storage
🔴
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"SDF","colors":{"primary":"#527398","light":"#9FBBDC","dark":"#0C1D37"},"logo":{"light":"https://mintcdn.com/promise-sdf/DO4pvPF5_fwFXGN4/assets/logo/light.svg?fit=max\u0026auto=format\u0026n=DO4pvPF5_fwFXGN4\u0026q=85\u0026s=81b54453175e2919ce43ff83e6a48e25","dark":"https://mintcdn.com/promise-sdf/DO4pvPF5_fwFXGN4/assets/logo/dark.svg?fit=max\u0026auto=format\u0026n=DO4pvPF5_fwFXGN4\u0026q=85\u0026s=4c91a2490a1c65e21cc66f49eba30832"},"favicon":"https://mintcdn.com/promise-sdf/DO4pvPF5_fwFXGN4/assets/favicon.png?fit=max\u0026auto=format\u0026n=DO4pvPF5_fwFXGN4\u0026q=85\u0026s=d96cdef018fc854071000699cbd70ae3","banner":{"content":"SDF is now a part of dbt Labs. Get live CTA previews, inline errors, and mesh support natively in the dbt platform. [Learn more](https://docs.getdbt.com/blog/dbt-fusion-engine?version=2.0) · [Migrate to Fusion](https://docs.getdbt.com/guides/prepare-fusion-upgrade?step=7\u0026version=2.0)","dismissible":false},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"promise-sdf","hasAudioNarration":false,"actualSubdomain":"promise-sdf","customDomains":["docs.sdf.com"],"gitSource":{"type":"github","owner":"dbt-labs","repo":"sdf-docs","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"DISABLED"},"REMOVE_BRANDING":{"status":"DISABLED"}},"buildId":"6ae914f9cd3faed8ded0eb5d:success","clientVersion":"0.0.4167","searchFilterCounts":[{"language":"default","tag":"Reference","count":85},{"language":"default","tag":"SQL Functions","count":75},{"language":"default","tag":"Documentation","count":55},{"language":"default","tag":"Trino Functions","count":28},{"language":"default","tag":"Guides","count":24},{"language":"default","tag":"Bigquery Functions","count":21},{"language":"default","tag":"Snowflake Functions","count":21},{"language":"default","tag":"Integrations","count":20},{"language":"default","tag":"Database","count":14},{"language":"default","tag":"Using SDF","count":12}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"database/introduction","slug":"/database/introduction","pageMetadata":{"title":"SDF DB Overview","description":"Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.","href":"/database/introduction"},"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: \"Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.\"\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`,em:`em`,li:`li`,ol:`ol`,p:`p`,pre:`pre`,span:`span`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{CodeBlock,Frame,Heading,Table,Tip}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);return _jsxs(_Fragment,{children:[_jsx(Frame,{children:_jsx(`video`,{autoPlay:true,muted:true,className:`mint-w-full mint-aspect-video`,src:`https://cdn.sdf.com/vid/final_final_incremental_run.mp4`,playsInline:`true`,loop:`true`})}),`\n`,_jsx(Heading,{level:`1`,id:`overview`,children:`Overview`}),`\n`,_jsx(_components.p,{children:`SDF DB was designed with two goals in mind:`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`Provide an integrated transformation layer and `,_jsx(_components.em,{children:`dependency aware`}),` database to make getting started with a data warehouse faster, more intuitive, and scalable.`]}),`\n`,_jsx(_components.li,{children:`Use SDF’s Executable Semantics for multiple SQL dialects to enable query acceleration for proprietary data warehouses on compute agnostic storage like Iceberg and AWS S3.`}),`\n`]}),`\n`,_jsx(_components.p,{children:`SDF DB understands time, code, and data dependencies to optimize execution across many queries in a warehouse. SDF DB only executes parts of the DAG that have changed since the last run. This intelligence is managed by\na sophisticated caching layer that fingerprints data, code, metadata to optimally recompute nodes that are out of date after a change.`}),`\n`,_jsxs(_components.p,{children:[`Use SDF to run fast, in-memory, queries on data locally or in the cloud. The physical plan, optimizer and execution is based on `,_jsx(_components.a,{href:`https://datafusion.apache.org/`,children:`Apache Datafusion`}),` for which we have the greatest appreciation.`]}),`\n`,_jsx(Tip,{children:_jsx(_components.p,{children:`SDF DB is in alpha with breaking changes, new functionality, and more coming all the time. If you are interested in using the database product, please contact us.`})}),`\n`,_jsx(Heading,{level:`1`,id:`using-sdf-database`,children:`Using SDF Database`}),`\n`,_jsx(_components.p,{children:`It’s simple, SDF allows you to set an execution context per query. In fact, all checks and reports are executed with SDF’s builtin execution engine already!`}),`\n`,_jsx(_components.p,{children:`You can get started with the database in just a couple of commands.`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`2`,language:`shellscript`,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:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`2`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`sdf`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` new`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` sample_db`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` \u0026\u0026 `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`cd`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` sample_db`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`sdf`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` run`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --show`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` all`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:`To explicitly set the execution context and dialects, you can configure global, or even per-table settings via SDF’s defaults paradigm.`}),`\n`,_jsx(_components.p,{children:`If you wanted you could execute one query on Snowflake, another query on Redshift, then collect results from both locally on your laptop and then run an aggregation on the results locally on your laptop!\n(We’re not sure why you would want to though…)\nYou can also`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`4`,language:`yaml`,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:`yaml`,children:_jsxs(_components.code,{language:`yaml`,numberOfLines:`4`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:`workspace`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` ...`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:` defaults`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:` dialect`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`trino`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`3`,id:`what-sdf-db-is-not`,children:`What SDF DB is Not`}),`\n`,_jsx(_components.p,{children:`As the line between “Database”, “Query Engine”, and “Execution Runtime” is being blurred, it’s important to note what SDF DB is not.`}),`\n`,_jsx(_components.p,{children:`SDF is not designed to be a Online Transactional Processing, (OLTP) and as such is not a replacement for MySQL or PostgreSQL.`}),`\n`,_jsx(Heading,{level:`3`,id:`data-provider-capabilities`,children:`Data Provider Capabilities`}),`\n`,_jsx(_components.p,{children:`Data may come from many sources, either from a local file system, remote file system, or metadata storage layer.`}),`\n`,_jsx(_components.p,{children:`SDF DB supports the following data locations.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Feaure`}),_jsx(_components.th,{style:{textAlign:`center`},children:`SDF DB`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Local File System`}),_jsx(_components.td,{style:{textAlign:`center`},children:`🟢`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`AWS Glue`}),_jsx(_components.td,{style:{textAlign:`center`},children:`🟢`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Iceberg`}),_jsx(_components.td,{style:{textAlign:`center`},children:`🟢`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`AWS S3`}),_jsx(_components.td,{style:{textAlign:`center`},children:`🟢`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Delta Lake`}),_jsx(_components.td,{style:{textAlign:`center`},children:`🟡`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Google Cloud Storage`}),_jsx(_components.td,{style:{textAlign:`center`},children:`🔴`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Azure Bulk Storage`}),_jsx(_components.td,{style:{textAlign:`center`},children:`🔴`})]})]})]})]})}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":"SDF DB Overview","description":"Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.","href":"/database/introduction"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Overview","slug":"overview","depth":1,"children":[]},{"title":"Using SDF Database","slug":"using-sdf-database","depth":1,"children":[{"title":"What SDF DB is Not","slug":"what-sdf-db-is-not","depth":3,"children":[]},{"title":"Data Provider Capabilities","slug":"data-provider-capabilities","depth":3,"children":[]}]}],"codeExamples":{}},"jsLinks":[],"dynamicCss":".mint-aspect-video {\n aspect-ratio: 16 / 9\n}\n.mint-w-full {\n width: 100%\n}","subdomain":"promise-sdf","siteName":"SDF","title":"SDF DB Overview - SDF","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-06T22:49:19.537Z","originalFileLocation":"database/introduction.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=\"Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.\">\u003cmeta data-mint-head name=\"application-name\" content=\"SDF\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/promise-sdf/8sRhP2LknlfvxNPU/_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/promise-sdf/8sRhP2LknlfvxNPU/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/promise-sdf/8sRhP2LknlfvxNPU/_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/promise-sdf/8sRhP2LknlfvxNPU/_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/promise-sdf/8sRhP2LknlfvxNPU/_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/promise-sdf/8sRhP2LknlfvxNPU/_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/promise-sdf/8sRhP2LknlfvxNPU/_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/promise-sdf/8sRhP2LknlfvxNPU/_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/promise-sdf/8sRhP2LknlfvxNPU/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"SDF DB Overview - SDF\">\u003cmeta data-mint-head property=\"og:description\" content=\"Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"SDF\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.sdf.com/database/introduction\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://promise-sdf.mintlify.site/_mintlify/api/og/v2?division=SDF+DB\u0026amp;title=SDF+DB+Overview\u0026amp;description=Fast%2C+dependency+aware+in+memory+query+execution+built+into+the+same+binary+as+SDF%2C+with+the+same+SQL+syntax+as+Trino+and+AWS+Athena.+Powered+by+Apache+DataFusi\u0026amp;theme=385eeb9cf6f02860534b7728\u0026amp;signature=0044766788ff8a5054aa0afb1b5ebcb6d0816e201a7252f81ff560d0fa411e87\">\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=\"SDF DB Overview - SDF\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://promise-sdf.mintlify.site/_mintlify/api/og/v2?division=SDF+DB\u0026amp;title=SDF+DB+Overview\u0026amp;description=Fast%2C+dependency+aware+in+memory+query+execution+built+into+the+same+binary+as+SDF%2C+with+the+same+SQL+syntax+as+Trino+and+AWS+Athena.+Powered+by+Apache+DataFusi\u0026amp;theme=385eeb9cf6f02860534b7728\u0026amp;signature=0044766788ff8a5054aa0afb1b5ebcb6d0816e201a7252f81ff560d0fa411e87\">\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/promise-sdf/8sRhP2LknlfvxNPU/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"SDF\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#527398\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.sdf.com/database/introduction\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/database/introduction.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.sdf.com/#organization\",\"name\":\"SDF\",\"url\":\"https://docs.sdf.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/promise-sdf/DO4pvPF5_fwFXGN4/assets/logo/light.svg?fit=max\u0026auto=format\u0026n=DO4pvPF5_fwFXGN4\u0026q=85\u0026s=81b54453175e2919ce43ff83e6a48e25\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.sdf.com#website\",\"name\":\"SDF\",\"url\":\"https://docs.sdf.com\",\"publisher\":{\"@id\":\"https://docs.sdf.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.sdf.com/database/introduction#webpage\",\"url\":\"https://docs.sdf.com/database/introduction\",\"name\":\"SDF DB Overview\",\"description\":\"Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.\",\"dateModified\":\"2026-01-06T22:49:19.537Z\",\"isPartOf\":{\"@id\":\"https://docs.sdf.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.sdf.com/database/introduction#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.sdf.com/database/introduction#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SDF\",\"item\":\"https://docs.sdf.com\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SDF DB Overview\",\"item\":\"https://docs.sdf.com/database/introduction\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.sdf.com/database/introduction#article\",\"headline\":\"SDF DB Overview\",\"name\":\"SDF DB Overview\",\"description\":\"Fast, dependency aware in memory query execution built into the same binary as SDF, with the same SQL syntax as Trino and AWS Athena. Powered by Apache DataFusion.\",\"url\":\"https://docs.sdf.com/database/introduction\",\"mainEntityOfPage\":{\"@id\":\"https://docs.sdf.com/database/introduction#webpage\"},\"dateModified\":\"2026-01-06T22:49:19.537Z\",\"publisher\":{\"@id\":\"https://docs.sdf.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.sdf.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"SDF\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"SDF\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/database/introduction.md","siteName":"SDF","nav":{"global":null,"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":"/introduction/welcome"}]},{"tab":"Database","groups":[{"group":"SDF DB","pages":[{"title":"SDF DB Overview","href":"/database/introduction"},{"title":null,"description":null,"href":"/database/file-formats"},{"title":"Partitioning","href":"/database/partitioning"},{"title":"Benchmarks","href":"/database/benchmarks"}]},{"group":"Trino Supported Functions","pages":[{"title":"Overview of Function Execution","href":"/database/supported-functions/overview"},{"title":"String Functions","href":"/database/supported-functions/trino/string-functions"},{"title":"Math Functions","href":"/database/supported-functions/trino/math-functions"},{"title":"Datetime Functions","href":"/database/supported-functions/trino/datetime-functions"},{"title":"Aggregate Functions","href":"/database/supported-functions/trino/aggregate-functions"},{"title":"Regexp Functions","href":"/database/supported-functions/trino/regexp-functions"},{"title":"Comparison Functions","href":"/database/supported-functions/trino/comparison-functions"},{"title":"Binary Functions","href":"/database/supported-functions/trino/binary-functions"},{"title":"Conditional Functions","href":"/database/supported-functions/trino/conditional-functions"},{"title":"Array Functions","href":"/database/supported-functions/trino/array-functions"}]}]},{"tab":"Cloud","pages":[{"title":"Cloud","href":"/cloud/introduction"}]},{"tab":"Linter","pages":[{"title":"Linter","href":"/linter/overview"}]},{"tab":"Releases","pages":[{"title":"Releases","href":"/releases/latest"}]},{"tab":"Reference","pages":[{"title":"Reference","href":"/reference/sdf-cli"}]}]},"basePath":"","title":"SDF DB Overview - SDF","buildId":"dpl_9RFrWkXdFTJCytfx6jAofvAaEXr6","deploymentId":"dpl_9RFrWkXdFTJCytfx6jAofvAaEXr6","dynamics":["10e4515597","07c022d89b"],"chunks":["BannerMarkdown-DpgbmzWY.js","dist-CiVXVcSh.js","lib-DuNMoZ05.js","lib-B8HbPgcC.js","katex-YMM-FMeD.js","html-void-elements-mCSPHezU.js","marked.esm-CZWythHk.js","Frame-1H5zLJUq.js","DynamicMarkdown-RhjEuCHC.js"]}