published_app_integrations

Operations on a published_app_integrations resource.

Overview

Name	published_app_integrations
Type	Resource
Id	databricks_account.oauth.published_app_integrations

Fields

Name	Datatype
name	string
app_id	string
create_time	string
created_by	integer
integration_id	string
token_access_policy	object

Methods

Name	Accessible by	Required Params	Description
get	SELECT	account_id, integration_id	Gets the Published OAuth App Integration for the given integration id.
list	SELECT	account_id	Get the list of published OAuth app integrations for the specified Databricks account
create	INSERT	account_id	Create Published OAuth App Integration.
delete	DELETE	account_id, integration_id	Delete an existing Published OAuth App Integration. You can retrieve the published OAuth app integration via
update	UPDATE	account_id, integration_id	Updates an existing published OAuth App Integration. You can retrieve the published OAuth app integration via

SELECT examples

published_app_integrations (list)

SELECT
name,
app_id,
create_time,
created_by,
integration_id,
token_access_policy
FROM databricks_account.oauth.published_app_integrations
WHERE account_id = '{{ account_id }}';

published_app_integrations (get)

SELECT
name,
app_id,
create_time,
created_by,
integration_id,
token_access_policy
FROM databricks_account.oauth.published_app_integrations
WHERE account_id = '{{ account_id }}' AND
integration_id = '{{ integration_id }}';

INSERT example

Use the following StackQL query and manifest file to create a new published_app_integrations resource.

published_app_integrations

/*+ create */
INSERT INTO databricks_account.oauth.published_app_integrations (
account_id,
data__PowerBI,
data__TableauDesktop
)
SELECT 
'{{ account_id }}',
'{{ PowerBI }}',
'{{ TableauDesktop }}'
;

Manifest

- name: your_resource_model_name
  props:
  - name: PowerBI
    value:
      summary: Enable PowerBI OAuth Login
      value:
        app_id: power-bi
  - name: TableauDesktop
    value:
      summary: Enable Tableau Desktop OAuth Login
      value:
        app_id: tableau-desktop

UPDATE example

Updates a published_app_integrations resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update        
UPDATE databricks_account.oauth.published_app_integrations
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE account_id = '{{ account_id }}' AND
integration_id = '{{ integration_id }}';

DELETE example

Deletes a published_app_integrations resource.

/*+ delete */
DELETE FROM databricks_account.oauth.published_app_integrations
WHERE account_id = '{{ account_id }}' AND
integration_id = '{{ integration_id }}';