v0.7.0

New macro:

• create_index creates a clustered columnstore index on the source table given as argument for SQL Server.

v0.6.0

New macros:

• as_varchar converts a string to a nvarchar(2000) datatype for SQL Server.
• test_type_varchar evaluates whether a field is a string data type. For SQL Server, it is checked that the data type is nvarchar and that the length is not max.

Updates:

• updated string_agg macro to concatenate strings of up to 2000 characters instead of max for SQL Server
• updated generate_variant.sql model to apply the correct nvarchar(2000) datatype for SQL Server

v0.5.0

New macro:

• test_format macro available for testing whether the format of values of the column is as expected

Updates to macros:

• updated test_exists to return a fail instead of an error
• updated to_date to also handle datetime formats
• updated datatype in to_varchar

v0.4.1

Bugfixes for macros:

• generate_id now also works when multithreading is used in Snowflake to run the transformations.

v0.4.0

The following new macro is available:

• generate_id to create an ID field for the current model in which the macro is used. For details on how to use this macro, see the README.md file.

v0.3.1

Bugfixes for macros:

• All tests which checked for proper types of fields did not work properly when the fieldname was encapsulated in extra double quotes. In those cases the test would always pass, even if the type of the field was incorrect.
• The test type_integer only allowed the int type for SQL Server, it now also accepts bigint as type to be compatible with the to_integer macro.

Other updates:

• The documentation and internal code have been updated to use ‘field’ instead of ‘attribute’. Note: Also the test attribute_length was renamed to field_length.
• A file with third party licenses was added

v0.3.0

New macros are available:

• Optional to make sure that a field gets the value null if it is not available in the source data.
• To_boolean to typecast fields to the boolean type for Snowflake and to the bit type in SQL Server. Also the related test to check for boolean types is updated.
• Datediff to compute the difference between two timestamps.

Updates to macros:

• The date/time conversion macros work with a default format when no format is provided. Specifying a format with a variable will override the default.
• To_varchar casts fields to the datatype nvarchar(max) instead of nvarchar(50) for SQL Server.
• String_agg works with data types nvarchar(max) to prevent size limits for SQL Server.
• Test_edge_count is compatible with SQL Server.

v0.2.2

Coding style has been updated to not render white spaces.

v0.2.1

Patch on the functionality: updated macros to type cast attributes to also work on non text attributes.

v0.2.0

• Created macros for process mining tables: edges and variant attribute.
• Updated macros to type cast attributes to also work on non text attributes.
• Updated license file for year 2022.