steampipe plugin install francois2metz/ovhsteampipe plugin install francois2metz/ovh

ovh_bill ovh_bill_detail ovh_cloud_ai_app ovh_cloud_ai_job ovh_cloud_ai_notebook ovh_cloud_data_job ovh_cloud_database ovh_cloud_flavor ovh_cloud_image ovh_cloud_instance ovh_cloud_postgres ovh_cloud_project ovh_cloud_region ovh_cloud_ssh_key ovh_cloud_storage_s3 ovh_cloud_storage_swift ovh_cloud_volume ovh_cloud_volume_snapshot

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.