Tuesday, 12 May 2015

Spoon - Editor

Component NameNameFunction
ToolbarSingle-click access to common actions such as create a new file, opening existing documents, save and save as.
Perspectives ToolbarSwitch between the different perspectives.
  • Data Integration — Create ETL transformations and jobs
  • Instaview — Use pre-made templates to create visualizations from PDI transformations
  • Visualize — Test reporting and OLAP metadata models created in the Model perspective using the Report Design Wizard and Analyzer clients
  • Model Editor — Design reporting and OLAP metadata models which can be tested right from within the Visualization perspective or published to the Pentaho BA Server
  • Schedule — Manage scheduled ETL activities on the Data Integration Server
Sub-toolbarProvides buttons for quick access to common actions specific to the transformation or job such as RunPreview, and Debug.
Design and View Tabs
The Design tab of the Explore pane provides an organized list of transformation steps or job entries used to build transformations and jobs. Transformations are created by simply dragging transformation steps from the Designtab onto the canvas and connecting them with hops to describe the flow of data.
The View tab of the Explore pane shows information for each job or transformation. This includes information such as available database connections and which steps and hops are used.
In the image, the Design tab is selected.
CanvasMain design area for building transformations and jobs describing the ETL activities you want to perform



Table 1. Spoon Icon Descriptions
IconDescription
Create a new job or transformation
Open transformation/job from file if you are not connected to a repository or from the repository if you are connected to one
Explore the repository
Save the transformation/job to a file or to the repository
Save the transformation/job under a different name or file name (Save as)
Run transformation/job; runs the current transformation from XML file or repository
Pause transformation
Stop transformation
Preview transformation: runs the current transformation from memory. You can preview the rows that are produced by selected steps.
Run the transformation in debug mode; allows you to troubleshoot execution errors
Replay the processing of a transformation
Verify transformation
Run an impact analysis on the database
Generate the SQL that is needed to run the loaded transformation.
Launch the database explorer allowing you to preview data, run SQL queries, generate DDL and more
Hide execution results pane
Lock transformation

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...