Fanny Wiryana
08/31/2022, 3:20 PMFileNotFoundError: [Errno 2] No such file or directory: 'dbt'
dagster version is 0.15.8Fanny Wiryana
08/31/2022, 3:21 PMFileNotFoundError: [Errno 2] No such file or directory: 'dbt'
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_grpc/server.py", line 227, in __init__
self._loaded_repositories = LoadedRepositories(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_grpc/server.py", line 101, in __init__
loadable_targets = get_loadable_targets(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_grpc/utils.py", line 33, in get_loadable_targets
else loadable_targets_from_python_file(python_file, working_directory)
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_core/workspace/autodiscovery.py", line 26, in loadable_targets_from_python_file
loaded_module = load_python_file(python_file, working_directory)
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_core/code_pointer.py", line 86, in load_python_file
return import_module_from_path(module_name, python_file)
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_seven/__init__.py", line 51, in import_module_from_path
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 848, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/opt/dagster/repo_sync/data_engineering/dbt_repository.py", line 20, in <module>
dbt_assets = load_assets_from_dbt_project(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster_dbt/asset_defs.py", line 424, in load_assets_from_dbt_project
manifest_json, cli_output = _load_manifest_for_project(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster_dbt/asset_defs.py", line 41, in _load_manifest_for_project
cli_output = execute_cli(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster_dbt/cli/utils.py", line 102, in execute_cli
process = subprocess.Popen(
File "/usr/lib/python3.8/subprocess.py", line 858, in __init__
self._execute_child(args, executable, preexec_fn, close_fds,
File "/usr/lib/python3.8/subprocess.py", line 1704, in _execute_child
raise child_exception_type(errno_num, err_msg, err_filename)
Fanny Wiryana
08/31/2022, 3:22 PMdagit==0.15.8
dagster==0.15.8
dagster-airbyte==0.15.8
dagster-cron==0.11.16
dagster-dbt==0.15.8
dagster-graphql==0.15.8
dagster-pandas==0.15.8
dagster-postgres==0.15.8
dagster-slack==0.15.8
db-dtypes==1.0.2
dbt-bigquery==1.2.0
dbt-core==1.2.0
dbt-extractor==0.4.1
dbt-postgres==1.2.0
Adam Bloom
08/31/2022, 3:29 PMdbt_configured = dbt_cli_resource.configured(
{
"project_dir": DBT_PROJECT_DIR,
"profiles_dir": DBT_PROFILES_DIR,
}
)
Adam Bloom
08/31/2022, 3:29 PMAdam Bloom
08/31/2022, 3:29 PMFanny Wiryana
09/01/2022, 2:08 AMdata-eng
__ data_engineering
____ dbt_repository
__ dbt_transform
____ dbt.yaml
and this the code
ROOT_DIR = "/opt/dagster/repo_sync"
DBT_PROJECT_DIR = f"{ROOT_DIR}/dbt_transform"
DBT_PROFILES_DIR = f"{ROOT_DIR}/dbt_transform/config"
dbt_assets = load_assets_from_dbt_project(
DBT_PROJECT_DIR,
DBT_PROFILES_DIR,
)
Fanny Wiryana
09/01/2022, 2:48 AM@repository
def transformation_layer():
return with_resources(
dbt_assets,
resource_defs={
"dbt": dbt_cli_resource.configured(
{"project_dir": DBT_PROJECT_DIR, "profiles_dir": DBT_PROFILES_DIR}
),
},
)
Adam Bloom
09/01/2022, 2:31 PMFanny Wiryana
09/02/2022, 12:54 AMAdam Bloom
09/02/2022, 4:37 PMos.getcwd()
Adam Bloom
09/02/2022, 4:42 PMFanny Wiryana
09/05/2022, 4:34 AMnot adding dbt to your PATH
in server?Fanny Wiryana
09/05/2022, 8:35 AMsudo pip install dbt-bigquery=1.2.0
, now I got new error when loading the repo
dagster_dbt.errors.DagsterDbtCliFatalRuntimeError: Fatal error in the dbt CLI (return code 2)
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_grpc/server.py", line 227, in __init__
self._loaded_repositories = LoadedRepositories(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_grpc/server.py", line 101, in __init__
loadable_targets = get_loadable_targets(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_grpc/utils.py", line 33, in get_loadable_targets
else loadable_targets_from_python_file(python_file, working_directory)
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_core/workspace/autodiscovery.py", line 26, in loadable_targets_from_python_file
loaded_module = load_python_file(python_file, working_directory)
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_core/code_pointer.py", line 86, in load_python_file
return import_module_from_path(module_name, python_file)
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster/_seven/__init__.py", line 51, in import_module_from_path
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 848, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/opt/dagster/repo_sync/data_engineering/dbt_repository.py", line 22, in <module>
dbt_assets = load_assets_from_dbt_project(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster_dbt/asset_defs.py", line 424, in load_assets_from_dbt_project
manifest_json, cli_output = _load_manifest_for_project(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster_dbt/asset_defs.py", line 41, in _load_manifest_for_project
cli_output = execute_cli(
File "/home/ubuntu/.local/lib/python3.8/site-packages/dagster_dbt/cli/utils.py", line 139, in execute_cli
raise DagsterDbtCliFatalRuntimeError(
Yogic Wahyu
09/05/2022, 9:19 AMraise DagsterDbtCliFataRuntimeError
). I hope anyone could give some clues about this.
(We have not used neither environment or container option, it is global setup, place the repository into certain folder in the VM for CI/CD sync)Fanny Wiryana
09/06/2022, 7:43 AM