# Snowflake

[Snowflake](https://snowflake.com) is a multi-cloud data warehouse. Tenzir can send events from a pipeline to [Snowflake databases](https://docs.snowflake.com/en/sql-reference/ddl-database).

Use the [`to_snowflake`](https://preview.docs.tenzir.com/375/375/reference/operators/to_snowflake.md) output operator at the end of a pipeline to send events to a specific table.

ADBC

Tenzir uses [Apache Arrow](https://arrow.apache.org) under the hood to encode batches of events into a columnar representation. The [Arrow Database Connectivity (ADBC)](https://arrow.apache.org/docs/format/ADBC.html) API makes makes it possible to efficiently transfer large datasets between Tenzir and a database. Think of ADBC as the columnar equivalent of JDBC/ODBC. ADBC has a [Snowflake driver](https://arrow.apache.org/adbc/current/driver/snowflake.html) that Tenzir uses to send events to Snowflake with the bulk ingestion API. For further details on ADBC, read the [introductory blog post](https://arrow.apache.org/blog/2023/01/05/introducing-arrow-adbc/) from the Arrow project.

## Examples

### Send data to a Snowflake database

```tql
from {foo: 42, bar: true}
to_snowflake \
  account_identifier="asldyuf-xgb47555",
  user_name="tenzir_user",
  password="password1234",
  database="MY_DB",
  schema="MY_SCHEMA",
  table="TENZIR"
```