Auto-generated from: scripts/ — Last scanned: 2026-06-08T13:11:14.906459+00:00

Script Reference

108 utility scripts in scripts/:

Script	Description
`__init__.py`	Package marker — required so PyInstaller treats scripts/ as a package
`_lib_steps.py`	Emit structured step events for the fabric-ui JobRunner.
`add_bronze_shortcut.py`	Create a OneLake shortcut in a feature environment's FEAT-X-Bronze/LH_Bronze.
`apply_dictionary_learnings.py`	apply_dictionary_learnings.py
`apply_report_renames.py`	Apply column renames across all .json files in workspaces/reports/.
`archive_ax_data.py`	Archive AX 2012 data from Lakehouse_Bronze_AX to Azure Blob Storage.
`audit_dev_uat_parity.py`	DEV vs UAT workspace-item parity audit.
`audit_silent_failures.py`	Audit pipeline YAML for silent-failure patterns without justification.
`bootstrap_bronze_data.py`	Bootstrap Bronze data for first-time environment provisioning.
`bronze_git_sync.py`	Sync a Fabric Bronze workspace from git (updateFromGit).
`build_90d_flow_page.py`	Rebuild the '90+d Flow' page in Stock Report.Report/report.json.
`build_gold_local.py`	Build Gold models into local DuckDB. Zero Fabric CU.
`check_cascade.py`	Cascade detection: trace column/measure renames across all project layers.
`check_column_alignment.py`	Check dbt mart output columns against TMDL semantic model expectations.
`check_cu_utilization.py`	Check Fabric capacity CU utilization before starting a production dbt build.
`check_feature_env_activity.py`	Check feature environment activity and auto-teardown inactive environments.
`check_main_bindings.py`	check_main_bindings.py — PR gate for merges into main / release/*.
`check_no_stdin_reads.py`	Fail if any file under scripts/ has a read -p or input( in a non-allowlisted place.
`check_pipeline_parity.py`	Verify the three dbt build pipelines have the same step set.
`check_spn_access.py`	Check what Fabric API access the SPN actually has.
`cleanup_dbt_backups.py`	cleanup_dbt_backups.py
`cleanup_dev_workspaces.py`	Delete all SemanticModel and Report items from DEV Semantic/Reports workspaces.
`cleanup_uat_workspace_folders.py`	Delete leftover folders and zombie items from UAT-Semantic and UAT-Reports.
`compare_parallel_runs.py`	compare_parallel_runs.py
`configure_semantic_model_access.py`	Configure semantic model access and RLS role assignments.
`deploy_dataverse_shortcuts.py`	Create/sync Dataverse shortcuts in Lakehouse_Bronze.
`deploy_shortcuts.py`	Deploy all shortcuts in Lakehouse_Bronze from shortcuts.metadata.json.
`deploy_to_feature.py`	Deploy Fabric items to a feature environment.
`discover_gold_consumers.py`	Discover all active consumers of the current Lakehouse Gold / Gold Warehouse.
`download_bronze_to_local.py`	Download Bronze (Lakehouse) Delta tables from any provisioned environment as
`ensure_application_data_lists_mirror.py`	Ensure Application_Data_Lists MirroredDatabase exists in the Bronze workspace.
`ensure_gold_lakehouse_bronze.py`	Ensure Lakehouse_Bronze exists in Gold workspace with shortcuts pointing to Bronze workspace.
`execute_security_sql.py`	Execute SQL security scripts against a Fabric Warehouse using access token auth.
`export_dev_data.py`	export_dev_data.py
`fabric_connections.py`	Shared Cloud Connection (SCC) management for Fabric semantic models.
`fabric_git_sync.py`	Trigger Fabric workspace git sync (updateFromGit) for all workspaces in an environment.
`fabric_sync.py`	fabric_sync.py — safe UI↔git sync for feature-workspace developers.
`find_broken_report_refs.py`	Find report column references that don't match any semantic model column.
`fix_90d_flow_gaps.py`	Fix all spec §7 gaps in the '90+d Flow' page of Stock Report.
`generate-dev-stubs.py`	generate-dev-stubs.py
`generate_bronze_methods_config.py`	Generate functions/shared/config/bronze_methods.yaml from shortcut manifests.
`generate_changelog.py`	Generate a deployment changelog by diffing two dbt manifest.json files.
`generate_data_dictionary.py`	generate_data_dictionary.py
`generate_monitoring_report.py`	Generate the ETL Monitoring Power BI report (report.json) programmatically.
`generate_parameter_file.py`	Generate fabric-cicd parameter.yml files for environment-specific deployments.
`generate_transport_b2b_report.py`	Generate report.json for Transport B2B Analysis report.
`inject_env_banner.py`	Inject environment banner into Power BI report pages.
`inventory_sql_views.py`	Inventory existing SQL views on Gold Warehouse and Bronze Lakehouse SQL endpoints.
`lint_pipeline_yaml.py`	Lint Azure DevOps pipeline YAML files.
`manage_dbt_target.py`	Add or remove feature dbt targets from profiles.yml (Story 5d.3).
`migrate_ax_shortcuts.py`	Migrate AX shortcuts to cross-workspace OneLake shortcuts.
`migrate_bronze_schemas.py`	Migrate Lakehouse_Bronze shortcuts.metadata.json to schema-enabled layout.
`monitor_chronic_failures.py`	List pipelines whose last N runs were all failed; optionally disable schedules.
`persist_dbt_artifacts.py`	Persist dbt run artifacts to OneLake Bronze Lakehouse as Delta tables.
`populate_semantic_model_ids.py`	Populate UAT semantic model ID mappings in deployment/uat.yml.
`profile_loader.py`	Profile loader — loads, validates, and composes dev-profiles/*.yml.
`promote_cherry_pick.py`	Cherry-pick a merged PR onto a target release branch and open an ADO pull request.
`provision_feature_env.py`	Feature environment provisioning orchestrator (Story 5d.1, updated 5f.6 + Epic 10 full-stack).
`provision_sandbox.py`	Self-service sandbox provisioning.
`publish_workspace_app.py`	Validate workspace app configuration and verify reports exist in workspace.
`refresh_bronze_tables.py`	Refresh Bronze Lakehouse SQL endpoint metadata before dbt build.
`refresh_feat_gold.py`	Refresh a feature Gold Warehouse.
`refresh_semantic_models.py`	Refresh all semantic models in a Fabric workspace.
`rename_parquet_to_sql.py`	Rename columns in dev-data//*.parquet from Delta-logical (snake_case)
`sanitize_workspaces_for_main.py`	sanitize_workspaces_for_main.py
`screenshot_feature_report.py`	Export feature-workspace reports via Power BI REST and save locally.
`seed_feature_bronze.py`	Seed a feature branch Bronze Lakehouse with sample data from dev-data/.
`sync_broker_tables.py`	Sync broker tables by reading CSVs from Bronze Files/ shortcuts and writing Delta to Bronze Tables/.
`sync_ci_shortcuts.py`	sync_ci_shortcuts.py
`sync_cloud_parquets.py`	sync_cloud_parquets.py
`sync_descriptions_to_tmdl.py`	sync_descriptions_to_tmdl.py
`test_export_query.py`	Test an export query locally against Gold_Warehouse.
`test_spn_permissions.py`	Test sp-fabric-platform-admin SPN permissions for Epic 4.
`test_sql_endpoint_access.py`	Test connectivity to Gold Warehouse and Bronze Lakehouse SQL endpoints.
`update_tmdl_column_refs.py`	Update TMDL column references from old naming to snake_case per ADR-13.
`upload_reports_direct.py`	Upload reports to a Reports workspace via Fabric REST API directly.
`upload_to_bronze.py`	Upload a local file to a feature environment's FEAT-X-Bronze/LH_Bronze/Files/ folder.
`validate_bronze_immutability.py`	Validate Bronze immutability controls.
`validate_clean_provisioning.py`	Validate clean provisioning of the 4-workspace architecture.
`validate_connections.py`	Validate that the platform-admin SPN has access to all connections referenced in workspaces/.
`validate_credential_hygiene.py`	Credential hygiene validator for fabric_monorepo (Story 6.6, NFR-S3).
`validate_cutover.py`	Post-cutover validation script for the new production workspace.
`validate_deployment_config.py`	Validate deployment config files for missing or empty values.
`validate_descriptions.py`	validate_descriptions.py
`validate_new_datalake.py`	validate_new_datalake.py — One-off validation of Gold_Warehouse vs Lakehouse_Gold.
`validate_powerbi.py`	Pre-flight validator for Power BI semantic models + reports.
`validate_schema_dependencies.py`	validate_schema_dependencies.py
`validate_semantic_deployment.py`	Validate semantic model deployment: detect orphaned column references.
`verify_semantic_credentials.py`	Post-bind credential verification for Fabric semantic models.
`wait_for_sources.py`	Wait until all dbt source tables exist in the Fabric SQL endpoint.
`watch_main_pipelines.py`	Poll ADO REST for pipeline state on a target SHA; emit one line per status change.
`_lib_spn.sh`	=============================================================================
`_lib_tools.sh`	=============================================================================
`_lib_venv.sh`	=============================================================================
`create-dev-env.sh`	=============================================================================
`create_deployment_tag.sh`	Create a deployment tag and output git log since previous deployment.
`deploy-to-dev.sh`	=============================================================================
`dev-build.sh`	=============================================================================
`export-dev-data.sh`	=============================================================================
`generate_and_serve_docs.sh`	=============================================================================
`pr_prepare.sh`	=============================================================================
`provision_feature_env.sh`	=============================================================================
`rollback_prod.sh`	scripts/rollback_prod.sh
`setup-local.sh`	=============================================================================
`teardown-dev-env.sh`	=============================================================================
`teardown_feature_env.sh`	=============================================================================
`test_all_profiles.sh`	=============================================================================
`tf_autoimport_fabric_roles.sh`	=============================================================================