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