Other: Include Table_Schema and Table_Name in logs
AnsweredExample 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)
-
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?
-
It is so customers can see which tables have been updated.
Please sign in to leave a comment.
Comments
2 comments