# REFERENCE

- [SQL Reference](/reference/sql-reference.md)
- [Data Types](/reference/sql-reference/data-types.md)
- [SQL Functions](/reference/sql-reference/all-functions.md)
- [Aggregate](/reference/sql-reference/all-functions/aggregate.md)
- [APPROX\_COUNT\_DISTINCT](/reference/sql-reference/all-functions/aggregate/approx_count_distinct.md): Returns the approximate number of unique, non-null values in a column.
- [AVG](/reference/sql-reference/all-functions/aggregate/avg.md): Computes the average of a set of values.
- [BIT\_AND](/reference/sql-reference/all-functions/aggregate/bit_and.md): Returns the bitwise AND of non-NULL input values.
- [BIT\_OR](/reference/sql-reference/all-functions/aggregate/bit_or.md): Returns the bitwise OR of non-NULL input values.
- [CORR](/reference/sql-reference/all-functions/aggregate/corr.md): Calculates the Pearson correlation coefficient of the values expression1 and expression2. The function name must be enclosed in double quotes (“CORR”).
- [COUNT](/reference/sql-reference/all-functions/aggregate/count.md): Returns the total number of records for the specified expression.
- [COVAR\_POP](/reference/sql-reference/all-functions/aggregate/covar_pop.md): Returns the population covariance for non-NULL pairs across all input values.
- [COVAR\_SAMP](/reference/sql-reference/all-functions/aggregate/covar_samp.md): Returns the sample covariance for non-NULL pairs across all input values.
- [HLL](/reference/sql-reference/all-functions/aggregate/hll.md): Uses HyperLogLog to return an approximation of the distinct cardinality of the input.
- [LISTAGG](/reference/sql-reference/all-functions/aggregate/listagg.md): Concatenates a group of rows into a list of strings and places a separator between them.
- [MAX](/reference/sql-reference/all-functions/aggregate/max.md): Returns the maximum value among the non-NULL input expressions.
- [MIN](/reference/sql-reference/all-functions/aggregate/min.md): Returns the minimum value among the non-NULL input expressions.
- [NDV](/reference/sql-reference/all-functions/aggregate/ndv.md)
- [STDDEV](/reference/sql-reference/all-functions/aggregate/stddev.md): Returns the standard deviation of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
- [STDDEV\_POP](/reference/sql-reference/all-functions/aggregate/stddev_pop.md): Returns the population standard deviation (square root of variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
- [STDDEV\_SAMP](/reference/sql-reference/all-functions/aggregate/stddev_samp.md): Returns the sample standard deviation (square root of sample variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
- [SUM](/reference/sql-reference/all-functions/aggregate/sum.md): Returns the sum of non-NULL input expressions.
- [VAR\_POP](/reference/sql-reference/all-functions/aggregate/var_pop.md): Returns the population variance of non-NULL records.
- [VAR\_SAMP](/reference/sql-reference/all-functions/aggregate/var_samp.md): Returns the sample variance of non-NULL records.
- [Binary](/reference/sql-reference/all-functions/binary.md)
- [BASE64](/reference/sql-reference/all-functions/binary/base64.md): Returns the Base64 encoding of a binary string.
- [BIT\_LENGTH](/reference/sql-reference/all-functions/binary/bit_length.md): Gets length of bits of the input expression.
- [FROM\_HEX](/reference/sql-reference/all-functions/binary/from_hex.md): Returns a binary value for the given hexadecimal string.
- [HEX](/reference/sql-reference/all-functions/binary/hex.md): Returns the hexadecimal encoding of an expression.
- [TO\_HEX](/reference/sql-reference/all-functions/binary/to_hex.md): Returns a hexadecimal string for the given binary value.
- [UNBASE64](/reference/sql-reference/all-functions/binary/unbase64.md): Decodes a Base64-encoded string.
- [UNHEX](/reference/sql-reference/all-functions/binary/unhex.md): Converts the hexadecimal number into the bytes represented by a number.
- [Bitwise](/reference/sql-reference/all-functions/bitwise.md)
- [BIT\_AND](/reference/sql-reference/all-functions/bitwise/bit_and.md): Returns the bitwise AND of non-NULL input values.
- [BIT\_OR](/reference/sql-reference/all-functions/bitwise/bit_or.md): Returns the bitwise OR of non-NULL input values.
- [LSHIFT](/reference/sql-reference/all-functions/bitwise/lshift.md): Shifts the bits of the numeric expression to the left.
- [RSHIFT](/reference/sql-reference/all-functions/bitwise/rshift.md): Shifts the bits of the numeric expression to he right.
- [XOR](/reference/sql-reference/all-functions/bitwise/xor.md): Returns the bitwise XOR of two integers.
- [Boolean](/reference/sql-reference/all-functions/boolean.md)
- [IS \[NOT\] DISTINCT FROM](/reference/sql-reference/all-functions/boolean/is-not-distinct-from.md): Compares two expressions to determine whether they have the same or different values. NULLs are considered as comparable values.
- [ISFALSE](/reference/sql-reference/all-functions/boolean/isfalse.md): Tests whether the input expression is false. If it is, returns a value of true.
- [IS \[NOT\] NULL](/reference/sql-reference/all-functions/boolean/is-not-null.md): Determines if an expression is NULL or not NULL. Alias for the function ISNULL/ISNOTNULL.
- [ISNUMERIC](/reference/sql-reference/all-functions/boolean/isnumeric.md): Determines whether an expression is a valid numeric type (DECIMAL, DOUBLE, INT, BIGINT, VARBINARY).
- [ISTRUE](/reference/sql-reference/all-functions/boolean/istrue.md): Returns TRUE if the input expression evaluates to TRUE.
- [IS\_MEMBER](/reference/sql-reference/all-functions/boolean/is_member.md): Returns whether the current user is a member of the specified role.
- [Conditional](/reference/sql-reference/all-functions/conditional.md)
- [BOOL\_AND](/reference/sql-reference/all-functions/conditional/bool_and.md): Computes the boolean AND of two boolean expressions. Returns TRUE if both expressions evaluate to TRUE. Returns FALSE if one or both expression(s) evaluate(s) to FALSE.
- [BOOL\_OR](/reference/sql-reference/all-functions/conditional/bool_or.md): Computes the boolean OR of two boolean expressions. Returns TRUE if one or both expressions evaluate to TRUE. Returns FALSE if both expressions evaluate to FALSE.
- [CASE](/reference/sql-reference/all-functions/conditional/case.md): Evaluates a list of conditions and returns the first resulting true expression. If a true expression is not found, will return the ELSE statement, if present, or else will return NULL.
- [COALESCE](/reference/sql-reference/all-functions/conditional/coalesce.md): Evaluates the arguments in order and returns the value of the first expression that does not contain NULL.
- [GREATEST](/reference/sql-reference/all-functions/conditional/greatest.md): Returns the largest value from a list of expressions.
- [LEAST](/reference/sql-reference/all-functions/conditional/least.md): Returns the smallest value from a list of expressions.
- [NULLIF](/reference/sql-reference/all-functions/conditional/nullif.md): Compares two expressions. If the values in each expression are equal, returns NULL and, if they are not equal, returns the value of the first expression.
- [Conversion](/reference/sql-reference/all-functions/conversion.md)
- [BINARY\_STRING](/reference/sql-reference/all-functions/conversion/binary_string.md): Converts the input expression to a binary value.
- [CAST](/reference/sql-reference/all-functions/conversion/cast.md): Converts a value of one data type to another data type. This function behaves similarly to the TO\_\<data\_type> (i.e. TO\_TIMESTAMP) functions.
- [CONVERT\_FROM](/reference/sql-reference/all-functions/conversion/convert_from.md): Converts a binary string from the given data type to a Spice type.
- [CONVERT\_REPLACEUTF8](/reference/sql-reference/all-functions/conversion/convert_replaceutf8.md): Converts a binary string to a UTF-8 value and replaces all characters that cannot be converted to UTF-8 with the specified replacement character.
- [CONVERT\_TIMEZONE](/reference/sql-reference/all-functions/conversion/convert_timezone.md): Convert timestamp to the specified timezone.
- [CONVERT\_TO](/reference/sql-reference/all-functions/conversion/convert_to.md): Converts a value to a binary string of a supported data type.
- [FLATTEN](/reference/sql-reference/all-functions/conversion/flatten.md): Explodes compound values into multiple rows. This function takes a LIST column and produces a lateral view (that is, an inline view that contains correlation referring to other tables that precede it
- [FROM\_HEX](/reference/sql-reference/all-functions/conversion/from_hex.md): Returns a binary value for the given hexadecimal string.
- [HASH](/reference/sql-reference/all-functions/conversion/hash.md): Returns a hash value of the arguments. HASH does not return NULL, even for NULL inputs.
- [HEX](/reference/sql-reference/all-functions/conversion/hex.md): Returns the hexadecimal encoding of an expression.
- [TOASCII](/reference/sql-reference/all-functions/conversion/toascii.md): Converts a string that is encoded in the specified character set to UTF-8.
- [TO\_CHAR](/reference/sql-reference/all-functions/conversion/to_char.md): Converts the input expression to a character/string using the specified format.
- [TO\_DATE](/reference/sql-reference/all-functions/conversion/to_date.md): Converts the input expressions to the corresponding date.
- [TO\_HEX](/reference/sql-reference/all-functions/conversion/to_hex.md): Returns a hexadecimal string for the given binary value.
- [TO\_NUMBER](/reference/sql-reference/all-functions/conversion/to_number.md): Converts a string into a number (double) in the specified format.
- [TO\_TIME](/reference/sql-reference/all-functions/conversion/to_time.md): Converts the input expressions to the corresponding time.
- [TO\_TIMESTAMP](/reference/sql-reference/all-functions/conversion/to_timestamp.md): Converts the input expressions to the corresponding timestamp.
- [UNHEX](/reference/sql-reference/all-functions/conversion/unhex.md): Converts the hexadecimal number into the bytes represented by a number.
- [Cryptography](/reference/sql-reference/all-functions/cryptography.md)
- [AES\_DECRYPT](/reference/sql-reference/all-functions/cryptography/aes_decrypt.md): Decrypts a string produced by AES encryption.
- [AES\_ENCRYPT](/reference/sql-reference/all-functions/cryptography/aes_encrypt.md): Encrypts a string using AES encryption.
- [MD5](/reference/sql-reference/all-functions/cryptography/md5.md): Computes the MD5 hash value of a string.
- [SHA](/reference/sql-reference/all-functions/cryptography/sha.md): Computes the SHA-1 hash value of a string.
- [SHA1](/reference/sql-reference/all-functions/cryptography/sha1.md): Computes the SHA-1 hash value of a string.
- [SHA256](/reference/sql-reference/all-functions/cryptography/sha256.md): Computes the 256-bit SHA-2 hash value of a string.
- [SHA512](/reference/sql-reference/all-functions/cryptography/sha512.md): Computes the 512-bit SHA-2 hash value of a string.
- [Data Generation](/reference/sql-reference/all-functions/data-generation.md)
- [RANDOM](/reference/sql-reference/all-functions/data-generation/random.md): Each call returns a random generated number between 0 and 1 for each row.
- [Datatype](/reference/sql-reference/all-functions/datatype.md)
- [IS\_BIGINT](/reference/sql-reference/all-functions/datatype/is_bigint.md): Returns TRUE if the input expression is a big integer value.
- [IS\_DATE](/reference/sql-reference/all-functions/datatype/is_date.md): Returns TRUE if the input expression can be cast to a date.
- [IS\_INT](/reference/sql-reference/all-functions/datatype/is_int.md): Returns TRUE if the input expression is an integer value.
- [IS\_VARCHAR](/reference/sql-reference/all-functions/datatype/is_varchar.md): Returns TRUE if the input expression is a varchar value.
- [SIZE](/reference/sql-reference/all-functions/datatype/size.md): Returns the number of entries in a map expression.
- [TYPEOF](/reference/sql-reference/all-functions/datatype/typeof.md): Reports the type (in string format) of the input expression.
- [Date/Time](/reference/sql-reference/all-functions/date-time.md)
- [CONVERT\_TIMEZONE](/reference/sql-reference/all-functions/date-time/convert_timezone.md): Convert timestamp to the specified timezone.
- [CURRENT\_DATE](/reference/sql-reference/all-functions/date-time/current_date.md): Returns the current date of the system.
- [CURRENT\_DATE\_UTC](/reference/sql-reference/all-functions/date-time/current_date_utc.md): Returns the current date of the system based on the UTC timezone.
- [CURRENT\_TIME](/reference/sql-reference/all-functions/date-time/current_time.md): Returns the current time for the system.
- [CURRENT\_TIMESTAMP](/reference/sql-reference/all-functions/date-time/current_timestamp.md): Returns the current timestamp for the system in UTC time only.
- [DATEDIFF](/reference/sql-reference/all-functions/date-time/datediff.md): Compares two dates or timestamps and returns the difference in days.
- [DATE\_ADD](/reference/sql-reference/all-functions/date-time/date_add.md): Returns the sum of two expressions of time as another expression of time.
- [DATE\_DIFF](/reference/sql-reference/all-functions/date-time/date_diff.md): Returns the difference between two expressions of time as another expression of time.
- [DATE\_PART](/reference/sql-reference/all-functions/date-time/date_part.md): Return subfields such as year or hour from date or timestamp values.
- [DATE\_SUB](/reference/sql-reference/all-functions/date-time/date_sub.md): Returns the difference of two expressions of time as another expression of time.
- [DATE\_TRUNC](/reference/sql-reference/all-functions/date-time/date_trunc.md): Truncates the date or timestamp to the indicated precision.
- [DAY](/reference/sql-reference/all-functions/date-time/day.md): Returns the day of month of the date or timestamp.
- [DAYOFMONTH](/reference/sql-reference/all-functions/date-time/dayofmonth.md): Returns the day of month of the date or timestamp.
- [DAYOFWEEK](/reference/sql-reference/all-functions/date-time/dayofweek.md): Returns the day of the week (from 1 to 7) of the date or timestamp.
- [DAYOFYEAR](/reference/sql-reference/all-functions/date-time/dayofyear.md): Returns the day of the year (from 1 to 366) of the date or timestamp.
- [EXTRACT](/reference/sql-reference/all-functions/date-time/extract.md): Extracts the specified date or time part from the date or timestamp.
- [HOUR](/reference/sql-reference/all-functions/date-time/hour.md): Extracts the hour number (from 0 to 23) for a given time or timestamp.
- [LAST\_DAY](/reference/sql-reference/all-functions/date-time/last_day.md): Returns the last day of the month for the specified date or timestamp.
- [MINUTE](/reference/sql-reference/all-functions/date-time/minute.md): Extracts the minute number (from 0 to 59) for a given time or timestamp.
- [MONTH](/reference/sql-reference/all-functions/date-time/month.md): Extracts the month number (from 1 to 12) for a given date or timestamp.
- [MONTHS\_BETWEEN](/reference/sql-reference/all-functions/date-time/months_between.md): Returns the number of months between two date or timestamp values.
- [NEXT\_DAY](/reference/sql-reference/all-functions/date-time/next_day.md): Returns the date or timestamp of the first specified day of week that occurs after the input date.
- [QUARTER](/reference/sql-reference/all-functions/date-time/quarter.md): Extracts the quarter number (from 1 to 4) for a given date or timestamp.
- [SECOND](/reference/sql-reference/all-functions/date-time/second.md): Extracts the second number (from 0 to 59) for a given date or timestamp.
- [TIMESTAMPADD](/reference/sql-reference/all-functions/date-time/timestampadd.md): Add (or subtract) an interval of time from a date/timestamp value or column.
- [TIMESTAMPDIFF](/reference/sql-reference/all-functions/date-time/timestampdiff.md): Return the amount of time between two date or timestamp values.
- [TO\_DATE](/reference/sql-reference/all-functions/date-time/to_date.md): Converts the input expressions to the corresponding date.
- [TO\_TIME](/reference/sql-reference/all-functions/date-time/to_time.md): Converts the input expressions to the corresponding time.
- [TO\_TIMESTAMP](/reference/sql-reference/all-functions/date-time/to_timestamp.md): Converts the input expressions to the corresponding timestamp.
- [UNIX\_TIMESTAMP](/reference/sql-reference/all-functions/date-time/unix_timestamp.md): Returns the Unix epoch time representation of an ISO 8601 timestamp.
- [WEEK](/reference/sql-reference/all-functions/date-time/week.md): Extracts the week number (from 0 to 53) for a given date or timestamp.
- [WEEKOFYEAR](/reference/sql-reference/all-functions/date-time/weekofyear.md): Returns the week of year of the date or timestamp.
- [YEAR](/reference/sql-reference/all-functions/date-time/year.md): Extracts the year for a given date or timestamp.
- [Math](/reference/sql-reference/all-functions/math.md)
- [ABS](/reference/sql-reference/all-functions/math/abs.md): Computes the absolute value of a numeric expression.
- [ACOS](/reference/sql-reference/all-functions/math/acos.md): Computes the arccosine (inverse cosine) of a value in radians.
- [ASIN](/reference/sql-reference/all-functions/math/asin.md): Computes the arcsine (inverse sine) of a value in radians.
- [ATAN](/reference/sql-reference/all-functions/math/atan.md): Computes the Arctangent (inverse tangent) of a value.
- [CBRT](/reference/sql-reference/all-functions/math/cbrt.md): Computes the cube root of a numeric expression.
- [CEILING](/reference/sql-reference/all-functions/math/ceiling.md): Returns the nearest equal or larger value of the input expression. Can also be called using CEIL().
- [COS](/reference/sql-reference/all-functions/math/cos.md): Computes the cosine of a value in radians.
- [COSH](/reference/sql-reference/all-functions/math/cosh.md): Computes the hyperbolic cosine of a value in radians.
- [COT](/reference/sql-reference/all-functions/math/cot.md): Computes the cotangent of a value in radians.
- [DEGREES](/reference/sql-reference/all-functions/math/degrees.md): Converts radians to degrees.
- [E](/reference/sql-reference/all-functions/math/e.md): Returns Euler’s number, a constant approximately equal to 2.718281828459045.
- [EXP](/reference/sql-reference/all-functions/math/exp.md): Calculates Euler’s number, e, raised to the power of the specified value.
- [FLOOR](/reference/sql-reference/all-functions/math/floor.md): Returns the value from the specifed expression rounded to the nearest equal or smaller integer.
- [LOG](/reference/sql-reference/all-functions/math/log.md): Returns the logarithm of the numeric input expression. If no base is specified, the natural log (ln) will be calculated.
- [LOG10](/reference/sql-reference/all-functions/math/log10.md): Returns the log base 10 of the numeric input expression.
- [MOD](/reference/sql-reference/all-functions/math/mod.md): Returns the remainder of the input expression divided by the second input expression.
- [PI](/reference/sql-reference/all-functions/math/pi.md): Returns the value of pi, which is approximately 3.14592654.
- [POWER](/reference/sql-reference/all-functions/math/power.md): Returns the result of raising the input value to the specified power.
- [RADIANS](/reference/sql-reference/all-functions/math/radians.md): Convert a value in degrees to radians.
- [ROUND](/reference/sql-reference/all-functions/math/round.md): Returns the rounded value for the inputted value. If no scale is specified, the closest whole number is returned.
- [SIGN](/reference/sql-reference/all-functions/math/sign.md): Returns the sign of the input expression.
- [SIN](/reference/sql-reference/all-functions/math/sin.md): Computes the sine of a value.
- [SINH](/reference/sql-reference/all-functions/math/sinh.md): Computes the hyperbolic sine of the input expression.
- [SQRT](/reference/sql-reference/all-functions/math/sqrt.md): Returns the square root of the non-negative numeric expression.
- [STDDEV](/reference/sql-reference/all-functions/math/stddev.md): Returns the standard deviation of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
- [STDDEV\_POP](/reference/sql-reference/all-functions/math/stddev_pop.md): Returns the population standard deviation (square root of variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
- [STDDEV\_SAMP](/reference/sql-reference/all-functions/math/stddev_samp.md): Returns the sample standard deviation (square root of sample variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
- [TAN](/reference/sql-reference/all-functions/math/tan.md): Computes the tangent of a value in radians.
- [TANH](/reference/sql-reference/all-functions/math/tanh.md): Computes the hyperbolic tangent of the input expression.
- [TRUNCATE](/reference/sql-reference/all-functions/math/truncate.md): Rounds the input expression down the nearest of equal integer depending on the specified number of places before or after the decimal point.
- [Percentile](/reference/sql-reference/all-functions/percentile.md)
- [MEDIAN](/reference/sql-reference/all-functions/percentile/median.md): Computes the median of a dataset.
- [PERCENTILE\_CONT](/reference/sql-reference/all-functions/percentile/percentile_cont.md): Computes a percentile value based on a continuous distribution of the column input.
- [PERCENTILE\_DISC](/reference/sql-reference/all-functions/percentile/percentile_disc.md): Computes a specific percentile for sorted values in a column.
- [Regular Expressions](/reference/sql-reference/all-functions/regular-expressions.md)
- [REGEXP\_EXTRACT](/reference/sql-reference/all-functions/regular-expressions/regexp_extract.md): Extracts the first string in expression that matches the REGEXP expression and corresponds to the REGEX group index.
- [REGEXP\_LIKE](/reference/sql-reference/all-functions/regular-expressions/regexp_like.md): Returns true when the specified regular expression matches values in a column. Otherwise, returns false.
- [REGEXP\_MATCHES](/reference/sql-reference/all-functions/regular-expressions/regexp_matches.md): Returns true when the specified regular expression matches values in a column. Otherwise, returns false.
- [REGEXP\_REPLACE](/reference/sql-reference/all-functions/regular-expressions/regexp_replace.md): Finds strings that match the given regular expression and replaces the strings with the given string.
- [REGEXP\_SPLIT](/reference/sql-reference/all-functions/regular-expressions/regexp_split.md): Splits an input string by using a regular expression according to a keyword and an integer value.
- [Semistructured Data](/reference/sql-reference/all-functions/semistructured-data.md)
- [ARRAY\_CONTAINS](/reference/sql-reference/all-functions/semistructured-data/array_contains.md): Returns whether a list contains a given value.
- [MAP\_KEYS](/reference/sql-reference/all-functions/semistructured-data/map_keys.md): Returns all keys from a map expression.
- [MAP\_VALUES](/reference/sql-reference/all-functions/semistructured-data/map_values.md): Returns all values from a map expression.
- [String](/reference/sql-reference/all-functions/string.md)
- [ASCII](/reference/sql-reference/all-functions/string/ascii.md): Returns the ASCII code for the first character of a string. If the string is empty, 0 is returned.
- [BASE64](/reference/sql-reference/all-functions/string/base64.md): Returns the Base64 encoding of a binary string.
- [BTRIM](/reference/sql-reference/all-functions/string/btrim.md): Trims leading and trailing characters from a string.
- [CHARACTER\_LENGTH](/reference/sql-reference/all-functions/string/character_length.md): Returns the length of an input string.
- [CHAR\_LENGTH](/reference/sql-reference/all-functions/string/char_length.md): Returns the character length of the input string.
- [CHR](/reference/sql-reference/all-functions/string/chr.md): Converts a Unicode code point into the character that matches the input Unicode character. If an invalid code point is specified, an empty string is returned.
- [COL\_LIKE](/reference/sql-reference/all-functions/string/col_like.md): Tests whether an expression column matches a pattern column. Comparisons are case-sensitive.
- [CONCAT](/reference/sql-reference/all-functions/string/concat.md): Concatenates two or more strings. NULL values are ignored.
- [CONCAT\_WS](/reference/sql-reference/all-functions/string/concat_ws.md): Concatenate with separator. Returns a string resulting from the joining of two or more string values in an end-to-end manner. Uses the first argument as the separator between each string.
- [ENDS\_WITH](/reference/sql-reference/all-functions/string/ends_with.md): Returns whether a string ends with another string. The comparison is case-sensitive.
- [FROM\_HEX](/reference/sql-reference/all-functions/string/from_hex.md): Returns a binary value for the given hexadecimal string
- [HEX](/reference/sql-reference/all-functions/string/hex.md): Returns the hexadecimal encoding of an expression.
- [ILIKE](/reference/sql-reference/all-functions/string/ilike.md): Tests whether an expression matches a pattern. The comparison is case-insensitive.
- [INITCAP](/reference/sql-reference/all-functions/string/initcap.md): Returns the input string with the first letter of each word in uppercase and the subsequent letters in the word are in lowercase).
- [INSTR](/reference/sql-reference/all-functions/string/instr.md): Returns the position of the first occurrence of a string when it is contained in another string. If no such occurrence is found, a zero is returned. The comparison is case-sensitive.
- [IS\_UTF8](/reference/sql-reference/all-functions/string/is_utf8.md): Returns whether an expression is valid UTF-8.
- [LCASE](/reference/sql-reference/all-functions/string/lcase.md): Returns the input expression with all the characters converted to lowercase.
- [LEFT](/reference/sql-reference/all-functions/string/left.md): Returns the left-most substring. The function name must be enclosed in double quotes ("LEFT").
- [LENGTH](/reference/sql-reference/all-functions/string/length.md): Returns the length of an input string. If the character encoding isn’t specified, it assumes to UTF8.
- [LEVENSHTEIN](/reference/sql-reference/all-functions/string/levenshtein.md): Computes the Levenshtein distance between two input expressions.
- [LIKE](/reference/sql-reference/all-functions/string/like.md): Tests whether an expression matches one or more patterns. Comparisons are case-sensitive.
- [LOCATE](/reference/sql-reference/all-functions/string/locate.md)
- [LOWER](/reference/sql-reference/all-functions/string/lower.md): Returns the input expression with all the characters converted to lowercase.
- [LPAD](/reference/sql-reference/all-functions/string/lpad.md): Left pads a string with spaces or specified characters to reach the number of characters specified as a parameter.
- [LTRIM](/reference/sql-reference/all-functions/string/ltrim.md): Removes leading spaces or characters from a string.
- [MASK](/reference/sql-reference/all-functions/string/mask.md): Returns a masked version of a string.
- [MASK\_FIRST\_N](/reference/sql-reference/all-functions/string/mask_first_n.md): Returns a masked version of a string with the first num\_chars characters masked. By default, if you do not provide a mask value, the first four characters are masked.
- [MASK\_HASH](/reference/sql-reference/all-functions/string/mask_hash.md): Returns a consistent hash value based on the input string. This function returns NULL for non-string types.
- [MASK\_LAST\_N](/reference/sql-reference/all-functions/string/mask_last_n.md): Returns a masked version of a string with the last num\_chars characters masked. By default, if you do not provide a mask value, the last four characters are masked.
- [MASK\_SHOW\_FIRST\_N](/reference/sql-reference/all-functions/string/mask_show_first_n.md): Returns a masked version of a string with the first num\_chars characters unmasked. By default, if you do not provide a value, the first four characters are shown.
- [MASK\_SHOW\_LAST\_N](/reference/sql-reference/all-functions/string/mask_show_last_n.md): Returns a masked version of a string with the last num\_chars characters unmasked. By default, if you do not provide a value, the last four characters are shown.
- [OCTET\_LENGTH](/reference/sql-reference/all-functions/string/octet_length.md): Returns the length of the string in bytes.
- [POSITION](/reference/sql-reference/all-functions/string/position.md): Returns the position of the first occurrence of a substring within another string
- [QUOTE](/reference/sql-reference/all-functions/string/quote.md): Returns a result that can be used as a properly escaped data value in a SQL statement.
- [REGEXP\_EXTRACT](/reference/sql-reference/all-functions/string/regexp_extract.md): Extracts the first string in expression that matches the REGEXP expression and corresponds to the REGEX group index.
- [REGEXP\_LIKE](/reference/sql-reference/all-functions/string/regexp_like.md): Returns true when the specified regular expression matches values in a column. Otherwise, returns false.
- [REGEXP\_MATCHES](/reference/sql-reference/all-functions/string/regexp_matches.md): Returns true when the specified regular expression matches values in a column. Otherwise, returns false.
- [REGEXP\_REPLACE](/reference/sql-reference/all-functions/string/regexp_replace.md): Finds strings that match the given regular expression and replaces the strings with the given string.
- [REGEXP\_SPLIT](/reference/sql-reference/all-functions/string/regexp_split.md): Splits an input string by using a regular expression according to a keyword and an integer value.
- [REPEAT](/reference/sql-reference/all-functions/string/repeat.md): Builds a string by repeating the input for the specified number of times
- [REPEATSTR](/reference/sql-reference/all-functions/string/repeatstr.md): Repeats the given string n times.
- [REPLACE](/reference/sql-reference/all-functions/string/replace.md): Removes all occurrences of a specified substring and replaces them with another string.
- [REVERSE](/reference/sql-reference/all-functions/string/reverse.md): Reverses the order of characters in a string.
- [RIGHT](/reference/sql-reference/all-functions/string/right.md): Returns the right-most substring. The function name must be enclosed in double quotes (“RIGHT”).
- [RPAD](/reference/sql-reference/all-functions/string/rpad.md): Right pads a string with spaces or specified characters to reach the number of characters specified as a parameter.
- [RTRIM](/reference/sql-reference/all-functions/string/rtrim.md): Removes trailing spaces or characters from a string.
- [SIMILAR\_TO](/reference/sql-reference/all-functions/string/similar_to.md): Tests whether the entire expression matches a pattern.
- [SOUNDEX](/reference/sql-reference/all-functions/string/soundex.md): Returns a string that contains a phonetic representation of the input string.
- [SPLIT\_PART](/reference/sql-reference/all-functions/string/split_part.md): Splits a given string at a specified character and returns the requested part.
- [STARTS\_WITH](/reference/sql-reference/all-functions/string/starts_with.md): Returns whether a string starts with another string. The comparison is case-sensitive.
- [STRPOS](/reference/sql-reference/all-functions/string/strpos.md): Searches for the first occurrence of the substring in the given expression and returns the position of where the substring begins. Searching binary values is also supported.
- [SUBSTRING](/reference/sql-reference/all-functions/string/substring.md): Returns the portion of the string from the specified base expression starting at the specified characters.
- [SUBSTRING\_INDEX](/reference/sql-reference/all-functions/string/substring_index.md): Returns a substring of an expression before the specified number of delimiters occurs.
- [TOASCII](/reference/sql-reference/all-functions/string/toascii.md): Converts a string that is encoded in the specified character set to UTF-8.
- [TO\_HEX](/reference/sql-reference/all-functions/string/to_hex.md): Returns a hexadecimal string for the given binary value.
- [TRANSLATE](/reference/sql-reference/all-functions/string/translate.md): Translates the base expression from the source characters/expression to the target characters/expression.
- [TRIM](/reference/sql-reference/all-functions/string/trim.md): Removes leading, trailing, or both spaces or characters from a string.
- [UCASE](/reference/sql-reference/all-functions/string/ucase.md): Returns the input expression with all the characters converted to uppercase.
- [UNBASE64](/reference/sql-reference/all-functions/string/unbase64.md): Decodes a Base64-encoded string.
- [UNHEX](/reference/sql-reference/all-functions/string/unhex.md): Converts the hexadecimal number into the bytes represented by a number.
- [UPPER](/reference/sql-reference/all-functions/string/upper.md): Returns the input expression with all the characters converted to uppercase.
- [Window](/reference/sql-reference/all-functions/window.md)
- [COUNT](/reference/sql-reference/all-functions/window/count.md): Returns the total number of records for the specified expression.
- [COVAR\_POP](/reference/sql-reference/all-functions/window/covar_pop.md): Returns the population covariance for non-NULL pairs across all input values.
- [COVAR\_SAMP](/reference/sql-reference/all-functions/window/covar_samp.md): Returns the sample covariance for non-NULL pairs across all input values.
- [CUME\_DIST](/reference/sql-reference/all-functions/window/cume_dist.md): Returns the cumulative distribution of the current row with regard to other values within the same window partition.
- [DENSE\_RANK](/reference/sql-reference/all-functions/window/dense_rank.md): Returns the rank of the current row within its partition and ordering. Rows that are equal will have the same rank.
- [FIRST\_VALUE](/reference/sql-reference/all-functions/window/first_value.md): Returns the first value within an ordered group of a result set.
- [HLL](/reference/sql-reference/all-functions/window/hll.md): Uses HyperLogLog to return an approximation of the distinct cardinality of the input.
- [LAG](/reference/sql-reference/all-functions/window/lag.md): Returns the row before the current one in a partition based on the ORDER BY clause without the need for a self-join. If there are no rows, this function returns NULL.
- [LEAD](/reference/sql-reference/all-functions/window/lead.md): Returns the row after the current one in the same result set without the need for a self-join. If there are no rows, this function returns NULL.
- [MAX](/reference/sql-reference/all-functions/window/max.md): Returns the maximum value among the non-NULL input expressions.
- [MIN](/reference/sql-reference/all-functions/window/min.md): Returns the minimum value among the non-NULL input expressions.
- [NDV](/reference/sql-reference/all-functions/window/ndv.md)
- [NTILE](/reference/sql-reference/all-functions/window/ntile.md): Equally splits the rows in each partition into ranked parts specified by the integer value and starting from 1. This function requires the ORDER BY clause.
- [PERCENT\_RANK](/reference/sql-reference/all-functions/window/percent_rank.md): Returns the relative rank of the current row in the partition based on the ORDER BY clause. The displayed percentage ranges from 0.0 to 1.0.
- [RANK](/reference/sql-reference/all-functions/window/rank.md)
- [ROW\_NUMBER](/reference/sql-reference/all-functions/window/row_number.md): Returns the row number for the current row based on the ORDER BY clause within each partition. Rows containing identical values receive different row numbers.
- [SUM](/reference/sql-reference/all-functions/window/sum.md): Returns the sum of non-NULL input expressions.
- [VAR\_POP](/reference/sql-reference/all-functions/window/var_pop.md): Returns the population variance of non-NULL records.
- [VAR\_SAMP](/reference/sql-reference/all-functions/window/var_samp.md): Returns the sample variance of non-NULL records.
- [SQL Commands](/reference/sql-reference/sql-commands.md)
- [SELECT](/reference/sql-reference/sql-commands/select.md): The SELECT statement is used to select data from a database. Spice supports querying using standard SELECT statements.
- [USE](/reference/sql-reference/sql-commands/use.md)
- [SHOW](/reference/sql-reference/sql-commands/show.md)
- [DESCRIBE](/reference/sql-reference/sql-commands/describe.md): The DESCRIBE TABLE command is used to provide high-level information regarding the overall column properties of an existing dataset.
- [WITH](/reference/sql-reference/sql-commands/with.md)
- [SQL Query Tables](/reference/sql-query-tables.md)
- [Ethereum](/reference/sql-query-tables/ethereum.md): Ethereum data tables available in SQL query
- [Core Tables](/reference/sql-query-tables/ethereum/core-tables.md): Ethereum base type tables available to query via SQL
- [eth.blocks](/reference/sql-query-tables/ethereum/core-tables/eth.blocks.md): SQL table schema for eth.blocks and eth.recent\_blocks
- [eth.transactions](/reference/sql-query-tables/ethereum/core-tables/eth.transactions.md): SQL table schema for eth.transactions and eth.recent\_transactions
- [eth.logs](/reference/sql-query-tables/ethereum/core-tables/eth.logs.md): SQL table schema for eth.logs and eth.recent\_logs
- [eth.contracts](/reference/sql-query-tables/ethereum/core-tables/eth.contracts.md): SQL table schema for eth.contracts
- [eth.traces](/reference/sql-query-tables/ethereum/core-tables/eth.traces.md): SQL table schema for eth.traces and eth.recent\_traces
- [eth.withdrawals](/reference/sql-query-tables/ethereum/core-tables/eth.withdrawals.md): SQL table schema for eth.withdrawals and eth.recent\_withdrawals
- [Beacon Chain Tables](/reference/sql-query-tables/ethereum/beacon-chain-tables.md): Ethereum Beacon tables available to query via SQL
- [eth.beacon.validators](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.validators.md): SQL table schema for eth.validators
- [eth.beacon.slots](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.slots.md): SQL table schema for eth.beacon.slots and eth.beacon.recent\_slots
- [eth.beacon.attestations](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.attestations.md): SQL table schema for eth.beacon.attestations and eth.beacon.recent\_attestations
- [eth.beacon.deposits](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.deposits.md): SQL table schema for eth.beacon.deposits and eth.beacon.recent\_deposits
- [eth.beacon.voluntary\_exits](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.voluntary_exits.md): SQL table schema for eth.beacon.voluntary\_exits and eth.beacon.recent\_voluntary\_exits
- [eth.beacon.attester\_slashings](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.attester_slashings.md): SQL table schema for eth.beacon.attester\_slashings and eth.beacon.recent\_attester\_slashings
- [eth.beacon.proposer\_slashings](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.proposer_slashings.md): SQL table schema for eth.beacon.proposer\_slashings and eth.beacon.recent\_proposer\_slashings
- [eth.beacon.bls\_to\_execution\_changes](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.bls_to_execution_changes.md): SQL table schema for eth.beacon.bls\_to\_execution\_changes and eth.beacon.recent\_bls\_to\_execution\_changes
- [eth.beacon.withdrawals](/reference/sql-query-tables/ethereum/beacon-chain-tables/eth.beacon.withdrawals.md): SQL table schema for eth.beacon.withdrawals and eth.beacon.recent\_withdrawals
- [Token Tables](/reference/sql-query-tables/ethereum/token-tables.md): Ethereum Token tables available to query via SQL
- [eth.tokens](/reference/sql-query-tables/ethereum/token-tables/eth.tokens.md): SQL table schema for eth.tokens
- [eth.token\_transfers](/reference/sql-query-tables/ethereum/token-tables/eth.token_transfers.md): SQL table schema for eth.token\_transfers
- [eth.recent\_token\_transfers](/reference/sql-query-tables/ethereum/token-tables/eth.recent_token_transfers.md): SQL table schema for eth.recent\_token\_transfers
- [eth.tokens\_erc20](/reference/sql-query-tables/ethereum/token-tables/eth.tokens_erc20.md): SQL table schema for eth.tokens\_erc20
- [eth.token\_transfers\_erc20](/reference/sql-query-tables/ethereum/token-tables/eth.token_transfers_erc20.md): SQL table schema for eth.token\_transfers\_erc20
- [eth.tokens\_erc721](/reference/sql-query-tables/ethereum/token-tables/eth.tokens_erc721.md): SQL table schema for eth.tokens\_erc721
- [eth.token\_transfers\_erc721](/reference/sql-query-tables/ethereum/token-tables/eth.token_transfers_erc721.md): SQL table schema for eth.token\_transfers\_erc721
- [eth.tokens\_erc1155](/reference/sql-query-tables/ethereum/token-tables/eth.tokens_erc1155.md): SQL table schema for eth.tokens\_erc1155
- [eth.token\_transfers\_erc1155](/reference/sql-query-tables/ethereum/token-tables/eth.token_transfers_erc1155.md): SQL table schema for eth.token\_transfers\_erc1155
- [eth.token\_mints](/reference/sql-query-tables/ethereum/token-tables/eth.token_mints.md): SQL table schema for eth.token\_mints and eth.recent\_token\_mints
- [NFT Tables](/reference/sql-query-tables/ethereum/nft-tables.md): Ethereum NFT tables available to query via SQL
- [eth.nfts](/reference/sql-query-tables/ethereum/nft-tables/eth.nfts.md): SQL table schema for eth.nfts
- [eth.nft\_contracts](/reference/sql-query-tables/ethereum/nft-tables/eth.nft_contracts.md): SQL table schema for eth.nft\_contracts
- [eth.nft\_transfers](/reference/sql-query-tables/ethereum/nft-tables/eth.nft_transfers.md): SQL table schema for eth.nft\_transfers
- [eth.nft\_owners](/reference/sql-query-tables/ethereum/nft-tables/eth.nft_owners.md): SQL table schema for eth.nft\_owners
- [eth.recent\_nft\_transfers](/reference/sql-query-tables/ethereum/nft-tables/eth.recent_nft_transfers.md): SQL table schema for eth.recent\_nft\_transfers
- [eth.nft\_airdrop\_transfers](/reference/sql-query-tables/ethereum/nft-tables/eth.nft_airdrop_transfers.md): SQL table schema for eth.nft\_airdrop\_transfers
- [Wallet Balances](/reference/sql-query-tables/ethereum/wallet-balances.md): Ethereum Wallet Balance tables available to query via SQL, in Preview
- [eth.wallet\_balances](/reference/sql-query-tables/ethereum/wallet-balances/eth.wallet_balances.md): SQL table schema for eth.wallet\_balances
- [ENS Tables](/reference/sql-query-tables/ethereum/token-tables-1.md): Ethereum Name Service (ENS) tables available to query via SQL
- [ens.domains](/reference/sql-query-tables/ethereum/token-tables-1/ens.domains.md): SQL table schema for ens.domains
- [Uniswap V2 Tables](/reference/sql-query-tables/ethereum/uniswap-v2-tables.md): Ethereum Uniswap V2 tables available to query via SQL
- [eth.uniswap\_v2.pools](/reference/sql-query-tables/ethereum/uniswap-v2-tables/eth.uniswap_v2.pools.md): SQL table schema for eth.uniswap\_v2.pools
- [eth.uniswap\_v2.pool\_stats](/reference/sql-query-tables/ethereum/uniswap-v2-tables/eth.uniswap_v2.pool_stats.md): SQL table schema for eth.uniswap\_v2.pool\_stats
- [eth.uniswap\_v2.pool\_stats\_detailed](/reference/sql-query-tables/ethereum/uniswap-v2-tables/eth.uniswap_v2.pool_stats_detailed.md): SQL table schema for eth.uniswap\_v2.pool\_stats\_detailed
- [eth.uniswap\_v2.event\_mints](/reference/sql-query-tables/ethereum/uniswap-v2-tables/eth.uniswap_v2.event_mints.md): SQL table schema for eth.uniswap\_v2.event\_mints and eth.uniswap\_v2.recent\_event\_mints
- [eth.uniswap\_v2.event\_burns](/reference/sql-query-tables/ethereum/uniswap-v2-tables/eth.uniswap_v2.event_burns.md): SQL table schema for eth.uniswap\_v2.event\_burns and eth.uniswap\_v2.recent\_event\_burns
- [eth.uniswap\_v2.event\_swaps](/reference/sql-query-tables/ethereum/uniswap-v2-tables/eth.uniswap_v2.event_swaps.md): SQL table schema for eth.uniswap\_v2.event\_swaps and eth.uniswap\_v2.recent\_event\_swaps
- [eth.uniswap\_v2.event\_syncs](/reference/sql-query-tables/ethereum/uniswap-v2-tables/eth.uniswap_v2.event_syncs.md): SQL table schema for eth.uniswap\_v2.event\_syncs and eth.uniswap\_v2.recent\_event\_syncs
- [Uniswap V3 Tables](/reference/sql-query-tables/ethereum/uniswap-v3-tables.md): Ethereum Uniswap V3 tables available to query via SQL
- [eth.uniswap\_v3.pools](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.pools.md): SQL table schema for eth.uniswap\_v3.pools
- [eth.uniswap\_v3.pool\_stats](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.pool_stats.md): SQL table schema for eth.uniswap\_v3.pool\_stats
- [eth.uniswap\_v3.event\_burns](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_burns.md): SQL table schema for eth.uniswap\_v3.event\_burns and eth.uniswap\_v3.recent\_event\_burns
- [eth.uniswap\_v3.event\_mints](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_mints.md): SQL table schema for eth.uniswap\_v3.event\_mints and eth.uniswap\_v3.recent\_event\_mints
- [eth.uniswap\_v3.event\_swaps](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_swaps.md): SQL table schema for eth.uniswap\_v3.event\_swaps and eth.uniswap\_v3.recent\_event\_swaps
- [eth.uniswap\_v3.event\_set\_fee\_protocols](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_set_fee_protocols.md): SQL table schema for eth.uniswap\_v3.event\_set\_fee\_protocols and eth.uniswap\_v3.recent\_event\_set\_fee\_protocols
- [eth.uniswap\_v3.event\_collects](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_collects.md): SQL table schema for eth.uniswap\_v3.event\_collects and eth.uniswap\_v3.recent\_event\_collects
- [eth.uniswap\_v3.event\_collect\_protocols](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_collect_protocols.md): SQL table schema for eth.uniswap\_v3.event\_collect\_protocols and eth.uniswap\_v3.recent\_event\_collect\_protocols
- [eth.uniswap\_v3.event\_flashes](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_flashes.md): SQL table schema for eth.uniswap\_v3.event\_flashes and eth.uniswap\_v3.recent\_event\_flashes
- [eth.uniswap\_v3.event\_increase\_observation\_cardinality\_nexts](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_increase_observation_cardinality_nexts.md): SQL table schema for eth.uniswap\_v3.event\_increase\_observation\_cardinality\_nexts and eth.uniswap\_v3.recent\_event\_increase\_observation\_cardinality\_nexts
- [eth.uniswap\_v3.event\_initializes](/reference/sql-query-tables/ethereum/uniswap-v3-tables/eth.uniswap_v3.event_initializes.md): SQL table schema for eth.uniswap\_v3.event\_initializes and eth.uniswap\_v3.recent\_event\_initializes
- [Sushiswap Tables](/reference/sql-query-tables/ethereum/sushiswap-tables.md): Ethereum Sushiswap tables available to query via SQL
- [eth.sushiswap.pools](/reference/sql-query-tables/ethereum/sushiswap-tables/eth.sushiswap.pools.md): SQL table schema for eth.sushiswap.pools
- [eth.sushiswap.pool\_stats](/reference/sql-query-tables/ethereum/sushiswap-tables/eth.sushiswap.pool_stats.md): SQL table schema for eth.sushiswap.pool\_stats
- [eth.sushiswap.pool\_stats\_detailed](/reference/sql-query-tables/ethereum/sushiswap-tables/eth.sushiswap.pool_stats_detailed.md): SQL table schema for eth.sushiswap.pool\_stats\_detailed
- [eth.sushiswap.event\_mints](/reference/sql-query-tables/ethereum/sushiswap-tables/eth.sushiswap.event_mints.md): SQL table schema for eth.sushiswap.event\_mints and eth.sushiswap.recent\_event\_mints
- [eth.sushiswap.event\_burns](/reference/sql-query-tables/ethereum/sushiswap-tables/eth.sushiswap.event_burns.md): SQL table schema for eth.sushiswap.event\_burns and eth.sushiswap.recent\_event\_burns
- [eth.sushiswap.event\_swaps](/reference/sql-query-tables/ethereum/sushiswap-tables/eth.sushiswap.event_swaps.md): SQL table schema for eth.sushiswap.event\_swaps and eth.sushiswap.recent\_event\_swaps
- [eth.sushiswap.event\_syncs](/reference/sql-query-tables/ethereum/sushiswap-tables/eth.sushiswap.event_syncs.md): SQL table schema for eth.sushiswap.event\_syncs and eth.sushiswap.recent\_event\_syncs
- [Chainlink Tables](/reference/sql-query-tables/ethereum/chainlink-tables.md): Ethereum Chainlink tables available to query via SQL
- [Prices Tables](/reference/sql-query-tables/ethereum/chainlink-tables/prices-tables.md): Ethereum Chainlink Price tables available in SQL query
- [eth.chainlink.prices](/reference/sql-query-tables/ethereum/chainlink-tables/prices-tables/eth.chainlink.prices.md): SQL table schema for eth.chainlink.prices and eth.chainlink.recent\_prices
- [Aave V2 Tables](/reference/sql-query-tables/ethereum/aave-v2-tables.md): Ethereum Aave V2 tables available to query via SQL
- [eth.aave\_v2.loans](/reference/sql-query-tables/ethereum/aave-v2-tables/eth.aave_v2.loans.md): SQL table schema for eth.aave\_v2.loans and r eth.aave\_v2.loan\_updates
- [eth.aave\_v2.collateral](/reference/sql-query-tables/ethereum/aave-v2-tables/eth.aave_v2.collateral.md): SQL table schema for eth.aave\_v2.collateral and eth.aave\_v2.collateral\_updates
- [Goerli](/reference/sql-query-tables/goerli.md): Goerli data tables available in SQL query
- [Core Tables](/reference/sql-query-tables/goerli/goerli.md): Goerli base type tables available to query via SQL
- [goerli.blocks](/reference/sql-query-tables/goerli/goerli/goerli.blocks.md): SQL table schema for goerli.blocks and goerli.recent\_blocks
- [goerli.transactions](/reference/sql-query-tables/goerli/goerli/goerli.transactions.md): SQL table schema for goerli.transactions and goerli.recent\_transactions
- [goerli.logs](/reference/sql-query-tables/goerli/goerli/goerli.logs.md): SQL table schema for goerli.logs and goerli.recent\_logs
- [goerli.contracts](/reference/sql-query-tables/goerli/goerli/goerli.contracts.md): SQL table schema for goerli.contracts
- [goerli.traces](/reference/sql-query-tables/goerli/goerli/goerli.traces.md): SQL table schema for goerli.traces and goerli.recent\_traces
- [goerli.withdrawals](/reference/sql-query-tables/goerli/goerli/goerli.withdrawals.md): SQL table schema for goerli.withdrawals and goerli.recent\_withdrawals
- [Beacon Chain Tables](/reference/sql-query-tables/goerli/beacon-chain-tables.md): Goerli Beacon Chain tables available to query via SQL
- [goerli.beacon.validators](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.validators.md): SQL table schema for goerli.beacon.validators
- [goerli.beacon.slots](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.slots.md): SQL table schema for goerli.beacon.slots and goerli.beacon.recent\_slots
- [goerli.beacon.attestations](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.attestations.md): SQL table schema for goerli.beacon.attestations and goerli.beacon.recent\_attestations
- [goerli.beacon.deposits](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.deposits.md): SQL table schema for goerli.beacon.deposits and goerli.beacon.recent\_deposits
- [goerli.beacon.voluntary\_exits](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.voluntary_exits.md): SQL table schema for goerli.beacon.voluntary\_exits and goerli.beacon.recent\_voluntary\_exits
- [goerli.beacon.attester\_slashings](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.attester_slashings.md): SQL table schema for goerli.beacon.attester\_slashings and goerli.beacon.recent\_attester\_slashings
- [goerli.beacon.proposer\_slashings](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.proposer_slashings.md): SQL table schema for goerli.beacon.proposer\_slashings and goerli.beacon.recent\_proposer\_slashings
- [goerli.beacon.bls\_to\_execution\_changes](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.bls_to_execution_changes.md): SQL table schema for goerli.beacon.bls\_to\_execution\_changes and goerli.beacon.recent\_bls\_to\_execution\_changes
- [goerli.beacon.withdrawals](/reference/sql-query-tables/goerli/beacon-chain-tables/goerli.beacon.withdrawals.md): SQL table schema for goerli.beacon.withdrawals and goerli.beacon.recent\_withdrawals
- [Token Tables](/reference/sql-query-tables/goerli/token-tables.md): Goerli Token tables available to query via SQL
- [goerli.tokens](/reference/sql-query-tables/goerli/token-tables/goerli.tokens.md): SQL table schema for goerli.tokens
- [goerli.token\_transfers](/reference/sql-query-tables/goerli/token-tables/goerli.token_transfers.md): SQL table schema for goerli.token\_transfers and goerli.recent\_token\_transfers
- [goerli.tokens\_erc20](/reference/sql-query-tables/goerli/token-tables/goerli.tokens_erc20.md): SQL table schema for goerli.tokens\_erc20
- [goerli.token\_transfers\_erc20](/reference/sql-query-tables/goerli/token-tables/goerli.token_transfers_erc20.md): SQL table schema for goerli.token\_transfers\_erc20
- [goerli.tokens\_erc721](/reference/sql-query-tables/goerli/token-tables/goerli.tokens_erc721.md): SQL table schema for goerli.tokens\_erc721
- [goerli.token\_transfers\_erc721](/reference/sql-query-tables/goerli/token-tables/goerli.token_transfers_erc721.md): SQL table schema for goerli.token\_transfers\_erc721
- [goerli.tokens\_erc1155](/reference/sql-query-tables/goerli/token-tables/goerli.tokens_erc1155.md): SQL table schema for goerli.tokens\_erc1155
- [goerli.token\_transfers\_erc1155](/reference/sql-query-tables/goerli/token-tables/goerli.token_transfers_erc1155.md): SQL table schema for goerli.token\_transfers\_erc1155
- [goerli.token\_mints](/reference/sql-query-tables/goerli/token-tables/goerli.token_mints.md): SQL table schema for goerli.token\_mints and goerli.recent\_token\_mints
- [Wallet Balance Tables](/reference/sql-query-tables/goerli/token-tables-1.md): Goerli Wallet Balance tables available to query via SQL
- [goerli.wallet\_balances](/reference/sql-query-tables/goerli/token-tables-1/goerli.wallet_balances.md): SQL table schema for goerli.wallet\_balances
- [Polygon](/reference/sql-query-tables/polygon.md): Polygon data tables available in SQL query
- [Core Tables](/reference/sql-query-tables/polygon/polygon.md): Polygon base type tables available to query via SQL
- [polygon.blocks](/reference/sql-query-tables/polygon/polygon/polygon.blocks.md): SQL table schema for polygon.blocks and polygon.recent\_blocks
- [polygon.transactions](/reference/sql-query-tables/polygon/polygon/polygon.transactions.md): SQL table schema for polygon.transactions and polygon.recent\_transactions
- [polygon.logs](/reference/sql-query-tables/polygon/polygon/polygon.logs.md): SQL table schema for polygon.logs and polygon.recent\_logs
- [polygon.contracts](/reference/sql-query-tables/polygon/polygon/polygon.contracts.md): SQL table schema for polygon.contracts
- [polygon.traces](/reference/sql-query-tables/polygon/polygon/polygon.traces.md): SQL table schema for polygon.traces and polygon.recent\_traces
- [Token Tables](/reference/sql-query-tables/polygon/token-tables.md): Polygon Token tables available to query via SQL
- [polygon.tokens](/reference/sql-query-tables/polygon/token-tables/polygon.tokens.md): SQL table schema for polygon.tokens
- [polygon.token\_transfers](/reference/sql-query-tables/polygon/token-tables/polygon.token_transfers.md): SQL table schema for polygon.token\_transfers
- [polygon.recent\_token\_transfers](/reference/sql-query-tables/polygon/token-tables/polygon.recent_token_transfers.md): SQL table schema for polygon.recent\_token\_transfers
- [polygon.tokens\_erc20](/reference/sql-query-tables/polygon/token-tables/polygon.tokens_erc20.md): SQL table schema for polygon.tokens\_erc20
- [polygon.token\_transfers\_erc20](/reference/sql-query-tables/polygon/token-tables/polygon.token_transfers_erc20.md): SQL table schema for polygon.token\_transfers\_erc20
- [polygon.tokens\_erc721](/reference/sql-query-tables/polygon/token-tables/polygon.tokens_erc721.md): SQL table schema for polygon.tokens\_erc721
- [polygon.token\_transfers\_erc721](/reference/sql-query-tables/polygon/token-tables/polygon.token_transfers_erc721.md): SQL table schema for polygon.token\_transfers\_erc721
- [polygon.tokens\_erc1155](/reference/sql-query-tables/polygon/token-tables/polygon.tokens_erc1155.md): SQL table schema for polygon.tokens\_erc1155
- [polygon.token\_transfers\_erc1155](/reference/sql-query-tables/polygon/token-tables/polygon.token_transfers_erc1155.md): SQL table schema for polygon.token\_transfers\_erc1155
- [polygon.token\_mints](/reference/sql-query-tables/polygon/token-tables/polygon.token_mints.md): SQL table schema for polygon.token\_mints and polygon.recent\_token\_mints
- [NFT Tables](/reference/sql-query-tables/polygon/nft-tables.md): Polygon NFT tables available to query via SQL
- [polygon.nfts](/reference/sql-query-tables/polygon/nft-tables/polygon.nfts.md): SQL table schema for polygon.nfts
- [polygon.nft\_contracts](/reference/sql-query-tables/polygon/nft-tables/polygon.nft_contracts.md): SQL table schema for polygon.nft\_contracts
- [polygon.nft\_transfers](/reference/sql-query-tables/polygon/nft-tables/polygon.nft_transfers.md): SQL table schema for polygon.nft\_transfers and polygon.recent\_nft\_transfers
- [polygon.nft\_owners](/reference/sql-query-tables/polygon/nft-tables/polygon.nft_owners.md): SQL table schema for polygon.nft\_owners
- [polygon.nft\_airdrop\_transfers](/reference/sql-query-tables/polygon/nft-tables/polygon.nft_airdrop_transfers.md): SQL table schema for polygon.nft\_airdrop\_transfers and polygon.recent\_nft\_airdrop\_transfers
- [Bitcoin](/reference/sql-query-tables/bitcoin.md): Bitcoin data tables available in SQL query
- [btc.blocks](/reference/sql-query-tables/bitcoin/btc.blocks.md): SQL table schema for btc.blocks and btc.recent\_blocks
- [btc.transactions](/reference/sql-query-tables/bitcoin/btc.transactions.md): SQL table schema for btc.transactions and btc.recent\_transactions
- [btc.transaction\_inputs](/reference/sql-query-tables/bitcoin/btc.transaction_inputs.md): SQL table schema for btc.transaction\_inputs and btc.recent\_transaction\_inputs
- [btc.transaction\_outputs](/reference/sql-query-tables/bitcoin/btc.transaction_outputs.md): SQL table schema for btc.transaction\_outputs
- [Flow](/reference/sql-query-tables/flow.md): Flow data tables available in SQL query
- [Core Tables](/reference/sql-query-tables/flow/core-tables.md): Flow base type tables available to query via SQL
- [flow.blocks](/reference/sql-query-tables/flow/core-tables/flow.blocks.md)
- [flow.transactions](/reference/sql-query-tables/flow/core-tables/flow.transactions.md)
- [flow.events](/reference/sql-query-tables/flow/core-tables/flow.events.md)
- [Token/NFT Tables](/reference/sql-query-tables/flow/token-nft-tables.md): Flow NFT/Token tables available to query via SQL
- [flow.nfts](/reference/sql-query-tables/flow/token-nft-tables/flow.nfts.md)
- [flow.nft\_transfers](/reference/sql-query-tables/flow/token-nft-tables/flow.nft_transfers.md)
- [flow.token\_transfers](/reference/sql-query-tables/flow/token-nft-tables/flow.token_transfers.md)
- [Prices](/reference/sql-query-tables/prices.md): Tables containing historical prices of tokens
- [Specifications](/reference/specifications.md)
- [Dataset & View YAML Specification](/reference/specifications/dataset-and-view-yaml-specification.md)
- [Firecache](/reference/specifications/dataset-and-view-yaml-specification/firecache.md): Dataset firecache definition
- [Spice Functions YAML Specification](/reference/specifications/spice-functions-yaml-specification.md)
- [Triggers](/reference/specifications/spice-functions-yaml-specification/triggers.md): Function trigger definition
- [Arrow Flight Samples](/reference/arrow-flight-samples.md)
- [Kaggle Notebooks](/reference/kaggle-notebooks.md)
- [Release notes](/reference/release-notes.md): Spice.xyz Release notes