sfdcRegister Transformation

The sfdcRegister transformation registers a dataset to make it available for queries. Users can’t view or run queries against an unregistered dataset.

The sfdcRegister transformation overwrites the current version of the dataset.

You don’t need to register all datasets. For example, you don’t need to register an intermediate dataset that is used to build another dataset and doesn’t need to be queried. In addition, you don’t need to register datasets that are created when you upload external data because CRM Analytics automatically registers these datasets for you.

Carefully choose which datasets to register because:

• The total number of rows in all registered datasets can’t exceed 100,000 per platform license, or 250 million per platform license purchased before October 20, 2015.
• Users that have access to registered datasets can query their data. But you can apply row-level security on a dataset to restrict access to records.

Example Let’s look at an example. You create a dataflow that extracts opportunities from the Opportunity object. To register the dataset, name it "Opportunities," and apply row-level security on it, you add the sfdcRegister transformation as shown in the following dataflow definition file.

{
   "Extract_Opportunities": {
      "action": "sfdcDigest",
      "parameters": {
         "object": "Opportunity",
         "fields": [
            { "name": "Id" },
            { "name": "Name" },
            { "name": "Amount" },
            { "name": "StageName" },
            { "name": "CloseDate" },
            { "name": "AccountId" },
            { "name": "OwnerId" }
         ]
      }
   },
   "Register_Oppportunities_Dataset": {
      "action": "sfdcRegister",
      "parameters": {
         "alias": "Opportunities",
         "name": "Opportunities",
         "source": "Extract_Opportunities",
         "rowLevelSecurityFilter": "'OwnerId' == \"$User.Id\""
      }
   }
}

• sfdcRegister Parameters
  When you define an sfdcRegister transformation, you set the action attribute to sfdcRegister and specify the parameters.