#snowflake #sql #client #sql-query

snowflake-connector-rs

A Rust client for Snowflake

12 releases (4 breaking)

0.5.1 Jun 13, 2024
0.5.0 Jun 6, 2024
0.4.0 May 30, 2024
0.3.3 May 25, 2024
0.1.0 Dec 4, 2023

#1084 in Database interfaces

Download history 342/week @ 2024-03-25 282/week @ 2024-04-01 289/week @ 2024-04-08 284/week @ 2024-04-15 322/week @ 2024-04-22 206/week @ 2024-04-29 298/week @ 2024-05-06 567/week @ 2024-05-13 859/week @ 2024-05-20 910/week @ 2024-05-27 744/week @ 2024-06-03 635/week @ 2024-06-10 606/week @ 2024-06-17 745/week @ 2024-06-24 350/week @ 2024-07-01 511/week @ 2024-07-08

2,247 downloads per month

MIT license

38KB
903 lines

Snowflake Connector for Rust

test Crates.io

A Rust client for Snowflake, which enables you to connect to Snowflake and run queries.

let client = SnowflakeClient::new(
    "USERNAME",
    SnowflakeAuthMethod::Password("PASSWORD".to_string()),
    SnowflakeClientConfig {
        account: "ACCOUNT".to_string(),
        role: Some("ROLE".to_string()),
        warehouse: Some("WAREHOUSE".to_string()),
        database: Some("DATABASE".to_string()),
        schema: Some("SCHEMA".to_string()),
        timeout: Some(std::time::Duration::from_secs(30)),
    },
)?;
let session = client.create_session().await?;

let query = "CREATE TEMPORARY TABLE example (id NUMBER, value STRING)";
session.query(query).await?;

let query = "INSERT INTO example (id, value) VALUES (1, 'hello'), (2, 'world')";
session.query(query).await?;

let query = "SELECT * FROM example ORDER BY id";
let rows = session.query(query).await?;
assert_eq!(rows.len(), 2);
assert_eq!(rows[0].get::<i64>("ID")?, 1);
assert_eq!(rows[0].get::<String>("VALUE")?, "hello");

Dependencies

~10–27MB
~403K SLoC