Related to "Query"
Query data in InfluxDB Cloud
Learn to query data stored in InfluxDB using SQL and InfluxQL.
influx query
The influx query
command and /api/v2/query
API endpoint don’t work with InfluxDB Cloud Serverless. Use SQL or InfluxQL to query an InfluxDB Cloud Serverless bucket.
Query data with SQL
Learn to query data stored in InfluxDB Cloud Serverless using SQL.
Query data with InfluxQL
Learn to use InfluxQL to query data stored in InfluxDB Cloud Serverless.
Execute queries
Use tools and libraries to query data stored in InfluxDB Cloud Serverless.
Explore your schema with InfluxQL
Use InfluxQL SHOW
statements to return information about your data schema.
Explore your schema with SQL
When working with InfluxDB’s implementation of SQL, a bucket is equivalent to a database, a measurement is structured as a table, and time, fields, and tags are structured as columns.
Optimize queries
Optimize queries to improve performance and reduce their memory and compute (CPU) requirements in InfluxDB. Learn how to use observability tools to analyze query execution and view metrics.
Query plans
A query plan is a sequence of steps that the InfluxDB Querier devises and executes to calculate the result of a query in the least amount of time. InfluxDB query plans include DataFusion and InfluxDB logical plan and execution plan nodes for scanning, deduplicating, filtering, merging, and sorting data.
Troubleshoot and optimize queries
Troubleshoot errors and optimize performance for SQL and InfluxQL queries in InfluxDB. Use observability tools to view query execution and metrics.
Troubleshoot queries
Troubleshoot SQL and InfluxQL queries in InfluxDB.
Use Grafana to query and visualize data
Install and run Grafana to query and visualize data stored in InfluxDB.
Use Superset to query data
Install and run Apache Superset to query and visualize data stored in an InfluxDB Cloud Serverless bucket.
Use Tableau to query data with SQL
Install and use Tableau to query data stored in InfluxDB.
Use the InfluxDB Data Explorer to query data
Query your data in the InfluxDB user interface (UI) Data Explorer.
Perform a basic InfluxQL query
A basic InfluxQL query that queries data from InfluxDB most commonly includes SELECT
, FROM
, and WHERE
clauses.
Perform a basic SQL query
A basic SQL query that queries data from InfluxDB most commonly includes SELECT
, FROM
, and WHERE
clauses.
Aggregate data with InfluxQL
Use InfluxQL aggregate and selector functions to perform aggregate operations on your time series data.
Aggregate or apply selector functions to data
Use aggregate and selector functions to perform aggregate operations on your time series data.
Cast values to different types
Use the CAST
function or double-colon ::
casting shorthand syntax to cast a value to a specific type.
Use the InfluxDB v1 HTTP query API and InfluxQL
Use the InfluxDB v1 HTTP query API to query data in InfluxDB Cloud Serverless with InfluxQL.
Use the InfluxDB v1 HTTP write API
Use the InfluxDB v1 HTTP write API to write data stored in InfluxDB Cloud Serverless.
Use visualization tools to query data
Use visualization tools and SQL or InfluxQL to query data stored in InfluxDB.
Analyze a query plan
Learn how to read and analyze a query plan to understand how a query is executed and find performance bottlenecks.
Understand and troubleshoot Flight responses
Understand responses and troubleshoot errors encountered when querying InfluxDB with Flight+gRPC and Arrow Flight clients.
Use Go to query data
Use the influxdb3-go
Go package and SQL or InfluxQL to query data stored in InfluxDB. Execute queries and retrieve data over the Flight+gRPC protocol, and then process data using common Go tools.
Use Python to query data
Use the influxdb_client_3
Python module and SQL or InfluxQL to query data stored in InfluxDB. Execute queries and retrieve data over the Flight+gRPC protocol, and then process data using common Python tools.
Use parameterized queries with InfluxQL
Use parameterized queries to prevent injection attacks and make queries more reusable.
Use parameterized queries with SQL
Use parameterized queries to prevent injection attacks and make queries more reusable.