A Matillion ETL project is a logical grouping of configuration settings and jobs. All work carried out in Matillion ETL will be within the scope of a specific project, and a given Matillion ETL instance may contain multiple projects that users can switch between.
The project hierarchy
Projects are organized into a hierarchy of Project Group > Project > Version > Job. That is, a Matillion ETL instance may contain multiple project groups, which each contain multiple projects, and each project may have multiple versions, as in this example:
This shows the project group "aws-snowflake" which contains three projects. We have opened one of these projects, "CData_regression", to show the Default project version, which contains three jobs.
To understand project versions, read Manage Versions.
Selecting a project
When logging in to a Matillion ETL instance, you are presented with the Join Project dialog, and must choose a project before proceeding. You can switch to another project at any time by clicking Project → Switch Project, which will also open the Join Project dialog.
You can create a new project from Join Project by clicking Create Project. Read Create Project.
The All Jobs tab of the Join Project dialog shows the full project hierarchy available to you. To switch to a project, expand and navigate the hierarchy, select the project you want to join, and click OK.
The Recent Jobs tab contains a list of all jobs you have recently opened. To switch to the project containing that job, click the job and then click OK. You will be switched to the project, with that specific job open on the job canvas.
The Search Jobs tab allows you to search for a particular job by name and/or description, and switch to the project containing that job.
To search for a job, enter your search string in the field at the top of the tab, and then click Search. This will produce a list of all jobs that match your search string. To switch to the project containing the job you want, click the job and then click OK. You will be switched to the project, with that specific job open on the job canvas.
Use the following options to specify how the search will be carried out:
- Default version only — With this option selected, the search results will only include jobs in the default version of a project. Clear this checkbox to include all project versions in the results. Read Manage Versions for an explanation of project versions.
- Search descriptions — With this option selected, the search results will include jobs where the search string is found in either the job description or the job name. Clear this checkbox to search only job names.
- Case sensitive — With this option selected, the search results will have to match the exact case (capitalization) of the search string. Clear this checkbox to find matching strings regardless of case.