Skip to main content
Skip table of contents

Databricks SQL Warehouse - Execute Query

Overview

Quickly execute a SQL within a Databricks SQL Warehouse **NOTE** This vessel will not return any files, so if you are looking to fetch data from Databricks, use the `Databricks SQL Warehouse - Download Query Results to Workflows` Blueprint. Intended use of this blueprint is for queries with no return values (i.e. ALTER TABLE, DELETE TABLE, etc.)

Variables

NameReferenceTypeRequiredDefaultOptionsDescription
Access TokenDATABRICKS_SQL_ACCESS_TOKENPassword--The access token generated in Databricks for programatic access
Databricks Server HostDATABRICKS_SQL_SERVER_HOSTAlphanumeric--The URL address of the SQL warehouse
Warehouse HTTP PathDATABRICKS_SQL_HTTP_PATHAlphanumeric--The extended path for the SQL warehouse
CatalogDATABRICKS_SQL_CATALOGAlphanumeric--The optional catalog to connect to. If none is provided, this will default to Hive Metastore
SchemaDATABRICKS_SQL_SCHEMAAlphanumeric--The optional schema to connect to. If none is provided, the blueprint will connect to the `default` schema
QueryDATABRICKS_SQL_QUERYAlphanumeric--The query to send to Databricks

YAML

Below is the YAML template

YAML

source:
  template: Databricks SQL Warehouse - Execute Query
  inputs:
    DATABRICKS_SQL_ACCESS_TOKEN:
    DATABRICKS_SQL_SERVER_HOST:
    DATABRICKS_SQL_HTTP_PATH:
    DATABRICKS_SQL_CATALOG:
    DATABRICKS_SQL_SCHEMA:
    DATABRICKS_SQL_QUERY:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 200
    - 202
    - 203
    - 204
    - 205
    - 206
    - 207
    - 208
    - 209
    - 210
    - 211
    - 249

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.