Index

A

add_silver_metadata() (in module fabrictools) (in module fabrictools.quality) (in module fabrictools.quality.clean), [1] AddColumn() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] AddDays() (fabrictools.powerquery.Date static method) (fabrictools.powerquery.date.Date static method), [1]

ai_response() (in module fabrictools) AIError any (fabrictools.powerquery._common.type attribute) (fabrictools.powerquery.type attribute) Ascending (fabrictools.powerquery._common.Order attribute) (fabrictools.powerquery.Order attribute) Average (fabrictools.powerquery.List attribute) (fabrictools.powerquery.list.List attribute), [1]

B

Buffer() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] build_dimension_city() (in module fabrictools) (in module fabrictools.dimensions) (in module fabrictools.dimensions.geo) build_dimension_country() (in module fabrictools) (in module fabrictools.dimensions) (in module fabrictools.dimensions.geo) build_dimension_date() (in module fabrictools) (in module fabrictools.dimensions) (in module fabrictools.dimensions.date)

build_dimension_from_columns() (in module fabrictools) (in module fabrictools.dimensions) build_lakehouse_read_path_candidates() (in module fabrictools.core) (in module fabrictools.core.paths) build_lakehouse_write_path() (in module fabrictools.core) (in module fabrictools.core.paths) build_table_jobs_from_config() (in module fabrictools.pipelines) (in module fabrictools.pipelines.config) build_table_jobs_from_discovery() (in module fabrictools.pipelines) (in module fabrictools.pipelines.config) build_tcd() (in module fabrictools.transform)

C

cast_columns() (in module fabrictools.transform) Clean() (fabrictools.powerquery.Text static method) (fabrictools.powerquery.text.Text static method), [1] clean_and_write_all_tables() (in module fabrictools) (in module fabrictools.quality) (in module fabrictools.quality.pipeline) clean_and_write_data() (in module fabrictools) (in module fabrictools.quality) (in module fabrictools.quality.pipeline) clean_data() (in module fabrictools) (in module fabrictools.quality) (in module fabrictools.quality.clean), [1] clear() (fabrictools.transform.ParamResolver method) client_id (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute)

client_secret (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute) coalesce_dim() (in module fabrictools) (in module fabrictools.transform) Combine() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] (fabrictools.powerquery.Text static method) (fabrictools.powerquery.text.Text static method), [1] config (fabrictools.IFSClient property) (fabrictools.integrations.ifs.IFSClient property) configure_parquet_datetime_rebase() (in module fabrictools.core.spark) Count (fabrictools.powerquery.List attribute) (fabrictools.powerquery.list.List attribute), [1]

D

dataframe_last_nonnull_wide_month_from_long() (in module fabrictools) (in module fabrictools.transform) dataframe_pivot_category_wide_month_from_long() (in module fabrictools) (in module fabrictools.transform) dataframe_unpivot_wide_month_suffix() (in module fabrictools) (in module fabrictools.transform) Date (class in fabrictools.powerquery) (class in fabrictools.powerquery.date), [1] date (fabrictools.powerquery._common.type attribute) (fabrictools.powerquery.type attribute) datetime (fabrictools.powerquery._common.type attribute) (fabrictools.powerquery.type attribute) Day() (fabrictools.powerquery.Date static method) (fabrictools.powerquery.date.Date static method), [1]

delete_all_lakehouse_tables() (in module fabrictools) (in module fabrictools.io) (in module fabrictools.io.lakehouse) delete_lakehouse() (in module fabrictools.io) (in module fabrictools.io.lakehouse) Descending (fabrictools.powerquery._common.Order attribute) (fabrictools.powerquery.Order attribute) detect_and_cast_columns() (in module fabrictools.quality.clean), [1] diagnose_ifs_connectivity() (in module fabrictools.integrations.ifs) Distinct() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] drop_rows_over_empty_percent() (in module fabrictools) (in module fabrictools.transform) DuplicateColumn() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1]

E

empty_or_null() (in module fabrictools) (in module fabrictools.transform)

enrich() (fabrictools.transform.ParamResolver method) Excel (class in fabrictools.excel), [1]

F

fabrictools.core module fabrictools.core.logging module fabrictools.core.paths module fabrictools.core.spark module fabrictools.dimensions module fabrictools.dimensions.attribute module fabrictools.dimensions.date module fabrictools.dimensions.geo module fabrictools.dimensions.pipeline module fabrictools.excel module fabrictools.excel.aggregate module fabrictools.excel.logic module fabrictools.excel.lookup module fabrictools.excel.text module fabrictools.integrations.ifs module fabrictools.integrations.ifs.client module fabrictools.integrations.ifs.config module fabrictools.integrations.ifs.credentials module fabrictools.integrations.ifs.errors module fabrictools.integrations.ifs.read module fabrictools.io module fabrictools.io.discovery module fabrictools.io.lakehouse module fabrictools.io.warehouse module fabrictools.pipelines module fabrictools.pipelines.config module fabrictools.powerquery module fabrictools.powerquery.date module fabrictools.powerquery.list module fabrictools.powerquery.number module fabrictools.powerquery.table module

fabrictools.powerquery.text module fabrictools.prepare module fabrictools.prepare.aggregations module fabrictools.prepare.pipeline module fabrictools.prepare.resolve module fabrictools.prepare.schema module fabrictools.prepare.semantic module fabrictools.prepare.transform module fabrictools.quality module fabrictools.quality.clean module, [1] fabrictools.quality.pipeline module fabrictools.quality.scan module fabrictools.transform module fabrictools.transform.columns module fabrictools.transform.filter module fabrictools.transform.fr_text_period module fabrictools.transform.merge module fabrictools.transform.rows module fabrictools.transform.text module fabrictools.transform.wide_month_suffix module FillDown() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] FillUp() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] filter_column_by_values() (in module fabrictools) (in module fabrictools.transform) filter_pipeline_discovered_tables() (in module fabrictools.io) (in module fabrictools.io.discovery) First (fabrictools.powerquery.List attribute) (fabrictools.powerquery.list.List attribute), [1] FirstN() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] From() (fabrictools.powerquery.Date static method) (fabrictools.powerquery.date.Date static method), [1] (fabrictools.powerquery.Text static method) (fabrictools.powerquery.text.Text static method), [1] from_http_response() (fabrictools.AIError class method) (fabrictools.IFSError class method) (fabrictools.integrations.ifs.IFSError class method) FromText() (fabrictools.powerquery.Number static method) (fabrictools.powerquery.number.Number static method), [1]

G

generate_dimensions() (in module fabrictools) (in module fabrictools.dimensions) (in module fabrictools.dimensions.pipeline) generate_prepared_aggregations() (in module fabrictools) (in module fabrictools.prepare) (in module fabrictools.prepare.aggregations) get() (fabrictools.transform.ParamResolver method) get_access_token() (fabrictools.IFSClient method) (fabrictools.integrations.ifs.IFSClient method) get_entity() (fabrictools.IFSClient method) (fabrictools.integrations.ifs.IFSClient method)

get_fs_entry_name() (in module fabrictools.io.discovery) get_lakehouse_abfs_path() (in module fabrictools.core) (in module fabrictools.core.paths) get_spark() (in module fabrictools.core) (in module fabrictools.core.spark) get_warehouse_jdbc_url() (in module fabrictools.core) (in module fabrictools.core.paths) Group() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1]

H

host (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute)

I

If() (fabrictools.excel.Excel static method), [1] (in module fabrictools.excel.logic) ifs_config_with_keyvault_secret() (in module fabrictools) (in module fabrictools.integrations.ifs) ifs_data_to_dataframe() (in module fabrictools.integrations.ifs) ifs_request_json() (in module fabrictools) (in module fabrictools.integrations.ifs) IFSClient (class in fabrictools) (class in fabrictools.integrations.ifs)

IFSConfig (class in fabrictools) (class in fabrictools.integrations.ifs) IFSError, [1] Int64 (class in fabrictools.powerquery) (class in fabrictools.powerquery._common) integer (fabrictools.powerquery._common.type attribute) (fabrictools.powerquery.type attribute)

J

Join() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1]

L

lakehouse_table_exists() (in module fabrictools.io) (in module fabrictools.io.lakehouse) Last (fabrictools.powerquery.List attribute) (fabrictools.powerquery.list.List attribute), [1] LastN() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] layer (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute) List (class in fabrictools.powerquery) (class in fabrictools.powerquery.list), [1]

list_lakehouse_tables() (in module fabrictools.io) (in module fabrictools.io.discovery) list_lakehouse_tables_for_pipeline() (in module fabrictools.io) (in module fabrictools.io.discovery) log() (in module fabrictools.core) (in module fabrictools.core.logging) logical (fabrictools.powerquery._common.type attribute) (fabrictools.powerquery.type attribute) lookup_mode (fabrictools.transform.ParamResolver property) Lower() (fabrictools.powerquery.Text static method) (fabrictools.powerquery.text.Text static method), [1]

M

make_business_ready() (in module fabrictools.prepare) Max (fabrictools.powerquery.List attribute) (fabrictools.powerquery.list.List attribute), [1] merge_condition (fabrictools.pipelines.config.TableJobConfig attribute) (fabrictools.pipelines.TableJobConfig attribute) merge_dataframes() (in module fabrictools) (in module fabrictools.transform) merge_lakehouse() (in module fabrictools) (in module fabrictools.io) (in module fabrictools.io.lakehouse) metric_value_for_class() (in module fabrictools.transform) Min (fabrictools.powerquery.List attribute) (fabrictools.powerquery.list.List attribute), [1] mode (fabrictools.pipelines.config.TableJobConfig attribute) (fabrictools.pipelines.TableJobConfig attribute) module fabrictools.core fabrictools.core.logging fabrictools.core.paths fabrictools.core.spark fabrictools.dimensions fabrictools.dimensions.attribute fabrictools.dimensions.date fabrictools.dimensions.geo fabrictools.dimensions.pipeline fabrictools.excel fabrictools.excel.aggregate fabrictools.excel.logic fabrictools.excel.lookup fabrictools.excel.text fabrictools.integrations.ifs fabrictools.integrations.ifs.client fabrictools.integrations.ifs.config fabrictools.integrations.ifs.credentials fabrictools.integrations.ifs.errors fabrictools.integrations.ifs.read fabrictools.io fabrictools.io.discovery fabrictools.io.lakehouse fabrictools.io.warehouse fabrictools.pipelines fabrictools.pipelines.config fabrictools.powerquery fabrictools.powerquery.date fabrictools.powerquery.list fabrictools.powerquery.number fabrictools.powerquery.table fabrictools.powerquery.text fabrictools.prepare fabrictools.prepare.aggregations fabrictools.prepare.pipeline fabrictools.prepare.resolve fabrictools.prepare.schema fabrictools.prepare.semantic fabrictools.prepare.transform fabrictools.quality fabrictools.quality.clean, [1] fabrictools.quality.pipeline fabrictools.quality.scan fabrictools.transform fabrictools.transform.columns fabrictools.transform.filter fabrictools.transform.fr_text_period fabrictools.transform.merge fabrictools.transform.rows fabrictools.transform.text fabrictools.transform.wide_month_suffix

Month() (fabrictools.powerquery.Date static method) (fabrictools.powerquery.date.Date static method), [1] month_from_fr_text() (in module fabrictools) (in module fabrictools.transform) month_start_from_ca_monthly_col() (in module fabrictools) (in module fabrictools.transform)

N

NestedJoin() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] norm_text() (in module fabrictools) (in module fabrictools.transform)

Number (class in fabrictools.powerquery) (class in fabrictools.powerquery.number), [1] number (fabrictools.powerquery._common.type attribute) (fabrictools.powerquery.type attribute)

O

Order (class in fabrictools.powerquery) (class in fabrictools.powerquery._common)

P

page_size (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute) ParamResolver (class in fabrictools.transform) parse_ifs_data() (in module fabrictools.integrations.ifs) partition_by (fabrictools.pipelines.config.TableJobConfig attribute) (fabrictools.pipelines.TableJobConfig attribute) Percentage (class in fabrictools.powerquery) (class in fabrictools.powerquery._common) Pivot() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] prepare_and_write_all_tables() (in module fabrictools) (in module fabrictools.prepare) (in module fabrictools.prepare.pipeline)

prepare_and_write_data() (in module fabrictools) (in module fabrictools.prepare) (in module fabrictools.prepare.pipeline) projection_base_path() (fabrictools.IFSConfig method) (fabrictools.integrations.ifs.IFSConfig method) projection_version (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute) Proper() (fabrictools.powerquery.Text static method) (fabrictools.powerquery.text.Text static method), [1] publish_semantic_model() (in module fabrictools) (in module fabrictools.prepare) (in module fabrictools.prepare.semantic)

R

Range() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] read_ifs_entity() (in module fabrictools) (in module fabrictools.integrations.ifs) read_ifs_entity_with_token() (in module fabrictools) (in module fabrictools.integrations.ifs) read_ifs_to_lakehouse() (in module fabrictools) (in module fabrictools.integrations.ifs) read_lakehouse() (in module fabrictools) (in module fabrictools.io) (in module fabrictools.io.lakehouse) read_lakehouses() (in module fabrictools) (in module fabrictools.io) (in module fabrictools.io.lakehouse) read_warehouse() (in module fabrictools) (in module fabrictools.io) (in module fabrictools.io.warehouse) remove_columns() (in module fabrictools) (in module fabrictools.transform) RemoveColumns() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] rename_columns_month_year_block_labels() (in module fabrictools) (in module fabrictools.transform) rename_columns_normalized() (in module fabrictools) (in module fabrictools.transform)

rename_columns_pq_serial_to_dates() (in module fabrictools) (in module fabrictools.transform) rename_columns_pq_serial_to_mois_annee() (in module fabrictools) (in module fabrictools.transform) RenameColumns() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] ReorderColumns() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] ReplaceErrorValues() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] ReplaceValue() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] resolve_columns() (in module fabrictools) (in module fabrictools.prepare) (in module fabrictools.prepare.resolve) resolve_dataframe_column() (in module fabrictools) (in module fabrictools.transform) resolve_lakehouse_read_candidate() (in module fabrictools.io) (in module fabrictools.io.lakehouse) resolve_token_endpoint() (fabrictools.IFSConfig method) (fabrictools.integrations.ifs.IFSConfig method) Round() (fabrictools.excel.Excel static method), [1] (in module fabrictools.excel.logic) row_count_info (fabrictools.transform.ParamResolver property)

S

scan_data_errors() (in module fabrictools) (in module fabrictools.quality) (in module fabrictools.quality.scan) scope (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute) Select() (fabrictools.powerquery.Text static method) (fabrictools.powerquery.text.Text static method), [1] SelectColumns() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] SelectRows() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] Skip() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] snapshot_source_schema() (in module fabrictools) (in module fabrictools.prepare) (in module fabrictools.prepare.schema)

Sort() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] source_relative_path (fabrictools.pipelines.config.TableJobConfig attribute) (fabrictools.pipelines.TableJobConfig attribute) spark_map() (fabrictools.transform.ParamResolver method) SplitColumn() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] Sum (fabrictools.powerquery.List attribute) (fabrictools.powerquery.list.List attribute), [1] SumIf() (fabrictools.excel.Excel static method), [1] (in module fabrictools.excel.aggregate) SumIfs() (fabrictools.excel.Excel static method), [1] (in module fabrictools.excel.aggregate)

T

Table (class in fabrictools.powerquery) (class in fabrictools.powerquery.table), [1] TableJobConfig (class in fabrictools.pipelines) (class in fabrictools.pipelines.config) target_relative_path (fabrictools.pipelines.config.TableJobConfig attribute) (fabrictools.pipelines.TableJobConfig attribute) Text (class in fabrictools.powerquery) (class in fabrictools.powerquery.text), [1] text (fabrictools.powerquery._common.type attribute) (fabrictools.powerquery.type attribute) TextJoin() (fabrictools.excel.Excel static method), [1] (in module fabrictools.excel.text) timeout_seconds (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute) to_snake_case() (in module fabrictools.quality) (in module fabrictools.quality.clean), [1] token_endpoint (fabrictools.IFSConfig attribute) (fabrictools.integrations.ifs.IFSConfig attribute)

transform_ai_column() (in module fabrictools) transform_to_prepared() (in module fabrictools) (in module fabrictools.prepare) (in module fabrictools.prepare.transform) transform_wide_month_suffix() (in module fabrictools) (in module fabrictools.transform) TransformColumns() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] TransformColumnTypes() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] Trim() (fabrictools.powerquery.Text static method) (fabrictools.powerquery.text.Text static method), [1] type (class in fabrictools.powerquery) (class in fabrictools.powerquery._common) Type (fabrictools.powerquery._common.Int64 attribute) (fabrictools.powerquery._common.Percentage attribute) (fabrictools.powerquery.Int64 attribute) (fabrictools.powerquery.Percentage attribute)

U

Unpivot() (fabrictools.powerquery.Table static method) (fabrictools.powerquery.table.Table static method), [1] Upper() (fabrictools.powerquery.Text static method) (fabrictools.powerquery.text.Text static method), [1]

upsert_key_columns (fabrictools.pipelines.config.TableJobConfig attribute) (fabrictools.pipelines.TableJobConfig attribute)

W

wide_value_columns() (in module fabrictools) (in module fabrictools.transform) with_ai_column() (in module fabrictools) with_year_month_from_fr_text() (in module fabrictools) (in module fabrictools.transform) write_ifs_data_to_lakehouse() (in module fabrictools.integrations.ifs) write_ifs_data_to_lakehouses() (in module fabrictools.integrations.ifs) write_lakehouse() (in module fabrictools) (in module fabrictools.io) (in module fabrictools.io.lakehouse)

write_lakehouses() (in module fabrictools) (in module fabrictools.io) (in module fabrictools.io.lakehouse) write_prepared_table() (in module fabrictools) (in module fabrictools.prepare) (in module fabrictools.prepare.transform) write_warehouse() (in module fabrictools) (in module fabrictools.io) (in module fabrictools.io.warehouse)

X

XLookup() (fabrictools.excel.Excel static method), [1] (in module fabrictools.excel.lookup)

Y

Year() (fabrictools.powerquery.Date static method) (fabrictools.powerquery.date.Date static method), [1]

year_from_fr_text() (in module fabrictools) (in module fabrictools.transform)