Hi I am using ms sql connector as destination, The version of mssql that I am using is Prod version: Microsoft SQL Azure (RTM) - 12.0.2000.8 May 11 2024 172503 Copyright (C) 2022 Microsoft Corporation The error that i am getting is at normalization part , how to fix this?

('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'COLUMNSTORE' is not supported in this service tier of the database. See Books Online for more details on feature support in different service tiers of Azure SQL Database. (40536) (SQLExecDirectW)")

It looks like you are encountering an error related to the use of columnstore indexes in your Azure SQL Database during the normalization process. The error message indicates that the

COLUMNSTORE

feature is not supported in your current service tier of Azure SQL Database. Here are the steps you can take to address this issue: 1. Disable Columnstore Indexes in Normalization: Since your Azure SQL Database does not support columnstore indexes, you need to disable this feature in the normalization process. Unfortunately, the option to disable columnstore indexes directly in Airbyte's dbt normalization has been deprecated. However, you can manually adjust your dbt models to avoid using columnstore indexes. 2. Upgrade to a Supported Version: Ensure that you are using a version of SQL Server that supports the features you need. According to the [Normalization Requirements](https://docs.airbyte.com/integrations/destinations/mssql#normalization-requirements), normalization is supported on SQL Server 2014 and above. However, since you are using Azure SQL Database, you need to check the specific service tier and its supported features. 3. Manual Workaround: If upgrading or changing the service tier is not an option, you may need to manually modify the dbt models generated by Airbyte to remove or replace the columnstore index creation statements. 4. Check Airbyte Documentation: Refer to the [Airbyte documentation](https://docs.airbyte.com/using-airbyte/core-concepts/basic-normalization#ui-configurations) for more details on how to configure normalization and transformations. Given that the custom dbt transformation feature has been deprecated, you might need to handle these adjustments outside of Airbyte's built-in normalization process. If you continue to face issues, consider reaching out to the Airbyte community or support for further assistance. For more information, you can refer to the following sources: - [Normalization Requirements](https://docs.airbyte.com/integrations/destinations/mssql#normalization-requirements) - [Basic Normalization UI Configurations](https://docs.airbyte.com/using-airbyte/core-concepts/basic-normalization#ui-configurations) If you need further assistance, feel free to ask!