search

dbt-msft / dbt-synapse-serverless

dbt adapter for dbt serverless pools
MIT License
13 stars 6 forks source link

How to use CETAS? #1

Closed nvinhphuc closed 2 years ago

nvinhphuc commented 2 years ago

Hi there,

Is it possible to use CETAS using this plugin? I want to create external table and export the results to the Azure Data Lake Storage.

This is my expected compiled query:

CREATE EXTERNAL TABLE external_table
WITH (
    LOCATION = 'location/',
    DATA_SOURCE = staging_zone,  
    FILE_FORMAT = SynapseParquetFormat
)  
AS
SELECT * FROM table

How can I do this?

nvinhphuc commented 2 years ago

I'm writing a materialization for CETAS here: https://github.com/intheroom/dbt-synapse-serverless