If you want to use a local source file, for example in transformation maps, upload this file (for example myfile.csv) using the Configurations, Files section in the Actian Data Platform (formerly Avalanche) cloud environment. Use the following source path in the map:

Here LOCAL_JOB_SPEC_DIR is a predefined Actian Warehouse (formerly Avalanche Warehouse) system macro that should be created and set in DataConnect. When a package (djar) is deployed in Actian Warehouse (using the Import Integrations option), LOCAL_JOB_SPEC_DIR automatically points to the Configurations, Files section. Set the PROJECT macro to the project name when run locally. This allows to keep the source file in the project folder. When you are deploying to Actian Warehouse, delete the PROJECT macro from the source path, before creating a package.