---
title: "Snowflake@1"
description: "Snowflake@1 — Snowflake databases through the Snowflake connector for .NET, no driver needed"
url: "https://docs.justcat.it/reference/data-sources/providers/snowflake-1/"
---
# Snowflake@1


## Connects to

Snowflake, in any cloud and region.

## Example


**Properties**



Name
: MySnowflakeDatabase

Provider
: Snowflake@1

Technology
: Snowflake

Connection string
: ```
  account=testaccount;
  user=%USER_NAME%;
  password=%PASSWORD%;
  db=testdb;
  schema=testschema;
  ```





**YAML**


```yaml
Data sources:
- Name: MySnowflakeDatabase
  Provider: Snowflake@1
  Technology: Snowflake
  Connection string: >
    account=testaccount;
    user=%USER_NAME%;
    password=%PASSWORD%;
    db=testdb;
    schema=testschema;
```




## Connection string

A Snowflake connector for .NET connection string — `key=value` pairs separated by semicolons. The keys you will use most:

| Key | Meaning |
|---|---|
| `account` | Your account identifier, e.g. `myorg-myaccount` |
| `user`, `password` | Credentials |
| `db` | Database to connect to |
| `schema` | Default schema for unqualified names |
| `warehouse` | Virtual warehouse that runs the statements; the user's default when omitted |
| `role` | Role to assume; the user's default when omitted |

The full list, including other authenticators, is in the <a href="https://github.com/snowflakedb/snowflake-connector-net?tab=readme-ov-file#create-a-connection" target="_blank">Snowflake connector for .NET documentation</a>.

A password, or the whole string, can come from an environment variable — `%NAME%` is replaced with the value of `NAME`; see [How every provider is used](https://docs.justcat.it/reference/data-sources/providers/introduction/#how-every-provider-is-used "How every provider is used").

## Settings

None beyond `Connection string`.

## Query

One SQL statement in Snowflake's dialect that returns a result set.

## Prerequisites

None. The driver ships with CAT. Windows; on Linux it has no extra dependencies and is expected to work, but it has not been tested there.

## Serving test and data source definitions

`Snowflake@1` can also serve [lists](https://docs.justcat.it/reference/project-file/lists/ "Lists") of definitions: any statement that returns the columns of a [test](https://docs.justcat.it/reference/tests/properties/ "Test properties"), [data source](https://docs.justcat.it/reference/data-sources/properties/ "Data source properties") or [query](https://docs.justcat.it/reference/queries/properties/ "Query properties") definition works. Ready-made table scripts are in [Store definitions in a database](https://docs.justcat.it/how-to-guides/organize-and-run-tests/store-definitions-in-a-database/ "Store definitions in a database").

## Related

* [Technologies](https://docs.justcat.it/reference/data-sources/technologies/ "Technologies") — what CAT can test, with the provider behind each.