Source
POSITION
Searches for the first occurrence of the first argument in the second argument and, if successful, returns the position (1 - based) of the first argument in the second argument.
ARRAY_POSITION
Returns the index of the first occurrence of an element in an array.
Why do I see gaps in the ORDINAL_POSITION column in the INFORMATION_SCHEMA.COLUMNS view after cloning a table?
The above behavior may be observed when a column or columns are dropped in the source table. Because a cloned table references the original table's micro partitions, original micro partitions may have information or other tables could be…
BITMAP_ABSOLUTE_POSITION
Computes the absolute bit position from a bucket number and a relative bit position. This is the inverse of the BITMAP_BUCKET_NUMBER and BITMAP_BIT_POSITION functions.
REGEXP_INSTR
Returns the position of the specified occurrence of the regular expression pattern in the string subject. See also String functions (regular expressions).
BITMAP_BIT_POSITION
Given a numeric value, returns the relative position for the bit that represents that value in a bitmap.
ARRAY_POSITION Function: Changes to Finding the Position of a NULL Value
When you call the ARRAY_POSITION function and pass in a value as the first argument, the function returns the position of the first ARRAY element with that value.
CHARINDEX
Searches for the first occurrence of the first argument in the second argument and, if successful, returns the position (1 - based) of the first argument in the second argument.
Openflow Connector for MySQL: GTID-based replication
With binary log position tracking, a single transaction has to fit into a binary log message of no more than 4 GB. GTID tracking identifies transactions directly rather than by their offset in a file, so that limit doesn’t apply.
Sep 12, 2025: Support for position row-level deletes when writing to externally managed Apache Iceberg™ tables or catalog-linked databases on Amazon S3 or Google Cloud (Preview)
Snowflake now supports position row - level deletes when writing to externally managed Apache Iceberg™ or Iceberg tables in catalog - linked databases when the tables are stored on Amazon S3 or Google Cloud. These deletes are supported when…