v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins

francois2metz/ovh

steampipe plugin install francois2metz/ovhsteampipe plugin install francois2metz/ovh

Table: ovh_cloud_data_job

A data job is processed by OVH by Apache Spark.

The ovh_cloud_data_job table can be used to query information about your jobs and you must specify which cloud project in the where or join clause (where project_id=, join ovh_cloud_project on id=).

Examples

List data job of a cloud project

select
  id,
  name,
  status
from
  ovh_cloud_data_job
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'

List completed data job

select
  id,
  name,
  status
from
  ovh_cloud_data_job
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and status = 'COMPLETED'

Schema for ovh_cloud_data_job

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
container_name	text		Name of the container where the code and the log of the job is.
created_at	timestamp with time zone		Creation date of the job.
ended_at	timestamp with time zone		End date of the job.
engine	text		Engine of the job.
engine_version	text		Version of the engine.
id	text	=	UUID of the job.
name	text		name of the job.
project_id	text	=	Project ID.
region	text		Openstack region of the job.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
started_at	timestamp with time zone		Start date of the job.
status	text		Current state of the job.
ttl	text		Maximum 'Time To Live' (in RFC3339 (duration)) of this job, after which it will be automatically terminated.