Skip to main content

Rockset

Overview​

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

Read data from a Rockset database and use it within an Application

  • Save information retrieved by other API steps or UI components by writing data to a database

Write data into a Rockset database using SQL in a backend API

Setting up Rockset​

1. Add integration​

Select Rockset from the integrations page.

2. Configure settings​

Fill out the form with the following settings:

SettingRequiredDescription
NameTRUEName that will be displayed to users when selecting this integration in Superblocks
API KeyTRUECreate a new API key within Rockset, and provide the key here
RegionTRUERegion of your Rockset organization

3. Test and save​

Click Test Connection to check that Superblocks can connect to the data source.

info

If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for On-Premise-Agent)

After connecting successfully, click Create to save the integration.

4. Set profiles​

Optionally, configure different profiles for separate development environments.

success

Rockset Connected You can now write SQL to read from and write to Rockset in any Application, Workflow, or Scheduled Job.

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.

See the results of a Rockset query

See the executed SQL of a Rockset query

Use cases​

Applications

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.

Admin dashboard reads from Rockset allowing for order refunds

Workflows

Enrich customer order data within Rockset with shipping data from Snowflake or other datastores.

Use a workflow to enrich Rockset data with data from other datastores like Snowflake

Scheduled Jobs

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.

Use a scheduled job to query Rockset and send out a daily report