Skip to content

showdatasources.md

Latest commit

 

History

History
32 lines (23 loc) · 824 Bytes

showdatasources.md

File metadata and controls

32 lines (23 loc) · 824 Bytes

show datasources

Description

Use the show datasources command to query datasources configured in the PPL engine. The show datasources command can only be used as the first command in the PPL query.

Syntax

show datasources

Example 1: Fetch all PROMETHEUS datasources

This example shows fetching all the datasources of type prometheus. PPL query for all PROMETHEUS DATASOURCES

show datasources
| where CONNECTOR_TYPE='PROMETHEUS'

Expected output:

fetched rows / total rows = 1/1
+-----------------+----------------+
| DATASOURCE_NAME | CONNECTOR_TYPE |
|-----------------+----------------|
| my_prometheus   | PROMETHEUS     |
+-----------------+----------------+

Limitations

The show datasources command can only work with plugins.calcite.enabled=false.