INFO - 09:19:23 1 of 1 ERROR creating sql nothing...
# ask-elementary-ai
n
INFO - 091923 1 of 1 ERROR creating sql nothing model
elementary
.
update_skipped_alerts
... [ERROR in 0.04s] Database Error in model update_skipped_alerts (models/update_alerts/update_skipped_alerts.sql) HTTPDriver for clickhouse returned response code 400) Code: 62. DB:Exception Syntax error: failed at position 1281 (FORMAT) (line 32, col 2): FORMAT Native. Expected one of: token, OpeningRoundBracket, FILTER, RESPECT NULLS, IGNORE NULLS, OVER, OR, AND, IS NOT DISTINCT FROM, IS NULL, IS NOT NULL, BETWEEN, NOT BETWEEN, LIKE, ILIKE, NOT LIKE, NOT ILIKE, REGEXP, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, MOD, DIV, SETTINGS, ParallelWithClause, PARALLEL WITH, end of query. (SYNTAX_ERROR) (version 25.6.2.6151 (official build))
k
A message from kapa.ai
I'm sorry, but the knowledge sources do not contain specific information about the error you are encountering with the ClickHouse HTTPDriver and the model update_skipped_alerts, particularly regarding the "FORMAT Native" syntax error. Most documented issues with Elementary relate to Snowflake, Redshift, and BigQuery, and there is no explicit mention of ClickHouse support or troubleshooting for this type of error. If you are using ClickHouse as your data warehouse, it's possible that Elementary does not fully support it, or there may be compatibility issues with certain SQL syntax generated by the package. For example, there are known cases where unsupported warehouses (like DuckDB) cause similar SQL syntax errors and model creation failures in Elementary workflows [Elementary does not yet support DuckDB](https://slack.com/archives/C02CTC89LAX/p1705504360826139). I recommend checking if ClickHouse is officially supported by Elementary and reviewing your dbt and Elementary package versions for compatibility. If you need further assistance, providing more details (such as your dbt_project.yml, profiles.yml, and the full compiled SQL) to the Elementary support community may help diagnose the issue.