Schema:
ACCOUNT_USAGE

COLUMNS View

This Account Usage view displays a row for each column in the tables defined in the account.

See also:
DATABASES View

Columns

Column Name Data Type Description
COLUMN_ID NUMBER Internal/system-generated identifier for the column.
COLUMN_NAME TEXT Name of the column.
TABLE_ID NUMBER Internal/system-generated identifier for the table or view for the column.
TABLE_NAME TEXT Table or view that the column belongs to.
TABLE_SCHEMA_ID NUMBER Internal/system-generated identifier for the schema of the table or view for the column.
TABLE_SCHEMA TEXT Schema that the table or view belongs to.
TABLE_CATALOG_ID NUMBER Internal/system-generated identifier for the database of the table or view for the column.
TABLE_CATALOG TEXT Database that the table or view belongs to.
ORDINAL_POSITION NUMBER Ordinal position of the column in the table/view.
COLUMN_DEFAULT TEXT Default value of the column.
IS_NULLABLE TEXT Whether the column allows NULL values.
DATA_TYPE TEXT Data type of the column.
CHARACTER_MAXIMUM_LENGTH NUMBER Maximum length in characters of string columns.
CHARACTER_OCTET_LENGTH NUMBER Maximum length in bytes of string columns.
NUMERIC_PRECISION NUMBER Numeric precision of numeric columns.
NUMERIC_PRECISION_RADIX NUMBER Radix of precision of numeric columns.
NUMERIC_SCALE NUMBER Scale of numeric columns.
DATETIME_PRECISION NUMBER Not applicable for Snowflake.
INTERVAL_TYPE TEXT Not applicable for Snowflake.
INTERVAL_PRECISION TEXT Not applicable for Snowflake.
CHARACTER_SET_CATALOG TEXT Not applicable for Snowflake.
CHARACTER_SET_SCHEMA TEXT Not applicable for Snowflake.
CHARACTER_SET_NAME TEXT Not applicable for Snowflake.
COLLATION_CATALOG TEXT Not applicable for Snowflake.
COLLATION_SCHEMA TEXT Not applicable for Snowflake.
COLLATION_NAME TEXT Not applicable for Snowflake.
DOMAIN_CATALOG TEXT Not applicable for Snowflake.
DOMAIN_SCHEMA TEXT Not applicable for Snowflake.
DOMAIN_NAME TEXT Not applicable for Snowflake.
UDT_CATALOG TEXT Not applicable for Snowflake.
UDT_SCHEMA TEXT Not applicable for Snowflake.
UDT_NAME TEXT Not applicable for Snowflake.
SCOPE_CATALOG TEXT Not applicable for Snowflake.
SCOPE_SCHEMA TEXT Not applicable for Snowflake.
SCOPE_NAME TEXT Not applicable for Snowflake.
MAXIMUM_CARDINALITY TEXT Not applicable for Snowflake.
DTD_IDENTIFIER TEXT Not applicable for Snowflake.
IS_SELF_REFERENCING TEXT Not applicable for Snowflake.
IS_IDENTITY TEXT Whether the column is an identity column.
IDENTITY_GENERATION TEXT Whether an identity column’s value is always generated or only generated by default. Snowflake only supports BY DEFAULT.
IDENTITY_START TEXT Not applicable for Snowflake.
IDENTITY_INCREMENT TEXT Not applicable for Snowflake.
IDENTITY_MAXIMUM TEXT Not applicable for Snowflake.
IDENTITY_MINIMUM TEXT Not applicable for Snowflake.
IDENTITY_CYCLE TEXT Whether the value of an identity column allows cycling. Snowflake only supports NO CYCLE.
COMMENT TEXT Comment for the column.
DELETED TIMESTAMP_LTZ Date and time when the column was deleted.

Usage Notes

  • Latency for the view may be up to 90 minutes.
  • The view only displays objects for which the current role for the session has been granted access privileges.
  • The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.