File Jobs

"File Jobs" is a feature that allows users to automate actions on files, such as moving, editing metadata, and deleting files within a workflow. It simplifies processes and enables automated file management tasks.

Add File Jobs

To add a new “File Jobs”, follow the steps below:

1. In the left-hand menu, click "File Jobs".

2. Then, click "Add File Job Job".

3. The edit screen for the new File Job will be displayed automatically.

4. Create actions for the File Job. Learn more about actions.

5. Click the "Save" icon to complete the creation.

File Job Options

The menu in the upper right corner provides the following actions:

File Job Options

• Create new Job: Automatically creates a new Job, which will open in a new tab.

• Execute current Job: Runs the active Job in the current tab, processing the defined queries.

• Execute current Job in new tab: Opens a new tab to run the same Job.

• Job Process List: Displays all running processes.

• Job Configuration: Allows you to configure parameters for the current Job. Settings are organized into two tabs:

  • General: Set the Job name and drag a file or folder to enable actions (Move, Edit metadata, Delete files, etc). Learn more about actions.
  • Groups: Manage access permissions by adding or removing groups as needed.

Finally, click "Apply" to save the settings.

• Save Job: Saves the current state of the Job.

File Job Actions

You can perform the following actions using File Jobs:

Move

To move a file, follow these steps:

1. In the File Job, click “Job Configuration".

2. Make sure a file or folder is selected.

3. Choose the "Move option and click "Add Action".

4. In the displayed field, enter the name of the new folder.

5. Click Execute current File Job to execute the action.

6. Done! Your file has been moved to the new directory.

Edit Metadata

To move a file, follow these steps:

1. In the File Job, click “Job Configuration".

2. Make sure a file or folder is selected.

3. Choose the "Edit Metadata" option and click "Add Action".

4. You can modify the following settings:

• Read Group

• Write Group

• Tags

1. Click “Execute current File Job” to execute the action. Done! Your file metadata has been successfully updated..

Delete

To delete a file, follow these steps:

1. In the File Job, click “Job Configuration".

2. Make sure a file is selected.

3. Choose the "Delete File" option and click "Add Action".

4. Click “Execute current File Job” to execute the action.

5. Done! The file has been deleted.

Delete Folder

To delete a folder, follow these steps:

1. In the File Job, click “Job Configuration".

2. Make sure a folder is selected.

3. Choose the "Delete Folder" option and click "Add Action".

4. Click “Execute current File Job” to execute the action. Done!

5. The folder has been deleted.

Create new Folder

To create a new folder, follow these steps:

1. In the File Job, click “Job Configuration".

2. Make sure a folder is selected.

3. Choose the "Create New Folder" option and click "Add Action".

4. Enter a name for the new folder.

5. Click “Execute current File Job” to execute the action.

6. Done! The folder has been created.

Returned Data Panel

After selecting or running a Job in the Data Warehouse, the Returned Data Panel section displays three distinct tabs with information related to data execution and structure:

Files

In this tab, you can view the files available in the selected directory or file filter. It's the starting point to understand which data is being used as input.

Output

This tab shows the results of the Job after execution. Here, you can review the content generated based on the applied SQL transformations and queries.

Table Metadata

After selecting a table, you can view its metadata, such as column names, data types, and other properties. This tab helps you understand the structure of the data that was generated or manipulated.