See also
Tags
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.