vw_published_app_integrations

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

Overview

Name	vw_published_app_integrations
Type	View
Id	databricks_account.oauth2.vw_published_app_integrations

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
integration_id	string	Unique identifier for the published app integration.
app_id	string	ID of the published app (matches integration_id for published apps).
name	string	Human-readable name of the published app (e.g. Tableau, Power BI, Databricks CLI).
create_time	string	Timestamp when the integration was enabled on this account (ISO 8601).
created_by	integer	ID of the user who enabled this published app integration (0 for system-created).
access_token_ttl_minutes	integer	Time-to-live for access tokens issued to this app, in minutes (typically 60).
refresh_token_ttl_minutes	integer	Time-to-live for refresh tokens issued to this app, in minutes (typically 10080 - 7 days).
session_lifetime_minutes	integer	Maximum absolute session lifetime for this app, in minutes (e.g. 129600 = 90 days, 525600 = 1 year).
single_use_refresh_tokens	boolean	Whether refresh tokens are single-use and rotated on each use (1 = true, 0 = false).

Required Parameters

The following parameters are required by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.

SELECT Examples

SELECT
  account_id,
  integration_id,
  app_id,
  name,
  create_time,
  created_by,
  access_token_ttl_minutes,
  refresh_token_ttl_minutes,
  session_lifetime_minutes,
  single_use_refresh_tokens
FROM databricks_account.oauth2.vw_published_app_integrations
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  p.account_id,
  p.integration_id,
  p.app_id,
  p.name,
  p.create_time,
  p.created_by,
  JSON_EXTRACT(p.token_access_policy, '$.access_token_ttl_in_minutes') AS access_token_ttl_minutes,
  JSON_EXTRACT(p.token_access_policy, '$.refresh_token_ttl_in_minutes') AS refresh_token_ttl_minutes,
  JSON_EXTRACT(p.token_access_policy, '$.absolute_session_lifetime_in_minutes') AS session_lifetime_minutes,
  JSON_EXTRACT(p.token_access_policy, '$.enable_single_use_refresh_tokens') AS single_use_refresh_tokens
FROM databricks_account.oauth2.published_app_integration p
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  p.account_id,
  p.integration_id,
  p.app_id,
  p.name,
  p.create_time,
  p.created_by,
  (p.token_access_policy->>'access_token_ttl_in_minutes')::integer AS access_token_ttl_minutes,
  (p.token_access_policy->>'refresh_token_ttl_in_minutes')::integer AS refresh_token_ttl_minutes,
  (p.token_access_policy->>'absolute_session_lifetime_in_minutes')::integer AS session_lifetime_minutes,
  (p.token_access_policy->>'enable_single_use_refresh_tokens')::boolean AS single_use_refresh_tokens
FROM databricks_account.oauth2.published_app_integration p
WHERE account_id = '{{ account_id }}'