microsoft/dbt-synapse

add menagerie of external table syntax

dataders opened this issue 4 years ago · 1 comments

dataders commented 4 years ago

For each of these examples, give a snippet of the method to demonstrate how "diverse" the syntax can get using the csvs in https://dbtmsftblob.blob.core.windows.net/jaffle-shop

also we learned that the second option isn't supported for Azure SQL only SQL Server

https://github.com/dbt-msft/dbt-synapse/blob/261d536e31efc28598dc67f3b385119d98a34617/synapse_syntax_wishlist.md#L120-L126

dataders commented 3 years ago

this was done long ago! see here
https://github.com/dbt-msft/dbt-synapse/blob/master/synapse_syntax_wishlist.md#4-accessing-data-from-blob-or-an-external-table