Skip to main content
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 NameData TypeDescription
nameTEXTThe setting name.
valueTEXTThe current value serialized as text.
data_typeTEXTThe 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'