topic Re: Data Warehouse create from REST API to make case-insensitive collation deploy deployment pipeline in Data Warehouse

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

Chatop — Wed, 04 Dec 2024 18:48:56 GMT

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?

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

AndyDDC — Wed, 04 Dec 2024 23:25:40 GMT

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

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

Chatop — Thu, 05 Dec 2024 01:37:54 GMT

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

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

DataBard — Thu, 05 Dec 2024 14:58:18 GMT

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