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.