Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Other: Include Table_Schema and Table_Name in logs

Answered
Filipe McManus User

Example where EVENT_MESSAGE = 'alter_table':

{"type":"ALTER_COLUMN","oldProperties":{"byteLength":1000,"notNull":false,"columnName":"comments","dataType":"String"},"table":"practice_level_census_data_lookup_scd","properties":{"byteLength":2000,"notNull":false,"columnName":"comments","dataType":"String"}}

This json has the table name (practice_level_census_data_lookup_scd), but not the schema name

Example where EVENT_MESSAGE = 'create_table':

{"schema":"azure_personal_social_services","name":"female_pt_wte_by_local_authority","primary_key_clause":"\"UNIQUE_ID\"","columns":{"value_str":"String","_fivetran_synced":"Instant","unique_id":"BigDecimal","_fivetran_deleted":"Boolean","local_authority":"String","auditkey":"BigDecimal","report_period_length":"String","datasourcefileforthissnapshot_version":"BigDecimal","id":"String","type":"String","effective_snapshot_date":"LocalDate","value":"BigDecimal"}}

This has both the table name (female_pt_wte_by_local_authority) and the schema name (azure_personal_social_services)

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Alexa Maturana-Lowe User

    Hi Filipe McManus - thanks for the feature request. Can you tell me a bit more about the outcome that you're trying to drive with this change? How are you using this? 

  • Filipe McManus User

    It is so customers can see which tables have been updated.