modern-data-warehouse-dataops
DataOps for Microsoft Data Platform technologies. https://aka.ms/dataops-repo
File Explorer
Download Latest Version (.zip)- databricks-best-practices-checklist.md
- databricks-cicd.instructions.md
- databricks-dataops.instructions.md
- databricks-infrastructure.prompt.md
- databricks-medallion.prompt.md
- databricks-setup.prompt.md
- databricks-testing.instructions.md
- databricks-troubleshooting.prompt.md
- fabric-best-practices-checklist.md
- fabric-cicd.instructions.md
- fabric-dataops.instructions.md
- fabric-infrastructure.prompt.md
- fabric-medallion.prompt.md
- fabric-setup.prompt.md
- fabric-testing.instructions.md
- fabric-troubleshooting.prompt.md
- bash.instructions.md
- bug.md
- designreview.md
- feature.md
- found-dead-links.md
- issue.md
- new-sample-setup.md
- sample-complete-review.md
- spike.md
- task.md
- userstory.md
- bicep-audit.yml
- broken-hyperlinks-check.yml
- code_quality_checks.yaml
- credscan.yml
- copilot-readme.md
- dependabot.yml
- PULL_REQUEST_TEMPLATE.md
- data_versioning.py
- README.md
- adf-loan-dev_arm_template.json
- ArmTemplate_0.json
- ArmTemplate_master.json
- arm_template.json
- README.md
- source_data_store.md
- adf_pipeline.JPG
- architecture.PNG
- versioned_data.JPG
- iac-build-validation.yml
- iac-pipeline.yml
- iac-template.yml
- main.tf
- output.tf
- variables.tf
- main.tf
- output.tf
- variables.tf
- main.tf
- output.tf
- variables.tf
- main.tf
- variables.tf
- locals.tf
- main.tf
- output.tf
- variables.tf
- main.tf
- output.tf
- variables.tf
- main.tf
- variables.tf
- README.md
- setup.sh
- devcontainer.json
- Dockerfile
- __init__.py
- test_main.py
- test_process.py
- test_sample.csv
- keyvault_wrapper.py
- main.py
- process.py
- README.md
- requirements.txt
- sql_wrapper.py
- README.md
- watermark.sql
- README.md
- ExceptionController.cs
- TelemetriesController.cs
- AuthorizeByTenantIdAttribute.cs
- ValidateDeviceAttribute.cs
- HttpRequestExceptionFilter.cs
- ValidateDeviceFilter.cs
- GuidFormatAttributes.cs
- CosmosContext.cs
- Device.cs
- DeviceInfo.cs
- Telemetry.cs
- TelemetryEntity.cs
- TenantIdHandler.cs
- launchSettings.json
- CosmosRepository.cs
- IRepository.cs
- RepositoryConstructor.cs
- TableTelemetryRepository.cs
- appsettings.json
- Program.cs
- Startup.cs
- WebApi.csproj
- .gitignore
- WebApi.sln
- architecture-without-routing.jpg
- postman-token1.png
- postman-token2.png
- postman-token3.png
- postman-token4.png
- postman-token5.png
- postman-token6.png
- AUTH.md
- POSTMAN.md
- GuidFormatAttributes.cs
- TableStorageConfig.cs
- Telemetry.cs
- ITableClientService.cs
- TableClientService.cs
- .gitignore
- .local.settings.json
- host.json
- Program.cs
- SplitAndSaveFunc.cs
- TelemetryProcessor.csproj
- azuredeploy.json
- azuredeploy.parameters.json
- create-one-stamp.yml
- README.md
- deploymentadf.ps1
- ParkingSensors_Anonymized_CSV.json
- ParkingSensors_Bronze_CSV.json
- ParkingSensors_Source_CSV.json
- IngestToBronze.json
- app_insights.json
- app_insights.parameters.json
- azure_function_datalakelogs.json
- azure_function_datalakelogs.parameters.json
- data_factory.json
- data_factory.parameters.json
- data_lake.json
- data_lake.parameters.json
- databricks.json
- databricks.parameters.json
- email_logic_app.json
- email_logic_app.parameters.json
- key_vault.json
- key_vault.parameters.json
- log_analytics.json
- log_analytics.parameters.json
- O365_connector.json
- O365_connector.parameters.json
- private_endpoint.json
- private_endpoint.parameters.json
- purview.json
- purview.parameters.json
- vnet.json
- vnet.parameters.json
- On-street_Parking_Bay_Sensors.csv
- On-street_Parking_Bay_Sensors.json
- On-street_Parking_Bay_Sensors_baylist.csv
- README.md
- dim_date.csv
- dim_time.csv
- cluster.config.json
- run.setup.config.json
- 00_setup.py
- 01_transform_presidio.py
- startup.sh
- architecture.png
- pipelines-and-scripts.md
- create-data-lake-log-sender-job.yml
- create-email-sender-job.yml
- create-infrastructure-job.yml
- app-insights.yml
- azure-function-datalakelogs.yml
- data-factory.yml
- data-lake.yml
- databricks.yml
- df-email-logic-app.yml
- key-vault.yml
- log-analytics.yml
- O365_connector.yml
- purview.yml
- vnet.yml
- dev-environment.yml
- prod-environment.yml
- test-environment.yml
- create-infrastructure.yml
- Set-AgentTools.ps1
- ADF-Pre-And-Post-Deploy.ps1
- Databricks-Post-Deploy.ps1
- New-ADFLinkedService.ps1
- New-EnvironmentVariables.ps1
- New-PurviewADFConnection.ps1
- New-PurviewADLSource.ps1
- New-PurviewDataScan.ps1
- New-StorageContainerFolders.ps1
- Set-ADL-RBAC.ps1
- Set-AdlLoggingProperties.ps1
- Set-AdlRoleAssignmentForLogSenderFunction.ps1
- Set-AuthToken.ps1
- Set-SPNOwnerToPurview.ps1
- function.json
- run.ps1
- .funcignore
- .gitignore
- host.json
- profile.ps1
- proxies.json
- requirements.psd1
- README.md
- .envtemplate
- devcontainer.json
- docker-compose.yml
- Dockerfile
- post_create.sh
- dim_date.csv
- dim_time.csv
- deploy-dedicated-sql-pool-job.yml
- deploy-synapse-workspace-job.yml
- deploy-wheel-job.yml
- integration-tests-job.yml
- azure-pipelines-cd-release.yml
- azure-pipelines-ci-artifacts.yml
- azure-pipelines-ci-qa-python.yml
- azure-pipelines-ci-qa-sql.yml
- README.md
- architecture.png
- CI_CD_process.png
- CI_CD_process_sequence.png
- devcontainer_build_error.png
- observability-app-insights-logs-in-monitor.png
- observability-app-insights-logs-in-synapse.png
- observability-log4j-logs-in-monitor.png
- observability-log4j-logs-in-synapse.png
- observability-pipeline-runs-in-monitor.png
- observability-pipeline-runs-in-synapse.png
- parking_sensors_dev_container_start.gif
- ReleasePipelineSynapse.png
- SynapseGithubIntegration.png
- SynapseRun.png
- tableview_create_db_user.png
- tableview_deploy.png
- tableview_run_notebook.png
- tableview_run_queryview.png
- tableview_sqladmin.png
- devcontainer.md
- external_table.md
- NDCOslo 2020 - DataOps for MDW.pdf
- NDCSydney2019-DataDevOps.pdf
- observability.md
- appinsights.bicep
- diagnostic_settings.bicep
- keyvault.bicep
- log_analytics.bicep
- storage.bicep
- synapse.bicep
- synapse_sql_pool.bicep
- main.bicep
- main.parameters.dev.json
- main.parameters.prod.json
- main.parameters.stg.json
- PowerBI_ParkingSensors.pbix
- clean_up.sh
- common.sh
- deploy_azdo_pipelines.sh
- deploy_azdo_service_connections_azure.sh
- deploy_azdo_service_connections_github.sh
- deploy_azdo_variables.sh
- deploy_infrastructure.sh
- deploy_synapse_artifacts.sh
- init_environment.sh
- verify_prerequisites.sh
- load_dim_date.sql
- load_dim_time.sql
- load_dw.sql
- dim_date.sql
- dim_location.sql
- dim_parking_bay.sql
- dim_st_marker.sql
- dim_time.sql
- fact_parking.sql
- dim_date.sql
- dim_location.sql
- dim_parking_bay.sql
- dim_st_marker.sql
- dim_time.sql
- fact_parking.sql
- AzureDataLakeStorage.sql
- CSVSkipHeaderFileFormat.sql
- ParquetFileFormat.sql
- ADLSCredentialKey.sql
- ext.sql
- MasterKeys.sql
- ddo_azuresqldw_dw.sqlproj
- Script.PostDeployment.sql
- Script.PostDeployment1.sql
- ddo_azuresqldw_dw.sln
- devcontainer.json
- docker-compose.yml
- Dockerfile
- dim_location.json
- dim_parking_bay.json
- dim_st_marker.json
- interim_parking_bay.json
- interim_sensor.json
- MelbParkingBayData.json
- MelbParkingSensorData.json
- __init__.py
- standardize.py
- transform.py
- util.py
- make.png
- test_annotation.png
- test_standardize.py
- test_transform.py
- .editorconfig
- AUTHORS.rst
- CONTRIBUTING.rst
- Dockerfile
- HISTORY.rst
- Makefile
- MANIFEST.in
- README.md
- requirements.txt
- requirements_dev.txt
- setup.cfg
- setup.py
- tox.ini
- requirements.txt
- ddo_transform-localdev-py2.py3-none-any.whl
- 00_setup.ipynb
- 01a_explore.ipynb
- 01b_explore_sqlserverless.ipynb
- 02_standardize.ipynb
- 03_transform.ipynb
- Ds_AdlsGen2_MelbParkingData.json
- Ds_Http_Parking_Bay.json
- Ds_Http_Parking_Bay_Sensors.json
- Ds_REST_MelbParkingData.json
- Ls_AdlsGen2_01.json
- Ls_Http_Parking_Bay_01.json
- Ls_KeyVault_01.json
- Ls_Rest_MelParkSensors_01.json
- P_Ingest_MelbParkingData.json
- create_db_user_template.sql
- create_external_table_template.sql
- T_Sched.json
- template-parameters-definition.json
- devcontainer.json
- docker-compose.yml
- Dockerfile
- __init__.py
- blob_storage.py
- sql.py
- __init__.py
- conftest.py
- test_synapse_pipeline_ingest_melbparkingdata.py
- .envtemplate
- README.md
- requirements.txt
- setup.cfg
- deploy.sh
- README.md
- azure-pipelines-ci-artifacts.yml
- dotnet-tools.json
- DeviceEvent.cs
- .gitignore
- DeviceIdFilter.cs
- host.json
- local.settings.template.json
- TemperatureEventsProj.csproj
- TemperatureFilter.cs
- DeviceIdFilterTest.cs
- TemperatureEventsProj.Test.csproj
- TemperatureFilterTest.cs
- .editorconfig
- host.json
- README.md
- TemperatureEventsSln.sln
- application_map.png
- azure_pipeline_setup.png
- azure_pipeline_var_group.png
- correlated_logs.png
- e2e_transaction_detail_parallel.png
- e2e_transaction_detail_sequential.png
- function-deviceidfilter.png
- function-temperaturefilter.png
- function_instances_from_logs.png
- function_instances_live_metrics.png
- loadtesting_git_import.png
- loadtesting_git_import_url.png
- observability_eventhubmetrics.png
- observability_portaldashboard.png
- temperature-events-architecture.png
- var_group_secrets.png
- main.tf
- variables.tf
- main.tf
- outputs.tf
- variables.tf
- locals.tf
- main.tf
- outputs.tf
- variables.tf
- locals.tf
- main.tf
- variables.tf
- infra-ado-ci-pipeline-test.yml
- infra-ado-ci-pipeline.yml
- infra-ado-pipeline-template.yml
- README.md
- setup.sh
- IoTSimulator.ps1
- loadtest-pipeline.yml
- LoadTestCheckResult.ps1
- README.md
- README.md
- deploymentadf.ps1
- ParkingSensors_Bronze_CSV.json
- ParkingSensors_Source_CSV.json
- DataLakeStorage.json
- KeyVault.json
- SourceDataStorage.json
- IngestToBronze.json
- On-street_Parking_Bay_Sensors.csv
- On-street_Parking_Bay_Sensors.json
- On-street_Parking_Bay_Sensors_baylist.csv
- README.md
- dim_date.csv
- dim_time.csv
- deploy-adf-job.yml
- integration-test-adf-job.yml
- azure-pipelines-cd-release.yml
- azure-pipelines-ci-artifacts.yml
- .gitkeep
- ADFRun.png
- architecture.PNG
- CICD-logical.PNG
- CICD.PNG
- CICDv2.PNG
- create-pull.png
- create-pull2.png
- integrationTestResultv2.PNG
- new_branch.png
- publish.png
- PublishADF.PNG
- ReleasePipeline.png
- ReleasePipelinev3.PNG
- .gitkeep
- azuredeploy.json
- azuredeploy.parameters.dev.json
- azuredeploy.parameters.prod.json
- azuredeploy.parameters.stg.json
- clean_up.sh
- common.sh
- deploy_azdo_pipelines.sh
- deploy_azdo_service_connections_azure.sh
- deploy_azdo_service_connections_github.sh
- deploy_azdo_variables.sh
- deploy_infrastructure.sh
- init_environment.sh
- verify_prerequisites.sh
- __init__.py
- blob_storage.py
- __init__.py
- conftest.py
- README.md
- test_pipeline_ingest_to_bronze.py
- requirements.txt
- deploy.sh
- README.md
- aks-for-aml.template.bicep
- standalone-aks.template.bicep
- machinelearning.template.bicep
- create_cluster.sh
- create_pat.sh
- create_secret_scope.sh
- post_cluster_create.sh
- pre_cluster_create.sh
- capture_log_metrics.sh
- spark-listeners-loganalytics_3.0.1_2.12-1.0.0.jar
- spark-listeners_3.0.1_2.12-1.0.0.jar
- azure_runner_docs_example.ipynb
- test-notebook.ipynb
- timezone_test.ipynb
- deployment.template.bicep
- workspace.template.bicep
- keyvault.template.bicep
- keyvaultsecrets.template.bicep
- eventhub.template.bicep
- loganalytics.template.bicep
- firewall.template.bicep
- privateendpoint.template.bicep
- routetable.template.bicep
- routetableFirewallRoute.template.bicep
- securitygroup.template.bicep
- vnet.template.bicep
- clientdevice.template.bicep
- managedIdentity.template.bicep
- enabled-monitoring.sh
- storageaccount.template.bicep
- .gitignore
- Architecture.jpg
- azuredeploy.json
- azuredeploy.parameters.json
- build.sh
- main.bicep
- README.md
- devcontainer.json
- Dockerfile
- settings.vscode.json
- workspace.parameters.json
- workspace.template.json
- IAC_Adb.png
- IAC_Architecture.png
- IAC_Deployment_Logs.png
- IAC_Keyvault.png
- IAC_Script_Deploy.png
- IAC_Script_Teardown.png
- IAC_Storage.png
- keyvault.parameters.json
- keyvault.template.json
- storageaccount.parameters.json
- storageaccount.template.json
- deploy.sh
- destroy.sh
- README.md
- lock.json
- project.json
- devcontainer.json
- Dockerfile
- settings.vscode.json
- __init__.py
- module_a_test.py
- __init__.py
- module_a.py
- deployment-example.json
- deployment_notebook.json
- deployment_notebook_new_cluster.json
- deployment_spark_python.json
- deployment_spark_python_new_cluster.json
- create-deployment-json.yml
- deploy-lib-job.yml
- deploy-notebook-job.yml
- deploy-spark-python-job.yml
- test-lib-job.yml
- test-notebook-job.yml
- test-spark-python-job.yml
- lib-pipelines.yml
- notebook-pipelines.yml
- spark-python-pipelines.yml
- architecture.png
- dbx-repo.png
- deploy-lib.png
- notebook-prod.png
- notebook-staging.png
- notebook-test.png
- pipelines.png
- pytest-output-devcon.png
- pytest-output.png
- spark-python-prod.png
- spark-python-staging.png
- variable-group.png
- variables.png
- main_notebook_a_test.py
- main_notebook_b_test.py
- main_notebook_sql_test.py
- module_b_notebook_test.py
- main_notebook_a.py
- main_notebook_b.py
- main_notebook_sql.py
- module_b_notebook.py
- __init__.py
- main_test.py
- __init__.py
- main_test.py
- __init__.py
- __init__.py
- main.py
- .gitignore
- pytest.ini
- README.md
- requirements.txt
- setup.py
- devcontainer.json
- Dockerfile
- settings.vscode.json
- configure-databricks-cli.sh
- deploy-default-and-hc-clusters.sh
- import-data-access-notebooks.sh
- upload-sample-data.sh
- .gitignore
- access-data-directly-via-account-key.ipy
- access-data-mount-via-ad-passthrough.ipy
- cluster-config.default.json
- cluster-config.high-concurrency.json
- deploy.sh
- README.md
- sample-data.us-population.json
- architecture-diagram.drawio.png
- cdf.jpeg
- contextualizedTable.png
- Create-SQL-graph.png
- demo-databricks-notebook-01.png
- demo-databricks-notebook.png
- graph01.png
- graph02.png
- graph03.png
- graph04.png
- graph05.png
- graph06.png
- graph07.png
- graph08.png
- graph09.png
- import_databricks.png
- Run-SQL-graph.png
- Scenario.png
- demo-contextualizaion.py
- demo-setup.py
- create-graph.sql
- DataContextualizationSolution.md
- README.md
- devcontainer.json
- Dockerfile
- settings.vscode.json
- workspace.parameters.json
- workspace.template.json
- firewall.parameters.json
- firewall.template.json
- ADB_Notebooks.png
- ADE_Adb.png
- ADE_Architecture.png
- ADE_Deployment.png
- ADE_Deployment_Logs.png
- ADE_Firewall.png
- ADE_Firewall_AR.png
- ADE_Firewall_Deny.png
- ADE_Hub.png
- ADE_IP.png
- ADE_Keyvault.png
- ADE_NSG.png
- ADE_PL.png
- ADE_Route.png
- ADE_Script_Deploy.png
- ADE_Script_Teardown.png
- ADE_Spoke.png
- ADE_Storage.png
- ADE_Subnet.png
- ADO_Pipeline_Code.png
- ADO_Pipeline_Create.png
- ADO_Pipeline_Repo.png
- ADO_Pipeline_Repo_Select.png
- ADO_Pipeline_Type.png
- ADO_Pipeline_Variables.png
- ADO_Result.png
- ADO_Run.png
- ADO_RunChart.png
- ADO_Runlog.png
- ADO_Variables.png
- Azure_Databricks_Icon.png
- Lumos_logo.png
- MIT.svg
- Open_Source.svg
- Status-Active.svg
- keyvault.parameters.json
- keyvault.template.json
- privateendpoint.parameters.json
- privateendpoint.template.json
- routetable.parameters.json
- routetable.template.json
- securitygroup.parameters.json
- securitygroup.template.json
- privateendpoint.parameters.json
- privateendpoint.template.json
- storageaccount.parameters.json
- storageaccount.template.json
- vnet.parameters.json
- vnet.template.json
- deploy.sh
- destroy.sh
- example-dotenv
- README.md
- devcontainer.json
- Dockerfile
- adb-asset-bundle-dev-deployment.yml
- adb-asset-bundle-linting.yml
- adb-asset-bundle-sandbox-deployment.yml
- architecture.png
- databricks-asset-bundle-deploymeny-pipeline.png
- .env_example
- dev.deploy.sh
- dev.destroy.sh
- locals.tf
- main.tf
- providers.tf
- variables.tf
- locals.tf
- main.tf
- outputs.tf
- providers.tf
- variables.tf
- locals.tf
- main.tf
- outputs.tf
- provider.tf
- variables.tf
- README.md
- hello_test.py
- generate-databricks-workflows.sh
- hello_test.job.yml
- databricks.yml
- README.md
- requirements-dev.txt
- ruff.toml
- Taskfile.yml
- devcontainer.json
- __init__.py
- configuration.py
- data_share_helper.py
- function.json
- .gitignore
- host.json
- local.settings.template.json
- requirements.txt
- bash_setup_infra.sh
- bash_setup_sp_permissions.sh
- ps_setup_infra.ps1
- ps_setup_sp_permissions.ps1
- add-data-share-permissions.png
- dataset.png
- invitation.png
- mapping.png
- schedule.png
- share_created.png
- snapshot.png
- subscription_created.png
- trigger.png
- dest.py
- requirements.txt
- source.py
- .gitignore
- README.md
- deploymentadf.ps1
- CustomerBronzeData.json
- CustomerDataDrop.json
- DataLakeStorage.json
- KeyVault.json
- IngestCustomerData.json
- Customers.csv
- architecture.png
- azuredeploy.json
- azuredeploy.parameters.dev.json
- azuredeploy.parameters.prod.json
- azuredeploy.parameters.stg.json
- --name
- --resource-group
- --resource-type
- clean_up.sh
- common.sh
- delete_purview_data.sh
- deploy_infrastructure.sh
- deploy_purview_linkedservices.sh
- deploy_purview_spn.sh
- get_purview_access_token.sh
- init_environment.sh
- search_advanced.sh
- verify_prerequisites.sh
- deploy.sh
- README.md
- action.yml
- entrypoint.sh
- functions-lib-to-set-purview-permissions.sh
- README.md
- data_lifecycle_rules.png
- storage_accounts.png
- storage_containers.png
- main.tf
- terraform.auto.tfvars
- variables.tf
- README.md
- README.md
- devcontainer.json
- ASA-job.PNG
- Bicep-doc.PNG
- BLOB-OUT.PNG
- e2e-test.PNG
- InkedIoT-Simulator_LI.jpg
- e2e.ts
- temperature_equal_to_27_degrees.json
- temperature_greater_than_27_degrees.json
- temperature_less_than_27_degrees.json
- testConfig.json
- .gitignore
- asaproj.json
- containers.bicep
- iothubs.bicep
- JobConfig.json
- main.bicep
- README.md
- samplecicdpipeline.yml
- streamanalytics-tech-sample.asaql
- streamingjobs.bicep
- README.md
- .envtemplate
- devcontainer.json
- docker-compose.yml
- Dockerfile
- devcontainer_build_error.png
- parking_sensors_dev_container_start.gif
- SynapseRun.png
- devcontainer.md
- keyvault.bicep
- storage.bicep
- synapse.bicep
- synapse_sql_pool.bicep
- main.bicep
- main.parameters.dev.json
- clean_up.sh
- common.sh
- deploy_infrastructure.sh
- deploy_synapse_artifacts.sh
- init_environment.sh
- verify_prerequisites.sh
- ETL_sample.ipynb
- Ds_SqlDW_Table_template.json
- Ls_KeyVault_01_template.json
- P_Sample3_template.json
- T_Stor_template.json
- Df_SaveToSQL.json
- Ds_AdlsGen2_Data.json
- Ds_AdlsGen2_Interim.json
- Ds_Egress_Parquet.json
- Ds_Ingest_CSV.json
- Ls_AdlsGen2_01.json
- README.md
- README.md
- devcontainer.json
- docker-compose.yml
- Dockerfile
- dim_date.csv
- adls.py
- local_file.py
- sql.py
- processed_parquet_file.parquet
- __init__.py
- conftest.py
- test_synapse_pipeline_sample3.py
- pipelineutils.py
- .envtemplate
- README.md
- requirements.txt
- setup.cfg
- deploy.sh
- README.md
- devcontainer.json
- Dockerfile
- country_list.csv
- Architecture_design.png
- IAC_package.png
- IAC_Script_Deploy.png
- IAC_Storage.png
- IAC_Synapse.png
- pipeline_run.png
- pipeline_run_asia.png
- spark-pool1.png
- spark-pool2.png
- spark_table_asia.png
- Spark_table_full.png
- __init__.py
- data_filter.py
- README.MD
- setup.py
- __init__.py
- md5.py
- README.MD
- setup.py
- deploy.sh
- destroy.sh
- .gitignore
- csv_dataset.json
- linked_service.json
- OrchestratorNotebook.ipynb
- pipeline.json
- README.md
- .envtemplate
- devcontainer.json
- docker-compose.yml
- Dockerfile
- CLS.jpg
- container.jpg
- datalake_after_field_query_delete.jpg
- datalake_after_folder_delete.jpg
- datalake_after_ingestion.jpg
- datalake_after_running_vacuum.jpg
- datalake_config_json.jpg
- deltalake_folders.jpg
- NO_AAD_MEMBER.jpg
- SSMS.jpg
- stored_procedure_details.jpg
- views_synapse_studio.jpg
- keyvault.bicep
- storage.bicep
- synapse.bicep
- main.bicep
- datalake_config_template.json
- common.sh
- deploy_infrastructure.sh
- deploy_synapse_artifacts.sh
- verify_prerequisites.sh
- __init__.py
- synadlsaccess.py
- requirements.txt
- setup.py
- Nb_NYCTaxi_Config_Operations_Library.ipynb
- Nb_NYCTaxi_Config_Operations_Library_No_Wheel.ipynb
- Nb_NYCTaxi_Convert_Parquet_to_Delta.ipynb
- Nb_NYCTaxi_Run_Data_Retention.ipynb
- Nb_NYCTaxi_Run_Data_Retention_No_Wheel.ipynb
- Ds_NYCTaxi_ADLS2.json
- Ds_NYCTaxi_ADLS2_Folder.json
- Ds_NYCTaxi_ADLS2_Year_Folder.json
- Ds_NYCTaxi_Config.json
- Ds_NYCTaxi_HTTP.json
- Ls_NYCTaxi_ADLS2.json
- Ls_NYCTaxi_ADLS2_Folder.json
- Ls_NYCTaxi_Config.json
- Ls_NYCTaxi_HTTP.json
- Ls_NYCTaxi_KeyVault.json
- Ls_NYCTaxi_Synapse_Serverless_db.json
- Ls_NYCTaxi_Synapse_Serverless_master.json
- Pl_NYCTaxi_0_Main.json
- Pl_NYCTaxi_1_Setup.json
- Pl_NYCTaxi_2_CreateServerlessView.json
- Pl_NYCTaxi_2_IngestData.json
- Pl_NYCTaxi_Run_Data_Retention.json
- Sc_Column_Level_Security.sql
- Tg_NYCTaxi_0_Main.json
- adlsaccess-1.0-py3-none-any.whl
- deploy.sh
- README.md
- README.md
- destination.json
- source.json
- adls_connection.json
- keyvault_connection.json
- copy_data.json
- trigger1.json
- arm-template-parameters-definition.json
- publish_config.json
- adf_deploy_to_dev_env.png
- adf_deploy_to_preprod_env.png
- adf_deployment_architecture.png
- adf_link_to_git.png
- new_branch.png
- azuredeploy.json
- adf-deployment-multi-env.yml
- adf-deployment.yml
- cereal.csv
- deploy_azdo_pipelines.sh
- deploy_azdo_service_connections_azure.sh
- deploy_azdo_variables.sh
- deploy_infra.sh
- DEPLOYMENT_STEPS.md
- README.md
- devcontainer.json
- azurebatch_ls.json
- azurebatchstorage_ls.json
- temp_azurebatch_ls.json
- pipeline.json
- deploy-pipeline.sh
- README.md
- main.tf
- outputs.tf
- variables.tf
- main.tf
- output.tf
- variables.tf
- main.tf
- outputs.tf
- variables.tf
- main.tf
- output.tf
- storage-container.json
- variables.tf
- main.tf
- output.tf
- variables.tf
- main.tf
- variables.tf
- main.tf
- outputs.tf
- variables.tf
- main.tf
- variables.tf
- main.tf
- outputs.tf
- variables.tf
- main.tf
- output.tf
- variables.tf
- .gitignore
- main.tf
- outputs.tf
- provider.tf
- README.md
- terraform.tfvars
- variables.tf
- adf-batch-integration-design.svg
- apply-output.png
- author-pipelines.png
- deployed-resources-output.png
- destroy-output.png
- init-output.png
- jobs.png
- local-debug.png
- pipeline-output.png
- pipeline-run.png
- plan-output.png
- post-apply-output.png
- pre-processing-usecase.map.drawio.svg
- sample-pipeline.png
- storage-mount.png
- terraform-vars.png
- devcontainer.json
- Dockerfile
- __init__.py
- job.py
- task.py
- __init__.py
- extractscheduler.py
- extracttasks.py
- taskbuilder.py
- __init__.py
- config.py
- __init__.py
- batchclient.py
- confighelper.py
- enums.py
- keyvaultclient.py
- extract.py
- .gitignore
- env.template
- README.md
- requirements.txt
- devcontainer.json
- _slash_can_bus_dbw_slash_can_rx.csv
- _slash_center_camera_slash_camera_info.csv
- _slash_center_camera_slash_image_color_slash_compressed.csv
- _slash_diagnostics.csv
- _slash_ecef_slash_.csv
- _slash_fix.csv
- _slash_imu_slash_data.csv
- _slash_left_camera_slash_camera_info.csv
- _slash_left_camera_slash_image_color_slash_compressed.csv
- _slash_pressure.csv
- _slash_right_camera_slash_camera_info.csv
- _slash_right_camera_slash_image_color_slash_compressed.csv
- _slash_time_reference.csv
- _slash_vehicle_slash_brake_info_report.csv
- _slash_vehicle_slash_brake_report.csv
- _slash_vehicle_slash_filtered_accel.csv
- _slash_vehicle_slash_fuel_level_report.csv
- _slash_vehicle_slash_gear_report.csv
- _slash_vehicle_slash_gps_slash_fix.csv
- _slash_vehicle_slash_gps_slash_time.csv
- _slash_vehicle_slash_gps_slash_vel.csv
- _slash_vehicle_slash_imu_slash_data_raw.csv
- _slash_vehicle_slash_joint_states.csv
- _slash_vehicle_slash_misc_1_report.csv
- _slash_vehicle_slash_sonar_cloud.csv
- _slash_vehicle_slash_steering_report.csv
- _slash_vehicle_slash_surround_report.csv
- _slash_vehicle_slash_suspension_report.csv
- _slash_vehicle_slash_throttle_info_report.csv
- _slash_vehicle_slash_throttle_report.csv
- _slash_vehicle_slash_tire_pressure_report.csv
- _slash_vehicle_slash_wheel_speed_report.csv
- _slash_velodyne_packets.csv
- sample-data.bag
- app.py
- deploy-processor.sh
- Dockerfile
- README.md
- README.md
- README.md
- azuresql_addcolumn.PNG
- azuresql_azure_resources.PNG
- azuresql_builds.PNG
- azuresql_gitbranchcheckout.PNG
- azuresql_gitcommitpush.PNG
- azuresql_pipelines.PNG
- azuresql_prvalidation.PNG
- azuresql_release.PNG
- azuresql_service_connections.PNG
- azuresql_viewchanges.PNG
- azuredeploy.json
- azure-pipelines-01-validate-pr.yml
- azure-pipelines-02-build.yml
- azure-pipelines-03-simple-multi-stage.yml
- azure-pipelines-04-multi-stage-predeploy-test.yml
- clean_up.sh
- common.sh
- deploy_azure_pipelines_01_validate_pr.sh
- deploy_azure_pipelines_02_build.sh
- deploy_azure_pipelines_03_simple_multi_stage.sh
- deploy_azure_pipelines_04_multi_stage_predeploy_test.sh
- init_environment.sh
- ufnGetAllCategories.sql
- ufnGetCustomerInformation.sql
- ufnGetSalesOrderStatusText.sql
- uspLogError.sql
- uspPrintError.sql
- BuildVersion.sql
- ErrorLog.sql
- AccountNumber.sql
- Flag.sql
- Name.sql
- NameStyle.sql
- OrderNumber.sql
- Phone.sql
- SalesOrderNumber.sql
- Address.sql
- Customer.sql
- CustomerAddress.sql
- Product.sql
- ProductCategory.sql
- ProductDescription.sql
- ProductModel.sql
- ProductModelProductDescription.sql
- SalesOrderDetail.sql
- SalesOrderHeader.sql
- vGetAllCategories.sql
- vProductAndDescription.sql
- vProductModelCatalogDescription.sql
- SalesLT.sql
- ddo_samples_azuresql.sqlproj
- ddo_samples_azuresql.sln
- deploy.sh
- README.md
- README.md
- bash.md
- .envtemplate
- create_env.js
- devcontainer.json
- docker-compose.yml
- Dockerfile
- post_create.sh
- deploymentadf.ps1
- Ds_AdlsGen2_ParkingData.json
- Ds_Http_Parking_Locations.json
- Ds_Http_Parking_Sensors.json
- Ds_REST_ParkingData.json
- mdwdops-adf-dev-16.json
- Ls_AdlsGen2_01.json
- Ls_AzureDatabricks_01.json
- Ls_AzureSQLDW_01.json
- Ls_Http_DataSimulator.json
- Ls_KeyVault_01.json
- Ls_Rest_ParkSensors_01.json
- P_Ingest_ParkingData.json
- T_Sched.json
- arm-template-parameters-definition.json
- package.json
- sensorLocations.json
- sensors.json
- sensorTypeRegistry.js
- ParkingBaySensor.js
- Sensor.js
- .env
- app.js
- package.json
- web.config
- dim_date.csv
- dim_time.csv
- catalog.external.location.json
- cluster.config.json
- cluster.config.template.json
- data.external.location.json
- job.setup.config.json
- libs.config.json
- run.setup.config.json
- storage.credential.json
- uc.json
- 00_setup.py
- 01_explore.py
- 02_standardize.py
- 03_transform.py
- Makefile
- deploy-adf-job.yml
- deploy-azuresqldb-job.yml
- deploy-databricks-job.yml
- integration-tests-job.yml
- azure-pipelines-cd-release.yml
- azure-pipelines-ci-artifacts.yml
- azure-pipelines-ci-qa-python.yml
- azure-pipelines-ci-qa-sql.yml
- README.md
- ADFRun.png
- architecture.png
- CI_CD_process.drawio.png
- CI_CD_process_sequence.drawio.png
- data_quality_report.png
- databricks_ws.png
- devcontainer_build_error.png
- parking_sensors_dev_container_start.gif
- PBI_parking_sensors.png
- ReleasePipeline.png
- unity-catalog-architecture.drawio.png
- unity-catalog-architecture.drawio.svg
- devcontainer.md
- NDCOslo 2020 - DataOps for MDW.pdf
- NDCSydney2019-DataDevOps.pdf
- actiongroup.bicep
- alerts.bicep
- appinsights.bicep
- appservice.bicep
- dashboard.bicep
- data_quality_workbook.bicep
- databricks.bicep
- datafactory.bicep
- diagnostic_settings.bicep
- keyvault.bicep
- log_analytics.bicep
- storage.bicep
- synapse_sql_pool.bicep
- main.bicep
- main.parameters.dev.json
- main.parameters.prod.json
- main.parameters.stg.json
- PowerBI_ParkingSensors.pbix
- build_dependencies.sh
- clean_up.sh
- common.sh
- configure_databricks.sh
- configure_unity_catalog.sh
- databricks_common.sh
- deploy_adf_artifacts.sh
- deploy_azdo_pipelines.sh
- deploy_azdo_service_connections_azure.sh
- deploy_azdo_service_connections_github.sh
- deploy_azdo_variables.sh
- deploy_infrastructure.sh
- init_environment.sh
- verify_prerequisites.sh
- load_dim_date.sql
- load_dim_time.sql
- load_dw.sql
- dim_date.sql
- dim_location.sql
- dim_parking_bay.sql
- dim_st_marker.sql
- dim_time.sql
- fact_parking.sql
- dim_date.sql
- dim_location.sql
- dim_parking_bay.sql
- dim_st_marker.sql
- dim_time.sql
- fact_parking.sql
- AzureDataLakeStorage.sql
- CSVSkipHeaderFileFormat.sql
- ParquetFileFormat.sql
- ADLSCredentialKey.sql
- ext.sql
- MasterKeys.sql
- ddo_azuresqldw_dw.sqlproj
- Script.PostDeployment.sql
- Script.PostDeployment1.sql
- ddo_azuresqldw_dw.sln
- devcontainer.json
- docker-compose.yml
- Dockerfile
- __init__.py
- standardize.py
- transform.py
- util.py
- make.png
- test_annotation.png
- test_standardize.py
- test_transform.py
- .editorconfig
- AUTHORS.rst
- CONTRIBUTING.rst
- Dockerfile
- HISTORY.rst
- Makefile
- MANIFEST.in
- README.md
- requirements.txt
- requirements_dev.txt
- setup.py
- tox.ini
- devcontainer.json
- docker-compose.yml
- Dockerfile
- __init__.py
- blob_storage.py
- sql.py
- __init__.py
- conftest.py
- test_pipeline_ingest_parkingdata.py
- .envtemplate
- README.md
- requirements.txt
- deploy_pause_resume_synapse.ps1
- pause_resume_synapse.ps1
- README_pause_resume_synapse.md
- deploy.sh
- README.md
- 001_parking_sensor_synapse.md
- __template.md
- a_workspace_package_with_name_already_exists.png
- conditional_access_error.png
- set_o_xtrace.png
- token_expiration_workaround.png
- wsl_cannot_recognize_env_var.png
- ADFRun.png
- architecture.png
- CI_CD_process.png
- CI_CD_process_sequence.png
- CI_CD_process_simplified.drawio
- CI_CD_process_simplified.png
- PBI_parking_sensors.png
- pre_commit_1_git_commit.png
- pre_commit_2_manual_run.png
- Release_1_Agent_DeployToDatabricks.png
- ReleasePipeline.png
- deploy.ps1
- deploy.sh
- README.md
- parking_sensors_troubleshooting.md
- pre_commit_guide.md
- run-deployment-pipelines.ps1
- update-workspace-from-git.ps1
- azdo-fabric-cd-release-with-approvals.yml
- azdo-fabric-cd-release.yml
- README.md
- azdo_pipeline_execution.png
- default-lakehouse.png
- dep_pipeline.png
- fabric-cicd-update-definition-focus.png
- fabric-cicd-update-definition.drawio.png
- fabric-cicd.drawio
- fabric-cicd.drawio-update-def.svg
- fabric-cicd.drawio.svg
- gitflow-based-deployment.drawio
- gitflow-based-deployment.svg
- implication-of-deployment-pipeline.drawio
- implication-of-deployment-pipeline.svg
- manual_approval.png
- manual_approval_2.png
- fabric_capacity.bicep
- main.bicep
- params.json-template
- .envtemplate
- lakehouse-file-upload.png
- README.md
- requirements.txt
- upload-file-to-lakehouse.py
- update-token-to-azdo-variable.sh
- pl-covid-data-content.json
- nb-city-safety.ipynb
- nb-covid-data.ipynb
- .envtemplate
- bootstrap.sh
- issues-limitations-and-workarounds.md
- README.md
- ci.yaml
- release_pipeline.yml
- .gitlab-ci.yml
- README.md
- item-definition.json
- item-metadata.json
- notebook-content.ipynb
- item-definition.json
- item-metadata.json
- pipeline-content.json
- item-metadata.json
- architecture_and_workflow.png
- new_branch.sh
- params.psd1
- update_from_git_to_ws.ps1
- update_from_ws_to_git.ps1
- README.md
- devcontainer.json
- docker-compose.yaml
- Dockerfile
- post_create.sh
- application.cfg.template
- lakehouse_ddls.yaml
- dim_date.csv
- dim_time.csv
- build_adls_files.sh
- build_workspace.py
- cleanup_workspace.py
- requirements.txt
- update_environment.py
- utils.py
- publish-adls-artifacts.yml
- publish-fabric-env-artifacts.yml
- azure-pipelines-ci-artifacts.yml
- azure-pipelines-ci-qa-cleanup.yml
- azure-pipelines-ci-qa.yml
- adr_fabric_cicd.md
- adr_naming_convention.md
- build_and_release_pipelines.md
- known_issues_limitations_and_faqs.md
- environment.yml
- spark_pool_settings.yml
- __init__.py
- test_setup.py
- __init__.py
- fabric_test_utils.py
- requirements.txt
- adls-shortcut.png
- admin-portal-allow-apis.png
- application-enterprise-object-id.png
- azure-devops-repo.png
- azure-repo-directory-structure.png
- azure-resources.png
- branch-out-to-new-workspace.gif
- config-update-workflow.drawio
- config-update-workflow.png
- create-pr.gif
- creating-onelake-shortcut.gif
- data-pipeline-execution.png
- dev-container.png
- fabric-archi-cicd-highlevel-end.drawio
- fabric-archi-cicd-highlevel-start.drawio
- fabric-archi.drawio
- fabric-archi.png
- fabric-cicd-option1-sequence.png
- fabric-cicd-option1.drawio
- fabric-cicd-option1.png
- fabric-cicd-option2.drawio
- fabric-cicd-option2.png
- fabric-resources.png
- graph-api-permission.png
- make-workspace-changes.gif
- managed-identity-permission.png
- missing-lakehouse-environment.png
- pipeline-interactive-login.png
- published-artifacts.gif
- role-assignment-condition-old.png
- role-assignment-condition.png
- storage-error.png
- trigger-cleanup-pipeline.gif
- uncommitted-environment.gif
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- variables.tf
- versions.tf
- main.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- output.tf
- variables.tf
- versions.tf
- main.tf
- outputs.tf
- variables.tf
- versions.tf
- main.tf
- variable.tf
- versions.tf
- data.tf
- locals.tf
- main.tf
- outputs.tf
- providers.tf
- variables.tf
- versions.tf
- __init__.py
- ddo_transform_standardize.py
- ddo_transform_transform.py
- otel_monitor_invoker.py
- dim_location.json
- dim_parking_bay.json
- dim_st_marker.json
- interim_parking_bay.json
- interim_sensor.json
- parking_bay_data.json
- parking_sensor_data.json
- README.md
- __init__.py
- test_standardize.py
- test_transform.py
- __init__.py
- __init__.py
- requirements.txt
- setup_workspace.py
- cleanup_infrastructure.sh
- common.sh
- configure_resource_groups.sh
- deploy_azdo_pipelines.sh
- deploy_infrastructure.sh
- setup_azdo_repository.py
- setup_fabric_environment.py
- upload_config_files.sh
- verify_prerequisites.sh
- 00_setup.ipynb
- 02_standardize.ipynb
- 03_transform.ipynb
- 00-main.json
- .envtemplate
- cleanup.sh
- deploy.sh
- prepare_azure_repo.sh
- README.md
- data_lineage_in_purview.gif
- feature_lineage.gif
- model_training_lineage.gif
- data_pipeline_01.png
- data_pipeline_02.png
- data_pipeline_03.png
- data_pipeline_04.png
- data_pipeline_05.png
- data_pipeline_06.png
- data_pipeline_07.png
- data_pipeline_08.png
- data_pipeline_09.png
- data_pipeline_10.png
- data_pipeline_11.png
- data_pipeline_12.png
- data_pipeline_13.png
- data_pipeline_15.png
- add_lh_to_notebook.png
- data_pipeline.png
- fabric_env_1.png
- fabric_spark_env_1.png
- fabric_spark_env_2.gif
- fabric_spark_env_3.gif
- featurestore_1.png
- fs_architecture.png
- import_all_notebooks.png
- inferencing_result.png
- inferencing_result_2.png
- managed_feature_store.gif
- model_list.png
- model_type.png
- pipeline_image.png
- pipeline_run.png
- Publiclibrary.yml
- sparkProperties.yml
- deploy-azure-resources.ipynb
- data_catalog_and_lineage.ipynb
- data_cleansing.ipynb
- data_ingestion.ipynb
- data_transformation.ipynb
- data_validation.ipynb
- exploratory_data_analysis.ipynb
- feature_set_registration.ipynb
- feature_set_retrieval.ipynb
- model_inferencing.ipynb
- model_training.ipynb
- utils.ipynb
- README.md
- README.md
- .gitignore
- .markdownlint.yml
- .pre-commit-config.yaml
- .yamllint.yaml
- CODE_OF_CONDUCT.md
- CONTRIBUTING.md
- LICENSE
- linkspector.yml
- package-lock.json
- pyproject.toml
- README.md
- SECURITY.md
π Installation Guide
git clone https://github.com/Azure-Samples/modern-data-warehouse-dataops
Downloads the entire project code from GitHub to your computer.
cd modern-data-warehouse-dataops
Moves into the project folder you just downloaded.
2. Docker
Easy Recommended- Git Needed to download the project code from GitHub.
- Docker Desktop Needed to build and run containers. Install it and keep it running in the background.
docker build -f archive/e2e_samples/parking_sensors_synapse/src/ddo_transform/Dockerfile -t modern-data-warehouse-dataops .
Builds a runnable image based on the Dockerfile.
docker run -p 8080:80 modern-data-warehouse-dataops
Runs the built image as an actual container.
3. .NET
Mediumcd archive/e2e_samples/deployment_stamps/api
This project's files live in a subfolder, so move into it first.
dotnet restore
Downloads the packages the project depends on.
dotnet run
Builds the project and runs it immediately.
4. Node.js
Easycd databricks/parking_sensors/adf
This project's files live in a subfolder, so move into it first.
npm install
Downloads and installs the libraries listed in package.json.
npm start
Starts the development/run server.
5. Python
Easypip install -r archive/e2e_samples/dataset_versioning/sql/data_generator/requirements.txt
Installs the Python libraries listed in requirements.txt (or similar).
jupyter notebook
Launches Jupyter in your browser so you can open and run the notebook (.ipynb) files.
6. Make
Medium- Git Needed to download the project code from GitHub.
- Make Usually pre-installed on Linux/macOS. On Windows, install separately (e.g. via MSYS2 or WSL).
cd archive/e2e_samples/parking_sensors_synapse/src/ddo_transform
This project's files live in a subfolder, so move into it first.
make
Compiles the code based on the generated build configuration to produce an executable.
