Data Warehouse create from REST API to make case-insensitive collation deploy deployment pipeline

[Chatop]

From now as my header. I was creating Data Warehouse with REST API to make it case-insensitive collation as this doc :  How to: Create a warehouse with case-insensitive (CI) collation and now I have 3 workspace after I using this method for create Warehouse in first workspace I plan to using deployment pipeline to copy Warehouse name & schema to other stage. But the problem happen when the deployment is creating new Warehouse in other workspace the collation was change from "Latin1_General_100_CI_AS_KS_WS_SC_UTF8" to default one "Latin1_General_100_BIN2_UTF8". Do any one have solution for this?

[DataBard]

If you're okay with a manual approach, you can use a Schema Compare in visual studio to deploy individual objects between two warehouses. As of yet I haven't found a way to do this automatically with Git.

I go over this approach in a video on my YouTube channel here: https://youtu.be/OWF6YlAAY54?si=juZDqE4WWSNNqDp6

[AndyDDC · Accepted solution]

This may be a current limitation. You may need to create a warehouse in each of your deployment workspaces using the api

[Chatop]

Hi @AndyDDC , I have tried that method, but I am facing an issue. I cannot deploy a new table that I created in the Warehouse of my first workspace to another Warehouse in a different workspace. Do you have any suggestions or ideas on how to resolve this