Dlt

What's Changed
* update 2023-02-16-dlthub-mission.md by matthauskrzykowski in https://github.com/dlt-hub/dlt/pull/131
* adding blog + mission post stub by TyDunn in https://github.com/dlt-hub/dlt/pull/130
* json/normalizer performance improvements and bugfixes by rudolfix in https://github.com/dlt-hub/dlt/pull/133
* adds technical documentation for contributors by rudolfix in https://github.com/dlt-hub/dlt/pull/139

New Contributors
* matthauskrzykowski made their first contribution in https://github.com/dlt-hub/dlt/pull/131

`dlt` library changes
* `orjson` is used instead of `simplejson` by default (with a fallback for pypy)
* `spawn` method now supported to run normalizer stage in parallel (so works on MacOS and Windows)
* indexes are not created by default on `duckdb` (inserting slow), but enabled in `postgres`
* bumped `duckdb` to 0.7.0 and newest `dbt-duckdb`
* bugfixes and additional tests

**Full Changelog**: https://github.com/dlt-hub/dlt/compare/0.2.0a18...0.2.0a19

What's Changed
* small improvements to duckdb docs by TyDunn in https://github.com/dlt-hub/dlt/pull/128
* Fix current columns and new columns referencing the same object by steinitzu in https://github.com/dlt-hub/dlt/pull/127
* tests file rotation on schema changes + bumps duckdb to 0.7 by rudolfix in https://github.com/dlt-hub/dlt/pull/129

New Contributors
* steinitzu made their first contribution in https://github.com/dlt-hub/dlt/pull/127

What's Changed
* adds duckdb destination and dbt support by rudolfix in https://github.com/dlt-hub/dlt/pull/124
The 🦆 `db` destination is added and may be used like any other destination. The multithreaded loading is quite fast thanks to `duckdb` dropping the GIL when called. See more in our [docs](https://dlthub.com/docs/destinations#duckdb)
We also support the `dbt-duckdb` adapter, the [jaffle shop example](https://github.com/dlt-hub/dlt/blob/devel/docs/examples/dbt_run_jaffle.py) was converted to `duckdb` to showcase this ability

* transaction support was added to `sql_client` and Big Query got multi-statement transactions via Sessions


**Full Changelog**: https://github.com/dlt-hub/dlt/compare/0.2.0a16...0.2.0a17

What's Changed
* uses structured data types to store json by rudolfix in https://github.com/dlt-hub/dlt/pull/121
* brings back the functionality to run dbt packages by rudolfix in https://github.com/dlt-hub/dlt/pull/122

This update changes how the `complex` data type is being stored. Most often `complex` data type is generated to hold `json` data when `nesting_level` is limited in the source. The complex types are stored as JSONB (postgres), SUPER (redshift), JSON (BigQuery)

This update also allows to easily run `dbt` packages together with `dlt` pipelines. Most of the work went into making it user friendly and avoiding any dependency conflicts. This feature is also quite well tested. Take a look at those two examples:
https://github.com/dlt-hub/dlt/blob/devel/docs/examples/dbt_run_jaffle.py
https://github.com/dlt-hub/dlt/blob/devel/docs/examples/chess/chess_dbt.py
https://github.com/dlt-hub/dlt/tree/devel/docs/examples/chess/dbt_transform

Runing the `dbt` package is just two lines and you have more control over it that with the CLI

What's Changed
* only specific default config values are generated in `dlt init` ie BigQuery Location
* correct postgres port generated
* sends traces to sentry if `RUNTIME__SENTRY_DSN` is present
* sends slack notification if `RUNTIME__SLACK_INCOMING_HOOK` is present

What's Changed
* `dlt init` renames sources and resources by rudolfix in https://github.com/dlt-hub/dlt/pull/106