Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for daviewalesâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Comment | Post #296058 |
Even more wild that it's a [known issue](https://docs.azure.cn/en-us/synapse-analytics/known-issues#querying-a-view-shows-unexpected-results), and there seems to be no plan to fix it. I have no idea how to raise this with Microsoft. (more) |
— | 4 months ago |
| Edit | Post #296059 | Initial revision | — | 5 months ago |
| Answer | — |
A: Prevent Azure Synapse Serverless views from returning invalid data after source file schema change Explicitly specify the schema to ensure that the view continues to return valid data, even if new columns are added to the source file. Adapt the example above as follows to prevent the issue: ``` sql create view test as SELECT FROM OPENROWSET( BULK 'https://example.dfs.cor... (more) |
— | 5 months ago |
| Edit | Post #296058 | Initial revision | — | 5 months ago |
| Question | — |
Prevent Azure Synapse Serverless views from returning invalid data after source file schema change I'm using Azure Synapse Serverless SQL to create views over Parquet files in a data lake. I have encountered an issue where views return invalid results if the source table schema changes. For example, suppose I have the following parquet file: | A | B | C | | - | - | - | | A | B | C | |... (more) |
— | 5 months ago |
| Edit | Post #291292 | Initial revision | — | over 2 years ago |
| Question | — |
Convert Synapse SQL Server hex `sid` to Azure Entra group object ID. Suppose I have an Azure Synapse Serverless SQL database. I can run the following to get the `sid` of added groups: ``` sql select name, typedesc, authenticationtypedesc, sid from sys.databaseprincipals where typedesc = 'EXTERNALGROUP' ``` However, the `sid` is a long hex string, some... (more) |
— | over 2 years ago |
| Comment | Post #284424 |
Consider creating a [minimal reproducible example](https://software.codidact.com/posts/285810/285811#answer-285811) for this question. This will make it easier to answer. (Remove as much code as possible while still reproducing the problem.) (more) |
— | over 2 years ago |