microsoft / azure_synapse_toolbox Goto Github PK

I'm not sure this is the right place to ask, but Synapse is pretty new so it's tough to find answers to concrete questions. If this isn't the right place, please let me know where I can ask this.

I am using a pipeline to get data from a CSV and compare it to a SQL table. I have data about groups coming from an API, which we're storing in SQL for reporting. One of the column names from the API is "group-id". I need to get all the values of this column and store them in an array variable for comparison with the SQL values. I get this error when I attempt to run the pipeline: {"code":"BadRequest","message":"ErrorCode=InvalidTemplate, ErrorMessage=Unable to parse expression 'activity('Get ids from Data Lake').output.['group-id']'","target":"pipeline/MyAPI_Groups_With_Check/runid/cfe57967-f7bc-48dc-ae2f-5bb92029488c","details":null,"error":null}.

What is the proper way to get the values of this column? Expression I'm trying is: activity('Get ids from Data Lake').output.['group-id']. The output of 'Get ids from Data Lake' is a CSV, and group-id is the name of one of the columns.

Fails on this line:
WHEN 1
THEN CONCAT ('CLUSTERED INDEX (', STRING_AGG(c.Name, ', ') WITHIN GROUP (ORDER BY ic.key_ordinal ASC), ')')

Had to change it to get results back:
WHEN 1
THEN CONCAT ('CLUSTERED INDEX (', STRING_AGG(Convert(VARCHAR(MAX),c.Name), ', ') WITHIN GROUP (ORDER BY ic.key_ordinal ASC), ')')

Followed the instructions and created a workbook however save is not working and throwing error Cannot load from JSON: This item type is 9 (parameters), but the JSON provided was undefined (Unknown)

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

CREATE PROCEDURE dbo.format_recommendation fails on variable re-declaration:

The variable name '@DistribLength' has already been declared. Variable names must be unique within a query batch or stored procedure.```

SP was shared by Diego Caracciolo from his Github: https://github.com/diegocaracciolo/synapse_dmv_reporter

Add the SP and documentation to this repository

The workload classifier query in the Power BI template (WLMClassifier) has incorrect case for the classifier_type and classifier_value columns. They should be lower case, but lines 22 and 23 use camelcase.

Only an issue when the dedicated sql pool is running case sensitive (most aren't, but we are!)

Provided by Nik

No results are displayed when I select [All Authentication] in the [Database Authentication success/failure rate] table in DedicatedSQLPool_workspace_v1.2.workbook.
Because when selecting [All Authentication] button, AuthResult parameter is '', so ksql condition is "where Succeeded == ''".

I think it would be good to fix it as follows,

1. the default value of AuthResult parameter is "true,false",
2. the value of AuthResult parameter when select [All Authentication] button is "true, false"
3. the condition in KQL changes "where Succeeded == '{AuthResult}'" to "where Succeeded in (AuthResult)"

title describes all