COLLATION VALUE

Target database: Snowflake, Azure SQL Database, Azure Synapse SQL

Agile Data Engine supports column level collation definition in listed target database management systems. Column level collation is defined in the COLLATION VALUE attribute property.

See also:

• Collation Support (Snowflake documentation)

• Column-level collations (MS SQL Docs)

• Attributes

Usage

COLLATION VALUE: collation_specification

Notes

Collation change will force entity recreate.

Examples

Setting column collation in Snowflake

Set case-insensitive and punctuation-insensitive collation for column service_zone in table S_TAXI_ZONE:

COLLATION VALUE:
en-ci-pi

Resulting DDL generated by Agile Data Engine:

CREATE TABLE rdv.S_TAXI_ZONE (
  ...,
  service_zone VARCHAR (255) COLLATE 'en-ci-pi' NULL
);

Setting column collation in Azure SQL Database

Search for supported collations with sys.fn_helpcollations, for example:

SELECT * FROM sys.fn_helpcollations() 
WHERE name LIKE 'SQL%';

Set case-sensitive and accent-insensitive collation for column service_zone in table S_TAXI_ZONE:

COLLATION VALUE:
Latin1_General_CS_AI

Resulting DDL generated by Agile Data Engine:

CREATE TABLE [rdv].[S_TAXI_ZONE] (
  ...,
  [service_zone] VARCHAR (20) COLLATE Latin1_General_CS_AI NULL
);