Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

macro 'dbt_macro__databricks__tblproperties_clause' takes not more than 0 argument(s) #869

Open
simone919 opened this issue Dec 10, 2024 · 2 comments
Labels
bug Something isn't working

Comments

@simone919
Copy link

Describe the bug

A model running perfectly with 1.8.9 fails for tblproperties with 1.9.0

Steps To Reproduce

this is the source code. I just did
dbt build

{{ config( materialized='incremental', incremental_strategy='merge', unique_key=['bk_user_category', 'id_source_system'], full_refresh=false, tblproperties={ 'delta.autoOptimize.optimizeWrite' : 'true', 'delta.autoOptimize.autoCompact' : 'auto' } ) }} SELECT DISTINCT bk_user_category, id_source_system FROM {{source('stg','t_user_category')}} op

Expected behavior

The model working as happens with 1.8.9

Screenshots and log output

Compilation Error in model user_category_history (models/user_category_history/user_category_history.sql)
  macro 'dbt_macro__databricks__tblproperties_clause' takes not more than 0 argument(s)
  
  > in macro apply_tblproperties (macros/relations/tblproperties.sql)
  > called by macro materialization_incremental_databricks (macros/materializations/incremental/incremental.sql)
  > called by model user_category_history (models/user_category_history/user_category_history.sql)

System information

The output of dbt --version:

Running with dbt=1.9.0

The operating system you're using: Databricks workflow on SQLWarehouse Classic

The output of python --version:

Additional context

Add any other context about the problem here.

@simone919 simone919 added the bug Something isn't working label Dec 10, 2024
@benc-db
Copy link
Collaborator

benc-db commented Dec 10, 2024

Thanks for reporting, will investigate.

@benc-db
Copy link
Collaborator

benc-db commented Dec 10, 2024

Can you try fresh installing your dbt libraries? databricks__tblproperties_clause in 1.9.0 takes an argument, so this error suggests you still have an old copy of the macro.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants