# Configuration

#### **Useful dbt profile assignment (to be inserted in ".zshrc"):**

For an easier `profiles.yml` file assignment, the following function can be used.

```bash
function dbt_profile_assign() {
    export DBT_PROFILES_DIR=$1
}
```

An example application would be if you have your `profiles.yml` file in your current working directory, you could call the previous function as:

```
dbt_profile_assign $(pwd)
```

#### Common GitLab PAT

In Dashlane secured notes, you will find a note called *\[COMMON] Gitlab PAT.*

Add `COMMON_GITLAB_PAT` to your local environment variables to be able to fetch git repos in your projects, for example:

```
export COMMON_GITLAB_PAT = <PAT TOKEN>
```

```yaml
packages:
  - git: :{{ env_var('COMMON_GITLAB_PAT') }}@gitlab.com/a8042/data-analytics/dp-common.git
    revision: main
    warn-unpinned: false
```

#### fzf for dbt

{% @github-files/github-code-block url="<https://github.com/Infused-Insight/fzf-dbt>" %}

#### Recommended config

* [Visual Studio Code](https://code.visualstudio.com/) (IDE)
* [dbt Power User (VS code) plugin](https://marketplace.visualstudio.com/items?itemName=innoverio.vscode-dbt-power-user)
* [Better Jinja (VS code) plugin](https://marketplace.visualstudio.com/items?itemName=samuelcolvin.jinjahtml)