File Explorer

Your current dbt project files are updated on the File Explorer tab of the Console page. 5X Managed dbt CoreTM supports files for SQL and Python queries. The dbt project files constitute databases of the dbt project set up when configuring the development environment.

Modified files get updated with a modified tag (“M”) on the File Explorer and Version Control tabs. You can search for files using the search bar and manage actions on SQL files to rename, delete, and move files between folders.

You can also modify directories to add folders, add files, and rename and delete directories.

Note

Users cannot move to the main(read-only) branch with modified changes in the draft.

Parameters

The dbt files included by default are as follows:

File nameDescription

dbt_project.yml

The dbt project configuration file required to connect with the user profile and access the database.

analyses

A way to organize analytical SQL queries in your project such as the general ledger from your QuickBooks.

dbt_packages

Package configuration and details. The directory is removed by dbt clean after modified changes are compiled.

logs

the logic to generate logs or capture metadata related to data processing activities

models

Directories to where your model and source files live.

snapshots

Way to capture the state of your mutable tables so you can refer to it later.

target

Directory which stores the compiled SQL files, and is configured with target-path.

Others

README.md and .gitignore

dbt_project.yml default parameters:

ParametersAttributeDefault value

profile

Configures which user profile dbt uses for this project using the development credentials.

default

name

Project name

n/a (user-defined)

version

Project version

n/a (user-defined)

config-version

dbt configuration version

n/a (user-defined)

model-paths

Models in this project are configured in the models/ directory.

models

target-path

Directory which stores the compiled SQL files.

target-path.

clean-targets

directories to be removed by dbt clean

target

dbt_packages

analysis-paths

Directory storing the analyses files.

analyses

test-paths

Directories storing the test files.

tests

seed-paths

Directory storing the seed files.

seeds

macro-paths

Directories storing the macros.

macros

snapshot-paths

Directory storing the snapshots.

snapshots

Last updated