Skip to main content

provider_providers

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

Overview

Nameprovider_providers
TypeResource
Iddatabricks_workspace.marketplace.provider_providers

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
providerobject

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectid, deployment_nameGet provider profile
listselectdeployment_namepage_size, page_tokenList provider profiles for account.
createinsertdeployment_name, providerCreate a provider
updatereplaceid, deployment_name, providerUpdate provider profile
deletedeleteid, deployment_nameDelete provider

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.

NameDatatypeDescription
deployment_namestringThe Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)
idstringstr
page_sizeinteger:param page_token: str (optional)
page_tokenstring

SELECT examples

Get provider profile

SELECT
provider
FROM databricks_workspace.marketplace.provider_providers
WHERE id = '{{ id }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
;

INSERT examples

Create a provider

INSERT INTO databricks_workspace.marketplace.provider_providers (
provider,
deployment_name
)
SELECT
'{{ provider }}' /* required */,
'{{ deployment_name }}'
RETURNING
id
;

REPLACE examples

Update provider profile

REPLACE databricks_workspace.marketplace.provider_providers
SET
provider = '{{ provider }}'
WHERE
id = '{{ id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND provider = '{{ provider }}' --required
RETURNING
provider;

DELETE examples

Delete provider

DELETE FROM databricks_workspace.marketplace.provider_providers
WHERE id = '{{ id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
;