Microsoft Azure Application Insights SQL to Analytics ...
[Pages:2]Microsoft Azure Application Insights
SQL to Analytics language cheat sheet
Download this document at
Select data from table
Null evaluation Comparison operators (date)
Comparison Operators (string)
Comparison (boolean) Distinct Grouping, Aggregation Column aliases, Extending
Ordering
Top n by measure
Union
Join
SQL Query
SELECT * FROM dependencies SELECT name, resultCode FROM dependencies
Analytics Query
dependencies dependencies | project name, resultCode dependencies | project-away name
SELECT TOP 100 * FROM dependencies
SELECT * FROM dependencies WHERE resultCode IS NOT NULL
SELECT * FROM dependencies WHERE timestamp > getdate()-1
dependencies | take 100 dependencies | where isnotnull(resultCode)
dependencies | where timestamp > ago(1d)
SELECT * FROM dependencies WHERE timestamp
BETWEEN '2016-10-01' AND '2016-11-01' SELECT * FROM dependencies WHERE type = "Azure blob"
--substring SELECT * FROM dependencies WHERE type like "%blob%"
dependencies | where timestamp > datetime(2016-10-01)
and timestamp .. UNION SELECT * FROM exceptions WHERE timestamp>..
SELECT * FROM dependencies LEFT OUTER JOIN exception ON dependencies.operation_Id =
exceptions.operation_Id
dependencies | where type startswith "Azure"
dependencies | where type matches regex "^Azure.*" dependencies | where success == "False" dependencies | summarize by name, type dependencies | summarize avg(duration) by name
dependencies | summarize AvgD=avg(duration) by operation_Name | project Name=operation_Name, AvgD
dependencies | project name, timestamp | order by timestamp asc nulls last dependencies | summarize Count=count() by name | top 100 by Count desc
union dependencies, exceptions
dependencies | where timestamp > ago(1d) | union
(exceptions | where timestamp > ago(1d) ) dependencies | join kind=leftouter
(exceptions) on $left.operation_Id == $right.operation_Id
These are just subset of the operators available. Please refer to for a complete reference. Try Analytics yourself by instrumenting with Azure Application Insights, or in the Analytics demo environment: !
? 2016 Microsoft Corporation. All rights reserved.
AIAnalyticsOutreach@ @Azure
Application Insights Analytics ? useful operators
Category Selection and Column aliases Temporary tables and constants
Comparison and String Operators
Relevant Analytics functions
project, project-away, extend
let scalar_alias_name = ...; let table_alias_name = (){ ... | ... | ... };
startswith, !startswith has*, !has contains, !contains, containscs hasprefix, !hasprefix, hassuffix, !hassuffix in, !in matches regex ==, =~, !=, !~
Common string functions
*has is more performant than contains
strcat(), replace() tolower()*, toupper()* substring(), strlen()
Common math functions Parsing text
*for a more performant solution than converting case when comparing strings use: "aBc" =~ "abc"
sqrt(), abs() exp(), exp2(), exp10(), log(), log2(), log10() pow() gamma(), gammaln()
extract(), extractjson(), parse*, split()
Limiting output
*parse is more performant take, limit, top, sample
Date functions
Grouping and aggregation by top, count(), min(), max(), bin() Joins and Unions
hash
now(), ago() datetime(), datepart(), timespan startofday(), startofweek(), startofmonth(), startofyear() endofday(), endofweek(), endofmonth(), endofyear() dayofweek(), dayofmonth(), dayofyear() getmonth(), getyear(), weekofyear(), monthofyear()
summarize by max(), min(), count(), dcount(), avg(), sum(), stddev() countif(), dcountif() argmax(), argmin() percentiles(), percentile_array()
top, top-nested join kind=leftouter, inner, rightouter, fullouter, leftanti
Sort, order Dynamic object (JSON and array) operators and functions
Logical operators
union
sort, order
parsejson() makeset(), makelist() split(), arraylength() zip(), pack()
iff(condition, value_t, value_f)
Machine learning
binary_and(), binary_or(), binary_not(), binary_xor() evaluate
autocluster, basket, diffpatterns, extractcolumns
More info about these and other functions and operators is available on our language reference:
? 2016 Microsoft Corporation. All rights reserved.
AIAnalyticsOutreach@ @Azure
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- delta lake cheatsheet the data and ai company
- microsoft azure application insights sql to analytics
- s p capital iq s excel plug in v 8 x frequently used formulas
- probability cheat sheet blast analytics
- data import tidy data read functions parsing data types
- pandas cheat sheet python data analysis library
- google analytics cheat sheet
- aws certified data analytics specialty exam guide
- a cloud services cheat sheet for aws azure and google cloud
- analytics excel handout shrm
Related searches
- microsoft azure revenue
- microsoft office application free download
- microsoft office application software
- t sql to date
- microsoft azure container
- microsoft azure container registry
- microsoft windows application not responding
- sql to date
- microsoft azure docker
- microsoft office application download
- microsoft azure sql pricing
- microsoft azure python notebook