Input nodes
Input nodes start a pipeline. They read files you upload, folders in Amazon S3, Azure Blob Storage, Google Cloud Storage and SFTP, databases and warehouses, Apache Iceberg tables, SaaS APIs, or a small table you type onto the canvas.
Files, cloud folders and databases show their columns while you build, before anything runs, so every node downstream can offer the real column names. Redshift and Databricks read their columns when you press Refresh columns.
Read an Apache Iceberg table from AWS Glue, S3 Tables or a REST catalog, with time-travel and column pruning. Its columns show without a run.
Query data in S3 with Amazon Athena. Picking a table shows its columns without a run, because the catalog already knows them.
Read a single blob or a whole prefix from an Azure Storage container. A Bookmark can read only the files no successful run has read.
Read a table or SQL query from BigQuery. Columns AND what the query will scan both show without a run.
Read a table or SQL query from ClickHouse. Columns show without a run, even for a query you write yourself. A Bookmark can read only the rows added or changed since the last successful run.
Read rows from a CSV file and stream them into the pipeline.
Read a table or SQL query from a Databricks SQL warehouse. Results stream back columnar.
Read one sheet, or every sheet, from an Excel workbook.
Read one file from a web link: CSV, JSON, Parquet, Excel or XML.
Read a single object or a whole prefix from a Google Cloud Storage bucket. A Bookmark can read only the files no successful run has read.
Read a tab and range from a Google spreadsheet. Column types are inferred unless you read everything as text.
Read HubSpot CRM objects: contacts, companies, deals and tickets.
Read Jira issues with JQL.
Read array or newline-delimited JSON; nested objects become columns.
List the files in a folder as rows, with each one's path, name, size and modified time, without reading any of them.
Read documents from a MongoDB collection into rows.
Read a table or SQL query from a MySQL database. A Bookmark can read only the rows added or changed since the last successful run.
Read a single file or a whole folder from a Windows network share or a NAS over SMB. A Bookmark can read only the files no successful run has read.
Read one or more columnar Apache Parquet files.
Read the result of a SQL query from PostgreSQL. A Bookmark can read only the rows added or changed since the last successful run.
Read a table or SQL query from Amazon Redshift. A Bookmark can read only the rows added or changed since the last successful run.
Read records from an HTTP/JSON API, following its pagination to the end.
Read a single object or a whole prefix from an S3 bucket. A Bookmark can read only the files no successful run has read.
Read Salesforce objects with SOQL, paged and typed automatically.
Read a single file or a whole folder from an SFTP server. A Bookmark can read only the files no successful run has read.
Read a table or SQL query from Snowflake. Picking a table shows its columns without a run, and without waking a warehouse.
Read a table or SQL query from Microsoft SQL Server. A Bookmark can read only the rows added or changed since the last successful run.
Read a table, or the result of a SQL query, from a local SQLite database file.
Type a small table straight onto the canvas: lookup values, constants, or a fixed set of rows, versioned with the pipeline.
Read a table or SQL query from a Trino / Starburst cluster. A Bookmark can read only the rows added or changed since the last successful run.
Read one or more XML files, shredding a repeating element into typed rows.
Read Zendesk tickets, users, or organizations.