Connections

Zerve offers support to integrate with popular database solutions which can be queried directly from canvas and can be used across different blocks/languages.

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.

connection setup

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

snowflake connection setup

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

add connection asset to canvas

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

connect from sql block

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

full screen mode of SQL Query

This variable is now available for downstream python blocks as an input variable.