Skip to main content

vw_all_settings

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

Overview​

Namevw_all_settings
TypeView
Iddatabricks_workspace.settings.vw_all_settings

Fields​

The following fields are returned by this view:

NameDatatypeDescription
propertystringThe name of the workspace setting (only non-null values are included).
valuestringThe value of the workspace setting (only non-null values are included).

Required Parameters​

The following parameters are required by this view:

NameDatatypeDescription
deployment_namestringWorkspace deployment name used to scope the query.

SELECT Examples​

SELECT
  property,
  value
FROM databricks_workspace.settings.vw_all_settings
WHERE deployment_name = '{{ deployment_name }}';

SQL Definition​

SELECT key, value
FROM (
  SELECT
    json_object(
    'enableWebTerminal', enableWebTerminal,
      'enableTokensConfig', enableTokensConfig,
      'maxTokenLifetimeDays', maxTokenLifetimeDays,
      'enableWorkspaceFilesystem', enableWorkspaceFilesystem,
      'enableExportNotebook', enableExportNotebook,
      'enableNotebookTableClipboard', enableNotebookTableClipboard,
      'enableResultsDownloading', enableResultsDownloading,
      'enableDcs', enableDcs,
      'enableGp3', enableGp3,
      'mlflowRunArtifactDownloadEnabled', mlflowRunArtifactDownloadEnabled,
      'enableUploadDataUis', enableUploadDataUis,
      'storeInteractiveNotebookResultsInCustomerAccount', storeInteractiveNotebookResultsInCustomerAccount,
      'enableDeprecatedGlobalInitScripts', enableDeprecatedGlobalInitScripts,
      'rStudioUserDefaultHomeBase', rStudioUserDefaultHomeBase,
      'enforceUserIsolation', enforceUserIsolation,
      'enableProjectsAllowList', enableProjectsAllowList,
      'projectsAllowListPermissions', projectsAllowListPermissions,
      'projectsAllowList', projectsAllowList,
      'reposIpynbResultsExportPermissions', reposIpynbResultsExportPermissions,
      'enableDbfsFileBrowser', enableDbfsFileBrowser,
      'enableDatabricksAutologgingAdminConf', enableDatabricksAutologgingAdminConf,
      'mlflowModelServingEndpointCreationEnabled', mlflowModelServingEndpointCreationEnabled,
      'enableVerboseAuditLogs', enableVerboseAuditLogs,
      'enableFileStoreEndpoint', enableFileStoreEndpoint,
      'loginLogo', loginLogo,
      'productName', productName,
      'homePageLogo', homePageLogo,
      'homePageLogoWidth', homePageLogoWidth,
      'homePageWelcomeMessage', homePageWelcomeMessage,
      'sidebarLogoText', sidebarLogoText,
      'sidebarLogoActive', sidebarLogoActive,
      'sidebarLogoInactive', sidebarLogoInactive,
      'customReferences', customReferences,
      'loginLogoWidth', loginLogoWidth,
      'enforceWorkspaceViewAcls', enforceWorkspaceViewAcls,
      'enforceClusterViewAcls', enforceClusterViewAcls,
      'enableJobViewAcls', enableJobViewAcls,
      'enableHlsRuntime', enableHlsRuntime,
      'enableEnforceImdsV2', enableEnforceImdsV2,
      'enableJobsEmailsV2', enableJobsEmailsV2,
      'enableProjectTypeInWorkspace', enableProjectTypeInWorkspace,
      'mlflowModelRegistryEmailNotificationsEnabled', mlflowModelRegistryEmailNotificationsEnabled,
      'heapAnalyticsAdminConsent', heapAnalyticsAdminConsent,
      'jobsListBackendPaginationEnabled', jobsListBackendPaginationEnabled,
      'jobsListBackendPaginationOptOut', jobsListBackendPaginationOptOut
    ) AS settings_object,
    json_each.key,
    json_each.value
  FROM databricks_workspace.settings.workspace_config c,
      json_each(settings_object)
  WHERE keys='enableWebTerminal,enableTokensConfig,maxTokenLifetimeDays,enableWorkspaceFilesystem,enableExportNotebook,enableNotebookTableClipboard,enableResultsDownloading,enableDcs,enableGp3,mlflowRunArtifactDownloadEnabled,enableUploadDataUis,storeInteractiveNotebookResultsInCustomerAccount,enableDeprecatedGlobalInitScripts,rStudioUserDefaultHomeBase,enforceUserIsolation,enableProjectsAllowList,projectsAllowListPermissions,projectsAllowList,reposIpynbResultsExportPermissions,enableDbfsFileBrowser,enableDatabricksAutologgingAdminConf,mlflowModelServingEndpointCreationEnabled,enableVerboseAuditLogs,enableFileStoreEndpoint,loginLogo,productName,homePageLogo,homePageLogoWidth,homePageWelcomeMessage,sidebarLogoText,sidebarLogoActive,sidebarLogoInactive,customReferences,loginLogoWidth,enforceWorkspaceViewAcls,enforceClusterViewAcls,enableJobViewAcls,enableHlsRuntime,enableEnforceImdsV2,enableJobsEmailsV2,enableProjectTypeInWorkspace,mlflowModelRegistryEmailNotificationsEnabled,heapAnalyticsAdminConsent,jobsListBackendPaginationEnabled,jobsListBackendPaginationOptOut'
    AND deployment_name='{{ deployment_name }}'
) t WHERE value IS NOT NULL;