Dataflake Documentation
  • Home
    • Welcome to Dataflake
    • FAQs
  • Get Started
    • Create my first dashboard
    • Share my dashboard
  • Data Sources
    • PostgreSQL
    • MySQL
    • ClickHouse
    • BigQuery
    • Microsoft SQL Server
    • Flat files
    • Public Dataset
    • Edit, Rename, Delete a Data Source
  • Query
    • Add a query
    • Edit, Delete a query
  • Visualizations
    • Create a chart
    • Chart types
      • Bar chart
      • Pie chart
      • Line chart
      • Horizontal bar chart
      • Mixed chart
      • Card chart
      • Table
      • Bubble chart
      • Scatter chart
      • Sankey Diagram
      • Map chart
  • Manage charts
    • Copy a chart
    • Delete a chart
    • Move a chart
    • Duplicate a chart
  • Custom charts
    • Quick styling toolbar
    • Right styling panel
  • Dashboard
    • Add a dashboard
    • Dashboard Templates
    • Manage Dashboard
    • Manage Legend Color
    • Manage chart labels
    • UI elements
    • JSON Card
  • Drilldowns
    • Zoomed-in Analysis
    • Table Chart Comparison & Running
    • Graph Max/ Min/ Average
    • Filter/ Data Control
  • Email Scheduling
    • Create an email delivery Schedule
    • Stop email delivery
  • Share/ Embed
    • Share/ Embed Dashboard link
    • Embed Iframe
  • Security
    • Security Overview
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. Query

Add a query

When you successfully connect to a database, you begin create query by writing SQL. Follow these instructions to add the query successfully!

PreviousEdit, Rename, Delete a Data SourceNextEdit, Delete a query

Last updated 1 year ago

Was this helpful?

To add a query:

  1. Choose Queries tab

  2. Click Add button to add a query

  3. Choose the connection

  4. Fill in the query name.

  5. You can choose cache time. Cache time help us display the dashboard faster for viewer, and reduce the load for your database server.

  6. Write your SQL in the query box. You can view Schema and Table to help you while you are executing your query

  7. After completing these steps, select Next to finish the process

That’s done, you already add a query to Dataflake!