Yes, it is possible to test your destination connector with normalization locally before publishing it. To activate normalization for your destination connector, you need to update the

spec.json

file and set

supportsNormalization

and

supportsDBT

to

true

. However, with the newest version, these settings have been moved to

destination_definitions.yaml

and

destination_specs.yaml

[source](https://airbyte.com/tutorials/creating-duckdb-destination-with-python). To build the Docker image and run the Gradle command for DuckDB, you can follow these steps:

bash #build normalization cd airbyte-integrations/connectors/destination-duckdb docker build . -t airbyte/normalization-duckdb:0.1.0 -t airbyte/normalization-duckdb:0.2.25 --no-cache  cd ../../.. ./gradlew :airbyte-integrations:bases:base-normalization:airbyteDockerDuckDb && docker tag airbyte/normalization-duckdb:dev airbyte/normalization-duckdb:0.2.25

And to run the integration tests either locally with [PyTest](https://docs.pytest.org/):

bash cd airbyte-integrations/bases/base-normalization NORMALIZATION_TEST_TARGET=duckdb  pytest integration_tests/test_normalization.py

Or with Gradle from the root folder:

bash NORMALIZATION_TEST_TARGET=duckdb ./gradlew :airbyte-integrations:bases:base-normalization:integrationTest`

[source](https://airbyte.com/tutorials/creating-duckdb-destination-with-python) If you need more help with normalization, you can watch this [Demo Hour: Debugging Normalization]() video for more insights. Remember that some documents might be outdated, and it's always a good idea to check the latest documentation and requirements. If you need further assistance, don't hesitate to reach out to the Airbyte community for support.

(edited the above to add links)

The goal is to eventually remove dbt from our connectors. We want to be able to more tightly control how things work, when typing-and-deduplication runs, and how we handle errors... which all point to the connector building and running that SQL itself. TBD on how soon that happens (answering a now removed question about dbt)