search

fivetran / dbt_fivetran_log

Data models for Fivetran's internal log connector built using dbt.
https://fivetran.github.io/dbt_fivetran_log/
Apache License 2.0
30 stars 24 forks source link

[Feature] Support for Fabric #103

Open itsalljustdata opened 9 months ago

itsalljustdata commented 9 months ago

Is there an existing feature request for this?

Describe the Feature

(this may well be a mate to #94)

Can we get support for reading from a Fabric Warehouse? My suspicion is that the SQL Server changes might well do most of the work for us, but with a fabric__ prefix instead

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

Anything else?

No response

elanfivetran commented 8 months ago

Hey @itsalljustdata , thanks for reaching out and your engagement with our Fivetran Log package! As far as my understanding, Microsoft Fabric supports querying data from various warehouses like Azure Synapse Analytics, Azure SQL Database, Teradata, Snowflake, and even on-premises SQL Server databases using connectors.

Because of that I'm not sure if we can build destination support specifically for Microsoft Fabric, but rather have Microsoft Fabric be able to run one of the warehouses we do support. As you have noticed, we do planning on supporting SQL Server as well in the near future for this specific package.

Are you able to provide which specific warehouse your Microsoft Fabric instance is connected to?

itsalljustdata commented 8 months ago

@elanfivetran - the logs are being written to the OneLake destination type from fivetran, so (AFAIK) it's using Synapse Analytics WH underneath the covers to read the delta files.