Invoke-AzSynapseDataFlowDebugSessionCommand

Referensi

Modul:: Az.Synapse

Panggil tindakan debug dalam sesi debug aliran data.

Sintaks

Invoke-AzSynapseDataFlowDebugSessionCommand
      -WorkspaceName <String>
      -SessionId <String>
      -Command <String>
      -StreamName <String>
      [-RowLimit <Int32>]
      [-Expression <String>]
      [-Column <System.Collections.Generic.List`1[System.String]>]
      [-AsJob]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Invoke-AzSynapseDataFlowDebugSessionCommand
      -WorkspaceObject <PSSynapseWorkspace>
      -SessionId <String>
      -Command <String>
      -StreamName <String>
      [-RowLimit <Int32>]
      [-Expression <String>]
      [-Column <System.Collections.Generic.List`1[System.String]>]
      [-AsJob]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Deskripsi

Perintah ini menjalankan pratinjau data/pratinjau statistik/pratinjau ekspresi untuk aliran aliran data yang berbeda dalam sesi debug. Urutan perintah PowerShell untuk alur kerja debug aliran data harus:

Start-AzSynapseDataFlowDebugSession
Add-AzSynapseDataFlowDebugSessionPackage
Invoke-AzSynapseDataFlowDebugSessionCommand (ulangi langkah ini untuk perintah/target yang berbeda, atau ulangi langkah 2-3 untuk mengubah file paket)
Stop-AzSynapseDataFlowDebugSession

Contoh

Contoh 1

$result = Invoke-AzSynapseDataFlowDebugSessionCommand -WorkspaceName ContosoWorkspace -Command executePreviewQuery -SessionId 3afb278e-ac5f-469f-a0b6-2f04c3ab59bc -StreamName source1 -RowLimit 100 -AsJob
$result | Format-Table -wrap

Id     Name                       PSJobTypeName          State         HasMoreData     Location         Command
--     ----                       -------------          -----         -----------     --------         -------
1      Long Running Operation     AzureLongRunningJob`1  Completed     True            localhost        Invoke-AzSynapseDataFlowDebugSessionCommand
       for 'Invoke-AzSynapseD                                                             
       ataFlowDebugSessionCommand'            

$output = ConvertFrom-Json($result.Output.Data)
$output.output

    {
      "schema": "output(ResourceAgencyNum as string, PublicName as string)" ,
      "data": [["4445679354", "Syrian Refugee Information", 1], ["44456793", "Syrian Refugee Information", 1]]
    }

Contoh ini memanggil perintah pratinjau data untuk sesi debug "3afb278e-ac5f-469f-a0b6-2f04c3ab59bc" di ruang kerja Synapse "ContosoWorkspace" dan kemudian mengonversi output JSON menjadi string yang dapat dibaca.

Contoh 2

$ws = Get-AzSynapseWorkspace -Name ContosoWorkspace
$ws | Invoke-AzSynapseDataFlowDebugSessionCommand -Command executePreviewQuery -SessionId 3afb278e-ac5f-469f-a0b6-2f04c3ab59bc -StreamName source1 -RowLimit 100

Contoh ini memanggil perintah pratinjau data untuk sesi debug "3afb278e-ac5f-469f-a0b6-2f04c3ab59bc" di ruang kerja Synapse "ContosoWorkspace" melalui alur.

Parameter

-AsJob

Jalankan cmdlet di latar belakang

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Column

Daftar kolom untuk pratinjau statistik aliran data.

Type:	List<T>[String]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Command

Perintah debug aliran data. Opsional adalah executePreviewQuery, executeStatisticsQuery, dan executeExpressionQuery.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

Meminta Anda mengonfirmasi sebelum menjalankan cmdlet.

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DefaultProfile

Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure.

Type:	IAzureContextContainer
Aliases:	AzContext, AzureRmContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Expression

Ekspresi untuk pratinjau ekspresi aliran data.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-RowLimit

Batas baris untuk pratinjau data aliran data.

Type:	Nullable<T>[Int32]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SessionId

Pengidentifikasi untuk sesi debug aliran data Synapse.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-StreamName

Nama aliran aliran data untuk penelusuran kesalahan.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

Menunjukkan apa yang akan terjadi jika cmdlet berjalan. Cmdlet tidak dijalankan.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WorkspaceName

Nama ruang kerja Synapse.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-WorkspaceObject

objek input ruang kerja, biasanya melewati alur.

Type:	PSSynapseWorkspace
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

Input

PSSynapseWorkspace

Output

PSDataFlowDebugCommandResponse

Bagikan melalui