Follow the quickstart guide to get started with Superjoin 🚀

Steps to create queries ✨

Ensure Superjoin is installed and working before following the rest of the guide.

1

Open sources page

Click on the Sources tab. This will open the sources page in the sidebar.

2

Select a source

Click on the desired source which you wish to create a query for.

You can use the Integrations tab in the documentation to set-up an integration.

3

Select the import option

Click on Create new import button.

4

Select Query Method

Choose between three query methods through which you would like to import your data.

5

Method 1: Custom Query

  • Click on Custom Query to use the custom query method.
  • Enter the desired SQL query in the text area.
  • Click on Run Query to preview the data.
6

Method 2: Visual SQL builder

  • Click on Visual SQL Builder to use the visual SQL builder.
  • Select a table and its desired columns to import.
7

Optional: using the "Join" operator

Here, you can use a combination of columns from different tables to get the desired output.

E.g., Here we are trying to use the id from the account columns to fetch the email and amount from the account and investment columns, respectively.

8

Method 3: Generate Query with AI

  • Click on Generate Query with AI to generate a query for your data using AI.
  • In the text area, type the desired prompt to generate a query for your data.
  • Click on Generate Query.
  • Click on Run Query to run the generated query.
9

Saving the query

Click on Import to import the data and wait for the data to be imported (optionally, create a refresh schedule).

  • Click on the 3 dots button on the top right corner of the desired query.
  • Click on Save Query.
10

Describe the query

Fill in the Name and Description (Optional) of the query.

11

Save the query

Click on the Save Query button to save the query.