What's Changed

🎉 Exciting New Features

📋 Airtable Destination

Airtable as a now a destination sync in data integration pipelines. This means you can easily export your data directly to Airtable, keeping everything up to date without any hassle.

by @TalaatHasanin in https://github.com/mage-ai/mage-ai/pull/5454

🐍 Support Mage in Python 3.11 and 3.12

Mage now supports Python versions 3.11 and 3.12, offering enhanced performance and access to the latest Python features for a more robust development experience. by @csharplus in https://github.com/mage-ai/mage-ai/pull/5393

🪝 Support to multiples webhook endpoints for Microsoft Teams notification service

This enhancement allows users to send notifications to multiple Teams channels simultaneously, providing greater flexibility in notification management. by @messerzen in https://github.com/mage-ai/mage-ai/pull/5508

🔴 Updated Redshift connector to enable merge load and correct row count

We’ve added a new configuration option, use_merge_load, to the Redshift destination connector. By default, this setting is disabled. When enabled, it first ingests data into a staging table and then merges it into the target table using Redshift’s Merge process. This feature enhances data loading flexibility and ensures accurate data integration.

by @csharplus in https://github.com/mage-ai/mage-ai/pull/5522

🔍 ElasticSearch Enhancements

• Updated Elasticsearch + verify_certs connection option by @syepes in https://github.com/mage-ai/mage-ai/pull/5462
• Added support of _op_type for bulk operations of destinations by @syepes in https://github.com/mage-ai/mage-ai/pull/5482
• Elasticsearch support of _op_type for bulk operations by @syepes in https://github.com/mage-ai/mage-ai/pull/5471
• Elasticsearch - Align the doc publishing with the Standard (batch) by @syepes in https://github.com/mage-ai/mage-ai/pull/5510

🐘 Added Postgres client package

by @jx2lee in https://github.com/mage-ai/mage-ai/pull/5486

🐛 Bug Fixes

• [xh]Pass OpenAI API key to OpenAI Library by @matrixstone in https://github.com/mage-ai/mage-ai/pull/5430
• [jk] Fix error detail log parsing by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/5443
• [jk] Render json objects in block outputs as string instead of nested table by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/5450
• [jk] Block output table cell overflow by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/5451
• [Bug] Updated SalesForce source to handle multiple date formats by @tolson17 in https://github.com/mage-ai/mage-ai/pull/5493
• [jk] Handle encoded page_block_layouts and block_outputs routes by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/5544
• [jk] Revert name of test environment by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/5478
• [hw] Correct the SSL settings in the nats configuration template by @csharplus in https://github.com/mage-ai/mage-ai/pull/5579
• Fix encoding in GCS Integration by @TalaatHasanin in https://github.com/mage-ai/mage-ai/pull/5447
• bugfix/#5562 python data exporter failed insert 2d array to postgres by @sugimiyanto in https://github.com/mage-ai/mage-ai/pull/5563
• Fix unable to pass extra parameters to psycopg2 in Postgres connector by @kanenorman in https://github.com/mage-ai/mage-ai/pull/5449
• [hw] Avoid throwing exceptions when block_type is None by @csharplus in https://github.com/mage-ai/mage-ai/pull/5439
• Fix load data in GCS integration by @TalaatHasanin in https://github.com/mage-ai/mage-ai/pull/5467

💅 Enhancements & Polish

• [xh] Update python version to fix vulnerabilities by @matrixstone in https://github.com/mage-ai/mage-ai/pull/5523
• [jk] Display ID in block runs table by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/5457
• [Oracle DB] Modify inefficient code that converts dataframe to list of tuples by @farmboy-dev in https://github.com/mage-ai/mage-ai/pull/5502
• [jk] Allow user to set number of lines displayed for block output sample preview by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/5485
• [hw] Use self.logger.debug to replace print to make code clean by @csharplus in https://github.com/mage-ai/mage-ai/pull/5494
• Updated Facebook Ads SDK to 20.0.2 by @jonatansthlmstratlab in https://github.com/mage-ai/mage-ai/pull/5437
• [Enhancement] io/base.py: add Excel support by @LucasGrugru in https://github.com/mage-ai/mage-ai/pull/5542
• [hw] Update deltalake to a recent version 0.20.2 by @csharplus in https://github.com/mage-ai/mage-ai/pull/5541

✨ Other Changes

• Update documentation for Git in Mage in the Getting Started section by @Lennardvb in https://github.com/mage-ai/mage-ai/pull/5459
• [hw] Use the built-in IntEnum instead of creating a new class by @csharplus in https://github.com/mage-ai/mage-ai/pull/5433
• [hw] Add time delay to avoid getting the same file timestamp for multiple changes by @csharplus in https://github.com/mage-ai/mage-ai/pull/5499
• Update text in documentation about enabling HTTPS in AWS by @Lennardvb in https://github.com/mage-ai/mage-ai/pull/5517
• Fix typos in compute-resource.mdx by @mvillaizan in https://github.com/mage-ai/mage-ai/pull/5519
• Update alerting-teams.mdx for multiples webhooks. by @messerzen in https://github.com/mage-ai/mage-ai/pull/5511
• Update README.md by @neubert-analytics in https://github.com/mage-ai/mage-ai/pull/5441
• Typo fix ai-client.mdx by @MageKai in https://github.com/mage-ai/mage-ai/pull/5582
• Add information regarding feature dependency to docs by @oscarlofwenhamn in https://github.com/mage-ai/mage-ai/pull/5584

👏 New Contributors

• @jonatansthlmstratlab made their first contribution in https://github.com/mage-ai/mage-ai/pull/5437
• @Lennardvb made their first contribution in https://github.com/mage-ai/mage-ai/pull/5459
• @syepes made their first contribution in https://github.com/mage-ai/mage-ai/pull/5471
• @jx2lee made their first contribution in https://github.com/mage-ai/mage-ai/pull/5486
• @mvillaizan made their first contribution in https://github.com/mage-ai/mage-ai/pull/5519
• @farmboy-dev made their first contribution in https://github.com/mage-ai/mage-ai/pull/5502
• @tolson17 made their first contribution in https://github.com/mage-ai/mage-ai/pull/5493
• @neubert-analytics made their first contribution in https://github.com/mage-ai/mage-ai/pull/5441
• @kanenorman made their first contribution in https://github.com/mage-ai/mage-ai/pull/5449
• @LucasGrugru made their first contribution in https://github.com/mage-ai/mage-ai/pull/5542
• @sugimiyanto made their first contribution in https://github.com/mage-ai/mage-ai/pull/5563
• @oscarlofwenhamn made their first contribution in https://github.com/mage-ai/mage-ai/pull/5584

Full Changelog: https://github.com/mage-ai/mage-ai/compare/0.9.74...0.9.75