How to include tblproperties in a iceberg table

[wesleygoi-liftoff]

Hi team, where can i specify tblproperties for iceberg table?

[JCZuurmond]

Hi @vungle-wesleygoi , independent of the format you use, you set tblproperties by defining it as a dictionary in the model config. This macro does the magic

{{
  config(
    tblproperties = {
      "property": "value",
      ...
  })
}}

[wesleygoi-liftoff]

hi @JCZuurmond i see in dbt-databricks the {{ tblproperties_clause() }} is defined in helpers.sql

but it's not found in the equivalent in dbt-spark https://github.com/dbt-labs/dbt-spark/blob/main/dbt/include/spark/macros/materializations/seed.sql#L71

[JCZuurmond]

I think I do not understand your question, could you clarify?

It could be that dbt-databricks put the macro in the helpers.sql. The location does not matter, it matters whether the macro is called. Search for dbt_spark_tblproperties_clause I do not see it being used anywhere, that might be a problem.

I do not expect the dbt_spark_tblproperties_clause in the seeds.

[wesleygoi-liftoff]

Would like to include tblproperties when creating tables, I've added it in the PR. Hope this clarifies.

[wesleygoi-liftoff]

I do not see it being used anywhere, that might be a problem.
yeap see the PR adding it

#848