---
title: 'This Week in Databend #138'
date: 2024-04-01
slug: category-weekly/2024-04-01-databend-weekly
cover_url: 'weekly/weekly-138.jpg'
image: 'weekly/weekly-138.jpg'
tags: [weekly]
category: Weekly
description: 'Stay up to date with the latest weekly developments on Databend!'
contributors:
  - name: andylokandy
  - name: b41sh
  - name: blackstar-baba
  - name: c8ef
  - name: Chasen-Zhang
  - name: dantengsky
  - name: Dousir9
  - name: dqhl76
  - name: drmingdrmer
  - name: everpcpc
  - name: Freejww
  - name: hantmac
  - name: JackTan25
  - name: kkk25641463
  - name: ncuwaln
  - name: PsiACE
  - name: SkyFan2002
  - name: soyeric128
  - name: sundy-li
  - name: TCeason
  - name: Xuanwo
  - name: xudong963
  - name: youngsofun
  - name: zhang2014
  - name: ZhiHanZ
  - name: zhyass
authors:
  - PsiACE
---

[Databend](https://github.com/databendlabs/databend) is a modern cloud data warehouse, serving your massive-scale analytics needs at low cost and complexity. Open source alternative to Snowflake. Also available in the cloud: [https://app.databend.com](https://app.databend.com) .

## What's New

Stay informed about the latest features of Databend.

### Supporting Multi-Table Insert

Databend now supports multi-table inserts, allowing data to be inserted into multiple different tables according to actual needs. This includes support for both unconditional and conditional insert modes.

{/* truncate */}

```sql
-- Unconditional multi-table insert
INSERT [ OVERWRITE ] ALL
  intoClause [ ... ]
<subquery>

-- Conditional multi-table insert
INSERT [ OVERWRITE ] { FIRST | ALL }
  { WHEN <condition> THEN intoClause [ ... ] }
  [ ... ]
  [ ELSE intoClause ]
<subquery>
```

![](../static/img/blog/multi-insert.png)

If you would like to learn more, please contact the [Databend team](https://databend.com/contact-us/) or refer to the resources listed below:

- [PR | feat: support multi-table insert](https://github.com/databendlabs/databend/pull/15002)

## Code Corner

Discover some fascinating code snippets or projects that showcase our work or learning journey.

### Adding Support for OpenTelemetry Context Propagation

OpenTelemetry is a tool for observing performance, helping to track and monitor data requests in distributed systems. Databend Query now has built-in support for OpenTelemetry context propagation, enabling better integration into existing monitoring systems and facilitating developers to track and analyze the flow of queries throughout the system.

![](../static/img/blog/otel-tracing.png)

If you're interested, please read the materials below to learn how to implement distributed tracing with the Databend Go Driver.

- [Examples | How to Realize Distributed Tracing Using Native Go Driver with Databend](https://github.com/databendlabs/databend-go/tree/main/examples/opentelemetry)
- [PR | feat: support otel context propagation for databend-query](https://github.com/databendlabs/databend/pull/15096)

## Highlights

We have also made these improvements to Databend that we hope you will find helpful:

- Added support for GEO functions `st_makeline` and `st_geometryfromewkb`.
- Added support for refreshing inverted indexes after data changes, including synchronous and asynchronous modes.
- Added time travel and specifying offsets for `STREAM`.
- Read the documentation [Docs | Access Control](https://docs.databend.com/guides/security/access-control/) to understand access control in Databend.

## What's Up Next

We're always open to cutting-edge technologies and innovative ideas. You're more than welcome to join the community and bring them to Databend.

### Adding Support for Query Forwarding

Databend plans to support query forwarding, mainly for the following two benefits:

- Flexible Routing: Avoids the necessity to route queries strictly to their origin node.
- Statelessness: Similar to k8s deployments, the system doesn't require stateful management.

[Issue #15127 | feat: query forward](https://github.com/databendlabs/databend/issues/15127)

Please let us know if you're interested in contributing to this feature, or pick up a good first issue at [https://link.databend.com/i-m-feeling-lucky](https://link.databend.com/i-m-feeling-lucky) to get started.

## New Contributors

We always open arms to everyone and can't wait to see how you'll help our community grow and thrive.

- [@kkk25641463](https://github.com/kkk25641463) implemented support for the `st_makeline` function, [#15059](https://github.com/databendlabs/databend/pull/15059).
- [@c8ef](https://github.com/c8ef) fixed a type mismatch issue in SQL logic tests, [#15090](https://github.com/databendlabs/databend/pull/15090).

## Changelog

You can check the changelog of Databend Nightly for details about our latest developments.

**Full Changelog**: [https://github.com/databendlabs/databend/compare/v1.2.386-nightly...v1.2.397-nightly](https://github.com/databendlabs/databend/compare/v1.2.386-nightly...v1.2.397-nightly)