Lakehouse tutorial: Ingest data into the lakehouse
In this tutorial, you ingest more dimensional and fact tables from the Wide World Importers (WWI) into the lakehouse.
Prerequisites
- If you don't have a lakehouse, you must create a lakehouse.
Ingest data
In this section, you use the Copy data activity of the Data Factory pipeline to ingest sample data from an Azure storage account to the Files section of the lakehouse you created earlier.
Select Workspaces in the left navigation pane, and then select your new workspace from the Workspaces menu. The items view of your workspace appears.
From the +New menu item in the workspace ribbon, select Data pipeline.
In the New pipeline dialog box, specify the name as IngestDataFromSourceToLakehouse and select Create. A new data factory pipeline is created and opened.
On your newly created data factory pipeline, select Pipeline activity to add an activity to the pipeline and select Copy data. This action adds copy data activity to the pipeline canvas.
Select the newly added copy data activity from the canvas. Activity properties appear in a pane below the canvas (you might need to expand the pane upwards by dragging the top edge). On the General tab in the properties pane, type Data Copy to Lakehouse in the Name field.
On the Source tab of the selected copy data activity, select External as Data store type and then select + New to create a new connection to data source.
For this tutorial, all the sample data is available in a public container of Azure blob storage. You connect to this container to copy data from it. On the first New connection screen, select Azure Blob Storage and then select Continue.
On the Connection settings screen, enter the following details and select Create to create the connection to the data source.
Property Value Account name or URL https://azuresynapsestorage.blob.core.windows.net/sampledata
Connection Create new connection Connection name wwisampledata Authentication kind Anonymous Once the new connection is created, return to the Source tab of the copy data activity, and the newly created connection is selected by default. Specify the following properties before moving to the destination settings.
Property Value Data store type External Connection wwisampledata File path type File path File path Container name (first text box): sampledata
Directory name (second text box): WideWorldImportersDW/parquetRecursively Checked File format Binary On the Destination tab of the selected copy data activity, specify the following properties:
Property Value Data store type Workspace Workspace data store type Lakehouse Lakehouse wwilakehouse Root folder Files File path Directory name (first text box): wwi-raw-data File format Binary You have configured the copy data activity. Select the save icon on the top ribbon (below Home) to save your changes, and select Run to execute your pipeline and its activity. You can also schedule pipelines to refresh data at defined intervals to meet your business requirements. For this tutorial, we run the pipeline only once by selecting Run.
This action triggers data copy from the underlying data source to the specified lakehouse and might take up to a minute to complete. You can monitor the execution of the pipeline and its activity under the Output tab, which appears when you click anywhere on the canvas. Optionally, you can select the glasses icon, which appears when you hover over the name, to look at the details of the data transfer.
Once the data is copied, go to the items view of the workspace and select your new lakehouse (wwilakehouse) to launch the Explorer view.
Validate that a new folder wwi-raw-data appears in the Explorer view, and data for all the tables is copied there.
To load incremental data into a lakehouse, see Incrementally load data from a data warehouse to a lakehouse.
Next step
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho