home.social

#365daysofadx — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #365daysofadx, aggregated by home.social.

  1. Azure Data Explorer @azuredataexplorer ·

    Ingest data from to @AzDataExplorer
    Day60

    () Logstash plugin enables you to process events from Logstash into an Azure Data Explorer database for later analysis.

    Learn More
    [1] learn.microsoft.com/en-us/azur
    [2] learn.microsoft.com/en-us/azur

    #logstash #365daysofadx #azuredataexplorer #adx
  2. Azure Data Explorer @azuredataexplorer ·

    Ingest data from to @AzDataExplorer
    Day59

    The sink connector makes ingestion from , code free and configuration based, scalable and fault tolerant, easy to deploy, manage and monitor.

    Learn More: learn.microsoft.com/en-us/azur

    #apachekafka #365daysofadx #adx #kafkaconnect #kafka
  3. Azure Data Explorer @azuredataexplorer ·

    Ingest data in @AzDataExplorer using Output Plugin
    Day58

    output supports both streaming and queued ingestion of data from many types of telegraf input plugins into .

    [1] lnkd.in/dSPGMmRJ
    [2] learn.microsoft.com/en-us/azur

    #telegraf #365daysofadx #azuredataexplorer #adx
  4. Azure Data Explorer @azuredataexplorer ·

    Native Ingestion from Amazon S3 into @AzDataExplorer
    Day56

    Customers can bring data from S3 natively without relying on complex ETL pipelines, with S3 support.

    More: techcommunity.microsoft.com/t5

    Sample: github.com/Azure/azure-kusto-s

    #365daysofadx
  5. Azure Data Explorer @azuredataexplorer ·

    Data Ingestion in @AzDataExplorer
    Day54

    Data ingestion is the process used to load data records from one or more sources into a table in Azure Data Explorer. Once ingested, the data becomes available for query.

    More: learn.microsoft.com/en-us/azur

    #365daysofadx
  6. Azure Data Explorer @azuredataexplorer ·

    Visualize data with @AzDataExplorer dashboards
    Day53

    ADX Dashboards (part of web UI), have a user-friendly interface, allowing users to quickly explore and analyze their data without the need for extensive technical knowledge.

    More: learn.microsoft.com/en-us/azur

    #365daysofadx #adx
  7. Azure Data Explorer @azuredataexplorer ·

    Right semi join in @AzDataExplorer
    Day52

    Right semi-join returns all records from the right side that match a record from the left side. Only columns from the right side are returned.

    Try: lnkd.in/dze9kFTe
    More: lnkd.in/dBznzFTy

    #365daysofadx #kusto #kql #adx
  8. Azure Data Explorer @azuredataexplorer ·

    Left Semi join in @AzDataExplorer
    Day51

    Left semi-join returns all records from the left side that match a record from the right side. Only columns from the left side are returned.

    Try: lnkd.in/dKNy6VKd
    Learn More: lnkd.in/dJrmh-DV

    #365daysofadx #kusto #kql #adx
  9. Azure Data Explorer @azuredataexplorer ·

    Right Anti Join in @AzDataExplorer
    Day50

    Right anti-join returns all records from the right side that don't match any record from the left side.

    Try: lnkd.in/d98BhDNS
    Learn More: lnkd.in/dKCZpyEe

    #365daysofadx #adx #kql #azuredataexplorer #kusto #azure
  10. Azure Data Explorer @azuredataexplorer ·

    Left Anti join in @AzDataExplorer
    Day49

    Left anti-join returns all records from the left side that don't match any record from the right side.

    Try: lnkd.in/dmCi_th4
    Learn More: lnkd.in/dXg9xTB7

    #365daysofadx #kusto #kql #azuredataexplorer #joins #sql
  11. Azure Data Explorer @azuredataexplorer ·

    Full outer join in @AzDataExplorer
    Day48

    A full outer-join combines the effect of applying both left and right outer-joins.

    Run the example: lnkd.in/d8RYX2Mb
    Learn More: lnkd.in/dtSFEG_a

    #365daysofadx #kusto #kql #adx #azuredataexplore #nosql
  12. Azure Data Explorer @[email protected] ·

    Full outer join in @AzDataExplorer
    #365daysofADX Day48

    A full outer-join combines the effect of applying both left and right outer-joins.

    Run the example: lnkd.in/d8RYX2Mb
    Learn More: lnkd.in/dtSFEG_a

    #kusto #KQL #ADX #AzureDataExplore #nosql

    #365daysofadx #kusto #kql #adx #azuredataexplore #nosql
  13. Azure Data Explorer @azuredataexplorer ·

    Right outer join in @AzDataExplorer
    Day 47

    The right outer join flavor resembles the left outer-join, but the treatment of the tables is reversed as it always contains all records on the right table.

    Example: lnkd.in/d83K8e4K
    More: lnkd.in/dybNuaRg

    #365daysofadx
  14. Azure Data Explorer @azuredataexplorer ·

    Inner join in @AzDataExplorer
    Day45

    Like the standard inner-join from the SQL world, an output record is produced whenever a record on the left side has the same join key as the record on the right side.

    Try: lnkd.in/dQHkNfyv
    More: lnkd.in/dK2mBKdD

    #365daysofadx
  15. Azure Data Explorer @azuredataexplorer ·

    Default join in @AzDataExplorer
    Day44

    The default join is an inner join with left side deduplication. It's useful in log/trace analysis scenarios to correlate 2 events, each matching some filtering criterion, under the same correlation ID.

    learn.microsoft.com/en-us/azur

    #365daysofadx
  16. Azure Data Explorer @azuredataexplorer ·

    Create a dashboard from a query in @AzDataExplorer
    Day43

    Dashboards are an excellent way to communicate data science insights visually. You can pin a query as a visual tile in ADX KWE

    Learn More: lnkd.in/dH4r9NWJ

    #365daysofadx #kql #kusto #azuredataexplorer #adx #azure
  17. Azure Data Explorer @azuredataexplorer ·

    Join operator in @AzDataExplorer
    Day42

    Merge the rows of two tables to form a new table by matching values of the specified columns from each table.

    Run the sample - dataexplorer.azure.com/cluster

    Learn more: learn.microsoft.com/en-us/azur

    #365daysofadx #kusto #kql #azuredataexplorer #adx
  18. Azure Data Explorer @azuredataexplorer ·

    Anomaly chart in @AzDataExplorer
    Day41

    The anomaly chart visualization is similar to a timechart, but highlights anomalies using the series_decompose_anomalies function.

    Run this example - dataexplorer.azure.com/cluster


    learn.microsoft.com/en-us/azur

    #365daysofadx #kql #kusto #adx
  19. Azure Data Explorer @azuredataexplorer ·

    in @AzDataExplorer
    Day40

    The time chart visual is similar to a line chart except the x-axis is always time.

    Syntax
    T | render timechart [with ( PropertyName = PropertyValue [, ...] )]

    learn.microsoft.com/en-us/azur

    #timechart #365daysofadx #kql #kusto #adx #azuredataexplorer
  20. Azure Data Explorer @azuredataexplorer ·

    Line chart in @AzDataExplorer
    Day39

    Line charts track changes over short and long periods of time.

    Try it out - dataexplorer.azure.com/cluster
    StormEvents
    | where State=="VIRGINIA"
    | project StartTime, DamageProperty
    | render linechart

    More - learn.microsoft.com/en-us/azur

    #365daysofadx
  21. Azure Data Explorer @azuredataexplorer ·

    Checkout KQL Search: kqlsearch.com
    A aggregator for KQL Queries that are shared on GitHub by @UgurKocDe


    ---
    RT @UgurKocDe
    I also want to thank the community members that share KQL Learning materials and queries with the Community:
    - @reprise_99
    - @rodtrent
    - @kustonaut
    - @BertJanCyber
    - @castello_johnny
    - @ep3p
    - @AzDataExplorer
    twitter.com/UgurKocDe/status/1

    #kql #365daysofadx #kusto #azuredataexplorer
  22. Azure Data Explorer @azuredataexplorer ·

    Card visualization in @AzDataExplorer

    Day38

    The card visual only shows one element. If there are multiple columns and rows in the output, the first result record is treated as set of scalar values and shows as a card.

    Learn More: learn.microsoft.com/en-us/azur

    #365daysofadx #kql
  23. Azure Data Explorer @azuredataexplorer ·

    Scatter chart in @AzDataExplorer
    Day37

    Scatter plots are used to observe relationships between variables. The scatter chart visual can also be used in the context of Geospatial visualizations.

    More: learn.microsoft.com/en-us/azur

    #365daysofadx #kql #adx #azuredataexplorer #kusto
  24. Azure Data Explorer @azuredataexplorer ·

    Stacked Area chart in @AzDataExplorer
    Day36

    The stacked area chart visual shows a continuous relationship. This visual is similar to the Area chart, but shows the area under each element of a series.

    Learn More: learn.microsoft.com/en-us/azur

    #365daysofadx #kql #adx #kusto #azure
  25. Azure Data Explorer @azuredataexplorer ·

    in @AzDataExplorer
    Day35

    The area chart visual shows a time-series relationship. Area charts are ideal for indicating the change among different data sets.

    Learn More: learn.microsoft.com/en-us/azur

    #areachart #365daysofadx #kql #adx #azuredataexplorer #kusto
  26. Azure Data Explorer @[email protected] ·

    #Areachart in @AzDataExplorer
    #365daysofADX Day35

    The area chart visual shows a time-series relationship. Area charts are ideal for indicating the change among different data sets.

    Learn More: learn.microsoft.com/en-us/azur

    #KQL #ADX #AzureDataExplorer #Kusto

    #areachart #365daysofadx #kql #adx #azuredataexplorer #kusto
  27. Azure Data Explorer @azuredataexplorer ·

    Bar chart visual in @AzDataExplorer
    Day34

    Learn more: learn.microsoft.com/en-us/azur

    #365daysofadx #kql #adx #azuredataexplorer
  28. Azure Data Explorer @azuredataexplorer ·

    Render columnchart from query in @AzDataExplorer
    Day33

    Column charts are used for comparing specific subcategory items in a main category range, where the length of each line represents its value.

    Learn more: learn.microsoft.com/en-us/azur

    #kql #365daysofadx #kusto #adx #azure #data
  29. Azure Data Explorer @azuredataexplorer ·

    Create pie chart visuals directly from KQL Queries using @AzDataExplorer
    Day32

    The pie chart visual needs a minimum of two columns in the query result where the first column is used as the color axis and other(s) are numeric data types.

    learn.microsoft.com/en-us/azur

    #365daysofadx
  30. Azure Data Explorer @azuredataexplorer ·

    Visualize query results within seconds in @AzDataExplorer using render operator
    Day31

    Learn More:

    Learn Documentation: lnkd.in/dAhzUbF9

    #365daysofadx #kwe #ke #kql #kusto #visualization
  31. Azure Data Explorer @[email protected] ·

    Visualize query results within seconds in @AzDataExplorer using render operator
    #365daysofADX Day31

    Learn More:

    Learn Documentation: lnkd.in/dAhzUbF9

    #KWE #KE #KQL #Kusto #Visualization #AzureDataExplorer #PowerBI #Data #Microsoft #synapseinfluencers #msftadvocate

    #365daysofadx #kwe #ke #kql #kusto #visualization
  32. Azure Data Explorer @azuredataexplorer ·

    Round values down in @AzDataExplorer using bin function.
    Day30

    It returns the nearest multiple of roundTo below value. Null values, a null bin size, or a negative bin size will result in null.

    More: learn.microsoft.com/en-us/azur

    #365daysofadx #kql #adx #kusto #azuredataexplorer
  33. Azure Data Explorer @azuredataexplorer ·

    Aggregate contents of an input table in @AzDataExplorer using summarize operator.

    Day29

    The summarize operator produces a table that aggregates the content of the input table.

    Learn more: lnkd.in/dhQr2T_Q

    #365daysofadx #kusto #kql #adx #azuredataexplorer #synapse