0.12.0-rc: Data API Builder for Azure Databases

[seantleonard]

Changes:

Bug Fixes

• 577a3f1 Fix Performance Issue for filtering on varchar columns in MS_SQL database (Fix Performance Issue for filtering on varchar columns in MS_SQL database #2052) [ MSSQL API slow with large tables due to incorrect varchar/nvarchar in sp_executesql #1973 ]
• 5504205 Ensure endCursor is NULL when hasNextPage is FALSE in GraphQL response (Ensure endCursor is NULL when hasNextPage is FALSE in GraphQL response #2121)
• 0fbf7cf Update DAB CLI to return appropriate exit codes based upon exit reason (Update DAB CLI to return appropriate exit codes based upon exit reason #2084) [ [Bug]: Dab start command exited with code 0 #1777 ]
• aad9c17 When deploying a container app, no longer throw WorkloadProfilePropertyNotSupportedInApiVersion. DAB now uses newer containerApp API version. (Thank you, @Benjiiim!)(Use newer containerApp API version #2114)
• 6a75c76 No longer hang/throw unhandled exception when a table definition is not found in the database when processing relationships. (fix relationship exception on dab validate #2100) [ [Bug]: dab validate returns an Unhandled Exception if a table definition is not inferred  #2037 ]
• 08f4d45 DAB no longer emits an OpenAPI init error message in the console when DAB is configured to use CosmosDB(Condition OpenAPI document creation to non-CosmosDB database types. #2072) [ [Bug]: Console logged "error" when DBtype is Cosmos and OpenAPI service fails to generate doc  #2045 ]
• ffd29b9 Correctly resolve uniqueidentifier database type from dab-config.json defined stored proc parameter default values instead of erroring out. (Resolve uniqueidentifier database type from dab-config.json defined stored proc parameter default values. #2042) [ [Bug]: Parse sp parameter default value from runtime config when target type is UUID. #2027 ]
• d86a6fb Update dab start --help loglevel link to be user-readable (Update dab start --help loglevel link #2083) [ [Bug]: CLI link is unusable #1819 ]
• fa419cd DAB correctly handles tables with the same name, in different schemas (Table name collision bug fix #1990) [ [Bug]: DAB seems to have issues with tables in different schemas that have the same name (SQL Server) #1908 ]
• 9846181 Fix dataSourceName not found exception in dab validate (Fix dataSourceName not found exception in dab validate #2040) [ [Bug]: dab validate getting exception due to datasourceName mismatch #2039 ]
• 8c95d76 Fix error fetching schema from URL error emitted when running dab validate. (Fix dab validate schema fetch Error from URL #2099) [ dab validate fetch schema from url error #2013 ]
• 780f923 Removing wrong FK definition generated during relationship processing which results in correctly withholding redundant join condition added to t-sql query generated when traversing a relationship in GraphQL(Removing wrong FK definition  #2051)

New Config Validation

• a23c590 Validation for relationship defined fields (Add validation for source and target fields in relationships #2139)
  • {source/target}
  • {source/linking-source}
  • {target/linking-target}

New Features

• a999b62 Pagination limits with config properties default-page-size and max-page-size (Adding pagination limits. #2153)
• 7f7c673 Root / endpoint returns DAB Version/App User Agent (Improved Health Endpoint Metadata (DAB Version/App User Agent) #2086) [ Improved HealthEndpoint (Return deployed version at root path) #1971, add current version number #1995 ]

CosmosDB New Features

• e660ba3 Cosmos DB: Item Level AuthZ (DAB config database policy support) (Cosmos DB: Adds Item Level Auth support using DB Policy #2106)
• 22c0ea5 Adding In-Memory cache support for CosmosDB (Adding In-Memory cache support for CosmosDB #2015) [ In Memory Cache - Cosmos #1884 ]
• 97d70f4 Cosmos DB: Upgrade cosmos DB SDK to latest version i.e. 3.38.1 (Cosmos DB: Upgrade cosmos DB SDK to latest version i.e. 3.38.1 #2073)

See More

MSSQL: Multiple Create Functionality (Feature not activated, pending next RC release)

• 2b18315 Multiple-Create : Feature (Multiple-Create : Feature #2122)

MSSQL Engineering Fundamentals (non-user facing changes)

• 9504f1d Change TypeName in DatabaseObject Serialization to exclude unwanted parts (Change TypeName in DatabaseObject Serialization to exclude unwanted parts #2154)
• 6ce6fe5 Update notice-generation.ps1 to fix pipeline Issue (Update notice-generation.ps1 to fix pipeline Issue #2151)
• dbcb651 Move Onebranch docker file out of .pipelines directory (Move Onebranch docker file out of .pipelines directory #2142)
• 2ce1591 Add new Dockerfile for pipeline container usage (Add new Dockerfile for pipeline container usage #2141) [ Pipeline migration #2095 ]
• a937f20 Remove myself from codeowners (Remove myself from codeowners #2120)
• 8a3f38e Disable mssql linux test pipeline (Disable mssql linux test pipeline #2076) [ Disable MSSQL Linux Pipelines #2077, [Bug]: MSSQL (primarily Linux) pipeline flakey #2010 ]
• 2115adf Update CODEOWNERS (Update CODEOWNERS #2044)
• 40142af Maintain Default Data Source Name from Original Config after Hot Reloading (Maintain Default Data Source Name from Original Config after Hot Reloading #2069)
• af42ac2 Only instantiate the file watcher in a hot reloadable scenario (Only instantiate the file watcher in a hot reloadable scenario #2108)

DW

• 5de3682 Introduce new metadata provider initialize method (Introduce new metadata provider initialize method  #2101)
• 31429e5 Making datasourcename mandatory during executequeryasync for multi-db scenario. (Making datasourcename mandatory during executequeryasync for multi-db scenario. #2112)
• ae880ad executionHelper public so consumers of nuget, can call logic (executionHelper public so consumers of nuget, can call logic #2102)
• 894cbeb Stored proc support test cases REST DW. (Stored proc support test cases REST DW. #2048)
• 81e42c9 Fixing nit comments from previous DW mutation support prs. (Fixing nit comments from previous DW mutation support prs. #2043)

CosmosDB - Engineering Fundamentals * 8169f86 Create a unittest pipeline, moving common steps into templates, disable CosmosDB testing on linux (#2049)

• 0920535 Cosmos DB: refactoring tests queries (Cosmos DB: Refactors tests GraphQL queries #2060)
• 165ba8a Cosmos DB: Added Authorization related tests (Cosmos DB: Added Authorization related tests #2034)

This list of changes was auto generated. List items were reorganized and titles were enhanced to provide more information.