https://linen.dev logo
Join Slack
Powered by
Hi, I am currently trying to run the dbt example d...
# general
d
Hi, I am currently trying to run the dbt example defined in the Lightdash repository but am encountering the following error:
Copy code
ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash/examples/full-jaffle-shop-demo/dbt (main)
$ lightdash dbt run 
(node:14208) [DEP0040] DeprecationWarning: The `punycode` module is deprecated. Please use a userland alternative instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
Usage: dbt run [OPTIONS]
Try 'dbt run -h' for help.

Error: Invalid value for '--profiles-dir': Path 'C:\\Users\\ASUS\\.dbt' does not exist.
Failed to run dbt:
  Command failed with exit code 2: dbt run
:warning: You are using Node.js version v22.12.0. Lightdash CLI is optimized for v20 so you might experience issues.

ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash/examples/full-jaffle-shop-demo/dbt (main)
$
The main issue appears to be that the 
--profiles-dir
argument is pointing to a non-existent path: 
C:\\Users\\ASUS\\.dbt
✅ 1
p
👋 Thanks for your message - someone from the Lightdash support team will get back to you asap. Feel free to add any additional context to the thread here in the meantime (screenshots, app version if you're self-hosting etc.).
i
hi @Divyansh Khatri By default, Lightdash uses a default dbt profile, which is usually located in the user’s home directory under the 
.dbt
folder. you can change that by navigating to 
~/Documents/Github/lightdash/examples/full-jaffle-shop-demo/
and running lightdash with 
--profiles-dir
and 
--project-dir
overrides 
lightdash dbt run --profiles-dir ./profiles --project-dir ./dbt
here’s a Lightdash CLI reference page if you want to read mroe about it: https://docs.lightdash.com/references/lightdash-cli#lightdash-cli-reference
d
@Irakli i did as instructed but now for some reason this error is coming 
Env var required but not provided: 'PGHOST'
Logs
Copy code
ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash (main)
$ docker compose -f docker-compose.yml --env-file .env up --detach --remove-orphans
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"LIGHTDASH_INSTALL_ID\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"LIGHTDASH_LICENSE_KEY\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"AUTH_DISABLE_PASSWORD_AUTHENTICATION\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"AUTH_ENABLE_GROUP_SYNC\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"AUTH_GOOGLE_ENABLED\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"AUTH_GOOGLE_OAUTH2_CLIENT_ID\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"AUTH_GOOGLE_OAUTH2_CLIENT_SECRET\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_HOST\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_PORT\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_SECURE\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_USE_AUTH\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_USER\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_PASSWORD\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_ALLOW_INVALID_CERT\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_SENDER_NAME\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"EMAIL_SMTP_SENDER_EMAIL\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"RUDDERSTACK_WRITE_KEY\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"RUDDERSTACK_DATA_PLANE_URL\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"POSTHOG_PROJECT_API_KEY\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"POSTHOG_FE_API_HOST\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"POSTHOG_BE_API_HOST\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"OPENAI_API_KEY\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"OPENAI_MODEL_NAME\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"OPENAI_EMBEDDING_MODEL_NAME\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"AI_COPILOT_ENABLED\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"AI_COPILOT_EMBEDDING_SEARCH_ENABLED\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"LANGCHAIN_TRACING_V2\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"LANGCHAIN_ENDPOINT\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"LANGCHAIN_API_KEY\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"LANGCHAIN_PROJECT\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"GOOGLE_DRIVE_API_KEY\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"SLACK_SIGNING_SECRET\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"SLACK_CLIENT_ID\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"SLACK_CLIENT_SECRET\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"SLACK_STATE_SECRET\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"GITHUB_PRIVATE_KEY\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"GITHUB_APP_ID\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"GITHUB_CLIENT_ID\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"GITHUB_CLIENT_SECRET\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"GITHUB_APP_NAME\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="The \"GITHUB_REDIRECT_DOMAIN\" variable is not set. Defaulting to a blank string."
time="2025-03-21T09:18:02+05:30" level=warning msg="C:\\Users\\ASUS\\Documents\\Github\\lightdash\\docker-compose.yml: the attribute `version` is obsolete, it will be ignored, please remove it to avoid potential confusion"
[+] Running 4/4
 ✔ Network lightdash_default               Created                                                                                                                   0.0s 
 ✔ Container lightdash-headless-browser-1  Started                                                                                                                   0.7s 
 ✔ Container lightdash-db-1                Started                                                                                                                   0.6s 
 ✔ Container lightdash-lightdash-1         Started                                                                                                                   0.8s 

ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash (main)
$ cd examples 

ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash/examples (main)
$ ls
api/  example-dbt-schema/  full-jaffle-shop-demo/

ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash/examples (main)
$ cd full-jaffle-shop-demo

ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash/examples/full-jaffle-shop-demo (main)
$ ls
dbt/  docker-compose.yml  dockerfile  entrypoint.sh*  logs/  profiles/  renderDeployHook.sh*

ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash/examples/full-jaffle-shop-demo (main)
$ lightdash dbt run --profiles-dir ./profiles --project-dir ./dbt
(node:3076) [DEP0040] DeprecationWarning: The `punycode` module is deprecated. Please use a userland alternative instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
03:49:13  Running with dbt=1.9.3
03:49:13  [WARNING]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
03:49:13  Encountered an error:
Parsing Error
  Env var required but not provided: 'PGHOST'
Failed to run dbt:
  Command failed with exit code 2: dbt run --profiles-dir ./profiles --project-dir ./dbt
⚠️ You are using Node.js version v22.12.0. Lightdash CLI is optimized for v20 so you might experience issues.

ASUS@LAPTOP-8AVD04VR MINGW64 ~/Documents/Github/lightdash/examples/full-jaffle-shop-demo (main)
$
i have set my env variables and have verified my password . these are some of the variables in the .env
Copy code
PGHOST=db
PGPORT=5432
PGUSER=postgres
PGDATABASE=postgres
PGPASSWORD="newpassword"
LIGHTDASH_SECRET="not very secret"
i
hi @Divyansh Khatri since you are running lightdash in a container, I suggest running 
lightdash dbt run --profiles-dir ./profiles --project-dir ./dbt
inside the container instead of your host by logging to your container - 
docker exec -it ightdash-lightdash-1 bash
Open in Slack
PreviousNext
Powered by