# Connections

Currently Zerve supports the following database connections with others following soon.

1. Snowflake
2. PostgreSQL
3. MySQL
4. MariaDB
5. BigQuery
6. Weaviate

## Setting up a Connection:

1. Go to Assets -> Connections -> Create Connections from your Zerve account's home page.

<figure><img src="https://1018070783-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIQKNeqjEeOp9UwUcB9R9%2Fuploads%2FBudVGcnnqok3IDlFNn1O%2Fimage.png?alt=media&#x26;token=cdd20d82-3ea3-48da-994b-d0bb2528176a" alt=""><figcaption><p>connection setup</p></figcaption></figure>

2. Select the required connection to setup and add the necessary connection parameters.

<figure><img src="https://1018070783-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIQKNeqjEeOp9UwUcB9R9%2Fuploads%2FLgsoMMTdzVyWRuxveGrn%2Fimage.png?alt=media&#x26;token=3712f8dd-2d84-464c-8092-91b211569de6" alt=""><figcaption><p>snowflake connection setup</p></figcaption></figure>

3. Once saved this connection can be accessed from SQL blocks in each canvas.

<figure><img src="https://1018070783-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIQKNeqjEeOp9UwUcB9R9%2Fuploads%2FQSPkfoFhXaFbNZ7di7nh%2Fimage.png?alt=media&#x26;token=671ea799-f547-4deb-8839-8224e5de7752" alt=""><figcaption><p>add connection asset to canvas</p></figcaption></figure>

4. Access the connection from SQL Block and store the queried table as df.

<figure><img src="https://1018070783-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIQKNeqjEeOp9UwUcB9R9%2Fuploads%2FT9Ifq1MxvK7Mjg2e9ru5%2Fimage.png?alt=media&#x26;token=4943db1b-3f99-42a8-87c3-f202c65126e4" alt=""><figcaption><p>connect from sql block</p></figcaption></figure>

5. Snowflake SQL query is executed and the result is stored as a dataframe in df variable.

<figure><img src="https://1018070783-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIQKNeqjEeOp9UwUcB9R9%2Fuploads%2FDs5vAymxqn6E5hEY4ccC%2Fimage.png?alt=media&#x26;token=a72a8afb-666a-4c01-a17f-a2e12486fe93" alt=""><figcaption><p>full screen mode of SQL Query</p></figcaption></figure>

This variable is now available for downstream python blocks as an input variable.&#x20;