Hello everyone and happy Thursday melty bouncy I bring you two new releases, including a few amazing community contributions! meltano Meltano 1.105.0 (Probably last minor release before 2.0 🙀*)* ✨ New • #3298 Add adapter-specific dbt plugins for Redshift, Postgres, and BigQuery. • #3482 Expand project-set environment variables in Environment-level

env:

. 🚀 Changes • #3174 - We now recommend pipx over manually created virtual environments. • #3031 Add lock artifacts during

meltano add

for stability and portability of plugin definitions. 🐛 Fixes • 3483 Fixes a bug where pipx-installed meltano can not find executable (.exe) meltano dependency packages • #3500 Fixes bug where lock file was added but not used. ⚙️ Under the Hood • #3484 Use

SettingsService.feature_flag

convention for lockfiles. singer logo SDK v0.5.0 ✨ New • Tap and Target SDK: The

--config=ENV

option now also considers environment variables from a dotenv (

.env

) file if present (#384, !293). 🚀 Changes • Target SDK: Use generic SQLALchemy markers for parameterized queries in SQL targets (#376, !287) - Thanks, Thomas Briggs! • Target SDK: Explicitly specify column names when inserting rows in SQL targets (#385, !294) - Thanks, Thomas Briggs! 🐛 Fixes • Target SDK: Fixes bug where an

activate_version

message caused an error when destination table does not exist (#372, !285) - Thanks, Thomas Briggs! • Tap and Target SDK: Do not fail

--about

option if tap or target is not configured (#379, !291).