Quick Start

Set up your sandbox and local environment to run a sample batch data transform script locally against the sandbox. Deploy the script to your sandbox, invoke code extension by creating a batch data transform, and then run the batch data transform to validate the code extension’s execution in the sandbox.

The sample script entrypoint.py reads data from the Account_Home__dll data lake object (DLO), converts the Description__c field to uppercase, drops the KQ_ParentId__c and KQ_Id__c columns (if present), and writes the transformed data to the Account_Home_copy__dll DLO.

Estimated time: ~20 minutes.

Edition Table
Available in: Developer, Enterprise, Performance, and Unlimited Editions. See Data 360 edition availability.
Permission Sets Needed
To run the sample script in a sandbox:Permission set:
  • Data Cloud Architect

Make sure that you have access to a sandbox with appropriate permission sets. If you don’t have a sandbox, create one. See Create a Data 360 Sandbox.

Create the required data lake objects (DLOs) to match the requirements of the entrypoint.py script. See Create Data Lake Objects.

Install Salesforce CLI and the Code Extension plugin on your computer. Authenticate Salesforce CLI to your Data 360 sandbox, and then initialize a script package. See Set Up Salesforce CLI for Code Extension.

When you authenticate Salesforce CLI to your Data 360 sandbox, specify myorg as the alias. In the next steps, every command that requires a target sandbox uses --target-org myorg.

  1. Go to your code extension package directory.

  2. Run this sample script against your sandbox.

  3. Review the output in your local terminal to verify that the batch data transform is successful and works as expected.

  1. Create a Data 360 configuration file from your sample script.

  2. Create a deployment package.

  3. Deploy the sample code extension to your sandbox.

  4. Invoke code extension by creating a batch data transform. See Invoke Code Extension by Creating a Batch Data Transform.

  5. Verify that the deployment status of my_custom_script is successful in the Data 360 UI. See Monitor Custom Script Deployments and Execution History.

  6. To run the my_custom_script batch data transform by using the Data 360 UI, click Data Transforms, click the triangle to the right of my_custom_script, and then select Run Now.

Check the code extension execution status. See Check Batch Data Transform Status. Review the transformed data to verify that it matches your expectations.

If the code extension execution fails, review the Run History tab in your code extension deployment details to see detailed execution logs, error messages, and performance metrics. This information helps you identify the root cause of failures and provides insights for debugging your custom scripts. See Run History.