ACCOUNT_PLAN
ROLES
DEPARTMENT
TEXT
2
3/7/2024, 4:28 PM
ACCOUNT_PLAN
ROLES
TITLE
TEXT
1
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
BUSINESSID
TEXT
16
3/7/2024, 4:28 PM
SMALL
PAGE_VIEWS
TIMESTAMP
TIMESTAMP_NTZ
3
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DOCS
CREATED
TIMESTAMP_NTZ
4
3/7/2024, 4:28 PM
SMALL
ORGS_1000
NAME
TEXT
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
TABLE_CATALOG
TEXT
Database that the table belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
TABLE_SCHEMA
TEXT
Schema that the table belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
TABLE_NAME
TEXT
Name of the table
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
TABLE_OWNER
TEXT
Name of the role that owns the table
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
TABLE_TYPE
TEXT
Whether the table is a base table, temporary table, or view
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
IS_TRANSIENT
TEXT
Whether this is a transient table
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
CLUSTERING_KEY
TEXT
Clustering key for the table
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
ROW_COUNT
NUMBER
Number of rows in the table
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
BYTES
NUMBER
Number of bytes accessed by a scan of the table
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
RETENTION_TIME
NUMBER
Number of days that historical data is retained for Time Travel
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
SELF_REFERENCING_COLUMN_NAME
TEXT
Not applicable for Snowflake.
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
REFERENCE_GENERATION
TEXT
Not applicable for Snowflake.
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
USER_DEFINED_TYPE_CATALOG
TEXT
Not applicable for Snowflake.
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
USER_DEFINED_TYPE_SCHEMA
TEXT
Not applicable for Snowflake.
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
USER_DEFINED_TYPE_NAME
TEXT
Not applicable for Snowflake.
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
IS_INSERTABLE_INTO
TEXT
Not applicable for Snowflake.
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
IS_TYPED
TEXT
Not applicable for Snowflake.
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
COMMIT_ACTION
TEXT
Not applicable for Snowflake.
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
CREATED
TIMESTAMP_LTZ
Creation time of the function
19
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the function
20
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
LAST_DDL
TIMESTAMP_LTZ
Last DDL time of the table
21
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
LAST_DDL_BY
TEXT
User name that performed the Last DDL of the table
22
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
AUTO_CLUSTERING_ON
TEXT
Whether automatic clustering is on for the table
23
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
COMMENT
TEXT
Comment for this table
24
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
IS_TEMPORARY
TEXT
Whether this is a temporary table
25
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
IS_ICEBERG
TEXT
Whether this is an Iceberg table
26
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLES
IS_DYNAMIC
TEXT
Whether this is a dynamic table
27
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
TABLE_CATALOG
TEXT
Database that the table belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
TABLE_SCHEMA
TEXT
Schema that the table belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
TABLE_NAME
TEXT
Table that the column belongs to
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
COLUMN_NAME
TEXT
Name of the column
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
ORDINAL_POSITION
NUMBER
Ordinal position of the column in the table
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
COLUMN_DEFAULT
TEXT
Default value of the column
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
IS_NULLABLE
TEXT
'YES' if the column may contain NULL, 'NO' otherwise
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
DATA_TYPE
TEXT
Data type of the column
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters of string columns
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes of string columns
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
NUMERIC_PRECISION
NUMBER
Numeric precision of numeric columns
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision of numeric columns
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
NUMERIC_SCALE
NUMBER
Scale of numeric columns
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
DATETIME_PRECISION
NUMBER
Not applicable for Snowflake.
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
INTERVAL_TYPE
TEXT
Not applicable for Snowflake.
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
INTERVAL_PRECISION
NUMBER
Not applicable for Snowflake.
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
CHARACTER_SET_CATALOG
TEXT
Not applicable for Snowflake.
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
CHARACTER_SET_SCHEMA
TEXT
Not applicable for Snowflake.
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
CHARACTER_SET_NAME
TEXT
Not applicable for Snowflake.
19
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
COLLATION_CATALOG
TEXT
Not applicable for Snowflake.
20
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
COLLATION_SCHEMA
TEXT
Not applicable for Snowflake.
21
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
COLLATION_NAME
TEXT
The name of collation, if present
22
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
DOMAIN_CATALOG
TEXT
Not applicable for Snowflake.
23
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
DOMAIN_SCHEMA
TEXT
Not applicable for Snowflake.
24
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
DOMAIN_NAME
TEXT
Not applicable for Snowflake.
25
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
UDT_CATALOG
TEXT
Not applicable for Snowflake.
26
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
UDT_SCHEMA
TEXT
Not applicable for Snowflake.
27
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
UDT_NAME
TEXT
Not applicable for Snowflake.
28
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
SCOPE_CATALOG
TEXT
Not applicable for Snowflake.
29
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
SCOPE_SCHEMA
TEXT
Not applicable for Snowflake.
30
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
SCOPE_NAME
TEXT
Not applicable for Snowflake.
31
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
MAXIMUM_CARDINALITY
NUMBER
Not applicable for Snowflake.
32
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
DTD_IDENTIFIER
TEXT
Not applicable for Snowflake.
33
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
IS_SELF_REFERENCING
TEXT
Not applicable for Snowflake.
34
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
IS_IDENTITY
TEXT
Whether this column is an identity column
35
3/7/2024, 4:28 PM
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
INFORMATION_SCHEMA
COLUMNS
IDENTITY_START
TEXT
Not applicable for Snowflake.
37
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
IDENTITY_INCREMENT
TEXT
Not applicable for Snowflake.
38
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
IDENTITY_MAXIMUM
TEXT
Not applicable for Snowflake.
39
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
COLUMNS
IDENTITY_MINIMUM
TEXT
Not applicable for Snowflake.
40
3/7/2024, 4:28 PM
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
INFORMATION_SCHEMA
COLUMNS
IDENTITY_ORDERED
TEXT
Whether the identity column is backed by an ordered sequence
42
3/7/2024, 4:28 PM
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
INFORMATION_SCHEMA
COLUMNS
COMMENT
TEXT
Comment for this column
44
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
OBJECT_CATALOG
TEXT
Database that contains the object that uses this array type
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
OBJECT_SCHEMA
TEXT
Schema that contains the object that uses this array type
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
OBJECT_NAME
TEXT
Name of the object that uses this array type
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
OBJECT_TYPE
TEXT
Type of the object that uses this array type
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
COLLECTION_TYPE_IDENTIFIER
TEXT
Type identifier
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
DATA_TYPE
TEXT
Element data type
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters for string types
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes for string types
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
NUMERIC_PRECISION
NUMBER
Numeric precision for numeric types
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision for numeric types
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
NUMERIC_SCALE
NUMBER
Scale for numeric types
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
DATETIME_PRECISION
NUMBER
Not applicable for Snowflake.
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
INTERVAL_TYPE
TEXT
Not applicable for Snowflake.
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
INTERVAL_PRECISION
NUMBER
Not applicable for Snowflake.
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_SET_CATALOG
TEXT
Not applicable for Snowflake.
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_SET_SCHEMA
TEXT
Not applicable for Snowflake.
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
CHARACTER_SET_NAME
TEXT
Not applicable for Snowflake.
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
COLLATION_CATALOG
TEXT
Not applicable for Snowflake.
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
COLLATION_SCHEMA
TEXT
Not applicable for Snowflake.
19
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
COLLATION_NAME
TEXT
The name of collation, if present
20
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
UDT_CATALOG
TEXT
Not applicable for Snowflake.
21
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
UDT_SCHEMA
TEXT
Not applicable for Snowflake.
22
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
UDT_NAME
TEXT
Not applicable for Snowflake.
23
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
SCOPE_CATALOG
TEXT
Not applicable for Snowflake.
24
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
SCOPE_SCHEMA
TEXT
Not applicable for Snowflake.
25
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
SCOPE_NAME
TEXT
Not applicable for Snowflake.
26
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
MAXIMUM_CARDINALITY
NUMBER
Not applicable for Snowflake.
27
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ELEMENT_TYPES
DTD_IDENTIFIER
TEXT
Not applicable for Snowflake.
28
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
OBJECT_CATALOG
TEXT
Database that contains the object that uses this object type
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
OBJECT_SCHEMA
TEXT
Schema that contains the object that uses this object type
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
OBJECT_NAME
TEXT
Name of the object that uses this object type
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
OBJECT_TYPE
TEXT
Type of the object that uses this object type
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
ROW_IDENTIFIER
TEXT
Type identifier
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
FIELD_NAME
TEXT
Field name
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
ORDINAL_POSITION
NUMBER
Ordinal position
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
DATA_TYPE
TEXT
Data type of the field
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters of string fields
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes of string fields
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
NUMERIC_PRECISION
NUMBER
Numeric precision of numeric fields
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision of numeric fields
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
NUMERIC_SCALE
NUMBER
Scale of numeric fields
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
DATETIME_PRECISION
NUMBER
Not applicable for Snowflake.
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
INTERVAL_TYPE
TEXT
Not applicable for Snowflake.
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
INTERVAL_PRECISION
NUMBER
Not applicable for Snowflake.
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
CHARACTER_SET_CATALOG
TEXT
Not applicable for Snowflake.
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
CHARACTER_SET_SCHEMA
TEXT
Not applicable for Snowflake.
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
CHARACTER_SET_NAME
TEXT
Not applicable for Snowflake.
19
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
COLLATION_CATALOG
TEXT
Not applicable for Snowflake.
20
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
COLLATION_SCHEMA
TEXT
Not applicable for Snowflake.
21
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
COLLATION_NAME
TEXT
The name of collation, if present
22
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
UDT_CATALOG
TEXT
Not applicable for Snowflake.
23
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
UDT_SCHEMA
TEXT
Not applicable for Snowflake.
24
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
UDT_NAME
TEXT
Not applicable for Snowflake.
25
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
SCOPE_CATALOG
TEXT
Not applicable for Snowflake.
26
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
SCOPE_SCHEMA
TEXT
Not applicable for Snowflake.
27
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
SCOPE_NAME
TEXT
Not applicable for Snowflake.
28
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
MAXIMUM_CARDINALITY
NUMBER
Not applicable for Snowflake.
29
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FIELDS
DTD_IDENTIFIER
TEXT
Not applicable for Snowflake.
30
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
CATALOG_NAME
TEXT
Database that the schema belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
SCHEMA_NAME
TEXT
Name of the schema
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
SCHEMA_OWNER
TEXT
Name of the role that owns the schema
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
IS_TRANSIENT
TEXT
Whether this is a transient table
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
IS_MANAGED_ACCESS
TEXT
Whether this is a managed access schema
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
RETENTION_TIME
NUMBER
Number of days that historical data is retained for Time Travel
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
DEFAULT_CHARACTER_SET_CATALOG
TEXT
Not applicable for Snowflake.
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
DEFAULT_CHARACTER_SET_SCHEMA
TEXT
Not applicable for Snowflake.
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
DEFAULT_CHARACTER_SET_NAME
TEXT
Not applicable for Snowflake.
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
SQL_PATH
TEXT
Not applicable for Snowflake.
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
CREATED
TIMESTAMP_LTZ
Creation time of the schema
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the schema
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SCHEMATA
COMMENT
TEXT
Comment for this schema
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
SEQUENCE_CATALOG
TEXT
Database that the sequence belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
SEQUENCE_SCHEMA
TEXT
Schema that the sequence belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
SEQUENCE_NAME
TEXT
Name of the sequence
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
SEQUENCE_OWNER
TEXT
Name of the role that owns the sequence
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
DATA_TYPE
TEXT
Data type of the sequence
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
NUMERIC_PRECISION
NUMBER
Numeric precision of the data type of the sequence
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
NUMERIC_PRECISION_RADIX
NUMBER
Radix of the numeric precision of the data type of the sequence
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
NUMERIC_SCALE
NUMBER
Scale of the data type of the sequence
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
START_VALUE
TEXT
Initial value of the sequence
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
MINIMUM_VALUE
TEXT
Not applicable for Snowflake.
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
MAXIMUM_VALUE
TEXT
Not applicable for Snowflake.
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
NEXT_VALUE
TEXT
Next value that the sequence will produce
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
INCREMENT
TEXT
Increment of the sequence generator
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
CYCLE_OPTION
TEXT
Not applicable for Snowflake.
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
CREATED
TIMESTAMP_LTZ
Creation time of the sequence
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the sequence
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
ORDERED
TEXT
Whether or not the sequence is ordered
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SEQUENCES
COMMENT
TEXT
Comment for this sequence
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
TABLE_CATALOG
TEXT
Database that the view belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
TABLE_SCHEMA
TEXT
Schema that the view belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
TABLE_NAME
TEXT
Name of the view
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
TABLE_OWNER
TEXT
Name of the role that owns the view
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
VIEW_DEFINITION
TEXT
Text of the view's query expression
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
CHECK_OPTION
TEXT
Not applicable for Snowflake.
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
IS_UPDATABLE
TEXT
Not applicable for Snowflake.
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
INSERTABLE_INTO
TEXT
Not applicable for Snowflake.
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
IS_SECURE
TEXT
Whether this view is secure.
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
CREATED
TIMESTAMP_LTZ
Creation time of the view
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the view
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
LAST_DDL
TIMESTAMP_LTZ
Last DDL time of the view
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
LAST_DDL_BY
TEXT
User name that performed the last DDL of the view
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
VIEWS
COMMENT
TEXT
Comment for this view
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
GRANTOR
TEXT
Role who granted the table privilege
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
GRANTEE
TEXT
Role to whom the table privilege is granted
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
TABLE_CATALOG
TEXT
Database containing the table on which the privilege is granted
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
TABLE_SCHEMA
TEXT
Schema containing the table on which the privilege is granted
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
TABLE_NAME
TEXT
Name of the table on which the privilege is granted
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
PRIVILEGE_TYPE
TEXT
Type of the granted privilege
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
IS_GRANTABLE
TEXT
Whether the privilege was granted WITH GRANT OPTION
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
WITH_HIERARCHY
TEXT
Not applicable for Snowflake.
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_PRIVILEGES
CREATED
TIMESTAMP_LTZ
Creation time of the privilege
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
GRANTOR
TEXT
Role who granted the usage privilege
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
GRANTEE
TEXT
Role to whom the usage privilege is granted
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
OBJECT_CATALOG
TEXT
Database containing the object on which the privilege is granted
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
OBJECT_SCHEMA
TEXT
Schema containing the object on which the privilege is granted
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
OBJECT_NAME
TEXT
Name of the object on which the privilege is granted
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
OBJECT_TYPE
TEXT
Type of the object on which the privilege is granted
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
PRIVILEGE_TYPE
TEXT
Type of the granted privilege
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
IS_GRANTABLE
TEXT
Whether the privilege was granted WITH GRANT OPTION
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
USAGE_PRIVILEGES
CREATED
TIMESTAMP_LTZ
Creation time of the privilege
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
DATABASES
DATABASE_NAME
TEXT
Name of the database
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
DATABASES
DATABASE_OWNER
TEXT
Name of the role that owns the schema
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
DATABASES
IS_TRANSIENT
TEXT
Whether this is a transient table
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
DATABASES
COMMENT
TEXT
Comment for this database
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
DATABASES
CREATED
TIMESTAMP_LTZ
Creation time of the database
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
DATABASES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the database
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
DATABASES
RETENTION_TIME
NUMBER
Number of days that historical data is retained for Time Travel
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
DATABASES
TYPE
TEXT
The type of database
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
REGION_GROUP
TEXT
Region group of this database
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
SNOWFLAKE_REGION
TEXT
Snowflake region of this database
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
ACCOUNT_NAME
TEXT
Name of the account that owns the database
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
DATABASE_NAME
TEXT
Name of the database
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
COMMENT
TEXT
Comment for this database
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
CREATED
TIMESTAMP_LTZ
Creation time of the database
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
IS_PRIMARY
BOOLEAN
Whether this database is the primary
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
PRIMARY
TEXT
Primary database of this replication group
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
REPLICATION_ALLOWED_TO_ACCOUNTS
TEXT
List of accounts that can host secondary replicas for this database
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_DATABASES
FAILOVER_ALLOWED_TO_ACCOUNTS
TEXT
List of accounts that can host primary replicas for this database
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
REGION_GROUP
TEXT
Region group of this database
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
SNOWFLAKE_REGION
TEXT
Snowflake region of this replication group
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
CREATED_ON
TIMESTAMP_LTZ
Creation time of the replication group
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
ACCOUNT_NAME
TEXT
Name of the account that owns the replication group
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
NAME
TEXT
Name of the replication group
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
TYPE
TEXT
Type of this replication group
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
COMMENT
TEXT
Comment for this replication group
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
IS_PRIMARY
BOOLEAN
Whether this replication group is the primary
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
PRIMARY
TEXT
Primary replication group name
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
OBJECT_TYPES
TEXT
Object types in the replication group
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
ALLOWED_INTEGRATION_TYPES
TEXT
Allowed integration types in the replication group
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
ALLOWED_ACCOUNTS
TEXT
List of accounts that can host secondary replicas for this replication group
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
ORGANIZATION_NAME
TEXT
Name of the organization that owns the replication group
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
ACCOUNT_LOCATOR
TEXT
Account locator for this replication group
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
REPLICATION_SCHEDULE
TEXT
Replication schedule for this replication group
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
SECONDARY_STATE
TEXT
Secondary state for this replication group
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
NEXT_SCHEDULED_REFRESH
TIMESTAMP_LTZ
Next schduled refresh time for this replication group
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
OWNER
TEXT
Owner of the replication group
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REPLICATION_GROUPS
IS_LISTING_AUTO_FULFILLMENT_GROUP
BOOLEAN
Whether this is auto-fulfillment listing group
19
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
FUNCTION_CATALOG
TEXT
Database which the function belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
FUNCTION_SCHEMA
TEXT
Schema which the function belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
FUNCTION_NAME
TEXT
Name of the function
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
FUNCTION_OWNER
TEXT
Name of the role that owns the function
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
ARGUMENT_SIGNATURE
TEXT
Type signature of the function's arguments
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
DATA_TYPE
TEXT
Return value data type
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters of string return value
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes of string return value
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
NUMERIC_PRECISION
NUMBER
Numeric precision of numeric return value
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision of numeric return value
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
NUMERIC_SCALE
NUMBER
Scale of numeric return value
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
FUNCTION_LANGUAGE
TEXT
Language of the function
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
FUNCTION_DEFINITION
TEXT
Function definition
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
VOLATILITY
TEXT
Whether the function is volatile or immutable
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
IS_NULL_CALL
TEXT
Whether the function is called on null input
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
IS_SECURE
TEXT
Whether this function is secure.
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
CREATED
TIMESTAMP_LTZ
Creation time of the function
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the function
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
COMMENT
TEXT
Comment for this function
19
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
IS_EXTERNAL
TEXT
Whether this function is external
20
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
API_INTEGRATION
TEXT
Integration for this function
21
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
CONTEXT_HEADERS
TEXT
Context headers for this function
22
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
MAX_BATCH_ROWS
NUMBER
Max batch rows for this function
23
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
REQUEST_TRANSLATOR
TEXT
Request Translator function name
24
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
RESPONSE_TRANSLATOR
TEXT
Response Translator function name
25
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
COMPRESSION
TEXT
Type of compression used for serializing function payload
26
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
IMPORTS
TEXT
List of imports for the function
27
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
HANDLER
TEXT
Handler for the function
28
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
TARGET_PATH
TEXT
Stage path for storage of compiled inline Java UDF code
29
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
RUNTIME_VERSION
TEXT
Runtime version of the function. NULL if function is SQL or Javascript
30
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
PACKAGES
TEXT
Packages requested by the function.
31
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
INSTALLED_PACKAGES
TEXT
All packages installed by the function.
32
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FUNCTIONS
IS_MEMOIZABLE
TEXT
Whether this function is memoizable.
33
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
PROCEDURE_CATALOG
TEXT
Database which the procedure belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
PROCEDURE_SCHEMA
TEXT
Schema which the procedure belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
PROCEDURE_NAME
TEXT
Name of the procedure
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
PROCEDURE_OWNER
TEXT
Name of the role that owns the procedure
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
ARGUMENT_SIGNATURE
TEXT
Type signature of the procedure's arguments
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
DATA_TYPE
TEXT
Return value data type
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters of string return value
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes of string return value
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
NUMERIC_PRECISION
NUMBER
Numeric precision of numeric return value
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision of numeric return value
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
NUMERIC_SCALE
NUMBER
Scale of numeric return value
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
PROCEDURE_LANGUAGE
TEXT
Language of the procedure
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
PROCEDURE_DEFINITION
TEXT
Procedure definition
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
CREATED
TIMESTAMP_LTZ
Creation time of the procedure
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the procedure
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PROCEDURES
COMMENT
TEXT
Comment for this procedure
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
GRANTOR
TEXT
Role who granted the privilege
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
GRANTEE
TEXT
Role to whom the privilege is granted
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
OBJECT_CATALOG
TEXT
Database containing the object on which the privilege is granted
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
OBJECT_SCHEMA
TEXT
Schema containing the object on which the privilege is granted
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
OBJECT_NAME
TEXT
Name of the object on which the privilege is granted
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
OBJECT_TYPE
TEXT
Type of the object on which the privilege is granted
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
PRIVILEGE_TYPE
TEXT
Type of the granted privilege
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
IS_GRANTABLE
TEXT
Whether the privilege was granted WITH GRANT OPTION
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
OBJECT_PRIVILEGES
CREATED
TIMESTAMP_LTZ
Creation time of the privilege
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
FILE_FORMAT_CATALOG
TEXT
Database that the file format belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
FILE_FORMAT_SCHEMA
TEXT
Schema that the file format belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
FILE_FORMAT_NAME
TEXT
Name of the file format
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
FILE_FORMAT_OWNER
TEXT
Name of the role that owns the file format
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
FILE_FORMAT_TYPE
TEXT
Type of the file format
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
RECORD_DELIMITER
TEXT
Character that separates records
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
FIELD_DELIMITER
TEXT
Character that separates fields
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
SKIP_HEADER
NUMBER
Number of lines skipped at the start of the file
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
DATE_FORMAT
TEXT
Date format
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
TIME_FORMAT
TEXT
Time format
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
TIMESTAMP_FORMAT
TEXT
Timestamp format
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
BINARY_FORMAT
TEXT
Binary format
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
ESCAPE
TEXT
String used as the escape character for any field values
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
ESCAPE_UNENCLOSED_FIELD
TEXT
String used as the escape character for unenclosed field values
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
TRIM_SPACE
TEXT
Whether whitespace is removed from fields
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
FIELD_OPTIONALLY_ENCLOSED_BY
TEXT
Character used to enclose strings
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
NULL_IF
TEXT
A list of strings to be replaced by null
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
COMPRESSION
TEXT
Compression method for the data file
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
ERROR_ON_COLUMN_COUNT_MISMATCH
TEXT
Whether to generate a parsing error if the number of fields in an input file does not match the number of columns in the corresponding table
19
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
CREATED
TIMESTAMP_LTZ
Creation time of the file format
20
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the file format
21
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
FILE_FORMATS
COMMENT
TEXT
Comment for this file format
22
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
APPLICABLE_ROLES
GRANTEE
TEXT
Role or user to whom the privilege is granted
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
APPLICABLE_ROLES
ROLE_NAME
TEXT
Name of the role
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
APPLICABLE_ROLES
ROLE_OWNER
TEXT
Owner of the role
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
APPLICABLE_ROLES
IS_GRANTABLE
TEXT
Whether this role can be granted to others
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ENABLED_ROLES
ROLE_NAME
TEXT
Name of the role
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
ENABLED_ROLES
ROLE_OWNER
TEXT
Owner of the role
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
STAGE_CATALOG
TEXT
Database that the stage belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
STAGE_SCHEMA
TEXT
Schema that the stage belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
STAGE_NAME
TEXT
Name of the stage
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
STAGE_URL
TEXT
Location of an external stage
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
STAGE_REGION
TEXT
AWS region where the stage resides
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
STAGE_TYPE
TEXT
Type of stage: User, Table, Internal Named or External Named
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
STAGE_OWNER
TEXT
Name of the role that owns the stage
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
COMMENT
TEXT
Comment for this stage
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
CREATED
TIMESTAMP_LTZ
Creation time of the stage
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the stage
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
ENDPOINT
TEXT
S3-compatible API endpoint
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STAGES
DIRECTORY_ENABLED
BOOLEAN
Whether or not the stage has directory tables enabled
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
CONSTRAINT_CATALOG
TEXT
Database that the constraint belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
CONSTRAINT_SCHEMA
TEXT
Schema that the constraint belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
CONSTRAINT_NAME
TEXT
Name of the constraint
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
UNIQUE_CONSTRAINT_CATALOG
TEXT
Database of the unique constraint referenced by the current constraint
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
UNIQUE_CONSTRAINT_SCHEMA
TEXT
Schema of the unique constraint referenced by the current constraint
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
UNIQUE_CONSTRAINT_NAME
TEXT
Name of the unique constraint referenced by the current constraint
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
MATCH_OPTION
TEXT
Match option for the constraint
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
UPDATE_RULE
TEXT
Update Rule for the current constraint
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
DELETE_RULE
TEXT
Delete Rule for the current constraint
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
COMMENT
TEXT
Comment for this constraint
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
CREATED
TIMESTAMP_LTZ
Creation time of the constraint
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
REFERENTIAL_CONSTRAINTS
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the constraint
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
CONSTRAINT_CATALOG
TEXT
Database that the constraint belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
CONSTRAINT_SCHEMA
TEXT
Schema that the constraint belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
CONSTRAINT_NAME
TEXT
Name of the constraint
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
TABLE_CATALOG
TEXT
Name of the database of the current table
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
TABLE_SCHEMA
TEXT
Name of the schema of the current table
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
TABLE_NAME
TEXT
Name of the current table
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
CONSTRAINT_TYPE
TEXT
Type of the constraint
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
IS_DEFERRABLE
TEXT
Whether evaluation of the constraint can be deferred
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
INITIALLY_DEFERRED
TEXT
Whether evaluation of the constraint is deferrable and initially deferred
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
ENFORCED
TEXT
Whether the constraint is enforced
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
COMMENT
TEXT
Comment for this constraint
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
CREATED
TIMESTAMP_LTZ
Creation time of the constraint
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the constraint
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_CONSTRAINTS
RELY
TEXT
Whether to use RELY
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
NAME
TEXT
Name of the BUNDLE INSTANCE
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
SCHEMA_NAME
TEXT
Schema which the INSTANCE belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
DATABASE_NAME
TEXT
Database which the INSTANCE belongs to
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
CLASS_NAME
TEXT
CLASS which the INSTANCE is instantiated from
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
CLASS_SCHEMA_NAME
TEXT
Schema of the CLASS which the INSTANCE is instantiated from
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
CLASS_DATABASE_NAME
TEXT
Database of the CLASS which the INSTANCE is instantiated from
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
VERSION
TEXT
Current version of the INSTANCE
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
OWNER
TEXT
Name of the role that owns the INSTANCE
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
OWNER_ROLE_TYPE
TEXT
Type of role that owns the INSTANCE.
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
CREATED
TIMESTAMP_LTZ
Date and time when the INSTANCE was created
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCES
COMMENT
TEXT
Comment for the INSTANCE
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
NAME
TEXT
Name of the BUNDLE CLASS
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
SCHEMA_NAME
TEXT
Schema which the CLASS belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
DATABASE_NAME
TEXT
Database which the CLASS belongs to
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
VERSION
TEXT
Current version of the CLASS
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
OWNER
TEXT
Name of the role that owns the CLASS
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
OWNER_ROLE_TYPE
TEXT
Type of role that owns the CLASS.
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
IS_SERVICE_CLASS
TEXT
Whether this is a SERVICE class
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
CREATED
TIMESTAMP_LTZ
Date and time when the CLASS was created
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASSES
COMMENT
TEXT
Comment for the CLASS
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
FUNCTION_NAME
TEXT
Name of the function
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
FUNCTION_INSTANCE_NAME
TEXT
Name of the instance which the function belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
FUNCTION_INSTANCE_SCHEMA
TEXT
Name of the schema which the instance belongs to
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
FUNCTION_INSTANCE_DATABASE
TEXT
Name of the database which the instance belongs to
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
FUNCTION_OWNER
TEXT
Name of the role that owns the function
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
ARGUMENT_SIGNATURE
TEXT
Type signature of the function's arguments
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
DATA_TYPE
TEXT
Return value data type
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters of string return value
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes of string return value
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
NUMERIC_PRECISION
NUMBER
Numeric precision of numeric return value
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision of numeric return value
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
NUMERIC_SCALE
NUMBER
Scale of numeric return value
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
FUNCTION_LANGUAGE
TEXT
Language of the function
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
FUNCTION_DEFINITION
TEXT
Function definition
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
VOLATILITY
TEXT
Whether the function is volatile or immutable
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
IS_NULL_CALL
TEXT
Whether the function is called on null input
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
IS_SECURE
TEXT
Whether this function is secure.
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
CREATED
TIMESTAMP_LTZ
Creation time of the function
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the function
19
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
COMMENT
TEXT
Comment for this function
20
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
IS_EXTERNAL
TEXT
Whether this function is external
21
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
API_INTEGRATION
TEXT
Integration for this function
22
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
CONTEXT_HEADERS
TEXT
Context headers for this function
23
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
MAX_BATCH_ROWS
NUMBER
Max batch rows for this function
24
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
COMPRESSION
TEXT
Type of compression used for serializing function payload
25
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
PACKAGES
TEXT
Packages requested by the function.
26
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
RUNTIME_VERSION
TEXT
Runtime version of the function. NULL if function is SQL or Javascript
27
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
INSTALLED_PACKAGES
TEXT
All packages installed by the function.
28
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_FUNCTIONS
IS_MEMOIZABLE
TEXT
Whether this function is memoizable.
29
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
PROCEDURE_NAME
TEXT
Name of the procedure
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
PROCEDURE_INSTANCE_NAME
TEXT
Name of the instance which the procedure belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
PROCEDURE_INSTANCE_SCHEMA
TEXT
Name of the schema which the procedure belongs to
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
PROCEDURE_INSTANCE_DATABASE
TEXT
Name of the database which the procedure belongs to
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
PROCEDURE_OWNER
TEXT
Name of the role that owns the procedure
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
ARGUMENT_SIGNATURE
TEXT
Type signature of the procedure's arguments
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
DATA_TYPE
TEXT
Return value data type
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
CHARACTER_MAXIMUM_LENGTH
NUMBER
Maximum length in characters of string return value
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
CHARACTER_OCTET_LENGTH
NUMBER
Maximum length in bytes of string return value
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
NUMERIC_PRECISION
NUMBER
Numeric precision of numeric return value
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
NUMERIC_PRECISION_RADIX
NUMBER
Radix of precision of numeric return value
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
NUMERIC_SCALE
NUMBER
Scale of numeric return value
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
PROCEDURE_LANGUAGE
TEXT
Language of the procedure
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
PROCEDURE_DEFINITION
TEXT
Procedure definition
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
CREATED
TIMESTAMP_LTZ
Creation time of the procedure
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the procedure
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CLASS_INSTANCE_PROCEDURES
COMMENT
TEXT
Comment for this procedure
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INFORMATION_SCHEMA_CATALOG_NAME
CATALOG_NAME
TEXT
The name of the database in which this information_schema resides.
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
SCHEMA_NAME
TEXT
Schema of target table
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
FILE_NAME
TEXT
Name of source file
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
TABLE_NAME
TEXT
Name of target table
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
LAST_LOAD_TIME
TIMESTAMP_LTZ
Timestamp of the load record
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
STATUS
TEXT
Status: loaded, load failed or partially loaded
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
ROW_COUNT
NUMBER
Number of rows loaded from the source file
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
ROW_PARSED
NUMBER
Number of rows parsed from the source file
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
FIRST_ERROR_MESSAGE
TEXT
First error of the source file
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
FIRST_ERROR_LINE_NUMBER
NUMBER
Line number of the first error
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
FIRST_ERROR_CHARACTER_POSITION
NUMBER
Position of the first error character
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
FIRST_ERROR_COL_NAME
TEXT
Column name of the first error
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
ERROR_COUNT
NUMBER
Number of error rows in the source file
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
LOAD_HISTORY
ERROR_LIMIT
NUMBER
If the number of error reach this limit, then abort
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
TABLE_CATALOG
TEXT
Database that the table belongs to. Potentially NULL if table is in failsafe.
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
TABLE_SCHEMA
TEXT
Schema that the table belongs to. Potentially NULL if table is in failsafe.
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
TABLE_NAME
TEXT
Name of the table. Potentially NULL if table is in failsafe.
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
ID
NUMBER
Unique identifier of the table
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
CLONE_GROUP_ID
NUMBER
Unique identifier of the oldest clone ancestor of this table. Same as this table's ID if it is not a clone.
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
IS_TRANSIENT
TEXT
'YES' if table is transient, 'NO' otherwise. Potentially NULL if table is in failsafe.
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
ACTIVE_BYTES
NUMBER
Bytes in the active version of the table. Some bytes may be billed to another table if this table is a clone.
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
TIME_TRAVEL_BYTES
NUMBER
Bytes in time travel versions of the table. Some bytes may be billed to another table if this table is a clone
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
FAILSAFE_BYTES
NUMBER
Bytes in failsafe versions of the table. All such bytes are billed to this table.
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
RETAINED_FOR_CLONE_BYTES
NUMBER
Bytes which used to be owned by this table and are no longer referenced by it. Still, they are retained (and billed) because other clone(s) of that table are still referencing these bytes. Note that the original metadata for this table might have been purged so the table, schema, and database names might be NULL in this case.
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
TABLE_CREATED
TIMESTAMP_LTZ
Time at which this table was created. Potentially NULL if table is in failsafe.
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
TABLE_DROPPED
TIMESTAMP_LTZ
Time at which the table was dropped, or NULL. Potentially NULL if table is in failsafe.
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
TABLE_ENTERED_FAILSAFE
TIMESTAMP_LTZ
Time at which the table entered the failsafe state, or NULL. Potentially NULL if table is in failsafe.
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
CATALOG_CREATED
TIMESTAMP_LTZ
Time at which the database was created. Potentially NULL if table is in failsafe.
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
CATALOG_DROPPED
TIMESTAMP_LTZ
Time at which the database was dropped. Potentially NULL if table is past failsafe.
15
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
SCHEMA_CREATED
TIMESTAMP_LTZ
Time at which the schema was created. Potentially NULL if table is past failsafe.
16
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
SCHEMA_DROPPED
TIMESTAMP_LTZ
Time at which the schema was dropped. Potentially NULL if table is in failsafe.
17
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
TABLE_STORAGE_METRICS
COMMENT
TEXT
Table's comment. Potentially NULL if table is in failsafe.
18
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
PIPE_CATALOG
TEXT
Database that the pipe belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
PIPE_SCHEMA
TEXT
Schema that the pipe belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
PIPE_NAME
TEXT
Name of the pipe
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
PIPE_OWNER
TEXT
Name of the role that owns the pipe
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
DEFINITION
TEXT
Definition of the pipe as it was created
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
IS_AUTOINGEST_ENABLED
TEXT
Whether this is an auto-ingest tpipe
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
NOTIFICATION_CHANNEL_NAME
TEXT
Notification channel name if it is an auto-ingest pipe
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
CREATED
TIMESTAMP_LTZ
Creation time of the pipe
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the pipe
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
COMMENT
TEXT
Comment for this pipe
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PIPES
PATTERN
TEXT
Pattern used to filter the files in Snowpipe
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
TABLE_CATALOG
TEXT
Database that the external table belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
TABLE_SCHEMA
TEXT
Schema that the external table belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
TABLE_NAME
TEXT
Name of the external table
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
TABLE_OWNER
TEXT
Name of the role that owns the external table
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
CREATED
TIMESTAMP_LTZ
Creation time of the external table
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the external table
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
LAST_DDL
TIMESTAMP_LTZ
Last DDL time of the view
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
LAST_DDL_BY
TEXT
User name that performed the last DDL of the view
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
COMMENT
TEXT
Comment for this external table
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
LOCATION
TEXT
Location of the external table
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
FILE_FORMAT_NAME
TEXT
File format name (if there is one) of the external table
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EXTERNAL_TABLES
FILE_FORMAT_TYPE
TEXT
File format type (if not named) of the external table
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EVENT_TABLES
TABLE_CATALOG
TEXT
Database that the event table belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EVENT_TABLES
TABLE_SCHEMA
TEXT
Schema that the event table belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EVENT_TABLES
TABLE_NAME
TEXT
Name of the event table
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EVENT_TABLES
TABLE_OWNER
TEXT
Name of the role that owns the event table
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EVENT_TABLES
CREATED
TIMESTAMP_LTZ
Creation time of the event table
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EVENT_TABLES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the event table
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
EVENT_TABLES
COMMENT
TEXT
Comment for this event table
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PACKAGES
PACKAGE_NAME
TEXT
Package name
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PACKAGES
VERSION
TEXT
Package version
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PACKAGES
LANGUAGE
TEXT
Package language
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
PACKAGES
RUNTIME_VERSION
TEXT
Supported runtime version
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CURRENT_PACKAGES_POLICY
NAME
TEXT
Packages policy name
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CURRENT_PACKAGES_POLICY
LANGUAGE
TEXT
Package language
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CURRENT_PACKAGES_POLICY
ALLOWLIST
TEXT
Allowlist
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CURRENT_PACKAGES_POLICY
BLOCKLIST
TEXT
BLocklist
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CURRENT_PACKAGES_POLICY
ADDITIONAL_CREATION_BLOCKLIST
TEXT
Additional creation blocklist
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
CURRENT_PACKAGES_POLICY
COMMENT
TEXT
comment
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_CATALOG
TEXT
Database that the streamlit belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_SCHEMA
TEXT
Schema that the streamlit belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_NAME
TEXT
Name of the streamlit
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_OWNER
TEXT
Name of the role that owns the streamlit
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_ROOT_LOCATION
TEXT
Root location of the streamlit
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_MAIN_FILE
TEXT
Main file of the streamlit
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_QUERY_WAREHOUSE
TEXT
Query warehouse of the streamlit
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_URL_ID
TEXT
URL id of the streamlit
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
CREATED
TIMESTAMP_LTZ
Creation time of the streamlit
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the streamlit
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
COMMENT
TEXT
Comment for this streamlit
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
STREAMLITS
STREAMLIT_TITLE
TEXT
Title for the streamlit app
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
CATALOG
TEXT
Database that the table belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
SCHEMA
TEXT
Schema that the table belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
NAME
TEXT
Name of the table
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
OWNER
TEXT
Name of the role that owns the table
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
ROW_COUNT
NUMBER
Number of rows in the table
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
BYTES
NUMBER
Number of bytes accessed by a scan of the table
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
RETENTION_TIME
NUMBER
Number of days that historical data is retained for Time Travel
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
CREATED
TIMESTAMP_LTZ
Creation time of the table
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the table
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
HYBRID_TABLES
COMMENT
TEXT
Comment for this table
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
TABLE_CATALOG
TEXT
Database that the table belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
TABLE_SCHEMA
TEXT
Schema that the table belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
TABLE_NAME
TEXT
Name of the table
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
NAME
TEXT
Name of the index
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
OWNER
TEXT
Name of the role that owns the index
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
IS_UNIQUE
TEXT
Whether this index is unique
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
CONSTRAINT_NAME
TEXT
Name of the constraint associated with this index, if any
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
STATUS
TEXT
The status of the index
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEXES
CREATED
TIMESTAMP_LTZ
Creation time of the index
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
TABLE_CATALOG
TEXT
Database that the table belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
TABLE_SCHEMA
TEXT
Schema that the table belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
TABLE_NAME
TEXT
Name of the table
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
INDEX_NAME
TEXT
Name of the index
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
NAME
TEXT
Name of the column
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
KEY_SEQUENCE
NUMBER
Position of the column in the index
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
INDEX_OWNER
TEXT
Name of the role that owns the index
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
IS_UNIQUE
TEXT
Whether this index is unique
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
CONSTRAINT_NAME
TEXT
Name of the constraint associated with this index, if any
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
STATUS
TEXT
The status of the index
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
INDEX_COLUMNS
CREATED
TIMESTAMP_LTZ
Creation time of the index
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
SERVICE_CATALOG
TEXT
Database that the service belongs to
1
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
SERVICE_SCHEMA
TEXT
Schema that the service belongs to
2
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
SERVICE_NAME
TEXT
Name of the service
3
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
SERVICE_OWNER
TEXT
Name of the role that owns the service
4
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
SERVICE_OWNER_ROLE_TYPE
TEXT
Type of role that owns the service
5
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
COMPUTE_POOL_NAME
TEXT
Name of the compute pool where the service runs
6
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
DNS_NAME
TEXT
DNS name associated with the service
7
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
MIN_INSTANCES
NUMBER
Mininum number of active instances for the service
8
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
MAX_INSTANCES
NUMBER
Maximum number of active instances for the service
9
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
AUTO_RESUME
BOOLEAN
Whether the service can be automatically resumed
10
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
COMMENT
TEXT
Comment for this service
11
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
QUERY_WAREHOUSE
TEXT
Query warehouse of the service
12
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
CREATED
TIMESTAMP_LTZ
Creation time of the service
13
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
LAST_ALTERED
TIMESTAMP_LTZ
Last altered time of the service
14
3/7/2024, 4:28 PM
INFORMATION_SCHEMA
SERVICES
LAST_RESUMED
TIMESTAMP_LTZ
Time when the service was last resumed
15
3/7/2024, 4:28 PM
ACCOUNT_PLAN
EVENTS
EVENT_TYPE
TEXT
2
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
CONTRACTCONFIDENCE
TEXT
19
3/7/2024, 4:28 PM
ACCOUNT_PLAN
CUSTOMERS
COUNTRY
TEXT
ISO 3166-2 country code (US, GB, etc)
4
3/7/2024, 4:28 PM
SMALL
SESSIONS
DURATION
NUMBER
8
3/7/2024, 4:28 PM
ACCOUNT_PLAN
CUSTOMERS
INDUSTRY
TEXT
Self-selected at signup
5
3/7/2024, 4:28 PM
May not match what we have in Salesforce. SNOWPULSE
APPLICATIONS
ACTIVEVULNERABILITIES
NUMBER
12
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
CATEGORY
TEXT
3
3/7/2024, 4:28 PM
ACCOUNT_PLAN
USERS
LAST_NAME
TEXT
3
3/7/2024, 4:28 PM
ACCOUNT_PLAN
EXPERIMENTS
ENABLED
BOOLEAN
3
3/7/2024, 4:28 PM
ACCOUNT_PLAN
CUSTOMERS
PLAN_ID
NUMBER
6
3/7/2024, 4:28 PM
SMALL
SESSIONS
CREATED
TIMESTAMP_NTZ
4
3/7/2024, 4:28 PM
ACCOUNT_PLAN
EVENTS
USER_ID
NUMBER
4
3/7/2024, 4:28 PM
ACCOUNT_PLAN
USERS
TITLE
TEXT
6
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
RATIONALE
TEXT
35
3/7/2024, 4:28 PM
SMALL
PAGE_VIEWS
ACTION
TEXT
6
3/7/2024, 4:28 PM
SMALL
USERS
CREATED
TIMESTAMP_NTZ
5
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
DESCRIPTION
TEXT
10
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
OPSSCORE
NUMBER
8
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
USEDBYDEPARTMENT
TEXT
2
3/7/2024, 4:28 PM
ACCOUNT_PLAN
EVENTS
DOC_ID
NUMBER
5
3/7/2024, 4:28 PM
SMALL
ORGS_1000
FOUNDED
NUMBER
7
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
ACTIVEUSERS
TEXT
11
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
DATACLASSIFICATION
TEXT
24
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DOCS
DOC_ID
NUMBER
1
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DEVICES
BROWSER_NAME
TEXT
4
3/7/2024, 4:28 PM
SMALL
PAGE_VIEWS
ID
NUMBER
1
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
SUPPORTSERVICEQUALITY
TEXT
46
3/7/2024, 4:28 PM
ACCOUNT_PLAN
PLANS
PLAN_ID
NUMBER
1
3/7/2024, 4:28 PM
ACCOUNT_PLAN
USERS
FIRST_NAME
TEXT
2
3/7/2024, 4:28 PM
SMALL
ORGS_1000
COUNTRY
TEXT
5
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
BUSINESSOWNER
TEXT
5
3/7/2024, 4:28 PM
SMALL
PAGE_VIEWS
PAGE
TEXT
4
3/7/2024, 4:28 PM
ACCOUNT_PLAN
CUSTOMERS
PAID_SEATS
NUMBER
7
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
COSTSAVINGSOVERTIME
TEXT
21
3/7/2024, 4:28 PM
ACCOUNT_PLAN
USERS
EMAIL
TEXT
4
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
REPLACEMENTEFFORTANDCOST
TEXT
40
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DEVICES
USER_ID
NUMBER
1
3/7/2024, 4:28 PM
SMALL
PAGE_VIEWS
SESSION_ID
NUMBER
2
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
GOODALTERNATIVES
TEXT
26
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
RECSCORE
TEXT
38
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
REPLACEMENTEFFORT
TEXT
39
3/7/2024, 4:28 PM
SMALL
USERS
FIRST_NAME
TEXT
2
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
KEEPORNOT
TEXT
9
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DEVICES
DEVICE_TYPE
TEXT
2
3/7/2024, 4:28 PM
SMALL
SESSIONS
USER_ID
NUMBER
2
3/7/2024, 4:28 PM
ACCOUNT_PLAN
CUSTOMERS
NAME
TEXT
2
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
APPOWNEREMAIL
TEXT
13
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
SNOWONSNOWSHOWCASE
BOOLEAN
43
3/7/2024, 4:28 PM
SMALL
ORGS_1000
DESCRIPTION
TEXT
6
3/7/2024, 4:28 PM
ACCOUNT_PLAN
PLANS
NAME
TEXT
2
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
SERVICESUPPORTQUALITY
TEXT
41
3/7/2024, 4:28 PM
ACCOUNT_PLAN
USERS
CREATED
TIMESTAMP_NTZ
5
3/7/2024, 4:28 PM
ACCOUNT_PLAN
CUSTOMERS
CUSTOMER_ID
NUMBER
1
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
BUSINESSOWNEREMAIL
TEXT
17
3/7/2024, 4:28 PM
SMALL
ORGS_1000
INDUSTRY
TEXT
8
3/7/2024, 4:28 PM
SMALL
SESSIONS
BROWSER
TEXT
5
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DOCS
TYPE
TEXT
2
3/7/2024, 4:28 PM
SMALL
PAGE_VIEWS
CONVERTED
BOOLEAN
5
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
APPOWNER
TEXT
4
3/7/2024, 4:28 PM
ACCOUNT_PLAN
CUSTOMERS
DOMAIN
TEXT
3
3/7/2024, 4:28 PM
SMALL
USERS
LANGUAGE
TEXT
6
3/7/2024, 4:28 PM
SMALL
USERS
EMAIL
TEXT
4
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
TOTALVULNERABILITIES
NUMBER
47
3/7/2024, 4:28 PM
ACCOUNT_PLAN
USERS
USER_ID
NUMBER
1
3/7/2024, 4:28 PM
SMALL
SESSIONS
IP_ADDRESS
TEXT
3
3/7/2024, 4:28 PM
SMALL
ORGS_1000
EMPLOYEE_COUNT
NUMBER
9
3/7/2024, 4:28 PM
SMALL
USERS
ID
NUMBER
1
3/7/2024, 4:28 PM
ACCOUNT_PLAN
EVENTS
EVENT_ID
TEXT
1
3/7/2024, 4:28 PM
SMALL
SESSIONS
ID
NUMBER
1
3/7/2024, 4:28 PM
SMALL
ORGS_1000
WEBSITE
TEXT
4
3/7/2024, 4:28 PM
ACCOUNT_PLAN
EVENTS
TIMESTAMP
TIMESTAMP_NTZ
3
3/7/2024, 4:28 PM
SMALL
ORGS_1000
ORGANIZATION_ID
TEXT
2
3/7/2024, 4:28 PM
SMALL
SESSIONS
OS
TEXT
7
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
PARTNERSHIP
BOOLEAN
34
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
CUSTOMERREVENUEPOTENTIAL
TEXT
23
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DOCS
CREATED_BY
NUMBER
5
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DOCS
NAME
TEXT
3
3/7/2024, 4:28 PM
ACCOUNT_PLAN
EXPERIMENTS
NAME
TEXT
1
3/7/2024, 4:28 PM
SMALL
USERS
LAST_NAME
TEXT
3
3/7/2024, 4:28 PM
SMALL
SESSIONS
DEVICE_TYPE
TEXT
6
3/7/2024, 4:28 PM
SMALL
ORGS_1000
INDEX
NUMBER
1
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
CUSTOMERORPROSPECT
BOOLEAN
22
3/7/2024, 4:28 PM
SMALL
SESSIONS
COUNTRY
TEXT
9
3/7/2024, 4:28 PM
ACCOUNT_PLAN
EXPERIMENTS
CUSTOMER
TEXT
2
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
MANAGEDBYDEPARTMENT
TEXT
32
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
LICENSEMODEL
TEXT
31
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
RENEWALDATE
DATE
6
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
APPLICATION
TEXT
1
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
COSTSAVINGS
TEXT
20
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
VALUESCORE
NUMBER
7
3/7/2024, 4:28 PM
ACCOUNT_PLAN
DEVICES
DEVICE_OS
TEXT
3
3/7/2024, 4:28 PM
SNOWPULSE
APPLICATIONS
USECASECOVERAGE
TEXT
49
3/7/2024, 4:28 PM
ACCOUNT_PLAN
PLANS
PRICE_PER_SEAT_USD
NUMBER
3
3/7/2024, 4:28 PM