DatabricksSQLCLI

yaml
type: "io.kestra.plugin.databricks.cli.DatabricksSQLCLI"

Examples

yaml
id: databricks_cli_query
namespace: company.team

tasks:
  - id: run_sql_query
    type: io.kestra.plugin.databricks.cli.DatabricksSQLCLI
    host: "{{ secret('DATABRICKS_HOST') }}"
    token: "{{ secret('DATABRICKS_TOKEN') }}"
    httpPath: "{{ secret('DATABRICKS_HTTP_PATH') }}"
    commands:
        - "SELECT * FROM my_catalog.my_schema.my_table LIMIT 10"

Properties

commands*array

SubTypestring

host*string

httpPath*string

token*string

containerImagestring

Defaultghcr.io/kestra-io/databricks-sql-cli

inputFilesobjectstring

optionsobject

SubTypestring

outputFilesarray

SubTypestring

taskRunner

Definitions

Run a task in a Docker container.

type*object

configstringobject

cpu

io.kestra.plugin.scripts.runner.docker.Cpu

cpusnumberstring

credentials

Credentials for a private container registry.

authstring

identityTokenstring

passwordstring

registrystring

registryTokenstring

usernamestring

deletebooleanstring

Defaulttrue

deviceRequestsarray

A request for devices to be sent to device drivers.

capabilitiesarray

SubTypearray

countintegerstring

deviceIdsarray

SubTypestring

driverstring

optionsobject

SubTypestring

entryPointarray

SubTypestring

Default

[
  ""
]

extraHostsarray

SubTypestring

fileHandlingStrategystring

DefaultVOLUME

Possible Values

MOUNTVOLUME

hoststring

killGracePeriodstring

DefaultPT0S

Formatduration

memory

io.kestra.plugin.scripts.runner.docker.Memory

kernelMemorystring

memorystring

memoryReservationstring

memorySwapstring

memorySwappinessstring

oomKillDisablebooleanstring

networkModestring

portBindingsarray

SubTypestring

privilegedbooleanstring

pullPolicyobject

resumebooleanstring

Defaulttrue

shmSizestring

userstring

versionstring

volumesarray

SubTypestring

waitbooleanstring

Defaulttrue

Task runner that executes a task as a subprocess on the Kestra host.

type*object

versionstring

Task runner that executes a task inside a job in Google Cloud Batch.

region*string

type*object

bucketstring

completionCheckIntervalstring

DefaultPT5S

Formatduration

computeResource

io.kestra.plugin.ee.gcp.runner.Batch-ComputeResource

bootDiskstring

cpustring

memorystring

deletebooleanstring

Defaulttrue

entryPointarray

SubTypestring

impersonatedServiceAccountstring

lifecyclePoliciesarray

io.kestra.plugin.ee.gcp.runner.Batch-LifecyclePolicy

actionstring

Possible Values

ACTION_UNSPECIFIEDRETRY_TASKFAIL_TASKUNRECOGNIZED

actionCondition

io.kestra.plugin.ee.gcp.runner.Batch-LifecyclePolicyAction

exitCodesarray

SubTypeinteger

machineTypestring

Defaulte2-medium

maxCreateJobRetryCountintegerstring

Default2

maxRetryCountinteger

Minimum>= 0

Maximum<= 10

networkInterfacesarray