I am new to DBT and elementary. I have tried to in...
# community-supports
Sravan
10/19/2023, 2:54 PMI am new to DBT and elementary. I have tried to install and run the elementary command and it says the database is missing. Any inputs on this. More details on this thread
👀 1
✅ 1
Sravan
10/19/2023, 2:55 PM.dbt-venv-1_5_2) sravankumarkunadi@MAC-Y9JV49V dbt % dbt run --select elementary
144809 Running with dbt=1.5.7
144809 Registered adapter: snowflake=1.5.2
144810 Unable to do partial parsing because a project dependency has been added
144810 Unable to do partial parsing because a project config has changed
144817 Encountered an error:
Compilation Error in macro generate_database_name (macros/overrides/default__generate_database_name.sql)
Missing database, please check that the environment variables are properly set and the database is set in dbt_project.yml under model, seeds, test, etc.
> in macro generate_database_name (macros/overrides/default__generate_database_name.sql)
> called by macro generate_database_name (macros/overrides/default__generate_database_name.sql)
o
Or Avidov
10/19/2023, 2:59 PMHi @Sravan! do you override the macro
generate_database_names
Sravan
10/19/2023, 3:02 PMdbt_project.rtf
o
Or Avidov
10/19/2023, 3:06 PMis there an option to send it not as rtf? it's hard for me to read it this way
s
Sravan
10/19/2023, 3:10 PMdbt_project.yml
o
Or Avidov
10/19/2023, 3:23 PMand what does your custom
generate_database_names
Sravan
10/19/2023, 3:28 PMare you referring to this ?
Sravan
10/19/2023, 3:28 PMimage.png
o
Or Avidov
10/19/2023, 3:31 PMyes, looking
Or Avidov
10/19/2023, 3:35 PMIt seems like you override the
generate_database_nameOr Avidov
10/19/2023, 3:36 PM(I also added a custom schema for elementary as it's recommended but it really depends on where you want to store the elementary models)
s
Sravan
10/19/2023, 3:41 PMmodels:
elementary:
+database: "PDM_MDM_DEV_SRAVAN"
+schema_name: "elementary_data_observability"
Sravan
10/19/2023, 3:42 PMi have updated like these. hope it works
🙏 1
o
Or Avidov
10/20/2023, 2:23 PMPlease let us know if it doesn't
29 Views