Skip to content

Table Created in Wrong Schema in the Web to Unified Migration Guide #1189

Open
@willhetfield

Description

@willhetfield

Hi, I am working through the migration guide and think I see an issue in the SQL script in the fourth create table command.

https://github.com/snowplow/documentation/blob/main/docs/modeling-your-data/modeling-your-data-with-dbt/migration-guides/web_to_unified/index.md#step-2-execute-sql-scripts-to-create-the-new-tables

create table (your_schema)_derived.snowplow_unified_incremental_manifest as (select * from (your_schema)_derived.snowplow_web_incremental_manifest);

should be

create table (your_schema)_snowplow_manifest.snowplow_unified_incremental_manifest as (select * from (your_schema)_snowplow_manifest.snowplow_web_incremental_manifest);

Otherwise run into a table not existing error at the end of the script

update (your_schema)_snowplow_manifest.snowplow_unified_incremental_manifest
set model = replace(model, 'snowplow_web', 'snowplow_unified')
where 1=1;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions