Queries

Queries

Queries

Queries are a type of page that allow you to leverage SQL to get the data you want from your connections.

Creating queries

It’s possible to create new queries from within teams.

image

Using queries

Queries can SELECT data from your connection and the result will appear in a table or chart layout. By default, a table layout is used.

⚠️
Queries allow you to execute ANY SQL against your data source, including UPDATE, DELETE, and DROP TABLE statements.

Queries are useful in the following scenarios:

  • When you need to do deep joins of your data source tables (e.g. joining on a foreign value from an already joined table)
  • Visualize data in a line or bar chart
  • Leverage SQL to make calculations on your data

Chart layout

If using chart layout, the first column specified in the SQL query will be used as the chart’s x-axis. A line chart will be used if one of the data points is a date, otherwise a bar chart will be used.

💠
https://www.basedash.com

© BaseDash Inc.