spark_optimize_delta_tables does not work on databricks

[stegus64]

dbt run-operation spark_optimize_delta_tables
06:24:27 Running with dbt=1.8.5
06:24:28 Registered adapter: databricks=1.8.5
06:24:29 Found 235 models, 17 snapshots, 83 data tests, 6 seeds, 142 sources, 5 exposures, 785 macros
06:24:30 Encountered an error while running operation: Runtime Error
Runtime Error
[PARSE_SYNTAX_ERROR] Syntax error at or near '''': missing 'LIKE'. SQLSTATE: 42601 (line 2, pos 29)
== SQL ==
/ {"app": "dbt", "dbt_version": "1.8.5", "dbt_databricks_version": "1.8.5", "databricks_sql_connector_version": "3.1.2", "profile_name": "liseberg-databricks", "target_name": "dev", "connection_name": "macro_spark_optimize_delta_tables"} /
show table extended in like ''
-----------------------------^^^

I have created an issue here: dbt-labs/spark-utils#38
But since I do not know where the real problem is I create an issue in this repo as well.

dbt --version
Core:

• installed: 1.8.5
• latest: 1.8.5 - Up to date!

Plugins:

• databricks: 1.8.5 - Up to date!
• spark: 1.8.0 - Up to date!

python --version
Python 3.11.6

packages.yml

packages:

• package: dbt-labs/dbt_utils
  version: 1.2.0
• package: dbt-labs/dbt_external_tables
  version: 0.9.0
• package: dbt-labs/spark_utils
  version: 0.3.0

[benc-db]

Since we have no code for that operation, I suspect the fix would have to come from them.

[stegus64]

This problem is caused by a change in dbt-spark. dbt-labs/dbt-spark#1048
It should be fixed there.
Closing this issue.