Search code examples
azure-sql-databaseazure-data-explorer

.export returns an error "Query could not be parsed" when trying to execute it in the browser query textbox

I'm new to Azure and I'm having troubles. Please help me. Following the article here, I cannot execute the .export query in the browser. It throws Query could not be parsed at '.' on line [1,0]

 .export async to sql ['test-continuous-export.database.windows.net.myFirstTable']
    h@"Server=myConnectionstring" with (createifnotexists="true", primarykey="Id")
    <| print Message = "Hello World!", Timestamp = now(), Id=12345678

I expect the simple printed message to be logged into the database, but it throws an error on the first char.

Solution

  • The command you're running is command that runs against a Kusto/Azure Data Explorer cluster, not against a LogAnalytics workspace. These are two different services, and even though the query language for both is similar-or-identical, management/control commands are significantly different.