data_sources

Creates, updates, deletes, gets or lists a data_sources resource.

Overview

Name	data_sources
Type	Resource
Id	databricks_workspace.sql.data_sources

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
id	string	Data source ID maps to the ID of the data source used by the resource and is distinct from the warehouse ID. [Learn more] [Learn more]: https://docs.databricks.com/api/workspace/datasources/list
name	string	The string name of this data source / SQL warehouse as it appears in the Databricks SQL web application.
warehouse_id	string	The ID of the associated SQL warehouse, if this data source is backed by a SQL warehouse.
pause_reason	string	Reserved for internal use.
paused	integer	Reserved for internal use.
supports_auto_limit	boolean	Reserved for internal use.
syntax	string	Reserved for internal use.
type	string	The type of data source. For SQL warehouses, this will be `databricks_internal`.
view_only	boolean	Reserved for internal use.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	deployment_name		Retrieves a full list of SQL warehouses available in this workspace. All fields that appear in this

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
deployment_name	string	The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)

SELECT examples

list

Retrieves a full list of SQL warehouses available in this workspace. All fields that appear in this

SELECT
id,
name,
warehouse_id,
pause_reason,
paused,
supports_auto_limit,
syntax,
type,
view_only
FROM databricks_workspace.sql.data_sources
WHERE deployment_name = '{{ deployment_name }}' -- required
;