Home
%3CLINGO-SUB%20id%3D%22lingo-sub-834816%22%20slang%3D%22en-US%22%3EHow%20to%20ingest%20your%20data%20into%20Azure%20Data%20Explorer%20with%20one%20click%20(preview)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834816%22%20slang%3D%22en-US%22%3E%3CP%3EManual%20ingestion%20of%20new%20data%20into%20Azure%20Data%20Explorer%20requires%20a%20few%20steps%20of%20table%20definition%2C%20mapping%2C%20and%20ingestion%20command%20as%20well%20as%20steps%20specific%20to%20ingestion%20method.%20Using%20One-click%20ingestion%2C%20Azure%20Data%20Explorer%20automatically%20generates%20a%20table%20and%20mapping%20based%20on%20the%20structure%20of%20the%20data%20source%20and%20ingests%20the%20data%20to%20the%20new%20table%20with%20high%20performance.%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EIngest%20new%20data%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E1.%20Open%20%3CA%20href%3D%22https%3A%2F%2Fdataexplorer.azure.com%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Explorer%20web%20UI%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E2.%20Right%20click%20on%20database%20name%20and%20select%26nbsp%3B%3CEM%3E%22Ingest%20new%20Data%22%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E3.%20Complete%20the%20next%20three%20steps%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3ESource%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20502px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129931iE5462E9E71E8C86A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22one-click-ingestion-source.png%22%20title%3D%22one-click-ingestion-source.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22padding-left%3A%2030px%3B%22%3E2.%20Schema%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129932iBD63630B7EEE82E5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22one-click-json-format.png%22%20title%3D%22one-click-json-format.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22padding-left%3A%2030px%3B%22%3E3.%20Ingestion%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129933i7B12F487D9386B75%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22one-click-data-ingestion-complete.png%22%20title%3D%22one-click-data-ingestion-complete.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERead%20more%20on%20one%20click%20ingestion%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-explorer%2Fingest-data-one-click%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELearn%20more%20about%20Data%20Explorer%20(Kusto)%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fazure.microsoft.com%252Fen-us%252Fservices%252Fdata-explorer%252F%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C33b94d34a7284713b30108d68cecb3ce%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636851345592939394%26amp%3Bsdata%3DVgtfwIFedpSnuQd4TClYLJCmmQ3CW%252FeA7coUPv%252FDOiw%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Explorer%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fazure%252Fdata-explorer%252F%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C33b94d34a7284713b30108d68cecb3ce%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636851345592949402%26amp%3Bsdata%3D1Z9Id3dkxVfW8sDD3M6syagFpT83LCwCKxkKTvPppbI%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EDocumentation%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.pluralsight.com%252Fcourses%252Fkusto-query-language-kql-from-scratch%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C33b94d34a7284713b30108d68cecb3ce%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636851345592959411%26amp%3Bsdata%3DlkjFtf%252FAzzi0nnn4jg2pCpfZfLYXugJ%252F2%252F%252FqksySeDc%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECourse%20%E2%80%93%20Basics%20of%20KQL%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fnkwe%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EQuery%20explorer%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fazureportal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Portal%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ffeedback.azure.com%252Fforums%252F915733-azure-data-explorer%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C33b94d34a7284713b30108d68cecb3ce%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636851345592959411%26amp%3Bsdata%3DWRs2tFgokomhQyIgu6dsRuy93JDtzDuzur6xXw7e0so%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUser%20Voice%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fadx.cost%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECost%20Estimator%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%3EJoin%20us%20to%20share%20questions%2C%20thoughts%2C%20or%20ideas%20about%20Azure%20Data%20Explorer%20(Kusto)%20and%20receive%20answers%20from%20the%20diverse%20and%20knowledgeable%20Azure%20Data%20Explorer%20community.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAzure%20Data%20Explorer%20product%20team%3C%2FP%3E%0A%3CP%3E%3CI%3E%3CSPAN%3E%E2%80%9CJoin%20the%20conversation%20on%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Femea01.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ftechcommunity.microsoft.com%252Ft5%252FAzure-Data-Explorer%252Fbd-p%252FKusto%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C9f50757c112e45322d5608d697587c18%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636862803655308273%26amp%3Bsdata%3DSuximQlW7qkiSzSZyJHW9SP4vX1calRCPs4P2HTneII%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Explorer%20community%3C%2FA%3E%E2%80%9D.%3C%2FSPAN%3E%3C%2FI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-834816%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20create%20a%20new%20table%2C%20mapping%2C%20or%20manually%20ingest%20new%20data%20into%20Azure%20Data%20Explorer%2C%20use%20our%20new%20one-click%20ingestion%20feature.%20Azure%20Data%20Explorer%20can%20generate%20and%20run%20table%2C%20mapping%2C%20and%20ingestion%20scripts%20for%20easy%20usage%20and%20fast%20ramp-up.%3C%2FP%3E%3C%2FLINGO-TEASER%3E

Manual ingestion of new data into Azure Data Explorer requires a few steps of table definition, mapping, and ingestion command as well as steps specific to ingestion method. Using One-click ingestion, Azure Data Explorer automatically generates a table and mapping based on the structure of the data source and ingests the data to the new table with high performance.

Ingest new data 

1. Open Azure Data Explorer web UI

2. Right click on database name and select "Ingest new Data"

3. Complete the next three steps:

  1. Source

one-click-ingestion-source.png

2. Schema 

one-click-json-format.png

3. Ingestion 

one-click-data-ingestion-complete.png

 

Read more on one click ingestion here 

 

 

Learn more about Data Explorer (Kusto):

  1. Azure Data Explorer
  2. Documentation
  3. Course – Basics of KQL
  4. Query explorer
  5. Azure Portal
  6. User Voice
  7. Cost Estimator

Join us to share questions, thoughts, or ideas about Azure Data Explorer (Kusto) and receive answers from the diverse and knowledgeable Azure Data Explorer community.

 

Azure Data Explorer product team

“Join the conversation on the Azure Data Explorer community”.