Input
Input starts a flow by loading a table. It reads a file from your computer, a public file URL, a file in Cloud, a bundled example dataset or a database or app through a connector.
Load an example dataset
Input is set to File, then Example, with the Retail Stores dataset. Example datasets are bundled with Oplema, so they load with no file or account.
Input interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| store_id | store_name | city | country | store_format |
|---|---|---|---|---|
| 1 | Nordlight Copenhagen | Copenhagen | Denmark | High street |
| 2 | Nordlight Aarhus | Aarhus | Denmark | High street |
| 3 | Nordlight Odense | Odense | Denmark | Outlet |
| 4 | Nordlight Aalborg | Aalborg | Denmark | High street |
| 5 | Nordlight Stockholm | Stockholm | Sweden | High street |
| 6 | Nordlight Gothenburg | Gothenburg | Sweden | Outlet |
| 7 | Nordlight Malmo | Malmo | Sweden | High street |
| 8 | Nordlight Uppsala | Uppsala | Sweden | High street |
- Look at the preview. It reports 40 rows and 5 columns, and the first row is store 1, Nordlight Copenhagen.
- Open Dataset and choose
Coffee Ratings. The preview reloads with that table, so its row count and columns change. - Select Connectors under Source. The menu that appears lists the services Input can read. Connecting an account works in the editor, not in this example.
When to use
Use Input whenever your data already exists somewhere: a CSV on your computer, a file in Cloud, a database table or records in an app such as Stripe or HubSpot. To type a small table by hand, use Manual Input. To read a value someone sets on a dashboard, use Vista Parameter.
Choose a source
Pick one of the three options under Source.
- File: Local File reads a file from your computer, File from URL reads a public link to a file and Example loads a bundled dataset.
- Cloud: reads a data file stored in your Cloud.
- Connectors: reads from a database or app through a saved connection.
Input reads CSV, compressed CSV, TSV, text, JSON, JSON Lines, Parquet, Arrow, Excel and DuckDB files. Excel and delimited files show further settings, such as the sheet, separator and header row.
Connectors
Read the connector guides for setup, permissions and limits.
- Sheets and files: Google Sheets, OneDrive, Dropbox, HTTP.
- Databases: Supabase, SQL Server, Postgres, MySQL, BigQuery, Snowflake, Databricks.
- Apps: Stripe, HubSpot, Airtable, Notion, QuickBooks, Xero.
What connector downloads cost
The first 50 MB of each download are free. Additional data costs $0.01 per GB and needs available usage. A download that needs more than you have available stops with an error. Project viewers (Viewer role) always stop at 50 MB.
To type a small table instead of loading one, use Manual Input.
To send the finished table somewhere, use Output.
Inputs and outputs
Inputs
0 portsNo input ports
This block has no incoming connection.
Outputs
1 port- Out
Configure the block
All 136 settings
- Source
Where the table comes from.
Default:
FileOptions: File, Cloud, Connectors.
- File source
Where the file comes from: your computer (Local File), a public link (File from URL) or a bundled dataset (Example).
Default:
Local FileOptions: Local File, File from URL, Example.
- Dataset
Bundled example dataset.
Default:
Coffee RatingsOptions: Coffee Ratings, NYC Squirrel Census, Retail Orders, Retail Sales, Retail Stores, Sales: orders, Sales: refunds, Monthly demand (sample), Contacts, Bike Share (sample), Profitability: orders, Profitability: costs, Cups sold, Orders over time, Fundraising, Team utilization, Website response time, Regional orders, Cups by day and drink, Cups through the week, Tea and coffee through the week, Customer wait times, Warm days and cold drinks, Drink price, sales and revenue, Cold drink sales, Units by department and item, Survey answers, Cups by store and drink, Three measurements, Daily orders, Bike ratings, Compare three electric cars, A small website project, Product launch milestones, Four orders, A tiny data quality example.
- File
Path to the input file. Supported types: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb
- URL
Public file URL. Supported types: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb. Paste a direct file link and press Enter or Load. Reload refreshes the preview and preserves import settings. Full runs download fresh data.
- Cloud File
Data file stored in Cloud.
- Connector
Connector to load from.
Default:
Google SheetsOptions: Google Sheets, OneDrive, Dropbox, HTTP, Supabase, SQL Server, Postgres, MySQL, BigQuery, Snowflake, Databricks, Stripe, HubSpot, QuickBooks, Xero, Airtable, Notion.
- Connection
The help for this setting changes with the connector you choose.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. For Excel, the whole workbook counts.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. For Excel, the whole workbook counts.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage.
- Path
Path and URL-encoded query below the connection URL.
- Method
Default:
GETOptions: GET, POST.
- Body
JSON request body. Leave empty to send none.
- Format
Format of the response.
Default:
JSONOptions: JSON, JSON Lines, CSV, Parquet.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Reads accounting records; attachments contain metadata only. • Use Parse → JSON for nested details: Unnest object for fields, or Flatten array then Unnest object for lists. • Lines can include discounts and subtotals; summing every line may give the wrong total.
- Object
QuickBooks Online records to load, including supplied totals and nested details.
- Active status
All includes inactive records needed for historical transactions.
Default:
All recordsOptions: All records, Active only, Inactive only.
- Transaction from
Inclusive transaction date, not last modified. Leave blank for no limit.
- Transaction to
Inclusive transaction date, not last modified. Leave blank for no limit.
- Rows
Records retains reported totals and every returned detail. Line items includes all top-level line types; summing lines doesn't necessarily equal the transaction total. Parent totals remain in Records; join using ParentId and CompanyId.
Default:
RecordsOptions: Records, Line items.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Reads accounting records and supported reports; aged reports require a contact. • Use Parse → JSON for nested details: Unnest object for fields, or Flatten array then Unnest object for lists. • Line amounts don't necessarily add up to reported totals.
- Organisation
Xero organisation the login can reach.
- Object
Xero list to load.
- Type
All invoice types, sales invoices or purchase bills.
Default:
AllOptions: All, Sales invoices, Purchase bills.
- Status
All includes archived records.
Default:
All recordsOptions: All records, Active only, Archived only.
- From
Inclusive transaction date, or required reporting period for Profit and Loss.
- To
Inclusive transaction date, or required reporting period for Profit and Loss.
- As of date
Required report date.
- Accounting basis
Basis used by Xero for this report.
Default:
AccrualOptions: Accrual, Cash.
- Contact
Contact for the aged report.
- Rows
Records preserves source totals and nested data. Line items retains every line without repeating parent totals.
Default:
RecordsOptions: Records, Line items.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Copy the Project URL from Supabase → Connect and a secret key from Settings → API Keys. Secret keys can bypass row-level security. • Input and Output can share a connection. A PostgreSQL connection string is required only for Output. • Reads tables and views exposed through your project’s Data API. • A custom schema must be exposed separately, even if Output can write to it.
- Table or view
Table or view exposed by the project's Data API.
- Columns
Read every column, or only the ones you select.
Default:
All columnsOptions: All columns, Selected columns.
- Columns
Columns to read when Columns is set to Selected columns.
- Date column
Both bounds include the whole day. Timestamps with a timezone use UTC; other date fields use stored calendar dates.
- From
First day to read from the date column, inclusive. Optional.
- To
Last day to read from the date column, inclusive. Optional.
- API schema
Leave blank to use the Data API’s default schema. For a custom schema, add it to Exposed schemas in Supabase’s Data API settings. Grant your API role USAGE on the schema and SELECT on its tables. Enter the exact schema name and refresh the table list. Writing to a schema doesn't expose it automatically.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Create a restricted key in Stripe Dashboard → API keys, with Read access to the objects you need; Write access is unnecessary. Test keys read test data; live keys read live data. • Use Parse → JSON for nested details: Unnest object for fields, or Flatten array then Unnest object for lists.
- Object
Native Stripe objects to load.
- Created from
Filter object creation dates in UTC; leave empty for no boundary.
- Created to
Filter object creation dates in UTC; leave empty for no boundary.
- Status
Choose subscription status or active/inactive catalog prices. Stripe excludes inline prices from its Prices list.
Default:
All statusesOptions: All statuses, Active, Inactive, Canceled, Incomplete, Incomplete expired, Past due, Paused, Trialing, Unpaid.
- Load complete line items
Fetch missing invoice, credit-note or subscription items. Additional pages can increase loading time. Items remain nested JSON.
Default:
false- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Use SQL username/password authentication and a host with port, or host\instance without a port. Verify server certificates in production. • Your administrator must allow Oplema’s backend network access and database permissions. • Consistency follows your database’s configured isolation.
- Schema
Schema that holds the table or view to read.
Default:
dbo- Table or view
Table or view to read.
- Columns
Read every column, or only the ones you select.
Default:
All columnsOptions: All columns, Selected columns.
- Columns
Columns to read when Columns is set to Selected columns.
- Date column
Both bounds include the whole day. DATETIMEOFFSET uses UTC; other date fields use stored calendar dates.
- From
First day to read from the date column, inclusive. Optional.
- To
Last day to read from the date column, inclusive. Optional.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Use your administrator’s host, port, database and database-user credentials, with the required TLS setting. • Your administrator must allow Oplema’s backend network access and database permissions. Local/private databases need a route from that backend. • Reads one consistent snapshot. • Transfer charges don't include your database's own costs.
- Schema
Schema that holds the table or view to read.
Default:
public- Table or view
Table or view to read.
- Columns
Read every column, or only the ones you select.
Default:
All columnsOptions: All columns, Selected columns.
- Columns
Columns to read when Columns is set to Selected columns.
- Date column
Both bounds include the whole day. Timestamps with a timezone use UTC; other date fields use stored calendar dates.
- From
First day to read from the date column, inclusive. Optional.
- To
Last day to read from the date column, inclusive. Optional.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Use your administrator’s host, port, database and database-user credentials, with the required TLS setting. • Allow Oplema’s backend network access and the MySQL user’s connecting host. Local/private databases need a route from that backend. • InnoDB reads use one consistent snapshot. Nontransactional data can change during loading.
- Table or view
Table or view to read from the connection's database.
- Columns
Read every column, or only the ones you select.
Default:
All columnsOptions: All columns, Selected columns.
- Columns
Columns to read when Columns is set to Selected columns.
- Date column
Both bounds include the whole day. TIMESTAMP uses UTC; DATETIME uses stored calendar dates.
- From
First day to read from the date column, inclusive. Optional.
- To
Last day to read from the date column, inclusive. Optional.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Use your account identifier, programmatic access token and optional warehouse; blank uses your Snowflake default. • The token needs warehouse/data access, and network policies must allow Oplema’s backend. Replace an expired token by creating a connection with a new one. • Transfer charges don't include warehouse compute costs, which your provider bills.
- Database
Database that holds the table or view to read.
- Schema
Schema that holds the table or view to read.
- Table or view
Table or view to read.
- Columns
Read every column, or only the ones you select.
Default:
All columnsOptions: All columns, Selected columns.
- Columns
Columns to read when Columns is set to Selected columns.
- Date column
Both bounds include the whole day. Zoned timestamps use UTC; unzoned timestamps use stored calendar dates.
- From
First day to read from the date column, inclusive. Optional.
- To
Last day to read from the date column, inclusive. Optional.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Find Server hostname and HTTP path in SQL Warehouses → your warehouse → Connection details. • Use a personal access token with warehouse/data access; create a connection with a new token when it expires. Allow Oplema’s backend to access the workspace and download query results. • Transfer charges don't include compute costs, which your provider bills.
- Catalog
Catalog that holds the schema to read.
- Schema
Schema that holds the table or view to read.
- Table or view
Table or view to read.
- Columns
Read every column, or only the ones you select.
Default:
All columnsOptions: All columns, Selected columns.
- Columns
Columns to read when Columns is set to Selected columns.
- Date column
Both bounds include the whole day. TIMESTAMP uses UTC; DATE and TIMESTAMP_NTZ use stored calendar dates.
- From
First day to read from the date column, inclusive. Optional.
- To
Last day to read from the date column, inclusive. Optional.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • A selected view filters and orders records; hidden fields are still included. • Linked records and attachment contents aren't downloaded automatically.
- Base
Airtable base to read.
- Table
All fields are included.
- View
Use an Airtable view to filter and order records. Fields hidden in the view are still included.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Share the data source with your Notion connection. • Reads database properties, not page bodies or attachment contents.
- Data source
Share the data source with your Notion connection.
- Calculated values
Standard uses values returned with rows. Retrieve calculation details makes extra requests and can be slower; Notion may not support every calculation.
Default:
StandardOptions: Standard, Retrieve calculation details.
- Connection
• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Loads the authorized properties you select. • Related record links contain IDs and labels, not the related records’ other fields.
- Object
Reconnect to grant access to additional objects.
- Archived only
Read archived records only. Off reads active records.
Default:
false- Columns
Choose columns to load, or explicitly include every authorized property.
Default:
All columnsOptions: Selected columns, All columns.
- Columns
Choose the HubSpot properties to include. Record metadata is always included.
- Related record links
Includes related record IDs and relationship labels, not the related records’ other columns.
- Spreadsheet
Google Sheet to load.
- Tab
Sheet tab to load; its used cells are imported.
- Project selection
Pick from your projects, or enter a project ID directly. Use the ID, not the display name.
Default:
Choose projectOptions: Choose project, Enter project ID.
- Project
Project that holds the dataset to read.
- Project ID
Google Cloud project ID, not its display name.
- Dataset
Dataset that holds the table or view to read.
- Table or view
Table or view to read.
- Columns
Read every column, or only the ones you select.
Default:
All columnsOptions: All columns, Selected columns.
- Columns
Columns to read when Columns is set to Selected columns.
- Date column
Both bounds include the whole day. TIMESTAMP uses UTC; DATE and DATETIME use stored calendar dates.
- From
First day to read from the date column, inclusive. Optional.
- To
Last day to read from the date column, inclusive. Optional.
- Query / billing project
Leave blank to run and bill queries in the data project.
- Maximum query size (GiB)
Maximum bytes Google may bill per query. Separate from download pricing and the available usage credit.
Default:
1- Folder
OneDrive folder; its files are listed next.
- File
OneDrive file to load. Supported types: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb
- Folder
Dropbox folder; its files are listed next.
- File
Dropbox file to load. Supported types: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb
- Refresh data
Reload the selected data.
- Sheet
Excel sheet to read. A workbook with one usable sheet selects it automatically.
- Table
Database table to import.
- Area
Part of the sheet to read: detected automatically, or a custom range such as A1:H500.
- Range
Rectangular cell address to import.
- Headers
Automatic detects headers. First row uses the first row as column names. No header generates names.
Options: Automatic, First row, No header.
- Separator
Empty detects the separator. TSV defaults to tab.
Options depend on the connected data and configuration.
- Headers
Automatic detects headers. First row uses the first row as column names. No header generates names.
Options depend on the connected data and configuration.
- Starting row
First row to read, counting from 1.
Default:
1- Custom separator
Character that separates columns in a delimited file when the separator is custom.
- Encoding
Empty uses UTF-8 or a Unicode BOM. Supports utf-8, utf-16le, utf-16be, windows-1252.
Options: Automatic (UTF-8/BOM), UTF-8, UTF-16 LE, UTF-16 BE, Windows-1252.
- Quote
Empty detects quoting; none disables it.
- Escape
Empty detects escaping; none disables it.
- Decimal separator
Period or comma. Empty uses a period.
Options: Period (default), Period, Comma.
- Date format
Optional strptime date format, such as %d/%m/%Y.
- Null marker
Empty unquoted fields are null by default; quoted empty strings remain strings. Enter a literal marker to replace the default.
- Read as text
Keep original CSV field text before numeric or date conversion.
Default:
false- Records
Empty chooses unambiguous records. $ reads the root; /data selects a JSON Pointer.
Input FAQs
- What can Input read?
- A file from your computer, a public file URL, a file in Cloud, a bundled example dataset or a table or list from a connector.
- What does loading data through a connector cost?
- The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. Query costs in BigQuery, Snowflake and Databricks are billed separately by those services.
- Does connector data stay in my browser?
- No. Connector traffic passes through Oplema servers, even when the rest of the flow runs in your browser.
- How do I get the latest data?
- Select Refresh data on the Input block to fetch the selected connector data again.
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.