SPACES in column names in model sql

Help
1

i am creating a sql model (databricks is the database) and the column names that i want to create have spaces in them (eg. First Name) . i am using backticks to wrap the column name but am getting the following error message when i run the model..

[DELTA_INVALID_CHARACTERS_IN_COLUMN_NAMES] Found invalid character(s) among ’ ,;{}()\n\t=’ in the column names of your schema.
Invalid column names: Job Code.
Please use other characters and try again.
Alternatively, enable Column Mapping to keep using these characters.
compiled code at target/run/cndp_warehouse/models/gold/interfaces/bettercomp/full/i_bettercomp_job.sql

here is my model SQL snippet..

select
j.job_code as Job Code
, j.job_name as Job Title

2

In general it’s not a good idea to have spaces in column names. Keep to lower_snake_case to avoid a lot of future issues :blush:

Note: @Jeremy Yeo originally posted this reply in Slack. It might not have transferred perfectly.

3

This is also just disallowed when persisting objects in Databricks’ Unity Catalog. Here’s some documentation on what they suggest/forbidden chars, which includes spaces: Names | Databricks Documentation