Make (formerly Integromat) allows you to integrate and automate workflows across various online apps, including automated queries on bit.io.
First, create a new scenario:
Then, select the PostgreSQL integration.
Select the operation you'd like to perform with your bit.io database. In this example, we'll choose "Select row(s) from a table."
At this point, you will have the option to add a new PostgreSQL connection with the "Add" button. Click "Add" and fill in the fields using the details in your bit.io database's "Connect" menu.
Make Sure Encrypt is Set to "Yes"
You must choose "Yes" under "Encrypt" or the connection to bit.io will not work.
Finally, follow the Make UI to configure your query. From here, you can export the query results to other Make integrations and set up a schedule for automated execution.
Updated about 1 month ago