Value too long for type character varying(1)

[yeexuan26]

I am trying to implement dbt artifacts after my running my model by implementing it as a post hook config in redshift

{{ config(
    post_hook = "{{dbt_artifacts.upload_results(results)}}"
) }}

But I got this error

02:31:55    Database Error in model yx_test_hk (dbt_models\hk\test_hk\yx_test_hk.sql)
  value too long for type character varying(1)
  compiled code at target\run\scripts\dbt_models\hk\test_hk\yx_test_hk.sql

I tried simply running a simple select 1 query, it throws the same error so i dont think its the script issue. This is my run_results.json file - if it's of any help.

{
  "metadata": {
    "dbt_schema_version": "https://schemas.getdbt.com/dbt/run-results/v6.json",
    "dbt_version": "1.10.7",
    "generated_at": "2025-09-11T02:31:54.893626Z",
    "invocation_id": "4ba3a771-114c-4e61-8a56-f017d3922691",
    "invocation_started_at": "2025-09-11T02:31:50.505924Z",
    "env": {}
  },
  "results": [
    {
      "status": "error",
      "timing": [
        {
          "name": "compile",
          "started_at": "2025-09-11T02:31:53.806561Z",
          "completed_at": "2025-09-11T02:31:53.822374Z"
        },
        {
          "name": "execute",
          "started_at": "2025-09-11T02:31:53.822374Z",
          "completed_at": "2025-09-11T02:31:54.717321Z"
        }
      ],
      "thread_id": "Thread-1 (worker)",
      "execution_time": 0.9147720336914062,
      "adapter_response": {},
      "message": "Database Error in model yx_test_hk (dbt_models\\hk\\test_hk\\yx_test_hk.sql)\n  value too long for type character varying(1)\n  compiled code at target\\run\\scripts\\dbt_models\\hk\\test_hk\\yx__test_hk.sql",
      "failures": null,
      "unique_id": "model.scripts.yx_test_hk",
      "compiled": true,
      "compiled_code": "\n\nselect 1",
      "relation_name": "\"analytics\".\"dbt_ds\".\"yx_test_hk\"",
      "batch_results": null
    }
  ],
  "elapsed_time": 2.2545695304870605,
  "args": {
    "log_level_file": "debug",
    "require_batched_execution_for_custom_microbatch_strategy": false,
    "invocation_command": "dbt run --select yx_test_hk",
    "partial_parse_file_diff": true,
    "skip_nodes_if_on_run_start_fails": false,
    "state_modified_compare_more_unrendered_values": false,
    "source_freshness_run_project_hooks": true,
    "empty": false,
    "defer": false,
    "warn_error_options": {
      "error": [],
      "warn": [],
      "silence": []
    },
    "use_colors_file": true,
    "project_dir": "C:\\Users\\em\\PycharmProjects\\2022\\ui\\scripts",
    "log_level": "info",
    "show_resource_report": false,
    "log_format_file": "debug",
    "require_yaml_configuration_for_mf_time_spines": false,
    "state_modified_compare_vars": false,
    "which": "run",
    "version_check": true,
    "use_fast_test_edges": false,
    "require_nested_cumulative_type_params": false,
    "exclude": [],
    "populate_cache": true,
    "profiles_dir": "C:\\Users\\em\\.dbt",
    "indirect_selection": "eager",
    "send_anonymous_usage_stats": true,
    "partial_parse": true,
    "cache_selected_only": false,
    "print": true,
    "require_generic_test_arguments_property": false,
    "introspect": true,
    "quiet": false,
    "upload_to_artifacts_ingest_api": false,
    "log_file_max_bytes": 10485760,
    "favor_state": false,
    "require_resource_names_without_spaces": true,
    "macro_debugging": false,
    "validate_macro_args": false,
    "vars": {},
    "show_all_deprecations": false,
    "log_path": "C:\\Users\\em\\PycharmProjects\\2022\\ui\\scripts\\logs",
    "require_all_warnings_handled_by_warn_error": false,
    "select": [
      "yx_test_hk"
    ],
    "strict_mode": false,
    "use_colors": true,
    "log_format": "default",
    "write_json": true,
    "require_explicit_package_overrides_for_builtin_materializations": true,
    "static_parser": true,
    "printer_width": 80
  }
}```

[yeexuan26]

Found this this could be due to redshift compatibility issue, from here - #406

tried running with updated package by @hanslemm -#453

but unfortunately got this error

Compilation Error
  Got nested tags: macro (started at 1328) did not have a matching {{% endmacro %}} before a subsequent macro was found (started at 1387)

I am running this with dbt version 1.10.7.

[hanslemm]

Hey @yeexuan26 I've commited the missing endmacro... weird that I didn't catch this early.