snowflake.snowpark.DataFrame.col_ilike

DataFrame.col_ilike(pattern: str) → DataFrame[source]

Returns a new DataFrame with only the columns whose names match the specified pattern using case-insensitive ILIKE matching (similar to SELECT * ILIKE ‘pattern’ in SQL).

Parameters:

pattern – The ILIKE pattern to match column names against. You can use the following wildcards: - Use an underscore (_) to match any single character. - Use a percent sign (%) to match any sequence of zero or more characters. - To match a sequence anywhere within the column name, begin and end the pattern with %.

Returns:

A new DataFrame containing only columns matching the pattern.

Return type:

DataFrame

Raises:

  • ValueError – If SQL simplifier is not enabled.

  • SnowparkSQLException – If no columns match the specified pattern.

Examples:

>>> # Select all columns containing 'id' (case-insensitive)
>>> df = session.create_dataframe([[1, "John", 101], [2, "Jane", 102]],
...                                 schema=["USER_ID", "Name", "dept_id"])
>>> df.col_ilike("%id%").show()
-------------------------
|"USER_ID"  |"DEPT_ID"  |
-------------------------
|1          |101        |
|2          |102        |
-------------------------