Connect Superblocks to Rockset to build apps with read and write access to a Rockset database:
- Read data from a Rockset database and utilize it in API steps or UI components
- Save information retrieved by other API steps or UI components by writing data to a database
Setting up Rockset
1. Select Rockset from the in-app integrations page
Select Rockset from the in-app Integrations page and fill out the form with the following configuration:
- Display Name - Name that will be displayed to users when selecting this integration in Superblocks
- API Key - Create a new API key within Rockset, and provide the key here
2. Fill out the form and click "Create Integration"
3. Set environments
After creating the integration, you can optionally set different connection settings for your Production and Staging environments. Be sure to click
Test Connection for each environment.
Creating Rockset steps
Connect to your Rockset integration from Superblocks by creating steps in Application APIs, Workflows and Scheduled Jobs. You can configure a Superblocks Rockset integration with read only, read/write, or write only users. You can then configure a Superblocks Rockset step to read from a database, as well as modify/delete data. To get started, enter your SQL query into the text area of the Rockset step. Then click "Run" to see the Result and Executed SQL statement below.
Create an admin dashboard that reads from Rockset and other sources. Mix in APIs to allow support agents to refund orders, update shipping statuses, or transform large datasets in a single UI.
Enrich customer order data within Rockset with shipping data from snowflake or other datastores.
Copy data from Rockset to a Google Sheet on a daily basis for teams who need to see info on new bookings, but don't have access to the database.