# Data Explorer

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

<figure><img src="/files/ltGikwGkjNi2rshFsEEQ" alt=""><figcaption></figcaption></figure>

***

### **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.*

<figure><img src="/files/XCuKnctaCZcyaqb1Cz4V" alt=""><figcaption></figcaption></figure>

***

### **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.*

<figure><img src="/files/67qwownAa5dhzteIsv3E" alt=""><figcaption></figcaption></figure>

***

### **Step 4: Write the SQL Query to Build a Dataset**

1. In the query editor, enter your SQL query.
   * Example:

     ```sql
      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.*

<figure><img src="/files/e5BjPIDgRCsFAyweEoMS" alt=""><figcaption></figcaption></figure>

***

### **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.*

<figure><img src="/files/qdII5WD7nALyOuht00Rp" alt=""><figcaption></figcaption></figure>

***

### **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.*\
![](/files/cEkZoxlqIoS256J40G4V)

***

### **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.*<br>

<figure><img src="/files/ogsyfkHTb9qzDoOAkXuS" alt=""><figcaption></figcaption></figure>

***

### **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.*

<figure><img src="/files/ftjg29ErcZpR9zdmzhkW" alt=""><figcaption></figcaption></figure>

***

### **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.*<br>

<figure><img src="/files/HvMe7Fph2utwjBX6sBCC" alt=""><figcaption></figcaption></figure>

***

### **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.*

<figure><img src="/files/A1xjz391M9alQxxGByHv" alt=""><figcaption></figcaption></figure>

***

### **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**](/user-guide/comprehensive-user-guide/2.-charts/chart-customization.md) 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**. 🚀


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.getinfinity.app/user-guide/comprehensive-user-guide/2.-charts/creating-charts/data-explorer.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.