Skip to content

Instantly share code, notes, and snippets.

@ryhanen

ryhanen/stream_analytics_meta.sql

Created September 4, 2015 11:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ryhanen/617867566fd1cd20e41e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ryhanen/617867566fd1cd20e41e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
stream_analytics_meta.sql
SELECT MonitoringInput.InstanceId as Id, MonitoringInput.EventId as EventReference, meta.arrayValue.[Key], meta.arrayValue.Type, meta.arrayValue.Value
INTO Monitoringmeta
FROM MonitoringInput
CROSS APPLY GetElements(MonitoringInput.Metadatas) AS meta
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment