#snowflake #sql #client #sql-query

snowflake-connector-rs

A Rust client for Snowflake

4 releases

0.2.0 Mar 14, 2024
0.1.2 Jan 22, 2024
0.1.1 Jan 16, 2024
0.1.0 Dec 4, 2023

#957 in Database interfaces

Download history 111/week @ 2024-01-16 194/week @ 2024-01-23 236/week @ 2024-01-30 80/week @ 2024-02-06 110/week @ 2024-02-13 222/week @ 2024-02-20 568/week @ 2024-02-27 408/week @ 2024-03-05 471/week @ 2024-03-12 276/week @ 2024-03-19 335/week @ 2024-03-26 292/week @ 2024-04-02 274/week @ 2024-04-09 289/week @ 2024-04-16

1,234 downloads per month

MIT license

28KB
690 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()),
    },
)?;

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

~11–25MB
~404K SLoC