DappLooker Docs
  • 👋Welcome
  • Data APIs for AI
    • Overview
    • Changelog
    • API Authentication
    • API Endpoints
      • GET: Crypto Token Market Data
      • GET: List of All Tokens
      • GET: Multi-Timeframe Technical Analysis
      • GET: Agent Details
      • POST: AI-Powered Query via NLQ
    • Best Practices
    • Conclusion
  • DappLooker Analytics
    • 🗃️Products
      • 📶Analytics
        • 🔎Browse and Search data
        • 📈Creating Charts
          • No-Code Charts
          • SQL Charts
        • 🔢Custom Values
        • 📊Dashboards
          • Create Dashboard
          • Add Charts to Dashboard
          • Discover Page
          • Link dashboard to another dashboard
          • Adding Filters to Dashboard
            • Time Filter
        • ♻️Convert No-Code to SQL
        • 🔗Making Charts and Dashboards Public
      • 🔍Subgraph Analyzer
      • ✨AI Studio
        • AI Studio API Support
      • 🤖DataBOT
        • 🎮Discord Bot
        • ▶️Telegram Bot
        • 🌐Connect with Leading Networks and dApps
      • 🔑DappLooker SDK
        • 🔎Tracking API Usage
    • 🌐Supported Networks
      • Blockchain Data
      • Smart Contracts
      • Subgraphs
      • SubQuery
      • Offchain Data Sources
    • 📲Registering Data
      • My Dashboard Overview
      • Smart Contracts
      • Subgraph
      • Subquery
      • Off-Chain Integration
    • 🔖Featured Projects
    • 🎯Features
      • XRay Feature
      • Filtering
      • Summarize
      • Downloading
        • Download Chart Data
      • Editor Panel
        • Preview Chart
        • Joining Data
        • Types Of Join Data
        • Sorting
        • Row Limit
        • Convert to models
        • Duplicate a Chart
        • New Collection
      • Creating Custom Column and Custom Expressions
      • 📷Screenshot
      • 🗃️Collections
        • Browse Collection
        • Personal Collection
        • Team Collection
    • ⛓️Smart Contract Live Query
    • 🔔Push Notifications
      • 👀Where to view notifications?
      • 📰Push x MetaMask Snaps
    • 👨‍⚖️Case Studies
      • 1️⃣Community Updates
      • 2️⃣DeFi Reports
      • 3️⃣On-Chain & Off-Chain Analysis
      • 4️⃣User Retention Analysis
      • 5️⃣DappLooker Telegram Bot
      • 6️⃣Subgraph Powered No-Code Dashboards
      • 7️⃣API Use Case: Beamswap
      • 8️⃣Embedding Use Case: GRTDataHub
    • 💰Pricing
      • Pricing Breakdown
      • Discounts And Payments
    • 💻Deploy a subgraph on the DappLooker custom node
    • 🥷DappLooker No-code Ninjas Program!
    • 🤝Sponsor With Us
    • 🔗Relevant Resources
    • ☎️Contact Us
  • API Guides
    • Get API Key
    • How to Get an API of a Chart
    • Render Chart or Dashboard as an Image with API
    • Mintbase
      • Individual Store Level APIs
      • Mintbase Protocol Level APIs
    • Nordek Developer APIs
  • Explorers
    • CeloSpy
    • VaraSpy
Powered by GitBook
On this page

Was this helpful?

  1. DappLooker Analytics
  2. Products
  3. Analytics

Convert No-Code to SQL

PreviousTime FilterNextMaking Charts and Dashboards Public

Last updated 1 year ago

Was this helpful?

This guide will walk you through the process of converting no-code charts into SQL charts using the selected dataset. By following these steps, you will be able to seamlessly transition from a visual representation to a SQL-based query, allowing for greater flexibility and control over your data analysis.

  1. Begin by selecting the dataset that you wish to work with. Once you have chosen the dataset, you will have access to all the data within it, which can then be converted into SQL charts.

  1. Locate the "Show Editor" button, typically found in the top right corner of the interface. Clicking on this button will grant you access to the editor, where you can make modifications to your charts and perform advanced operations.

  1. Within the editor interface, you will notice a button labeled "View SQL" positioned next to the editor button. Click on this button to access the SQL options related to your chart.

  1. Upon clicking the "View SQL" button, a popup will appear, presenting you with the option to convert your chart into SQL. Click on the button that prompts you to "Convert this chart to SQL."

  1. After that, you can see the No-code converted chart into SQL you can also customize the SQL query as per your choice.

🗃️
📶
♻️