dbt-labs / spark-utils

Utility functions for dbt projects running on Spark
https://hub.getdbt.com/fishtown-analytics/spark_utils/latest/
Apache License 2.0
30 stars 15 forks source link

spark_optimize_delta_tables does not work on databricks #38

Open stegus64 opened 4 weeks ago

stegus64 commented 4 weeks ago

I use dbt on databricks. After upgrading to the latest versions of dbt and all packages, I started getting errors from spark_utils

dbt run-operation spark_optimize_delta_tables 06:24:27 Running with dbt=1.8.4 06:24:28 Registered adapter: databricks=1.8.4 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.4", "dbt_databricks_version": "1.8.4", "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 '' -----------------------------^^^