Query data with Worksheet

Prerequisites

  • You must have your development credentials configured for that project.

Worksheet

Users can query data from multiple files of a project on the worksheet. Each file shows its directory path and subdirectory of the git repository. Modified data changes are highlighted based on modified (M), moved successfully (U) and invalid file path (D). Use double underscores (__) to display autocomplete suggestions to help construct your code syntax better.

Users can Preview the SQL model result on the output query panel to see the Results. You can also copy the Results by their rows if needed.

Compile your query and view the output on the Compiled Code tab.

Abort a model preview or compilation process by clicking on Abort. Aborting a model preview or compilation stops the query from processing.

Lineage

Data Lineage provides a holistic representation of your models on the output query panel of the Console. It provides a visual graph (DAG) of sequential workflows at the data set level with accessibility and search capabilities. Lineage enhances user productivity and decision-making, enabling users to build, troubleshoot, and analyze models more efficiently. Users can also track dashboard issues to their source models to help them assess changes' downstream impact.

You can view the Lineage of the data model and hide/ show parent and children nodes. Navigate the layout and customize the viewing screen with an expanded view, zoom in/ out and reset the view. Users can search for models in your repository as required and use tags to include/exclude models during the search. Search for a model like model_new, including complex searches (e.g., 2+model+2) to view the immediate dependencies of the transformation. You can also filter models by tags to refine your search results with autosuggested models. For example, a complex search like 2 + model + 2 will display the parent and child nodes up to two levels. Lineage diagrams are available to download in PNG format.

Terminal

Run dbt commands at the terminal level from the Console. The Terminal also provides insights into each command execution including its status, duration, branch, and system logs. System logs provide detailed information about the execution process including the execution status, queries, database interaction, errors and warnings. The insights aid in debugging, monitoring, auditing, and optimization of data transformation workflows

Recommended dbt commands to get started:

  • dbt run: Runs the dbt models defined in your project to generate the corresponding view in your database.

  • dbt test: Executes tests defined in your dbt project to validate the quality and correctness, and ensures that your data meets defined criteria.

Pull up the Terminal to run dbt commands for the terminal. To abort a command execution, click Abort on the right.

Last updated