Account info

You can use the information_schema.account_info view to return information about account-level settings and flags (for example, ALLOW_AMAZON_BEDROCK). You can use a SELECT query to return all settings, as shown below.

SELECT
  *
FROM
  information_schema.account_info
ORDER BY
  name;

For general account metadata (such as account name, region, and owner), see information_schema.accounts.

Columns in information_schema.account_info

Each row has the following columns with information about an account setting.

Column Name	Data Type	Description
name	TEXT	The setting name.
value	TEXT	The current value serialized as text.
data_type	TEXT	The data type of the setting value (for example, `BOOLEAN`).

Sample results

name TEXT,value TEXT,data_type TEXT

'ALLOW_AMAZON_BEDROCK','true','BOOLEAN'
'ALLOW_DATABRICKS_AI','true','BOOLEAN'

Information Schema

Applicable roles

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Columns in information_schema.account_info

Sample results

​Columns in information_schema.account_info

​Sample results

Columns in information_schema.account_info

Sample results