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.
Sources
tab. This will open the sources page in the sidebar.Create new import
button.Custom Query
to use the custom query method.Run Query
to preview the data.Visual SQL Builder
to use the visual SQL builder.id
from the account
columns to fetch the email
and amount
from the
account
and investment
columns, respectively.Generate Query with AI
to generate a query for your data using AI.Generate Query
.Run Query
to run the generated query.Import
to import the data and wait for the data to be imported (optionally, create a refresh schedule).3 dots
button on the top right corner of the desired query.Save Query
.Name
and Description (Optional)
of the query.Save Query
button to save the query.