Permissions List

Permissions list

Below is an exhaustive list of all available permissions within Matillion ETL. These permissions directly correspond to events logged in the Audit Log and thus this is also an exhaustive list of audited events.

Create your own Extract connector

• Get Place Holders Replaced Uri For Generate RSDResult
• Add Extract Connector Endpoint Command
• Create New Extract Connector Command
• Export Connector Command
• Get All Endpoints For Connector Command
• Get All Extract Connectors Command
• Get Wizard Result Command
• Remove Endpoint Command
• Remove Extract Connector Command
• Get Encoded Authorization Token
• Response Body Validator
• Run Http Request
• Schema Guesser Command
• Update Extract Connector Endpoint Command
• Get Column Entries From Results Body
• Get Column Entries From Schema
• Check Parameters Grid Matched Endpoint URL
• Extract Parameters From Endpoint URL
• Get Place Holders Replaced Endpoint URL

API Profile

Read

• Exist APIProfile
• Get APIProfile Files Truncated
• Get APIProfile Truncated Contents
• Get All APIProfiles
• Get All Original Files
• Get Api Profile Location
• Get Connection Props
• Get Original File
• Get Summary Values

Write

• Add APIProfile
• Delete APIProfile
• Delete APIProfile File
• Generate Schema File
• Import APIProfile
• Import APIProfile File
• Revert APIProfile
• Revert APIProfile File
• Save APIProfile
• Set APIProfile Properties
• Test APIProfile
• Test APIProfile File
• Test APIProfile File With Input Params
• Update APIProfile
• Update APIProfile File
• Validate APIProfile File
• Extract Parameters From Endpoint URL
• Get Authorization Header Value
• Get Column Entries From Results Body
• Get Uri With Added Query Parameters From Endpoint Uri
• Get Uri Without Parameters From Endpoint Uri
• Run Endpoint Step Request
• Validate XMLOr JSONContents
• Get Column Entries From File
• Add New Data Sources
• Get Data Source Columns

CDC

Read

• Generic CDCUpdate Broadcast
• Get CDC Details
• Get CDCLambda Status
• Get CDCQueue Status
• Get CDC Tasks
• Validate CDC Task

Write

• CDCTask Resolve Errors
• Create / Edit CDC
• Delete CDC
• Delete CDC FIFO Queue
• Delete CDC Lambda function
• Force Delete CDC
• Import CDCTask
• Start / Stop CDC
• Save CDC Details Using API
• Save CDC Details Using UI
• Update Lambda Function

Cloud Storage

Read

• Get Cloud Model Accounts
• Get Cloud Models Blob
• Get Cloud Models S3 Component
• Get Cloud Model Container S3
• Get Cloud Model Container GS
• Get Cloud Models GS
• Get Cloud Models S3

Credential

Read

• Get Available Credentials
• Get Available User Defined Credentials
• Get Azure Credentials
• Get Clusters
• Get AWSCredentials
• Get Available User Credentials
• Get GCPCredentials
• Get Redshift Buckets

Write

• Create Azure Credential
• Delete Azure Credential
• Update Azure Credential
• Test Credentials
• Create AWSCredential
• Delete AWSCredential
• Update AWSCredential
• Create GCPCredential
• Delete GCPCredential
• Update GCPCredential

License

Read

• Get Current License

Write

• Add License

Notice

Write

• Dismiss Notice

OAuth

Read

• Deliver Redirect URL
• Deliver Redirect URLDecaf
• Get Connection Properties
• List OAuth Details
• Get OAuth Infos
• Get OAuth Settings Path
• Get OAuth URL
• Get OAuth Details

Write

• Create OAuth
• Delete OAuth
• Update OAuth Details

Password

Read

• Get Azure Key Vault Keys
• Get Azure Key Vaults
• Get Azure Resource Groups
• Get Azure Storage Accounts
• Get Password By ID
• Get Password Entries
• Get Crypto Keys
• Get Key Rings
• Get Locations
• Get Master Keys
• Get KMSOptions SF

Write

• Create Key Vault Password
• Create Password
• Delete Password
• Update Key Vault Password
• Update Password
• Update Password Description

Project

Read

• Generate Report
• Join Project
• Get Task Jobs
• Get Task Packages
• Get Customer Loaded Rows Chart Data
• Get Pipeline Container Info
• Get Pipeline Edit Metadata
• Get Pipeline Feature Switches
• Get Pipeline Info
• Get Pipeline Info Dialog Data
• Get Pipeline Load Table Data
• Get Pipeline Loaded Rows Chart Data
• Get Pipeline Page
• Get Pipeline Settings Info
• Get Pipeline Total Rows Metric
• Get Pipelines
• Get Source And Target Pipeline Info

Write

• Update Project Group
• Create Project
• Delete Project
• Manage Project
• Paste Explorer Items
• Create Folder
• Delete Folders
• Duplicate Folders
• Move Folders
• Recycle Folders
• Rename Folder
• Create Pipeline
• Delete Pipelines
• Disable Pipeline
• Enable Pipeline
• Update Pipeline
• Update Pipeline Settings

Environment

Read

• External Environment Results
• Internal Environment Results
• Get Table Details BQ
• Check Environment Limit
• Get Current Environment Parameters
• Get Data Types With Size And Precision
• Get Environment
• Get Environment Parameters
• Get Environments
• Test Environment
• Get All Tables
• Get Schemas
• Get Columns
• Get Tables And Views And UDFs
• Test Connection Details
• Get Database Queries
• Get Databases RS
• Get External Table
• Get External Tables
• Get Internal Table
• Get Load Errors
• Get Load Status
• Get Databases SF
• Get External Table Details SF
• Get Roles SF
• Get Schemas SF
• Get Sequences
• Get Stages
• Get Table Definitions SF
• Get Table Properties SF
• Get View Properties SF
• Get Warehouses SF
• Get Storage Integrations

Write

• Cancel Task Batch
• Create Environment
• Delete Environment
• Delete Schema
• Delete Table
• Select Schema
• Set Environment Connection
• Switch Environment
• Create External Schema
• Create Internal Schema
• Create Aws Stage
• Create Azure Stage
• Create GCP Stage
• Create Internal Stage
• Create Schema
• Create Sequence
• Delete Sequence
• Drop Stage

Job

Execute

• Execute Orchestration Job
• Execute Transformation Job
• Run Schedule Now
• Validate Orchestration Job
• Validate Transformation Job

Read

• Export
• Request Job Search Results
• Request Recent Job Info

Write

• Import
• Populate Assert Component
• Delete Jobs
• Manage Job
• Recycle Jobs
• Restore Jobs
• Set Parameter Elements
• Restore Folders
• Unpack Shared Job
• Create Orchestration Job
• Redo Orchestration Job
• Undo Orchestration Job
• Extract Orchestrations To New Job
• Duplicate Orchestration Jobs
• Create Transformation Job
• Redo Transformation Job
• Undo Transformation Job
• Duplicate Transformation Jobs

Component

Execute

• Get Plan
• Get Row Count
• Get Sample
• Get Sample Orchestration
• Get Column Lineage
• Execute Python
• Execute SQLScript
• Run From Component
• Run Single Component

Read

• Get Grid Variable Exports
• Get Row Count Orchestration With Task
• Get Metadata Columns
• Get Metadata Details
• Get Metadata Sample
• Get Metadata Tables
• Get Row Count Orchestration
• Get Row Count Support
• Get Parameter Metadata
• Component Wizard Server Command
• Pipeline Wizard Server Command

Write

• Create Grid Export Mapping
• Delete Grid Export Mapping
• Move Components
• Set Export Variables
• Set Parameter
• Create Copy To External Components
• Connect Orchestration Components
• Connect Orchestration Iteration Components
• Create Orchestration Component
• Delete Orchestration Component
• Set Component Activation Status
• Paste Orchestration Components
• Reset Schema Cache
• Connect Transformation Components
• Create Data Inputs
• Create Transformation Component
• Delete Transformation Component
• Validate Expression
• Validate Expression For Sample
• Paste Transformation Components

Note

Write

• Create Note
• Delete Notes
• Link Note Component
• Move Notes Z
• Set Note
• Set Note Size

Schedule

Read

• Get Schedule Info
• Get Schedules
• Test Schedule Trigger

Write

• Create Schedule
• Delete Schedule
• Edit Schedule

Version

Write

• Clear Missing Jobs
• Delete Version
• Move Jobs
• Set Version Lock
• Simple Create Version
• Simple Delete Version
• Manage Version

Source control management (SCM)

Read

• Check Branch Changes
• Get Differences
• Get Remote Metadata
• Get SCMRemote
• Get SCMState
• Get Version Branches
• SCMFetch
• SCMPush
• SCMFetch API
• SCMPush API
• Get SCMLog

Write

• Commit Version
• Create New Branch
• Delete Branch
• Perform Merge
• Set Remote
• Switch To Commit
• Unset Remote
• Clone Repository
• Initialise Repository

Queue

Read

• Get Queue Details
• Test Queue Details
• Get Available Queues

Write

• Set Queue Details

User Session

Read

• Disconnect Session
• Get Active Sessions
• Update Password

Shared Jobs

Read

• Export Shared Job

Write

• Delete Shared Jobs
• Generate Shared Job

Task History

Read

• Get Task History
• Get Task
• Get Task History Summary
• Get Pipeline Task Log Output

Variable

Job

Read

• Get Job Grid Definitions
• Get Job Grids
• Get Job Variables
• Get Scalar Variables By Job Name

Write

• Delete Variable
• Set Environment Variables
• Delete Job Grid Variable
• Update Job Grid Variable
• Set Job Variables

Manage Webhook Error Reporting

• Get Error Reporting Config
• Set Error Reporting Config
• Test Webhook Payload

Webhook Payload

Read

• Get Webhook Payload
• Get Webhook Payload By Name
• Get Webhook Payloads

Write

• Delete Webhook Payload
• Save Webhook Payload
• Update Webhook Payloads
• Clientside Resolver

Scripting

• Get Interpreters
• Set Interpreters

Secret Manager

Read

• List Secret Managers

Write

• Create Secret Manager
• Delete Secret Manager