sql_visualization.md

subcategory
Databricks SQL

databricks_sql_visualization Resource

-> Public Preview This feature is in Public Preview. Contact your Databricks representative to request access.

To manage SQLA resources you must have allow_sql_analytics_access on your databricks_group or databricks_user.

Note: documentation for this resource is a work in progress.

A visualization is always tied to a query. Every query may have one or more visualizations.

Example Usage

resource "databricks_sql_visualization" "q1v1" {
  query_id = databricks_sql_query.q1.id
  type = "table"
  name = "My Table"
  description = "Some Description"

  // The options encoded in this field are passed verbatim to the SQLA API.
  options = jsonencode(
    {
      "itemsPerPage" : 25,
      "columns" : [
        {
          "name" : "p1",
          "type" : "string"
          "title" : "Parameter 1",
          "displayAs" : "string",
        },
        {
          "name" : "p2",
          "type" : "string"
          "title" : "Parameter 2",
          "displayAs" : "link",
          "highlightLinks" : true,
        }
      ]
    }
  )
}