Hi All, Did any one test or create a Custom Materialization which uses COPY INTO command to load data from External table to snowflake ? If you have created a Custom Materialization can you please share the details.

Another neat way of using DBT to load data into Snowflake is by using External Tables. DBT has supported Snowflake’s external tables since v0.14.1. If you define your datasets in your buckets as external tables and you have a sensible folder structure that allows you to define a partition key then…

Custom materialization to load from external table into Snowflake

Help

tristan March 25, 2020, 5:33pm 2

Hi @sudhirnune! You might find this post useful:

1 Like

Topic		Replies	Views
dbt_external_tables: can I create a materialized: table (and not external table) Help snowflake	4	1033	December 1, 2022
Custom Materialization with unique_key Archive	0	1975	October 16, 2020
Accessing external tables in snowflake from dbt Help external-tables , snowflake , dbt-cloud	0	285	August 29, 2024
dbt External Tables - can I use the same external table with different path? Help	0	1484	June 6, 2023
Custom materialization - Run DDL on snowflake -- Error Help	2	1350	January 25, 2023

Custom materialization to load from external table into Snowflake

Related topics