to_sql

Features.to_sql(targets=True, subfeatures=True, dialect='sqlite3')[source]

Returns SQL statements visualizing the features.

Args:
targets (boolean):

Whether you want to include the target columns in the main table.

subfeatures (boolean):

Whether you want to include the code for the subfeatures of a snowflake schema.

dialect (string):

The SQL dialect to use. Must be from dialect.

Examples:

my_pipeline.features.to_sql()
Returns:
SQLCode

Object representing the features.

Note:

Only fitted pipelines (fit()) can hold trained features which can be returned as SQL statements. The dialect is based on the SQLite3 standard.