SQLCode

class getml.pipeline.SQLCode(code: Sequence[Union[str, getml.pipeline.sql_string.SQLString]], dialect: Literal['bigquery', 'mysql', 'postgres', 'spark sql', 'sqlite3', 'tsql'] = 'sqlite3')[source]

Custom class for handling the SQL code of the features generated by the pipeline.

Example:
sql_code = my_pipeline.features.to_sql()

# You can access individual features
# by index.
feature_1_1 = sql_code[0]

# You can also access them by name.
feature_1_10 = sql_code["FEATURE_1_10"]

# You can also type the name of
# a table or column to find all
# features related to that table
# or column.
features = sql_code.find("SOME_TABLE")

# HINT: The generated SQL code always
# escapes table and column names using
# quotation marks. So if you want exact
# matching, you can do this:
features = sql_code.find('"SOME_TABLE"')

Methods

find(keyword)

Returns the SQLCode for all features containing the keyword.

save(fname[, split])

Saves the SQL code to a file.

to_str()

Returns a raw string representation of the SQL code.