Data Import

Row Zero supports a number of different methods for importing data into a Row Zero spreadsheet. Data imported into Row Zero can be imported straight into cells, like traditional spreadsheets, or into a data table, which are immutable tables that make it easy to work with large, connected data. The following are all the options for importing data into Row Zero.

File upload

Row Zero lets you import a variety of file types including CSV, TSV, TXT, Parquet, JSONL, XLSX, .gz and more. From any workbook go to Data > Import file. file upload screenshot Row Zero can import 10s of millions of rows on a free plan (up to 5GB) and can support a billion rows on Enterprise plans. Pro and Business users can optionally purchase XL workbooks that can support 30GB dataset.

Postgres

View instructions here: Postgres to Spreadsheet

Snowflake

View instructions here: Snowflake to Spreadsheet

Databricks

View instructions here: Databricks to Spreadsheet

Redshift

View instructions here: Redshift to Spreadsheet

S3 - Connect bucket

The following instructions explain how to create an IAM role in AWS S3 and grant permissions for a Row Zero workbook to connect a specific S3 bucket and ingest data. To begin the process, in the Data menu, select Import from Amazon S3. Import from Amazon S3

You will see a link to the public datasets S3 bucket and a button in the upper right hand corner that says + connect bucket. Click the button to connect a new bucket. The public datasets bucket is available to demo the integration and Row Zero features. Connect bucket

The first step is identifying the bucket name you intend to connect to Row Zero and entering the name in the provided text box. Bucket name Next, provide the Amazon Resource Name (ARN). To identify the name, follow the instructions below to create an IAM role for Row Zero and grab the ARN from the AWS console. At the top of the screen your Row Zero AWS Account ID and your External ID will be visible. Both will be needed to create the IAM role. ID numbers

Create an IAM Role

  1. Log in to the AWS Management Console

  2. Select AWS Account

  3. Select Another AWS Account and enter 732940336628 as the account ID

  4. Select Require External Id and enter Your Account ID

  5. Click Next Enter AWS account IDs

  6. Select Create Policy (this will open a new tab) AWS create policy

  7. Select the tab that says JSON and replace the text with this: AWS json text

  8. Click Next: Tags

  9. Click Next: Review

  10. Give the policy a name like 'RowZero-myS3bucket-ReadOnly'

  11. Click Create policy and close this browser tab AWS policy name

  12. On the first browser tab, refresh the list of policies

  13. Search for the policy you just created (e.g. RowZero-myS3bucket-ReadOnly), click the checkbox to its left, and click Next AWS permission policies

  14. Give the role a name, like RowZero-myS3bucket-ReadOnly

  15. Scroll to the bottom of the page, and click Create Role AWS create role

  16. Click View Role at the top of the screen and copy the role ARN and paste it in the text box at the top of the window. Click Next. AWS view role AWS copy ARN number Paste ARN

Shared Data Sources

The Data Sources feature lets teams share queries as dynamic data sources that can be refreshed or scheduled to update automatically. This is an easy way to give less technical users one-click access to live updating data from governed, "source of truth" datasets. share dynamic data sources Note: The Data Sources feature is only available on Business or Enterprise plans.

Users can create dynamic Open in Row Zero links that will open the latest version of a linked file (e.g. CSV, parquet, etc.) in a new Row Zero workbook. You can create dynamic links to open a file by using the following URL structure: https://rowzero.io/new?link=INSERT_YOUR_LINK_HERE and replace INSERT_YOUR_LINK_HERE with the URL of your file.

Copy/Paste

Copy and paste data from Excel and Google sheets into Row Zero using CTRL+C and CTRL+V commands.

API - Import with Python

Use the Python code window to connect to APIs with Python. Use the code window to write functions that call APIs and return requested data.

  1. Import package that connects to API
    import yfinance
  2. Write a function that calls the API with a request
    def STOCK(ticker):
return yfinance.Ticker(ticker).history(period="max")
  3. Run code window with 'run' button or 'Shift+Enter'
  4. Use the function STOCK() in any spreadsheet cells to display data frame

stock function

Explore examples for importing data with python: yfinance, nfl-data-py, pybaseball

Open large file formats

Row Zero makes it easy to open large files and big file formats. Here are posts for how to open big CSVs, parquet files, JSONL files, and large txt files. Row Zero also lets you open .gz files and automatically will decompress and unzip the .gz file for you.