Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Issue with Invoke-AzOperationalInsightsQuery Returning Incorrect Data Types #25516

Open
hinault opened this issue Jul 11, 2024 · 0 comments
Open

Issue with Invoke-AzOperationalInsightsQuery Returning Incorrect Data Types #25516

hinault opened this issue Jul 11, 2024 · 0 comments
Labels
bug This issue requires a change to an existing behavior in the product in order to be resolved. customer-reported needs-triage This is a new issue that needs to be triaged to the appropriate team.

Comments

@hinault
Copy link

hinault commented Jul 11, 2024

Description

I am encountering an issue with the Invoke-AzOperationalInsightsQuery command while attempting to retrieve the schema of a table. This schema is subsequently used to create a copy of the table. However, there appears to be a discrepancy in the data types returned by the command.

For columns of type GUID, the command returns String as type.

For exemple here is the schema of the source table :

image

The columns TestGuid1 and TestGuid2, which are of type GUID, are being returned as type String.

image

Thanks

Issue script & Debug output

Invoke-AzOperationalInsightsQuery -WorkspaceId MyLAWID -Query "TestDemoTable_CL | getschema | project ColumnName, ColumnType"

Environment data

Name                           Value
----                           -----
PSVersion                      5.1.22621.3880
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.22621.3880
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

Module versions

ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Script     3.0.1      Az.Accounts                         {Add-AzEnvironment, Clear-AzConfig, Clear-AzCont...
Script     3.2.1      Az.OperationalInsights              {Disable-AzOperationalInsightsIISLogCollection, ...

Error output

No response
@hinault hinault added bug This issue requires a change to an existing behavior in the product in order to be resolved. needs-triage This is a new issue that needs to be triaged to the appropriate team. labels Jul 11, 2024
@microsoft-github-policy-service microsoft-github-policy-service bot added customer-reported needs-triage This is a new issue that needs to be triaged to the appropriate team. and removed needs-triage This is a new issue that needs to be triaged to the appropriate team. labels Jul 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug This issue requires a change to an existing behavior in the product in order to be resolved. customer-reported needs-triage This is a new issue that needs to be triaged to the appropriate team.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@hinault