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

  1. 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

  1. Click "Add New Query" to create a new query workspace.

  2. 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

  1. 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

  1. In the query editor, enter your SQL query.

    • Example:

       SELECT sales, orderdate FROM orders;
  2. 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

  1. Once the query is written, click "EXECUTE" to run it.

  2. 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

  1. Click on the AI Bot feature to get SQL assistance.

  2. 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

  1. If your query has errors, AI will suggest corrections.

  2. Click "Apply Fix" to correct syntax issues automatically.

🛠️ This ensures that queries run without manual troubleshooting.


Step 8: Click "EXECUTE" Again

  1. 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

  1. Click on "Visualization" to let AI suggest a suitable chart for the dataset.

  2. 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

  1. Click "Customize the Table" to manually format/create the chart.

  2. 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

  1. Once the visualization is complete, click "Save" to store it.

  2. 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