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
            Query Federation

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Query Federation

            In Query federation, Data 360 queries data using partner-manager compute.

            When you deploy a data stream, an external data lake object (DLO) is created. The external DLO is a storage container with metadata for the federated data. The DLO acts as a reference and points to the data physically stored in the partner’s data warehouse or data lake. You can also opt for caching to improve performance.

            Note
            Note During the testing phase, we observed that the optimal data volume returned from the data lake when caching is enabled is up to 234 GB for Amazon Redshift, 20 GB for Snowflake, 23 GB for Databricks, and 10 GB for Google BigQuery. For our test datasets, these aforementioned data volumes translate to 1 Billion rows for Amazon Redshift, 500 million for Databricks, 750 million for Snowflake, and 100 million rows for Google BigQuery. These numbers are mere representative examples and the number of rows associated can vary for your use-cases.

            See Also

             
            Loading
            Salesforce Help | Article