Input · Databases and cloud

DB Reader

Reads a table from a PostgreSQL or MySQL database through a saved connection. You pick the schema and table.

Also known as: Postgres, MySQL, SQL input

How it works

The node reads one table over a saved PostgreSQL or MySQL connection. Connection picks a credential from Credentials; a connection string never sits on the node. Table names the table and is the one field you can bind to a column of the Loop's Current item, so a loop reads several tables from the same server. Schema is optional and qualifies the table. The node does not run until a connection and a table are set.

Inputs and outputs

Settings

Example

An orders table in the sales schema of a Postgres warehouse. Pick the saved connection, type orders in Table and sales in Schema. To read every table of the schema in turn, feed a Loop with a DB Directory and bind Table to its table column.

More in Databases and cloud

• S3 Reader — Reads a file stored in an Amazon S3 bucket, or another S3-compatible store, into a table. A pattern such as s3://bucket/exports/*.csv reads every matching object into one table.
• Snowflake Reader — Reads a table from Snowflake through a saved connection, or the result of a SQL query you write. A table is read whole unless you set a row limit.
• Salesforce Reader — Reads the records of a Salesforce object through a saved connection, or the result of a SOQL query you write. An object is read whole unless you set a row limit.
• Strava Reader — Reads your Strava activities, athlete profile or activity streams through your own connected Strava app.