Share via

Using table valued functions in Azure Synapse Dedicated SQL Pool and releasing them through Azure pipelines

RickMsBi 86 Reputation points
2021-04-02T10:33:09.243+00:00

I'm using a table valued functions on my Azure Synapse Dedicated SQL pool. I like using them as a way to provide datamart developers with an easy way to use point in time functions to query the PIT tables.

While I can drop, create, alter and even USE these functions without problems. Visual Studio keeps telling me the table valued functions are not supported, and in addition my Azure pipelines won't release them giving me errors regarding these functions not being supported.

The article below states that , although preview, it should work. (And it works, it's just not possible to release through pipeline)

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-function-sql-data-warehouse?view=aps-pdw-2016-au7#see-also

I know one workaround could be including these functions as post- or pre-release scripts, but of course that's not a very neat solution.

Any ideas?

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.