Share
Explore
Data
All Columns
All Columns
Table schema
Table name
Column name
Data type
Comment
Ordinal position
Last synced
Joins to
Notes
1
ACCOUNT_PLAN
ROLES
DEPARTMENT
TEXT
2
3/7/2024, 4:28 PM
2
ACCOUNT_PLAN
ROLES
TITLE
TEXT
1
3/7/2024, 4:28 PM
3
SNOWPULSE
APPLICATIONS
BUSINESSID
TEXT
16
3/7/2024, 4:28 PM
4
SMALL
PAGE_VIEWS
TIMESTAMP
TIMESTAMP_NTZ
3
3/7/2024, 4:28 PM
5
ACCOUNT_PLAN
DOCS
CREATED
TIMESTAMP_NTZ
4
3/7/2024, 4:28 PM
6
SMALL
ORGS_1000
NAME
TEXT
3
3/7/2024, 4:28 PM
7
INFORMATION_SCHEMA
TABLES
TABLE_CATALOG
TEXT
Database that the table belongs to
1
3/7/2024, 4:28 PM
8
INFORMATION_SCHEMA
TABLES
TABLE_SCHEMA
TEXT
Schema that the table belongs to
2
3/7/2024, 4:28 PM
9
INFORMATION_SCHEMA
TABLES
TABLE_NAME
TEXT
Name of the table
3
3/7/2024, 4:28 PM
10
INFORMATION_SCHEMA
TABLES
TABLE_OWNER
TEXT
Name of the role that owns the table
4
3/7/2024, 4:28 PM
11
INFORMATION_SCHEMA
TABLES
TABLE_TYPE
TEXT
Whether the table is a base table, temporary table, or view
5
3/7/2024, 4:28 PM
12
INFORMATION_SCHEMA
TABLES
IS_TRANSIENT
TEXT
Whether this is a transient table
6
3/7/2024, 4:28 PM
13
INFORMATION_SCHEMA
TABLES
CLUSTERING_KEY
TEXT
Clustering key for the table
7
3/7/2024, 4:28 PM
14
INFORMATION_SCHEMA
TABLES
ROW_COUNT
NUMBER
Number of rows in the table
8
3/7/2024, 4:28 PM
15
INFORMATION_SCHEMA
TABLES
BYTES
NUMBER
Number of bytes accessed by a scan of the table
9
3/7/2024, 4:28 PM
16
INFORMATION_SCHEMA
TABLES
RETENTION_TIME
NUMBER
Number of days that historical data is retained for Time Travel
10
3/7/2024, 4:28 PM
17
INFORMATION_SCHEMA
TABLES
SELF_REFERENCING_COLUMN_NAME
TEXT
Not applicable for Snowflake.
11
3/7/2024, 4:28 PM
18
INFORMATION_SCHEMA
TABLES
REFERENCE_GENERATION
TEXT
Not applicable for Snowflake.
12
3/7/2024, 4:28 PM
19
INFORMATION_SCHEMA
TABLES
USER_DEFINED_TYPE_CATALOG
TEXT
Not applicable for Snowflake.
13
3/7/2024, 4:28 PM
20
INFORMATION_SCHEMA
TABLES
USER_DEFINED_TYPE_SCHEMA
TEXT
Not applicable for Snowflake.
14
3/7/2024, 4:28 PM
21
INFORMATION_SCHEMA
TABLES
USER_DEFINED_TYPE_NAME
TEXT
Not applicable for Snowflake.
15
3/7/2024, 4:28 PM
22
INFORMATION_SCHEMA
TABLES
IS_INSERTABLE_INTO
TEXT
Not applicable for Snowflake.
16
3/7/2024, 4:28 PM
23
INFORMATION_SCHEMA
TABLES
IS_TYPED
TEXT
Not applicable for Snowflake.
17
3/7/2024, 4:28 PM
24
INFORMATION_SCHEMA
TABLES
COMMIT_ACTION
TEXT
Not applicable for Snowflake.
18
3/7/2024, 4:28 PM
25
INFORMATION_SCHEMA
TABLES
CREATED
TIMESTAMP_LTZ
Creation time of the function
19
3/7/2024, 4:28 PM
26
INFORMATION_SCHEMA
TABLES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the function
20
3/7/2024, 4:28 PM
27
INFORMATION_SCHEMA
TABLES
LAST_DDL
TIMESTAMP_LTZ
Last DDL time of the table
21
3/7/2024, 4:28 PM
28
INFORMATION_SCHEMA
TABLES
LAST_DDL_BY
TEXT
User name that performed the Last DDL of the table
22
3/7/2024, 4:28 PM
29
INFORMATION_SCHEMA
TABLES
AUTO_CLUSTERING_ON
TEXT
Whether automatic clustering is on for the table
23
3/7/2024, 4:28 PM
30
INFORMATION_SCHEMA
TABLES
COMMENT
TEXT
Comment for this table
24
3/7/2024, 4:28 PM
31
INFORMATION_SCHEMA
TABLES
IS_TEMPORARY
TEXT
Whether this is a temporary table
25
3/7/2024, 4:28 PM
32
INFORMATION_SCHEMA
TABLES
IS_ICEBERG
TEXT
Whether this is an Iceberg table
26
3/7/2024, 4:28 PM
33
INFORMATION_SCHEMA
TABLES
IS_DYNAMIC
TEXT
Whether this is a dynamic table
27
3/7/2024, 4:28 PM
34
INFORMATION_SCHEMA
COLUMNS
TABLE_CATALOG
TEXT
Database that the table belongs to
1
3/7/2024, 4:28 PM
35
INFORMATION_SCHEMA
COLUMNS
TABLE_SCHEMA
TEXT
Schema that the table belongs to
2
3/7/2024, 4:28 PM
36
INFORMATION_SCHEMA
COLUMNS
TABLE_NAME
TEXT
Table that the column belongs to
3
3/7/2024, 4:28 PM
37
INFORMATION_SCHEMA
COLUMNS
COLUMN_NAME
TEXT
Name of the column
4
3/7/2024, 4:28 PM
38
INFORMATION_SCHEMA
COLUMNS
ORDINAL_POSITION
NUMBER
Ordinal position of the column in the table
5
3/7/2024, 4:28 PM
39
INFORMATION_SCHEMA
COLUMNS
COLUMN_DEFAULT
TEXT
Default value of the column
6
3/7/2024, 4:28 PM
40
INFORMATION_SCHEMA
COLUMNS
IS_NULLABLE
TEXT
'YES' if the column may contain NULL, 'NO' otherwise
7
3/7/2024, 4:28 PM
41
INFORMATION_SCHEMA
COLUMNS
DATA_TYPE
TEXT
Data type of the column
8
3/7/2024, 4:28 PM
42
INFORMATION_SCHEMA
COLUMNS
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters of string columns
9
3/7/2024, 4:28 PM
43
INFORMATION_SCHEMA
COLUMNS
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes of string columns
10
3/7/2024, 4:28 PM
44
INFORMATION_SCHEMA
COLUMNS
NUMERIC_PRECISION
NUMBER
Numeric precision of numeric columns
11
3/7/2024, 4:28 PM
45
INFORMATION_SCHEMA
COLUMNS
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision of numeric columns
12
3/7/2024, 4:28 PM
46
INFORMATION_SCHEMA
COLUMNS
NUMERIC_SCALE
NUMBER
Scale of numeric columns
13
3/7/2024, 4:28 PM
47
INFORMATION_SCHEMA
COLUMNS
DATETIME_PRECISION
NUMBER
Not applicable for Snowflake.
14
3/7/2024, 4:28 PM
48
INFORMATION_SCHEMA
COLUMNS
INTERVAL_TYPE
TEXT
Not applicable for Snowflake.
15
3/7/2024, 4:28 PM
49
INFORMATION_SCHEMA
COLUMNS
INTERVAL_PRECISION
NUMBER
Not applicable for Snowflake.
16
3/7/2024, 4:28 PM
50
INFORMATION_SCHEMA
COLUMNS
CHARACTER_SET_CATALOG
TEXT
Not applicable for Snowflake.
17
3/7/2024, 4:28 PM
51
INFORMATION_SCHEMA
COLUMNS
CHARACTER_SET_SCHEMA
TEXT
Not applicable for Snowflake.
18
3/7/2024, 4:28 PM
52
INFORMATION_SCHEMA
COLUMNS
CHARACTER_SET_NAME
TEXT
Not applicable for Snowflake.
19
3/7/2024, 4:28 PM
53
INFORMATION_SCHEMA
COLUMNS
COLLATION_CATALOG
TEXT
Not applicable for Snowflake.
20
3/7/2024, 4:28 PM
54
INFORMATION_SCHEMA
COLUMNS
COLLATION_SCHEMA
TEXT
Not applicable for Snowflake.
21
3/7/2024, 4:28 PM
55
INFORMATION_SCHEMA
COLUMNS
COLLATION_NAME
TEXT
The name of collation, if present
22
3/7/2024, 4:28 PM
56
INFORMATION_SCHEMA
COLUMNS
DOMAIN_CATALOG
TEXT
Not applicable for Snowflake.
23
3/7/2024, 4:28 PM
57
INFORMATION_SCHEMA
COLUMNS
DOMAIN_SCHEMA
TEXT
Not applicable for Snowflake.
24
3/7/2024, 4:28 PM
58
INFORMATION_SCHEMA
COLUMNS
DOMAIN_NAME
TEXT
Not applicable for Snowflake.
25
3/7/2024, 4:28 PM
59
INFORMATION_SCHEMA
COLUMNS
UDT_CATALOG
TEXT
Not applicable for Snowflake.
26
3/7/2024, 4:28 PM
60
INFORMATION_SCHEMA
COLUMNS
UDT_SCHEMA
TEXT
Not applicable for Snowflake.
27
3/7/2024, 4:28 PM
61
INFORMATION_SCHEMA
COLUMNS
UDT_NAME
TEXT
Not applicable for Snowflake.
28
3/7/2024, 4:28 PM
62
INFORMATION_SCHEMA
COLUMNS
SCOPE_CATALOG
TEXT
Not applicable for Snowflake.
29
3/7/2024, 4:28 PM
63
INFORMATION_SCHEMA
COLUMNS
SCOPE_SCHEMA
TEXT
Not applicable for Snowflake.
30
3/7/2024, 4:28 PM
64
INFORMATION_SCHEMA
COLUMNS
SCOPE_NAME
TEXT
Not applicable for Snowflake.
31
3/7/2024, 4:28 PM
65
INFORMATION_SCHEMA
COLUMNS
MAXIMUM_CARDINALITY
NUMBER
Not applicable for Snowflake.
32
3/7/2024, 4:28 PM
66
INFORMATION_SCHEMA
COLUMNS
DTD_IDENTIFIER
TEXT
Not applicable for Snowflake.
33
3/7/2024, 4:28 PM
67
INFORMATION_SCHEMA
COLUMNS
IS_SELF_REFERENCING
TEXT
Not applicable for Snowflake.
34
3/7/2024, 4:28 PM
68
INFORMATION_SCHEMA
COLUMNS
IS_IDENTITY
TEXT
Whether this column is an identity column
35
3/7/2024, 4:28 PM
69
INFORMATION_SCHEMA
COLUMNS
IDENTITY_GENERATION
TEXT
Whether an identity column's value is always generated or only generated by default. Snowflake only supports BY DEFAULT
36
3/7/2024, 4:28 PM
70
INFORMATION_SCHEMA
COLUMNS
IDENTITY_START
TEXT
Not applicable for Snowflake.
37
3/7/2024, 4:28 PM
71
INFORMATION_SCHEMA
COLUMNS
IDENTITY_INCREMENT
TEXT
Not applicable for Snowflake.
38
3/7/2024, 4:28 PM
72
INFORMATION_SCHEMA
COLUMNS
IDENTITY_MAXIMUM
TEXT
Not applicable for Snowflake.
39
3/7/2024, 4:28 PM
73
INFORMATION_SCHEMA
COLUMNS
IDENTITY_MINIMUM
TEXT
Not applicable for Snowflake.
40
3/7/2024, 4:28 PM
74
INFORMATION_SCHEMA
COLUMNS
IDENTITY_CYCLE
TEXT
Whether the value of an identity column may cycle. Snowflake only supports NO CYCLE.
41
3/7/2024, 4:28 PM
75
INFORMATION_SCHEMA
COLUMNS
IDENTITY_ORDERED
TEXT
Whether the identity column is backed by an ordered sequence
42
3/7/2024, 4:28 PM
76
INFORMATION_SCHEMA
COLUMNS
SCHEMA_EVOLUTION_RECORD
TEXT
The record of the latest schema evolution of the column, if present
43
3/7/2024, 4:28 PM
77
INFORMATION_SCHEMA
COLUMNS
COMMENT
TEXT
Comment for this column
44
3/7/2024, 4:28 PM
78
INFORMATION_SCHEMA
ELEMENT_TYPES
OBJECT_CATALOG
TEXT
Database that contains the object that uses this array type
1
3/7/2024, 4:28 PM
79
INFORMATION_SCHEMA
ELEMENT_TYPES
OBJECT_SCHEMA
TEXT
Schema that contains the object that uses this array type
2
3/7/2024, 4:28 PM
80
INFORMATION_SCHEMA
ELEMENT_TYPES
OBJECT_NAME
TEXT
Name of the object that uses this array type
3
3/7/2024, 4:28 PM
81
INFORMATION_SCHEMA
ELEMENT_TYPES
OBJECT_TYPE
TEXT
Type of the object that uses this array type
4
3/7/2024, 4:28 PM
82
INFORMATION_SCHEMA
ELEMENT_TYPES
COLLECTION_TYPE_IDENTIFIER
TEXT
Type identifier
5
3/7/2024, 4:28 PM
83
INFORMATION_SCHEMA
ELEMENT_TYPES
DATA_TYPE
TEXT
Element data type
6
3/7/2024, 4:28 PM
84
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters for string types
7
3/7/2024, 4:28 PM
85
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes for string types
8
3/7/2024, 4:28 PM
86
INFORMATION_SCHEMA
ELEMENT_TYPES
NUMERIC_PRECISION
NUMBER
Numeric precision for numeric types
9
3/7/2024, 4:28 PM
87
INFORMATION_SCHEMA
ELEMENT_TYPES
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision for numeric types
10
3/7/2024, 4:28 PM
88
INFORMATION_SCHEMA
ELEMENT_TYPES
NUMERIC_SCALE
NUMBER
Scale for numeric types
11
3/7/2024, 4:28 PM
89
INFORMATION_SCHEMA
ELEMENT_TYPES
DATETIME_PRECISION
NUMBER
Not applicable for Snowflake.
12
3/7/2024, 4:28 PM
90
INFORMATION_SCHEMA
ELEMENT_TYPES
INTERVAL_TYPE
TEXT
Not applicable for Snowflake.
13
3/7/2024, 4:28 PM
91
INFORMATION_SCHEMA
ELEMENT_TYPES
INTERVAL_PRECISION
NUMBER
Not applicable for Snowflake.
14
3/7/2024, 4:28 PM
92
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_SET_CATALOG
TEXT
Not applicable for Snowflake.
15
3/7/2024, 4:28 PM
93
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_SET_SCHEMA
TEXT
Not applicable for Snowflake.
16
3/7/2024, 4:28 PM
94
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_SET_NAME
TEXT
Not applicable for Snowflake.
17
3/7/2024, 4:28 PM
95
INFORMATION_SCHEMA
ELEMENT_TYPES
COLLATION_CATALOG
TEXT
Not applicable for Snowflake.
18
3/7/2024, 4:28 PM
96
INFORMATION_SCHEMA
ELEMENT_TYPES
COLLATION_SCHEMA
TEXT
Not applicable for Snowflake.
19
3/7/2024, 4:28 PM
97
INFORMATION_SCHEMA
ELEMENT_TYPES
COLLATION_NAME
TEXT
The name of collation, if present
20
3/7/2024, 4:28 PM
98
INFORMATION_SCHEMA
ELEMENT_TYPES
UDT_CATALOG
TEXT
Not applicable for Snowflake.
21
3/7/2024, 4:28 PM
99
INFORMATION_SCHEMA
ELEMENT_TYPES
UDT_SCHEMA
TEXT
Not applicable for Snowflake.
22
3/7/2024, 4:28 PM
100
INFORMATION_SCHEMA
ELEMENT_TYPES
UDT_NAME
TEXT
Not applicable for Snowflake.
23
3/7/2024, 4:28 PM
101
INFORMATION_SCHEMA
ELEMENT_TYPES
SCOPE_CATALOG
TEXT
Not applicable for Snowflake.
24
3/7/2024, 4:28 PM
102
INFORMATION_SCHEMA
ELEMENT_TYPES
SCOPE_SCHEMA
TEXT
Not applicable for Snowflake.
25
3/7/2024, 4:28 PM
103
INFORMATION_SCHEMA
ELEMENT_TYPES
SCOPE_NAME
TEXT
Not applicable for Snowflake.
26
3/7/2024, 4:28 PM
104
INFORMATION_SCHEMA
ELEMENT_TYPES
MAXIMUM_CARDINALITY
NUMBER
Not applicable for Snowflake.
27
3/7/2024, 4:28 PM
105
INFORMATION_SCHEMA
ELEMENT_TYPES
DTD_IDENTIFIER
TEXT
Not applicable for Snowflake.
28
3/7/2024, 4:28 PM
106
INFORMATION_SCHEMA
FIELDS
OBJECT_CATALOG
TEXT
Database that contains the object that uses this object type
1
3/7/2024, 4:28 PM
107
INFORMATION_SCHEMA
FIELDS
OBJECT_SCHEMA
TEXT
Schema that contains the object that uses this object type
2
3/7/2024, 4:28 PM
108
INFORMATION_SCHEMA
FIELDS
OBJECT_NAME
TEXT
Name of the object that uses this object type
3
3/7/2024, 4:28 PM
109
INFORMATION_SCHEMA
FIELDS
OBJECT_TYPE
TEXT
Type of the object that uses this object type
4
3/7/2024, 4:28 PM
110
INFORMATION_SCHEMA
FIELDS
ROW_IDENTIFIER
TEXT
Type identifier
5
3/7/2024, 4:28 PM
111
INFORMATION_SCHEMA
FIELDS
FIELD_NAME
TEXT
Field name
6
3/7/2024, 4:28 PM
112
INFORMATION_SCHEMA
FIELDS
ORDINAL_POSITION
NUMBER
Ordinal position
7
3/7/2024, 4:28 PM
113
INFORMATION_SCHEMA
FIELDS
DATA_TYPE
TEXT
Data type of the field
8
3/7/2024, 4:28 PM
114
INFORMATION_SCHEMA
FIELDS