Row Zero has built-in data connectors to several data sources including Snowflake, Databricks, Redshift, Postgres, Athena, and BigQuery. Once connected, you can query the data source with SQL directly from the spreadsheet to import data. The data connection is dynamic so you can re-run for the latest data or schedule auto-updates and everything you build on connected data will automatically update and stay in sync. Here’s more info on building connected spreadsheets in Row Zero.
For users that don’t know SQL, teams can share queries as Data Sources, which give users one-click access to run the query and import the latest data into their spreadsheet.
In addition to importing data, you can also write-back to data sources by selecting your data, right-clicking, and selecting ‘Export to’.
You can also connect directly to an Amazon S3 bucket to import files.