* The username and password for your Snowflake account.
## Connecting to Your Snowflake Account
This section enumerates the options in the **Credentials** and **Details** panes in the Snowflake Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").
### Credentials Pane
This pane contains fields for entering credentials to connect to your Snowflake account. The following table describes what is needed for each field:
Field | Description |
|---|---|
Account Name | Enter the name of your account (provided by Snowflake). For US West Region account\_name , and All other regions account\_name.region\_id . |
Host | Enter the Host name (provided by Snowflake). For example, snowflakecomputing.com , snowflakecomputing.cn |
Username | Enter the username associated with your Snowflake account. |
Password | Enter the password associated with your Snowflake account. |
Role | Enter your role. |
Parameter | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
Query Type | Select the query type.
| ||||||||
Query | Enter the SQL query to use to retrieve your data. You can use the Query Helper parameter to help you write a usable SQL query. To use the Query Helper , do the following:
| ||||||||
Warehouses | Select the warehouse containing the data you want to retrieve. The list populates with all of the warehouses you have access to based on your credentials. | ||||||||
Databases | Select the database containing the data you want to retrieve. The list populates with all of the databases you have access to based on your credentials. | ||||||||
Database Schema | Select the database schema containing the data you want to retrieve. The list populates with all of the schemas you have access to based on your credentials. | ||||||||
Database Objects | Select the database object from the drop-down list. | ||||||||
Database Tables (Optional) | Select the database table you want to retrieve. The list populates with all of the tables you have access to based on your credentials. If you do not select a database table, the connector retrieves your entire database schema. | ||||||||
Table Columns (Optional) | Select the table columns you want to retrieve. The list populates with all of the columns you have access to based on your credentials. If you do not select a table column, the connector retrieves your entire selected database table. | ||||||||
Query Helper (Optional) | When you select warehouses, databases, schemas, tables, etc. from the above menus, a usable SQL query is built for you in this field. Copy and paste the SQL statement in this field into the Query field. For more information, see the entry for Query , above. | ||||||||
Database Views | Select the database view. | ||||||||
View Columns | Select which view columns you want to include in your report. | ||||||||
| Fetch Size (Optional) | Enter a fetch size for memory performance. If this field is left blank, the default value of 1000 will be used. If the DataSet throws an "Out of memory" error, try decreasing the fetch size. | ||||||||
| Convert BIGINT to LONG | Select this checkbox if you want to convert BIGINT columns to LONG. | ||||||||
| Disable NetWork Timeout | Select this checkbox if you observe errors regarding network timeout. | ||||||||
| Query Tag | This is an optional parameter that can be used to tag connector SQL executions in Snowflake as a Query Tag . | ||||||||
| Convert Columns to String | Enter the column names separated by comma to convert the columns to string. For example, column1, column2, column3. |