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] Audit user activity #89

Closed fivetran-elijahdavis closed 4 months ago

fivetran-elijahdavis commented 11 months ago

Is there an existing feature request for this?

Describe the Feature

Currently, we have a Fivetran platform audit table with data that is focused on a connector audit. However, customers frequently ask how to audit user actions. Thus, I posted an example to our docs. Customers have since requested this to be incorporated into the Fivetran Platform dbt package.

Can we scope this out for implementation into https://fivetran.com/docs/transformations/data-models/fivetran-platform-connector-data-model ?

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

Anything else?

Customers have expressed interest in other auditing queries I posted for the Fivetran Platform connector. Linked here. Could we get an 'audit' project started to review these for implementation into the dbt package?

https://fivetran.com/docs/logs/fivetran-platform/sample-queries#overviewofeventaveragesbyday

https://fivetran.com/docs/logs/fivetran-platform/sample-queries#assignyourownvariancelogicandmonitoryourenvironmentateventlevel

https://fivetran.com/docs/logs/fivetran-platform/sample-queries#reviewdifferenceinsecondsbetweenwritetotablestartandwritetotableendevents

https://fivetran.com/docs/logs/fivetran-platform/sample-queries#reviewrecordsmodifiedcountdatabytable

https://fivetran.com/docs/logs/fivetran-platform/sample-queries#assignyourownvariancelogicandmonitoryourenvironmentattablelevel