How best to copy schemas in redshift?

The problem I’m having

I’m experienced with dbt but not so much with redshift. My dbt build takes in excess of an hour and once the tables are built I’m looking for a fast way to copy many at once from schema to schema.

The context of why I’m trying to do this

I’d like to have an up-to-date series of personal schemas for development without duplicating the compute or the time of running dbt build in my own profile.

What I’ve already tried

Not sure where to start, it seems copying tables to s3 might be one avenue? Is there even a native feature for this?

Hey @alibrarydweller, you’re a bit early, but we’re going to have a native dbt clone command coming, most likely in dbt v1.6 (July 2023): [CT-2348] [Feature] `dbt clone` command · Issue #7256 · dbt-labs/dbt-core · GitHub

In the meantime, Snowflake has a clone function (Creating a dev environment quickly on Snowflake), but I’m not sure if there’s something equivalent for Redshift offhand.

Oh wow, that’s spot on for what I was thinking of.

If I’m reading correctly it will come out in core in July and then be up to the adapter/redshift maintainers to implement after that?

1 Like

Redshift support should be there on day one!