File Formats

• Fixed create or replace statements for file formats

File Formats

Fixed issue with file format creation

External Tables

• updated External Table creation so that file formats and stages originate in the database where the external table should reside

File Formats

• added in the ability to specify if create or replace or create if not exists is used when creating a file format by adding the parameter create_or_replace to the file_format materialization. Default is true which uses create or replace

Stored Procedures Modifications

• removed the create_or_replace parameter from the stored_procedure materialization as the create or alter doesnt allow for procedure body modifications
• modified the copy grants parameter to default to true as this is the most common use case

Stored Procedures Modifications

• added in the ability to include copy grants when creating or replacing a stored procedure by adding the parameter include_copy_grants to the stored_procedure materialization
• added in the ability to specify if create or replace or create or alter is used when creating a stored procedure by adding the parameter create_or_replace to the stored_procedure materialization. Default is true which uses create or replace

Stored Procedures

• added in the ability to include copy grants when creating or replacing a stored procedure by adding the parameter include_copy_grants to the stored_procedure materialization
• added in the ability to specify if create or replace or create or alter is used when creating a stored procedure by adding the parameter create_or_replace to the stored_procedure materialization. Default is true which uses create or replace

Materialized View

• Update changelog and add new macros for Snowflake materialized views

• Rename materialized_view to snowflake_materialized_view
• Add snowflake__alter_column_comment macro for altering column comments
• Add snowflake__alter_relation_comment macro for altering relation comments

Materialized View

0.2.10.3.beta1

Add support for clustering and automatic clustering in materialized v…

Stored Procedure Parameters

Bug fix for stored_procedure materialization to ensure that the parameters are correctly set up when no parameters are passed in