docs-v2/content/flux/v0/stdlib/sql/from.md

1.6 KiB

title description menu weight
sql.from() function `sql.from()` retrieves data from a SQL data source.
flux_v0_ref
name parent identifier
sql.from sql sql/from
101

sql.from() retrieves data from a SQL data source.

Function type signature
(dataSourceName: string, driverName: string, query: string) => stream[A]

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

driverName

({{< req >}}) Driver to use to connect to the SQL database.

Supported drivers:

  • awsathena
  • bigquery
  • hdb
  • mysql
  • postgres
  • snowflake
  • sqlite3 (Does not work with InfluxDB OSS or InfluxDB Cloud)
  • sqlserver
  • vertica, vertigo

dataSourceName

({{< req >}}) Data source name (DNS) or connection string used to connect to the SQL database.

query

({{< req >}}) Query to run against the SQL database.