azure-synapse-analytics-workshop-400
No description available.
File Explorer
Download Latest Version (.zip)- README.md
- Lab 05 - Exercise 3 - Column Level Security.sql
- Lab 05 - Exercise 3 - Dynamic Data Masking.sql
- Lab 05 - Exercise 3 - Row Level Security.sql
- Activity 03 - Data Warehouse Optimization.sql
- README.md
- convert-to-hex.ipynb
- convert-to-hex.ps1
- Lab 06 - Machine Learning.ipynb
- Lab 06 - Part 1 - Synapse ML.ipynb
- Lab 06 - Part 2 - AutoML with Spark.ipynb
- customers-lake-database.png
- query-delta-table.png
- Lab 07 - Spark.ipynb
- Lab 07 - Part 1 - Spark DataFrames.ipynb
- Lab 07 - Part 2 - Spark Delta Lake.ipynb
- Lab 07 - Part 3 - Spark Hyperspace.ipynb
- import-notebook.png
- Activity 05 - Model Training SOLUTION.ipynb
- Activity 05 - Model Training.ipynb
- Activity 05 - Solution.txt
- activity05-model-implementation-with-predict.md
- README.md
- README.md
- 00-asa-workspace-core.json
- 00-auto-pause.ps1
- 00-cosmosdb-setup.ps1
- 01-environment-setup-delta.ps1
- 01-environment-setup-poc.ps1
- 01-environment-setup.ps1
- 03-environment-validate.ps1
- 04-environment-spark-test.ps1
- 05-environment-fix.ps1
- 06-environment-poc-01-delta.ps1
- 06-environment-poc-01.ps1
- 07-01-environment-poc-pre-validate.ps1
- 07-02-environment-poc-validate.ps1
- 08-01-environment-cleanup-cosmosdb.ps1
- 08-02-environment-cleanup-sql-remove.ps1
- 08-03-environment-cleanup-asa.ps1
- 08-04-environment-cleanup-sql-rebuild.ps1
- 08-05-environment-cleanup-sql-rebuild-sale-small.ps1
- 08-environment-cleanup.ps1
- 09-environment-cleanup-validate.ps1
- 11-environment-validate.ps1
- 12-environment-scale-test.ps1
- README.md
- XX-thread-start.ps1
- customer_profile_cosmosdb.json
- wwi02_date_adls.json
- wwi02_date_asa.json
- wwi02_online_user_profiles_01_adal.json
- wwi02_poc_customer_adls.json
- wwi02_poc_customer_asa.json
- wwi02_product_adls.json
- wwi02_product_asa.json
- wwi02_sale_small_adls.json
- wwi02_sale_small_asa.json
- wwi02_sale_small_workload_01_asa.json
- wwi02_sale_small_workload_02_asa.json
- lab-artifacts.md
- bhol_azurecloudshellmenu.png
- bhol_clicodescreen.png
- bhol_createaresource.png
- bhol_customdeploymentform.png
- bhol_devicelogin.png
- bhol_downloadzip.png
- bhol_powershellintegratedselection.png
- bhol_resourcegroupform.png
- bhol_sampleshelloutput.png
- bhol_searchmarketplaceresourcegroup.png
- bhol_selectallrun.png
- shell-login-result.png
- Setup - PoC.ipynb
- Setup - Probe.ipynb
- execute_business_analyst_queries.json
- execute_data_analyst_and_ceo_queries.json
- import_customer_profiles_into_cosmosdb.json
- import_poc_customer_data.json
- load_sql_pool_from_data_lake.json
- solliance-synapse-automation.psm1
- AzureCreds.ps1
- AzureCreds.txt
- deploy.json
- deploy.parameters.json
- deploy.parameters.post.json
- policy.json
- post-install-script01.ps1
- post-install-script02.ps1
- rbac.json
- 01-create-logins.sql
- 02-create-users.sql
- 03-create-schemas.sql
- 04-create-tables-in-wwi-schema.sql
- 05-create-tables-in-wwi-ml-schema-delta.sql
- 05-create-tables-in-wwi-ml-schema.sql
- 06-create-tables-in-wwi-security-schema.sql
- 07-create-wwi-perf-sale-heap.sql
- 08-create-wwi-perf-sale-partition01.sql
- 09-create-wwi-perf-sale-partition02.sql
- 10-create-wwi-perf-sale-index.sql
- 11-create-wwi-perf-sale-hash-ordered.sql
- 12-create-wwi-perf-sale-hash-projection.sql
- 13-create-wwi-perf-sale-hash-projection2.sql
- 14-create-wwi-perf-sale-hash-projection-big.sql
- 15-create-wwi-perf-sale-hash-projection-big2.sql
- 16-create-poc-schema.sql
- 17-create-wwi-poc-sale-heap.sql
- 18-get-sql-pool-artifacts.sql
- 19-cleanup-sql-pool.sql
- _test.json
- blob_storage_linked_service.json
- cognitive_services_linked_service.json
- cosmos_db_linked_service.json
- data_lake_linked_service.json
- integration_runtime.json
- key_vault_linked_service.json
- machine_learning_linked_service.json
- spark_notebook.json
- spark_notebook_session.json
- sql_pool_key_vault_linked_service.json
- sql_pool_script.json
- sql_script.json
- README.md
- Analytics_Surge_PPT_Template_03_16_20_v2a.pptx
- Digital Content Storyboard.pptx
- MASTER PPT_SCAFFOLDING.pptx
- Day 1 - Technical Bootcamp.pdf
- Day 1 - Technical Bootcamp.pptx
- appendpropertynames_script.png
- attach-spark-pool.png
- campaign-analytics-dataset-connection.png
- campaign-analytics-dataset-preview-data.png
- campaign-analytics-query-results-chart.png
- campaign-analytics-query-results.png
- copy-data-step1.png
- copy-data-step2-connection.png
- copy-data-step2-dataset.png
- copy-pipeline-trigger-now.png
- cosmos-dataset-preview-data-link.png
- cosmos-db-dataset-preview-data.png
- cosmos-db-dataset-schema.png
- create-adls-dataset.png
- create-campaign-analytics-dataset.png
- create-cosmos-db-dataset.png
- create-cosmos-db-linked-service-step1.png
- create-cosmos-db-linked-service.png
- daily-sales-counts-chart.png
- data-flow-campaign-analysis-complete.png
- data-flow-campaign-analysis-derived-column-preview.png
- data-flow-campaign-analysis-derived-column-settings.png
- data-flow-campaign-analysis-name.png
- data-flow-campaign-analysis-new-derived.png
- data-flow-campaign-analysis-new-select.png
- data-flow-campaign-analysis-new-select2.png
- data-flow-campaign-analysis-new-sink-settings-options.png
- data-flow-campaign-analysis-new-sink-settings.png
- data-flow-campaign-analysis-new-sink.png
- data-flow-campaign-analysis-select-settings.png
- data-flow-campaign-analysis-select-settings2.png
- data-flow-campaign-analysis-source-preview.png
- data-flow-campaign-analysis-source-projection.png
- data-flow-campaign-analysis-source-settings.png
- data-flow-canvas-add-source.png
- data-flow-debug-session-large-ir.png
- data-flow-import-projection.png
- data-flow-script-columns.png
- data-flow-script.png
- data-flow-user-profiles-add-source.png
- data-flow-user-profiles-complete.png
- data-flow-user-profiles-data-preview.png
- data-flow-user-profiles-data-preview2.png
- data-flow-user-profiles-derived-column-settings.png
- data-flow-user-profiles-derived-column2-settings.png
- data-flow-user-profiles-derived-column3-preview.png
- data-flow-user-profiles-derived-column3-settings.png
- data-flow-user-profiles-flatten-data-preview.png
- data-flow-user-profiles-flatten-settings.png
- data-flow-user-profiles-flatten2-data-preview.png
- data-flow-user-profiles-flatten2-settings.png
- data-flow-user-profiles-join-inspect.png
- data-flow-user-profiles-join-optimize.png
- data-flow-user-profiles-join-preview.png
- data-flow-user-profiles-join-settings.png
- data-flow-user-profiles-new-derived-column.png
- data-flow-user-profiles-new-derived-column2.png
- data-flow-user-profiles-new-derived-column3.png
- data-flow-user-profiles-new-filter-settings.png
- data-flow-user-profiles-new-filter.png
- data-flow-user-profiles-new-flatten.png
- data-flow-user-profiles-new-flatten2.png
- data-flow-user-profiles-new-join.png
- data-flow-user-profiles-new-sink-settings-mapping.png
- data-flow-user-profiles-new-sink-settings-options.png
- data-flow-user-profiles-new-sink-settings.png
- data-flow-user-profiles-new-sink.png
- data-flow-user-profiles-script-link.png
- data-flow-user-profiles-script.png
- data-flow-user-profiles-source-options.png
- data-flow-user-profiles-source-settings.png
- data-flow-user-profiles-source2-projection.png
- data-flow-user-profiles-source2-settings.png
- data-hub-parquet-select-rows.png
- data-hub.png
- dataflowactivityscript.png
- develop-hub.png
- getting-started.png
- integration-runtine-setup.png
- ir-code-link.png
- ir-code-view.png
- lab3_statistics_automated.png
- lab3_statistics_customerid.png
- manage-hub.png
- monitor-hub.png
- new-cell.png
- new-copy-data.png
- new-data-flow-link.png
- new-dataset-campaign-analytics-asa.png
- new-dataset-staging-sale-asa.png
- new-dataset-userproductreviews.png
- new-dataset-usertopproductpurchases.png
- new-dataset.png
- new-ir-form.png
- new-ir-link.png
- new-pipeline.png
- new-spark-notebook-sales-displayed.png
- new-spark-notebook-sales.png
- notebook-top-products-attach-pool.png
- notebook-top-products-load-python-df.png
- notebook-top-products-top-5-preferred-output.png
- notebook-top-products-top-preferred-df.png
- orchestrate-hub.png
- pause-sql-pool.png
- pipeline-campaign-analysis-adding-data-flow.png
- pipeline-campaign-analysis-data-flow-settings.png
- pipeline-campaign-analysis-debug-succeeded.png
- pipeline-campaign-analysis-drag-data-flow.png
- pipeline-campaign-analysis-run-complete.png
- pipeline-copy-sales-drag-copy-data.png
- pipeline-copy-sales-name.png
- pipeline-copy-sales-pipeline-run.png
- pipeline-copy-sales-settings.png
- pipeline-copy-sales-sink-dataset.png
- pipeline-copy-sales-sink-mapping.png
- pipeline-copy-sales-sink-settings.png
- pipeline-copy-sales-source-dataset.png
- pipeline-debug.png
- pipeline-trigger-now.png
- pipeline-trigger-run.png
- pipeline-trigger.png
- pipeline-user-profiles-activity-runs.png
- pipeline-user-profiles-adding-data-flow.png
- pipeline-user-profiles-data-flow-details.png
- pipeline-user-profiles-data-flow-settings.png
- pipeline-user-profiles-data-flow-sink-details.png
- pipeline-user-profiles-debug-succeeded.png
- pipeline-user-profiles-run-complete.png
- pipelinedfactivitygeneralca.png
- placeholder.png
- poorly-formatted-csv.png
- publish-all-1.png
- rename-publish-sql-script.png
- resume-sql-pool.png
- sale-small-20100102-snappy.parquet
- select-top-1000-rows-campaign-analytics.png
- select-workspace.png
- sort-desc-error.png
- spark-display-sales.png
- spark-explode-output.png
- spark-grouped-top-purchases-total-items.png
- spark-grouped-top-purchases.png
- spark-json-output-nested.png
- spark-toppurchases-output.png
- sql-on-demand-selected.png
- sql-serverless-aggregates.png
- sqlpool01-import01-linked-service.png
- synapse-studio-new-sql-script.png
- synapse-studio-query-toolbar-connect.png
- synapse-studio-query-toolbar-run.png
- synapse-studio-usertopproductpurchases-new-notebook.png
- workload-classifiers-query-results.png
- activity01-data-lake-design-and-security-considerations.md
- activity02-data-engineering-discussion.md
- Day 1 - Technical Bootcamp.pdf
- Day 1 - Technical Bootcamp.pptx
- lab01-data-integration-part-1.md
- lab01-data-integration-part-1.pdf
- lab02-data-integration-part-2.md
- lab02-data-integration-part-2.pdf
- README.md
- demo-01-dsql-plans.md
- dmvs-pie-chart.png
- dmvs-query-operations.png
- dmvs-top-5-queries.png
- lab3_materialized_view_rebuilt.png
- lab3_materialized_view_updated.png
- lab3_ordered_cci.png
- lab3_ordered_cci_2.png
- lab3_query_id.png
- lab3_result_set_cache_build.png
- lab3_result_set_cache_off.png
- lab3_result_set_cache_size.png
- lab3_result_set_caching_db.png
- lab3_shuffle_move.png
- lab3_shuffle_move_2.png
- lab3_shuffle_move_3.png
- lab3_shuffle_move_4.png
- lab3_statistics_automated.png
- lab3_statistics_customerid.png
- lab3_table_space_usage.png
- lab4_column_store_row_groups.png
- lab4_column_store_row_groups_2.png
- lab4_data_skew_1.png
- lab4_data_skew_2.png
- lab4_data_type_selection.png
- lab4_table_space.png
- lab4_transaction_items_count_distribution.png
- lab5_aadgroupaddmembersblade.png
- lab5_aadgroupcopyobjectid.png
- lab5_aadgroupmembersaddtoolbar.png
- lab5_aadgroupmembersmenu.png
- lab5_aadgroupsmenu.png
- lab5_addroleassignmenttocontainerblade.png
- lab5_azurekeyvaultlinkedservicesearch.png
- lab5_filesystemcontainerfromlist.png
- lab5_keyvaultaddaccesspolicy.png
- lab5_keyvaultaddaccesspolicymenu.png
- lab5_keyvaultbasicstab.png
- lab5_keyvaultcreatesecretforpipeline.png
- lab5_keyvaultlinkedserviceform.png
- lab5_keyvaultsecretidentifier.png
- lab5_linkedservicesnewmenu.png
- lab5_newlinkedservicewithakv.png
- lab5_newpipelinevariable.png
- lab5_pipelineconfigsetvaractivity.png
- lab5_pipelineconfigurewebactivity.png
- lab5_pipelinedebugmenu.png
- lab5_pipelinekeyvaultsecretmenu.png
- lab5_pipelinesetvariableactivityinputresults.png
- lab5_pipelinewebactivitynew.png
- lab5_portalaadmenu.png
- lab5_portalcreatearesource.png
- lab5_posixaclcontributors.png
- lab5_selectusersaadgrouplist.png
- lab5_sqlpoolenabletdeform.png
- lab5_sqlpoolresourcetransparentdataencryptionmenu.png
- lab5_storageaccountrbac.png
- lab5_storageacctcontainerstile.png
- lab5_synapsecolumnlevel.png
- lab5_synapsedynamicdatamasking.png
- lab5_synapsefirewalladdclientipmenu.png
- lab5_synapsefirewalladdiprange.png
- lab5_synapserowlevelsecurity.png
- lab5_synapsestudiocreatenewpipelinemenu.png
- lab5_synapsestudiodatabladewwi.png
- lab5_synapsestudiodatalakemanageaccess.png
- lab5_synapsestudiodatamenuitem.png
- lab5_synapsestudiodevelopmenuitem.png
- lab5_synapsestudiodevelopnewsqlscriptmenu.png
- lab5_synapsestudiomanageaccessdirectoryblade.png
- lab5_synapsestudiomanagemenu.png
- lab5_synapsestudioorchestratemenu.png
- lab5_synapsestudioqueryruntoolbarmenu.png
- lab5_synapsestudioquerytoolbar.png
- lab5_synapsestudioquerytoolbarpublishmenu.png
- lab5_synapsestudioquerywindowpropertiesmenuandform.png
- lab5_synapseworkspacefirewallmenu.png
- lab5_synstudaccesscontroladdmenu.png
- lab5_synstudmanageaccesscontrolmenu.png
- lab5_workspacecreatewithmanagedvnet.png
- lab5_workspacehasvnet.png
- lab5_workspacesqladadmin.png
- lab5_workspacesqladmin.png
- lab7_model_training_and_registration.png
- manage-hub.png
- networking.png
- pause-sql-pool.png
- pipeline-activities-set-variable.png
- placeholder.png
- resource-group-key-vault.png
- resource-group-sqlpool01.png
- resume-sql-pool.png
- ssms-execution-plan.png
- ssms-toolbar-display-estimated-execution-plan.png
- xml-formatter-explain.png
- activity03-dw-optimization-storyboard.pptx
- activity03-dw-optimization.md
- activity03-dw-optimization.pdf
- activity04-security-storyboard.pptx
- activity04-security.md
- activity04-security.pdf
- Day 2 - Technical Bootcamp.pdf
- Day 2 - Technical Bootcamp.pptx
- lab03-dw-optimization-part-1.md
- lab03-dw-optimization-part-1.pdf
- lab04-dw-optimization-part-2.md
- lab04-dw-optimization-part-2.pdf
- lab05-security.md
- lab05-security.pdf
- README.md
- cancel-recursive-ba.png
- cancel-recursive.png
- data-hub.png
- develop-hub.png
- ex01-task01-01.png
- ex01-task01-02.png
- ex01-task01-03.png
- ex01-task01-04.png
- ex01-task02-01.png
- ex01-task02-02.png
- ex01-task02-03.png
- ex01-task02-04.png
- ex01-task02-05.png
- ex01-task02-06.png
- ex02-task01-01.png
- ex02-task01-02.png
- ex02-task01-03.png
- ex02-task01-04.png
- ex02-task01-05.png
- ex02-task01-06.png
- ex02-task02-01.png
- ex02-task02-02.png
- ex02-task02-03.png
- ex02-task03-01.png
- ex02-task03-02.png
- ex02-task03-03.png
- lab06-deploy-model-to-database.png
- lab06-machine-learning-process.png
- lab06-model-inputs-mapping.png
- lab06-predict-with-a-model.png
- lab06-prediction-results.png
- lab06-run-predict-sql-statement.png
- lab06-select-latest-model.png
- lab07-completed-spark-job.png
- lab07-monitor-spark-job.png
- lab07-new-spark-job-definition.png
- lab07-spark-job-properties.png
- lab07-submit-spark-job.png
- manage-hub.png
- pause-sql-pool.png
- query-active-requests-results.png
- resume-sql-pool.png
- sparkpool02_location_lab6.png
- sql-dsql-plan-results.png
- sql-query-2-results.png
- sql-query-4-results.png
- sql-result-below-normal.png
- synapse-studio-new-sql-script.png
- synapse-studio-query-toolbar-connect.png
- synapse-studio-query-toolbar-run.png
- trigger-data-analyst-and-ceo-queries-pipeline.png
- activity05-model-implementation-with-predict-storyboard.pptx
- activity05-model-implementation-with-predict.md
- activity05-model-implementation-with-predict.pdf
- activity05-ci-cd-with-synapse-workspace.md
- activity05-ci-cd-with-synapse-workspace.pdf
- activity06-monitor-and-manage-storyboard.pptx
- activity06-monitor-and-manage.md
- activity06-monitor-and-manage.pdf
- Day 3 - Technical Bootcamp.pdf
- Day 3 - Technical Bootcamp.pptx
- lab06-machine-learning.md
- lab06-machine-learning.pdf
- lab07-spark.md
- lab07-spark.pdf
- lab08-monitoring.md
- lab08-monitoring.pdf
- README.md
- placeholder.png
- challenges.md
- challenges.pdf
- coach-guidance.md
- Day 4 - Technical Bootcamp.pptx
- README.md
- AMLStudio.Default
- AutoML.png
- enable-managed-vnet-1.png
- enable-managed-vnet-2.png
- icon.png
- managed-pe-for-sql-1.png
- managed-pe-types.png
- power-bi-optimization.png
- powerbi-report.png
- DevOps.pptx
- Power BI.pptx
- Security.pptx
- Spark and ML.pptx
- 001-LinkWorkspace.png
- 002-NewPowerBILinkedService.png
- 002-PowerBILinkedService.png
- 003 - PowerBIWorkspace.png
- 004 - PowerBIWorkspaceNode.png
- 005 - SynapseWorkspaceInPowerBI.png
- 011-NewPBIDataset.png
- 012 - NewPBIDataset.png
- 013 - NewPBIDataset.png
- 014 - NewPBIDataset.png
- 015 - NewPBIDataset.png
- 021 - ConnectionSettingsPowerBIDesktop.png
- 022 - Datasource Navigator .png
- 022 - SelectDirectQuery.png
- 023 - Datasource Settings.png
- 023 - Edit datasource permissions.png
- 024 - Edit datasource.png
- 025 - DeleteTheNavigationStep.png
- 026 - CloseAndApply.png
- 027 - CreateVisualization.png
- 028 - ConfigureVisualization.png
- 029 - MonitorQueryExecution.png
- 030 - CheckRequestContent.png
- 031 - QueryRequestContent.png
- 031 - QuerySQLOnDemand.png
- 032 - Open Data Linked.png
- 032 - Publish.png
- 033 - ExploreFileSystemStructure.png
- 034 - Generate select script.png
- 035 - Data structure in parquet file.png
- 036 - Configure Connection to SqlOnDemand.png
- 037 - GetData.png
- 038 - Configure Connection.png
- 039 - Preview data.png
- 040 - Configure line chart axes.png
- 041 - Refreshdata.png
- 041 - Sort ascending.png
- 042 - Sort by Date.png
- ConnectPBILinkedService.png
- CreateMaterializedView.png
- CreatePBILinkedService.png
- CreatePBIWorkspace.png
- IntegrationDiagram.png
- power-bi-optimization.png
- SelectPBILinkedService.png
- StartPowerBIDesktop.png
- power-bi.md
- spark_pool_applications.jpeg
- spark_pool_cancel_application.jpeg
- sql_pool_resume.png
- whiteboard_personal_account.jpeg
- attendee-experience.md
- labs.md
- README.md
- synapse-features.md
- unanswered.md
- lab3_materialized_view_rebuilt.png
- lab3_materialized_view_updated.png
- lab3_ordered_cci.png
- lab3_ordered_cci_2.png
- lab3_query_id.png
- lab3_result_set_cache_build.png
- lab3_result_set_cache_off.png
- lab3_result_set_cache_size.png
- lab3_result_set_caching_db.png
- lab3_shuffle_move.png
- lab3_shuffle_move_2.png
- lab3_shuffle_move_3.png
- lab3_shuffle_move_4.png
- lab3_statistics_automated.png
- lab3_statistics_customerid.png
- lab3_table_space_usage.png
- lab4_column_store_row_groups.png
- lab4_column_store_row_groups_2.png
- lab4_data_skew_1.png
- lab4_data_skew_2.png
- lab4_data_type_selection.png
- lab4_table_space.png
- lab4_transaction_items_count_distribution.png
- powerbi_optimization.png
- sampleperformancemetricchart.png
- sqlpool_availablemetrics.png
- 01-overview.md
- 02-optimizing-pipelines-and-data-flows.md
- 03-optimizing-sql-pools.md
- 04-optimizing-spark-pools.md
- 05-optimizing-power-bi.md
- README.md
- .gitignore
- README.md
// repository documentation
Was this content helpful?
(0 ratings)