Create custom SQL queries
Learn how to create custom queries in Superjoin with a comprehensive guide. This section covers various methods, including writing SQL queries, using the Visual SQL Builder, and generating queries with AI. Follow the step-by-step instructions to import and manage your data effectively, ensuring a smooth setup and optimal data analysis.
Follow the quickstart guide to get started with Superjoin 🚀
Quickstart
Install Superjoin in under a minute and start pulling your data instantly.
Common Issues
We’ve listed down common issues that you might face & how to fix it.
Steps to create queries ✨
Ensure Superjoin is installed and working before following the rest of the guide.
Open sources page
Click on the Sources
tab. This will open the sources page in the sidebar.
Select a source
Click on the desired source which you wish to create a query for.
Select the import option
Click on Create new import
button.
Select Query Method
Choose between three query methods through which you would like to import your data.
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.
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.
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.
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.
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
.
Describe the query
Fill in the Name
and Description (Optional)
of the query.
Save the query
Click on the Save Query
button to save the query.
Was this page helpful?