vw_custom_app_integrations

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

Overview

Name	vw_custom_app_integrations
Type	View
Id	databricks_account.oauth2.vw_custom_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 custom app integration.
client_id	string	OAuth2 client ID issued for the custom app integration.
name	string	Human-readable name of the custom app integration.
confidential	boolean	Whether the app is a confidential client (can securely store a client secret).
creator_username	string	Username of the user who created the custom app integration.
created_by	integer	ID of the user who created the custom app integration.
create_time	string	Timestamp when the integration was created (ISO 8601).
redirect_urls	array	List of allowed OAuth2 redirect URLs for the app integration.
scopes	array	List of OAuth2 scopes the app integration is permitted to request.
user_authorized_scopes	array	List of scopes that users have individually authorized for this app.
access_token_ttl_minutes	integer	Time-to-live for access tokens issued to this app, in minutes.
refresh_token_ttl_minutes	integer	Time-to-live for refresh tokens issued to this app, in minutes.
session_lifetime_minutes	integer	Maximum absolute session lifetime for this app, in minutes.
single_use_refresh_tokens	boolean	Whether refresh tokens are single-use (rotated on each use).

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,
  client_id,
  name,
  confidential,
  creator_username,
  created_by,
  create_time,
  redirect_urls,
  scopes,
  user_authorized_scopes,
  access_token_ttl_minutes,
  refresh_token_ttl_minutes,
  session_lifetime_minutes,
  single_use_refresh_tokens
FROM databricks_account.oauth2.vw_custom_app_integrations
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  c.account_id,
  c.integration_id,
  c.client_id,
  c.name,
  c.confidential,
  c.creator_username,
  c.created_by,
  c.create_time,
  c.redirect_urls,
  c.scopes,
  c.user_authorized_scopes,
  JSON_EXTRACT(c.token_access_policy, '$.access_token_ttl_in_minutes') AS access_token_ttl_minutes,
  JSON_EXTRACT(c.token_access_policy, '$.refresh_token_ttl_in_minutes') AS refresh_token_ttl_minutes,
  JSON_EXTRACT(c.token_access_policy, '$.absolute_session_lifetime_in_minutes') AS session_lifetime_minutes,
  JSON_EXTRACT(c.token_access_policy, '$.enable_single_use_refresh_tokens') AS single_use_refresh_tokens
FROM databricks_account.oauth2.custom_app_integration c
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  c.account_id,
  c.integration_id,
  c.client_id,
  c.name,
  c.confidential,
  c.creator_username,
  c.created_by,
  c.create_time,
  c.redirect_urls,
  c.scopes,
  c.user_authorized_scopes,
  (c.token_access_policy->>'access_token_ttl_in_minutes')::integer AS access_token_ttl_minutes,
  (c.token_access_policy->>'refresh_token_ttl_in_minutes')::integer AS refresh_token_ttl_minutes,
  (c.token_access_policy->>'absolute_session_lifetime_in_minutes')::integer AS session_lifetime_minutes,
  (c.token_access_policy->>'enable_single_use_refresh_tokens')::boolean AS single_use_refresh_tokens
FROM databricks_account.oauth2.custom_app_integration c
WHERE account_id = '{{ account_id }}'