Read and write your own database
PostgreSQL, BigQuery and Snowflake in a flow.
- Database query runs one read-only SELECT and turns each row into an item (up to 5,000 rows).
- Database lookup reads a table once and matches each item to it.
- Save to my database adds or updates rows from the items; the connection must be set to allow writing.
Values from items and variables are sent as parameters, never pasted into the SQL. Only one statement that reads is accepted by the query blocks. Hosts must be reachable on the public internet.
Templates that use these blocks
Activity at industrial sites from spaceActivity at industrial sites from space, into your database.New openings into my databaseNew openings saved to your own database every week, classified.Ratings of my portfolio companies’ branchesRating changes and closures at your portfolio companies' branches, weekly.Phone retail footprint across IndiaPhone shops across two big cities, by operator, brand and independent, with a report.