Transformation is the key part of data processing. You can transform data in various ways and use variety of tools depending on the requirements, platform, usage and preference. Snowflake offers variety of features and extended support to other tools to transform data. Snowflake SQL team is continuously working on improving SQL features and enabling users to use extended SQL functions.
SQL (Structured Query Language) - With this month release Snowflake announced below SQL updates -
- Execute Immidiate from File - This is feature announced in Preview . This command executes the SQL statements in a file on a stage. The file must contain syntactically valid SQL statements. This feature provides a mechanism to control the deployment and management of your Snowflake objects and code. You can use the EXECUTE IMMEDIATE FROM command to execute scripts in any session.
- organization administrators can use ALTER ACCOUNT command to drop an account URL that was saved when Snowflake Customer Support performed any of the following actions: Renamed the organization, Merged two organizations or Moved an account from one organization to another. An old account URL is dropped automatically 90 days after Snowflake Customer Support performs one of these actions, but the organization administrator can now drop it sooner.
dbt - You can use dbt to ship, transform and transfer data to the Snowflake. You can elevate your data pipeline development and administration using dbt Cloud’s seamless integration with Snowflake. You can implement data pipelines with below features -
- Scale with ease. Control run-time and optimize resource usage by selecting a unique Snowflake warehouse size for each dbt model.
- Build with better tools. Maintain separate production and development environments and leverage git-based version control.
- Protect sensitive data. Manage access to sensitive data with Snowflake’s dynamic data masking and dbt Cloud’s fine-grained access controls.
- Simplify administration. Execute and version control administrative tasks related to dbt projects using dbt hooks and operations macros.
