Data Explorer
In this article, we will explain how to create and customize a line chart. So let's get started!
The Data Explorer in Infinity provides an advanced SQL-based interface for users who prefer to manually query datasets, customize visualizations, and leverage AI assistance for SQL generation. Follow these steps to build and analyze data using SQL.
Step 1: Access the Data Explorer
Click on "Data Explore" from the left sidebar.
💡 This opens the SQL based Data Explorer, where you can write queries and explore data.

Step 2: Add a New Query
Click "Add New Query" to create a new query workspace.
A new query editor box will appear.
📌 Each query box is independent, allowing multiple datasets to be built simultaneously.

Step 3: Select the Relevant Data Source
Choose the appropriate database or uploaded dataset from the available options.
🔍 Ensure you select the correct source before running queries to avoid errors.

Step 4: Write the SQL Query to Build a Dataset
In the query editor, enter your SQL query.
Example:
SELECT sales, orderdate FROM orders;
Modify the query based on the dataset requirements.
🛠️ This step allows full control over how the dataset is structured.

Step 5: Click "EXECUTE" to Run the Query
Once the query is written, click "EXECUTE" to run it.
The results will be displayed in a table format below the query box.
📊 Executing the query fetches the relevant data for visualization.

Step 6: Use AI Bot for SQL Assistance
Click on the AI Bot feature to get SQL assistance.
AI can suggest, auto-fix, or optimize your SQL query.
🔹 Helpful for users who are unsure about SQL syntax or need optimization suggestions.
Step 7: Automatically Fix Query Syntax Errors
If your query has errors, AI will suggest corrections.
Click "Apply Fix" to correct syntax issues automatically.
🛠️ This ensures that queries run without manual troubleshooting.

Step 8: Click "EXECUTE" Again
If the query was fixed or modified, click "EXECUTE" again to retrieve updated results.
🔄 Re-executing the query applies changes and fetches fresh data.

Step 9: Use AI to Generate a Visualization from the Dataset
Click on "Visualization" to let AI suggest a suitable chart for the dataset.
The system will automatically determine the best chart type, layout, and formatting.
📌 AI-driven visualizations help quickly convert raw data into meaningful insights.

Step 10: Customize the Table and Chart
Click "Customize the Table" to manually format/create the chart.
The user will be taken to the chart customization page.
🎨 This step allows users to create and refine the chart before saving it.

Final Step: Save the Chart
Once the visualization is complete, click "Save" to store it.
The chart will be available in your feed.
💾 Your SQL-powered chart is now ready for sharing and further analysis!
Next Steps
For more advanced customization, refer to the Chart Customization Guide to explore:
Using interactive filters and drill-downs.
Applying custom themes and layouts.
Integrating AI-powered insights into reports.
The Data Explorer in Infinity provides full SQL control, AI assistance, and powerful visualization tools, making it an ideal solution for data analysts, engineers, and SQL-savvy users. 🚀
Last updated