Project the fields of self into a table.This method is useful when analyzing data that has deeply nested structs or arrays of structs. lift can be chained to avoid repeating column names and table references.
Was this page helpful?
{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"turntable","colors":{"primary":"#ff996d","light":"#ff996d","dark":"#ff996d"},"favicon":"/favicon.png","logo":{"light":"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_light.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=cb06ad2dabda5538ca5e0c7934f06448","dark":"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_dark.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=d5b369063e4b595b13529633741a060f"},"navbar":{"primary":{"type":"button","label":"Get Started","href":"https://www.turntable.so/get-started"}},"footer":{"socials":{"twitter":"https://twitter.com/Turntable","github":"https://github.com/turntable-so","linkedin":"https://www.linkedin.com/company/92694701/"}},"navigation":{"global":{"anchors":[{"anchor":"Join our Slack","href":"https://join.slack.com/t/turntable-community/shared_invite/zt-25p0olvhz-Z~c5QWq1jv2YFHQ46mMFDA","icon":"slack"},{"anchor":"GitHub","href":"https://github.com/turntable-so/vinyl","icon":"github"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"turntable","hasAudioNarration":false,"actualSubdomain":"turntable","customDomains":["docs.turntable.so"],"gitSource":{"type":"github","owner":"ianrtracey","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6a21e61b33a4518725aab1f2","collectionId":"e3708f9f-49f8-40d4-b8f7-95a8219c2324","schemaVersion":"v2"},"feedback":{"thumbs":true},"entitlements":{},"buildId":"6a21e61b33a4518725aab1f2:success","clientVersion":"0.0.4021","searchFilterCounts":[{"language":"default","tag":"Reference","count":23},{"language":"default","tag":"CLI","count":11},{"language":"default","tag":"Extension","count":9},{"language":"default","tag":"Column Reference","count":9},{"language":"default","tag":"Basic Concepts","count":5},{"language":"default","tag":"Getting started","count":3},{"language":"default","tag":"Connectors","count":3},{"language":"default","tag":"FAQ","count":2},{"language":"default","tag":"Column-level lineage","count":2},{"language":"default","tag":"Docs composer","count":2}]},"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":"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":"pause-universal-search-reconcile","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":"per-site-search-delta","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":"editor-private-page-search","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":"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":"byok-sep-25","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":"billing-updated-9-15","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":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"reference/column/obj","slug":"/reference/column/obj","pageMetadata":{"title":"Struct Operations","description":null,"href":"/reference/column/obj"},"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={p:`p`,..._provideComponents(),...props.components},{Heading}=_components;if(!Heading)_missingMdxReference(`Heading`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`obj-destructure`,children:`obj.destructure`}),`\n`,_jsx(_components.p,{children:`Destructure a StructValue into the corresponding struct fields.`}),`\n`,_jsx(_components.p,{children:`When assigned, a destruct value will be destructured and assigned to multiple columns.`}),`\n`,_jsx(Heading,{level:`2`,id:`obj-lift`,children:`obj.lift`}),`\n`,_jsx(_components.p,{children:`Project the fields of self into a table.`}),`\n`,_jsx(_components.p,{children:`This method is useful when analyzing data that has deeply nested structs or arrays of structs. lift can be chained to avoid repeating column names and table references.`})]})}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":"Struct Operations","description":null,"href":"/reference/column/obj"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"obj.destructure","slug":"obj-destructure","depth":2,"children":[]},{"title":"obj.lift","slug":"obj-lift","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"turntable","siteName":"turntable","title":"Struct Operations - turntable","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-07T00:52:01.773Z","originalFileLocation":"reference/column/obj.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=\"application-name\" content=\"turntable\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_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/turntable/Dj3WJb4nh77Ftel1/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Struct Operations - turntable\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"turntable\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.turntable.so/reference/column/obj\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://turntable.mintlify.app/_mintlify/api/og/v2?division=Column+Reference\u0026amp;title=Struct+Operations\u0026amp;theme=1edc49b7c87eed2c259d9e2f\u0026amp;signature=29dfe5644f8428b829d9ef42d39ec853062483098adf28527017d8f5e2943569\">\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=\"Struct Operations - turntable\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://turntable.mintlify.app/_mintlify/api/og/v2?division=Column+Reference\u0026amp;title=Struct+Operations\u0026amp;theme=1edc49b7c87eed2c259d9e2f\u0026amp;signature=29dfe5644f8428b829d9ef42d39ec853062483098adf28527017d8f5e2943569\">\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/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"turntable\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#ff996d\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.turntable.so/reference/column/obj\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/reference/column/obj.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.turntable.so/#organization\",\"name\":\"turntable\",\"url\":\"https://docs.turntable.so\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_light.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=cb06ad2dabda5538ca5e0c7934f06448\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.turntable.so#website\",\"name\":\"turntable\",\"url\":\"https://docs.turntable.so\",\"publisher\":{\"@id\":\"https://docs.turntable.so/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.turntable.so/reference/column/obj#webpage\",\"url\":\"https://docs.turntable.so/reference/column/obj\",\"name\":\"Struct Operations\",\"dateModified\":\"2026-01-07T00:52:01.773Z\",\"isPartOf\":{\"@id\":\"https://docs.turntable.so#website\"},\"breadcrumb\":{\"@id\":\"https://docs.turntable.so/reference/column/obj#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.turntable.so/reference/column/obj#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Reference\",\"item\":\"https://docs.turntable.so/reference/table\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Column Reference\",\"item\":\"https://docs.turntable.so/reference/column/standard\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Struct Operations\",\"item\":\"https://docs.turntable.so/reference/column/obj\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.turntable.so/reference/column/obj#article\",\"headline\":\"Struct Operations\",\"name\":\"Struct Operations\",\"url\":\"https://docs.turntable.so/reference/column/obj\",\"mainEntityOfPage\":{\"@id\":\"https://docs.turntable.so/reference/column/obj#webpage\"},\"dateModified\":\"2026-01-07T00:52:01.773Z\",\"publisher\":{\"@id\":\"https://docs.turntable.so/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.turntable.so#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"turntable\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"turntable","nav":{"global":{"anchors":[{"anchor":"Join our Slack","href":"https://join.slack.com/t/turntable-community/shared_invite/zt-25p0olvhz-Z~c5QWq1jv2YFHQ46mMFDA","icon":"slack"},{"anchor":"GitHub","href":"https://github.com/turntable-so/vinyl","icon":"github"}]},"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":"/security/on_prem_agent"}]},{"tab":"Extension","pages":[{"title":"Extension","href":"/extension/getting-started/prerequisites"}]},{"tab":"CLI","pages":[{"title":"CLI","href":"/vinyl/introduction"}]},{"tab":"Reference","groups":[{"group":"Connectors","pages":[{"title":"Postgres","href":"/reference/connectors/postgres"},{"title":"BigQuery","href":"/reference/connectors/big_query"},{"title":"File","href":"/reference/connectors/file"}]},{"group":"Reference","pages":[{"group":"Table Reference","pages":[{"title":"Table Operations","href":"/reference/table"}]},{"group":"Column Reference","pages":[{"title":"Standard Operations","href":"/reference/column/standard"},{"title":"Math Operations","href":"/reference/column/math"},{"title":"Regex Operations","href":"/reference/column/re"},{"title":"String Operations","description":null,"href":"/reference/column/str"},{"title":"Struct Operations","href":"/reference/column/obj"},{"title":"Datetime Operations","description":null,"href":"/reference/column/dt"},{"title":"Map Operations","href":"/reference/column/dict"},{"title":"URL Operations","href":"/reference/column/url"},{"title":"Array Operations","href":"/reference/column/array"}]}]}]}]},"title":"Struct Operations - turntable","buildId":"dpl_EnxDqhjaNc9a8MVa833TGULPd9uJ","deploymentId":"dpl_EnxDqhjaNc9a8MVa833TGULPd9uJ","dynamics":[],"chunks":[]}
