incorrect eventsPath in ASP 1.5 - DataFrame & Column module

[Pawelski]

[Kaniz]

Hi @Paweł Tomczyk​, You seem to have an issue with the eventsPath variable in your Azure Stream Analytics (ASA) job using version 1.5 with DataFrame and Column modules.

I'll provide a general overview of setting up an ASA job and configuring the input and output paths correctly.

First, create a new ASA job with the following steps:

1. Sign in to the Azure portal.
2. Click on "Create a resource" in the left-hand menu.
3. Search for "Stream Analytics job" and click on the result.
4. Click the "Create" button and fill in the required information, then click "Create" again to create the job.

Once you have created the ASA job, you must configure the inputs, outputs, and queries. The eventsPath refers to the input data source (e.g., Event Hubs, IoT Hub, or Blob Storage).

Here's how to add input:

1. Go to the Stream Analytics job you created in the Azure portal.
2. Click "Inputs" under "Job Topology" and then click "Add stream input."
3. Select the input type (e.g., Event Hub, IoT Hub, or Blob Storage).
4. Fill in the required information and click "Save."

Now, add an output:

1. Click "Outputs" under "Job Topology" and then click "Add."
2. Select the output type (e.g., Blob Storage, SQL Database, or Event Hub).
3. Fill in the required information and click "Save."

Finally, you can write the query for your ASA job:

1. Click "Query" under "Job Topology."
2. Write your query using the input and output aliases you defined earlier. For example:

SELECT
    input_alias.column1,
    input_alias.column2,
    ...
INTO
    output_alias
FROM
    input_alias

Replace input_alias and output_alias with the input and output aliases you defined when configuring the inputs and outputs.

Ensure your eventsPath is correctly set in the input configuration and the input alias is used correctly in the query. If you still encounter issues, please provide more information about your problem so I can provide more targeted assistance.

[Anonymous]

Hi @Paweł Tomczyk​ 

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you. 

Cheers!