Power User for dbt

https://help.altimate.ai/dbt-power-user/
Admin
Power User for dbt is a VS Code and Cursor extension that accelerates dbt and SQL development with...
Tokens:48,615
Snippets:536
Trust Score:8.2
Update:5 days ago
Show doc for...
Tokens:
Raw
### Install sqlfmt with jinjafmt extra using pipx

Source: https://help.altimate.ai/dbt-power-user/setup/optConfig?q=

Install sqlfmt with the jinjafmt extra, which also installs Black. Requires pipx; if not installed, install it first.

```bash
pipx install 'shandy-sqlfmt[jinjafmt]'

```

--------------------------------

### Install altimate-datapilot package

Source: https://help.altimate.ai/dbt-power-user/test/defertoprod?q=

Install the altimate-datapilot Python package required to upload manifest files to the Altimate SaaS instance.

```bash
pip install altimate-datapilot
```

--------------------------------

### Install dbt Fusion on Windows (PowerShell)

Source: https://help.altimate.ai/dbt-power-user/setup/reqdConfigFusion

Run this PowerShell command to install dbt Fusion on Windows. It downloads and executes the official installer script.

```powershell
irm https://public.cdn.getdbt.com/fs/install/install.ps1 | iex
```

--------------------------------

### Verify dbt Fusion Installation

Source: https://help.altimate.ai/dbt-power-user/setup/reqdConfigFusion

Run `dbt --version` to verify that dbt Fusion is installed. The output should include 'dbt-fusion' in the version information.

```bash
dbt --version
```

--------------------------------

### Install DataPilot CLI with pip

Source: https://help.altimate.ai/dbt-power-user/discover/setupui-dbt-core?q=

Installs the latest version of the DataPilot CLI, which is used to upload manifest and catalog files to the SaaS instance.

```bash
pip install altimate-datapilot-cli --upgrade
```

--------------------------------

### Install dbt Fusion on macOS and Linux

Source: https://help.altimate.ai/dbt-power-user/setup/reqdConfigFusion

Run this curl command in a terminal to install dbt Fusion on macOS or Linux. The command downloads and runs the official installer script with the --update flag.

```bash
curl -fsSL https://public.cdn.getdbt.com/fs/install/install.sh | sh -s -- --update
```

--------------------------------

### Disable dbt.hideWalkthrough setting

Source: https://help.altimate.ai/dbt-power-user/setup/optConfig?q=

Add this configuration to your VS Code settings.json file to prevent the extension setup walkthrough from appearing on startup.

```json
{
    "dbt.hideWalkthrough": true
}
```

--------------------------------

### Install Altimate Code standalone via npm

Source: https://help.altimate.ai/dbt-power-user/teammates/altimate-code

Install the Altimate Code CLI globally using npm. This enables standalone usage outside the IDE, including TUI, CLI, Web UI, and CI/CD interfaces.

```bash
npm install -g altimate-code

```

--------------------------------

### Upload manifest and catalog files with datapilot dbt onboard

Source: https://help.altimate.ai/dbt-power-user/discover/setupui-dbt-core?q=

Sample command and output for uploading manifest and catalog files. Replace placeholders like --token, --instance-name, and file paths with your own values. The output confirms successful onboarding and provides a status link.

```bash
(.venv) pradnesh@pradneshs-MacBook-Air jaffle_shop % datapilot dbt onboard --backend-url https://api.tryaltimate.com --token 00x0x0x0x0x0x0 --instance-name freemegatenant --dbt_core_integration_id 1 --dbt_core_integration_environment prod --manifest-path ./target/manifest.json --catalog-path ./target/catalog.json
Manifest onboarded successfully!
Catalog onboarded successfully!
Manifest and catalog ingestion has started. You can check the status at https://freemegatenant.demo.tryaltimate.com/settings/integrations/1/prod
```

--------------------------------

### Upload manifest and catalog files with DataPilot CLI

Source: https://help.altimate.ai/dbt-power-user/discover/setupui-dbt-core

Command to upload manifest and catalog files to the SaaS instance. Replace placeholders with actual paths and token. Output shows successful upload and a status URL.

```bash
(.venv) pradnesh@pradneshs-MacBook-Air jaffle_shop % datapilot dbt onboard --backend-url https://api.tryaltimate.com --token 00x0x0x0x0x0x0 --instance-name freemegatenant --dbt_core_integration_id 1 --dbt_core_integration_environment prod --manifest-path ./target/manifest.json --catalog-path ./target/catalog.json
Manifest onboarded successfully!
Catalog onboarded successfully!
Manifest and catalog ingestion has started. You can check the status at https://freemegatenant.demo.tryaltimate.com/settings/integrations/1/prod

```

--------------------------------

### Upload manifest file with datapilot dbt onboard

Source: https://help.altimate.ai/dbt-power-user/test/defertoprod?q=

Command to upload a manifest file to the Altimate SaaS instance. Replace 'Path/to/file' with the actual path, e.g., /Users/mrx/documents/repos/jaffle_shop/target/manifest.json. Run this command at regular intervals in CI/CD or orchestration tools to keep the manifest up to date.

```bash
datapilot dbt onboard --token  --instance-name  --dbt_core_integration_id  --manifest-path 'Path/to/file'
```

--------------------------------

### Add Altimate credentials to .env file

Source: https://help.altimate.ai/dbt-power-user/setup/optConfig?q=

Add these entries to your .env file to set the Altimate Key and Instance Name as environment variables.

```plaintext
ALTIMATE_KEY=<Altimate Key>
ALTIMATE_INSTANCE_NAME=<Altimate Instance Name>

```
Tokens:
Raw