Databases

Reading Data from an SQL Database

We have connections with MS SQL, MySQL, PostgreSQL, Snowflake, and BigQuery available out of the box, so you can connect your databases to the platform.

During the setup process, you'll need to manually define SELECT queries. This means that we don't fetch all the database tables metadata automatically.

Writing Data to an SQL Database

You can also write data to an SQL database using our "Send to SQL" building block.

Data import limitation

There are no hard technical limits on rows, but there's a time limit for importing operations. Typically, an operation should be completed within 15 minutes for an ordinary data source. However, this limit is configurable.

Limit on volume of data

There are no hard limits for the SQL integration in asynchronous Workflows. For the interactive Copilot, I would suggest that users ideally should not have to wait dozens of minutes so you may need to aggregate data to smaller volumes with help of our ETL tools (Workflows). However, the wait time ultimately depends on the complexity of the query.

SSH tunnel

The SSH tunnel is under development, with an estimated completion date of June 2024.