Create a table with the 1-click experience

Published Aug 23 2020 07:31 AM 1,571 Views

Create a table easily and quickly using 1-click ingestion. 
One-click ingestion helps you ramp-up quickly to create database tables, mapping structures. Select data from different kinds of sources in different data formats to define the table schema. 

To access the wizard from the Azure Data Explorer web UI, right-click the database row in the left menu of the Azure Data Explorer web UI and select Create Table.

 

createtable.png

 

 

The service automatically generates schema, which you can then change and add new mapping based on your data source.

Feel free to use this tool to explore at will, as you will be given the option to revert all changes.

 

Read more about one-click ingestion

%3CLINGO-SUB%20id%3D%22lingo-sub-1606607%22%20slang%3D%22en-US%22%3ECreate%20a%20table%20with%20the%201-click%20experience%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606607%22%20slang%3D%22en-US%22%3E%3CP%3ECreate%20a%20table%20easily%20and%20quickly%20using%201-click%20ingestion.%26nbsp%3B%3CBR%20%2F%3EOne-click%20ingestion%20helps%20you%20ramp-up%20quickly%20to%20create%20database%20tables%2C%20mapping%20structures.%20Select%20data%20from%20different%20kinds%20of%20sources%20in%20different%20data%20formats%20to%20define%20the%20table%20schema.%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20access%20the%20wizard%20from%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdataexplorer.azure.com%252F%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C7e943c4d63ff47d4ca0308d8476f6851%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637337891100111284%26amp%3Bsdata%3Ds5L5T3dRN0HH6V5EME84DBVcKqCX43R9I8V%252F16fhrhY%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAzure%20Data%20Explorer%20web%20UI%3C%2FA%3E%2C%20right-click%20the%26nbsp%3B%3CSTRONG%3Edatabase%3C%2FSTRONG%3E%26nbsp%3Brow%20in%20the%20left%20menu%20of%20the%20Azure%20Data%20Explorer%20web%20UI%20and%20select%26nbsp%3B%3CSTRONG%3ECreate%20Table%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22createtable.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214198iBB2F37D25B1EDF39%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22createtable.png%22%20alt%3D%22createtable.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20service%20automatically%20generates%20schema%2C%20which%20you%20can%20then%20change%20and%20add%20new%20mapping%20based%20on%20your%20data%20source.%3C%2FP%3E%0A%3CP%3EFeel%20free%20to%20use%20this%20tool%20to%20explore%20at%20will%2C%20as%26nbsp%3Byou%20will%20be%20given%20the%20option%20to%20revert%20all%26nbsp%3Bchanges.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fazure%252Fdata-explorer%252Fingest-data-one-click%26amp%3Bdata%3D02%257C01%257Ctzgitlin%2540microsoft.com%257C7e943c4d63ff47d4ca0308d8476f6851%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637337891100121278%26amp%3Bsdata%3D27xlbEJpcd34A%252B0Awjn7wjMB0Nq04oVSruF05N%252FdXlc%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ERead%20more%20about%20one-click%20ingestion%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1606607%22%20slang%3D%22en-US%22%3E%3CP%3ECreate%20a%20table%20easily%20and%20quickly%20using%201-click%20ingestion.%26nbsp%3B%3CBR%20%2F%3EOne-click%20ingestion%20helps%20you%20ramp-up%20quickly%20to%20create%20database%20tables%2C%20mapping%20structures.%20Select%20data%20from%20different%20kinds%20of%20sources%20in%20different%20data%20formats%20to%20define%20the%20table%20schema.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22createtable.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214160i51A76BB4FC3DB460%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22createtable.png%22%20alt%3D%22createtable.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1606607%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eadx%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Data%20Explorer%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ehow%20to%20create%20a%20table%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ekql%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Aug 23 2020 01:50 PM
Updated by: