[Bug] dbt_utils.date_spine gives Python error

[hazvk]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Running this model and using dbt_utils.date_spine used to work. I now get an error I can't get to the bottom of.

Expected Behavior

Should evaluate and give a table

Steps To Reproduce

With dbt on local machine:

1. Define model as per below

{{
    config(
        materialized = "view" if target.name not in ['prod'] else 'table'
    )
}}




WITH date_list AS
(
{{ dbt_utils.date_spine(
datepart="day",
start_date="TO_DATE('01/01/2008', 'dd/mm/yyyy')",
end_date="TO_DATE(CONCAT(YEAR(CURRENT_DATE) + 6,'-12-31'))"
)
}}

)

SELECT
*
FROM date_list;

2. Install the following packages

databricks-sdk = "==0.17.0"
dbt-databricks = "==1.6.8"

3. Run dbt build -f

Relevant log output

Snippet

01:09:20  Completed with 1 error and 0 warnings:
01:09:20  
01:09:20    Compilation Error in model dim_date (dbt_demo/models/XXX/datamarts/customer_service/dim_date.sql)
  int() argument must be a string, a bytes-like object or a real number, not 'NoneType'
  
  > in macro default__get_intervals_between (macros/sql/date_spine.sql)
  > called by macro get_intervals_between (macros/sql/date_spine.sql)
  > called by macro default__date_spine (macros/sql/date_spine.sql)
  > called by macro date_spine (macros/sql/date_spine.sql)
  > called by model dim_date (dbt_demo/models/adventureworks/datamarts/customer_service/dim_date.sql)

Environment

- OS: MacOS 14.3 (23D56) Sonoma
- Python: 3.10.2
- dbt: 1.6.10

Which database adapter are you using with dbt?

other (mention it in "Additional Context")

Additional Context

Using dbt-databricks==1.6.8

Last seen working on Jan 24th. Then another issue came up that I only just resolved, per issue (and hence why I fixed version of databricks-sdk). I haven't tested this functionality until yesterday, which is when I first noticed it was broken.

[vymaker]

Wondering if there is an update on the issue?

[SvenRelijveld1995]

I run into the same error, also databricks 1.7.0 and dbt-core 1.7.14

[alxsbn]

I got the issue but it's working after upgrade. My versions:

Core:
  - installed: 1.8.2
  - latest:    1.8.2 - Up to date!

Plugins:
  - spark:      1.8.0 - Up to date!
  - databricks: 1.8.1 - Up to date!

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[alxsbn]

Issue still valid