When using Snowflake change bundle2024_03(https://docs.snowflake.com/en/release-notes/bcr-bundles/2024_03_bundle), dbt is issuing adrop table ...for dynamic tables which is resulting in someobject already existsdatabase error. When the the change bundle is disabled - there is no suchdrop...
AzureStorageAuthenticationType AzureStorageLinkedService AzureSynapseArtifactsLinkedService AzureTableDataset AzureTableSink AzureTableSource AzureTableStorageLinkedService BigDataPoolParametrizationReference BigDataPoolReferenceType BinaryDataset BinaryReadSettings BinarySink BinarySource BlobEventTypes Blo...
In the ETL approach, data is replicated using a dedicated CDC tool, then it is consumed in near real-time by an ETL engine like Apache Spark or Flink. The engine then merges the data into a data lakehouse table like Apache Iceberg or Hudi. Either during or after the data arrives, data...
See theSnowflake connector, driver, and library monthly releasesfor current release note and change log informationfrom January 2022 and later. Note that this list doesnotinclude all changes made to SnowSQL; it only lists significant changes or changes that may impact your usage. In addition, th...
SNOW-215983 Added support for unicode in folder names in PUT / GET statements. SNOW-275777 Updated the driver to use JSON format for Win32 applications when exchanging data with Snowflake. SNOW-269456 Upgraded the version of Arrow to 0.17.0. SNOW-78018 Updated the driver to return the query...
AzureTableSource AzureTableStorageLinkedService BigDataPoolParametrizationReference BigDataPoolReferenceType BinaryDataset BinaryReadSettings BinarySink BinarySource BlobEventTypes BlobEventsTrigger BlobSink BlobSource BlobTrigger CassandraLinkedService CassandraSource CassandraSourceReadConsistencyLevels Cassa...
AzureSqlTableDataset AzureStorageAuthenticationType AzureStorageLinkedService AzureSynapseArtifactsLinkedService AzureTableDataset AzureTableSink AzureTableSource AzureTableStorageLinkedService BigDataPoolParametrizationReference BigDataPoolReferenceType BinaryDataset BinaryReadSettings BinarySink BinarySource ...
AzureSqlTableDataset AzureStorageAuthenticationType AzureStorageLinkedService AzureSynapseArtifactsLinkedService AzureTableDataset AzureTableSink AzureTableSource AzureTableStorageLinkedService BigDataPoolParametrizationReference BigDataPoolReferenceType BinaryDataset BinaryReadSettings BinarySink BinarySource BlobEventTypes ...
Snowflake setup Create the target database CREATE DATABASE demo; USE demo; Create the target schema CREATE SCHEMA arcion_cdc; USE demo.arcion_cdc; Create the target table CREATE TABLE IF NOT EXISTS transactions ( transaction_id NUMBER, invoice VARCHAR(55), stock_code VARCHAR(55), description...
Snowflake setup Create the target database CREATE DATABASE demo; USE demo; Create the target schema CREATE SCHEMA arcion_cdc; USE demo.arcion_cdc; Create the target table CREATE TABLE IF NOT EXISTS transactions ( transaction_id NUMBER, invoice VARCHAR(55), stock_code VARCHAR(55), descript...