{% hint style="warning" %} The following document assumes that you understand the basics of connecting to databases on Appsmith. If not, please go over them before reading further. {% endhint %}
Appsmith needs the following parameters for connecting to a Snowflake database:
{% hint style="success" %} All required fields are suffixed with an asterisk (*). {% endhint %}
You need to fill in the following parameters:
- Account name*: Your account name is part of the connection string and consists one or more of the components mentioned in the Snowflake documentation.
- Warehouse*: Specifies the virtual warehouse to use once connected. The specified warehouse should be an existing warehouse for which the default role has privileges.
- Database*: Specifies the default database to use once connected. The specified database should be an existing database for which the default role has privileges.
- Default Schema: The connection does not limit queries to this schema. This information is only used to provide a view of the schema structure inside Appsmith.
You need to fill in the following parameters:
- Username*: Fill username required for authenticating connection requests to your database.
- Password*: Fill password required for authenticating connection requests for the given username to the database.
Snowflake databases can be queried using the SQL syntax provided in their command reference documentation. All Snowflake queries return an array of objects where each object is a row returned by the query and each property in the object is a column.
Once you have successfully run a Query, you can use it in your application to