Requesting SQL

DJ can generate SQL for one or more metrics with a set of compatible filters and dimensions.

curl

curl -X 'GET' \
  'http://localhost:8000/sql/?metrics=default.num_repair_orders&dimensions=default.all_dispatchers.company_name&filters=default.all_dispatchers.company_name%20IS%20NOT%20NULL' \
  -H 'accept: application/json'

python

dj.sql(
    metrics=[
      "default.num_repair_orders",
    ],
    dimensions=[
      "default.all_dispatchers.company_name",
    ],
    filters=[
      "default.all_dispatchers.company_name IS NOT NULL"
    ],
)

javascript

dj.sql.get(
  metrics=["default.num_repair_orders"],
  dimensions=["default.all_dispatchers.company_name"],
  filters=["default.all_dispatchers.company_name IS NOT NULL"]
).then(data => console.log(data))

👉

You can optionally provide an engine_name and engine_version. A typical DataJunction query service will include a default engine.