Loading
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Unstructured Data in Data 360

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Unstructured Data in Data 360

            By bringing unstructured data in Data 360, you can ground your Agentforce agents, generative AI, analytics, and automation use cases with business-specific data that delivers deeper insights for your users and customers.

            Required Editions

            Available in: All Editions supported by Data 360. See Data 360 edition availability.

            Unstructured data is data that doesn’t have a specific, consistent format and can’t be easily stored in a typical relational database. Its lack of structure makes it particularly challenging to search or analyze. However, AI technologies, such as large language models, can process unstructured data effectively. Common forms of unstructured data include chat transcripts, PDFs, audio and video files, legal documents, and other large texts, such as books. In Salesforce, unstructured data can come from Knowledge Articles or sales call transcripts. To learn more about unstructured data, see these resources.

            Unstructured Data Lake Objects

            For typical structured data, a data lake object (DLO) is a storage container for the data ingested using a data stream in Data Cloud. Unstructured data is referenced directly by an unstructured data lake object (UDLO) that can also be ingested by data stream.

            A single UDLO contains metadata for a collection of unstructured data files.

            A UDLO has these key pieces of metadata at the table level.

            • Content Type: For a UDLO, contains a metadata attribute value of Content
            • Total Records: Indicates the number of records in the UDLO. Because each record in the UDLO corresponds to a file on the blob store, the number of records in a UDLO represents the number of unstructured data files that are represented in the UDLO.
            • Last Updated On: The timestamp for when the file metadata stored in the UDLO was most recently modified.

            UDLO Schema Attributes

            The UDLO schema has these attributes.

            Field Label Field API Name Data Type Description
            File Path FilePath__c Text Primary Key: Contains the relative path of the source file
            Resolved FilePath ResolvedFilePath__c Text Fully resolved path of the file, for internal use
            Content Type ContentType__c Text The file MIME type, such as text/csv or text/html
            Parent Id ParentId__c Text Used to set up a foreign key to a related object
            Size Size__c Number File size, in bytes
            Col1…Col5 Col1__c…Col5__c Text Currently unused
            Data Source Data Source__c Text <Empty>
            Data Source Object DataSourceObject__c Text <Empty>
            Internal Organization InternalOrganization__c Text <Empty>
            ETag ETag__c Text Currently unused
            KQ_FilePath KQ_FilePath__c Text Key Qualifier for "FilePath__c"
            URL URL__c Text URL in source.
            Type Type__c Text File types such as .html, .pdf
            Title Title__c Text Title of the document
            Metadata Metadata__c Text Extra metadata (currently only used in the Youtube connector)
            Last Modified LastModified__c Date/Time The data's latest update time
            Labels Labels__c Text Labels, tags etc. Defined per connector type

            UDMO Schema Attributes

            Unstructured data model objects (UDMOs) are groups of data created from unstructured data sources. The UDMO schema has these attributes.

            Field Label Field API Name Data Type Description
            File Path FilePath__c Text Primary Key: Contains the relative path of the source file
            Resolved FilePath ResolvedFilePath__c Text Fully resolved path of the file, for internal use
            Content Type ContentType__c Text The file MIME type, such as text/csv or text/html
            Parent Id ParentId__c Text Used to set up a foreign key to a related object
            Size Size__c Number File size, in bytes
            Col1…Col5 Col1__c…Col5__c Text Currently unused
            Data Source Data Source__c Text <Empty>
            Data Source Object DataSourceObject__c Text <Empty>
            Internal Organization InternalOrganization__c Text <Empty>
            ETag ETag__c Text Currently unused
            KQ_FilePath KQ_FilePath__c Text Key Qualifier for "FilePath__c"
            URL URL__c Text URL in source.
            Type Type__c Text File types such as .html, .pdf
            Title Title__c Text Title of the document
            Metadata Metadata__c Text Extra metadata (currently only used in the Youtube connector)
            Last Modified LastModified__c Date/Time The data's latest update time
            Labels Labels__c Text Labels, tags etc. Defined per connector type

            Fully Qualified Keys for UDLOs and UDMOs

            Fully Qualified Keys Data 360 adds key qualifier fields to UDLOs and UDMOs, which behave the same as in standard DLOs and DMOs. Key qualifier fields can be added when you create object relationships between DMOs and UDMOs. See Fully Qualified Keys in Data Objects.

            See Also

             
            Loading
            Salesforce Help | Article