[Bug]: Runtime error since migration to dbt 1.9 (Object of type datetime is not JSON serializable)

[D1111111]

Overview

Error during dbt compile after I migrated from 1.8.2 to 1.9.0 dbt.

dbt_artifacts version: 2.8.0

How to reproduce

1. Migrate dbt to the latest version 1.9.0
2. Run dbt compile
3. An error is raised

2:57:33  Encountered an error:
Runtime Error
  Compilation Error in operation confirmation_transformation_dw-on-run-end-0 (.\dbt_project.yml)
    Object of type datetime is not JSON serializable
    > in macro upload_models (macros\upload_individual_datasets\upload_models.sql)
    > called by macro get_table_content_values (macros\upload_results\get_table_content_values.sql)
    > called by macro upload_results (macros\upload_results\upload_results.sql)
    > called by operation confirmation_transformation_dw-on-run-end-0 (.\dbt_project.yml)

Expected behavior

Screenshots

Environment

Results of running dbt --version:

Core:
  - installed: 1.9.2
  - latest:    1.9.2 - Up to date!

Plugins:
  - postgres: 1.9.0 - Up to date!

Please paste the contents of your packages.yml file here:

packages:
  - package: dbt-labs/dbt_utils
    version: 1.3.0

  - package: dbt-labs/codegen
    version: 0.13.1

  - package: calogica/dbt_expectations
    version: 0.10.4

  - package: calogica/dbt_date
    version: 0.10.1

  - package: brooklyn-data/dbt_artifacts
    version: 2.8.0

[D1111111]

This may be related to microbatches loading strategy since I use it, and that was the reason for migration to 1.9.

Might be related to this bug: #476