TODO

Source Area Generate Table

Purpose

This code-generation template creates table creation scripts for Snowflake based on source conventions.

Motivation

After importing data definitions from operational systems, a typical next step is generating source objects to load the data delta into. This template creates these tables.

Applicability

• Snowflake

Design Pattern

• Staging / Landing

Schema Type

• Data Object

Output Type

• Data Definition Language (DDL)

Implementation guidelines

This template can be assigned to ‘source’ Data Objects. It will add the defined data solution standard columns and streamline the data types.

Considerations and consequences

N/A.

Extensions

N/A.

Code

--
-- Source table creation statement for {{./conventions.sourceObjectLocation}}.{{name}}.
--
-- Generated from template '{{templateMetadata.name}}'.
--

DROP TABLE IF EXISTS "{{./conventions.sourceObjectLocation}}.{{name}}";

CREATE TABLE "{{./conventions.sourceObjectLocation}}.{{name}}"
(
{{#each dataItems}}
  "{{name}}" {{dataType}}{{#unless @last}},{{/unless}}
{{/each}}
);