Removal of Junk Tables with IDs Automatically Generated during Ingestion via Dynamics API

Removal of Junk Tables with IDs Automatically Generated during Ingestion via Dynamics API

Hello,

When ingesting Dynamics data for Snowflake, we identified that, in addition to the correct tables (such as account, quote, annotation), the system is creating additional unwanted tables, with unique identifier suffixes.
These "garbage" tables have no practical use and negatively impact the organization of the schema in Snowflake, in addition to generating confusion and the need for constant manual cleaning.

We request that the tool be adjusted to:

Do not create additional tables with unique identifiers, keeping only the main tables provided for in the mapping (e.g. account, quote, etc.).
Validate if there is any configuration or error that could be generating these extra tables automatically.
This problem hinders the automation and efficiency of data pipelines and requires attention so that loads are done cleanly and accurately.

We look forward to a solution or guidance to correct this behavior as soon as possible.


TABLE_NAME
account_12526190_e8db_4761_bb8b_95041a2ae641
account_20a314c6_8e42_4851_bd35_c16b1f35bc46
account_a87a6c65_f0c5_43df_8932_9bcc65786bdb
account_c3fe9cf8_8415_4210_8a25_92d233163923
account_d943c5aa_1789_432e_a0cc_ce2f6e2e7c84
annotation_0e8157e0_24a0_4a84_bf66_42fbf91687d4
annotation_19940044_a995_4b23_9712_5db2129afaa4
annotation_28d40867_5dd1_426d_804b_7e150536e458
annotation_3ba740b7_1ba4_41a4_831b_f522314bc9f2
annotation_7241625a_b91c_48e7_89af_d830faa470a1
annotation_b05a288f_ab49_4abc_ad31_1189b4d9ecba
annotation_bef86b5c_112c_49a9_be91_f98803ed5dae
contact_0a843d7e_2a6c_41d2_b62d_1fe4478908b1
contact_12c7fdb2_4f82_4f80_8371_59f4bcf100fa
contact_8ccbde39_e12b_457f_9f5c_01efc08555da
contact_bf097e84_169b_4bdc_a3e0_6359e6922a5e
contact_cdec9e1b_06de_40ec_ab4d_fcaff523bea9
contact_e12c225f_5f6d_4196_bf7a_fe40c9e918fd
contact_fec707ca_44db_4f40_97ac_8738d7dbaaf0
csh_aceitedacampanha_b5062ffc_690d_4f42_8d02_0a4b6acc28b0
csh_analisecredito_01a18112_5c5a_4cb9_aa6c_8a08a050b8c5
csh_analisecredito_4c33f79b_4987_4cee_a7ff_4b08d8eff35e
csh_analisecredito_80d036cb_6383_43b5_b6d0_c809ebc9b86b
csh_analisecredito_a671b13e_e553_49e9_9784_a82ca350ec75
csh_analisecredito_c056d9bb_2bac_4abc_9642_f2884f28e459
csh_analisecredito_dd658895_c9ce_414a_85c0_28a4b2dc21e4
csh_analisecredito_e0c2b654_02f1_4119_aa48_63ef29b91da6
csh_analiseimovel_0fff7f88_1865_4dac_8a56_b5e4e9623d7d
csh_analiseimovel_51212237_988d_441b_af15_cc098a66a2fe
csh_analisejuridica_139d95c6_cda3_40f7_9350_a8fd3c0519be
csh_analisejuridica_55b721fb_0dbf_4bf0_a5bb_96de7fd392a0
csh_analisejuridica_71d0f8a4_abcf_4bd1_a10e_fa764c59d69c
csh_analisejuridica_95acc636_e69a_4468_8206_e9746996288e
csh_auditoriacampo_0f4176b3_ddae_435c_802c_4cf9d62922fe
csh_auditoriacampo_233db1cc_3d05_43a6_a786_6c1cc83c0c71
csh_auditoriacampo_97c8c54e_4774_420f_b875_568c807b389b
csh_auditoriacampo_ae22e1af_b4a8_45ba_aec0_7324368825be
csh_bpfsalesprocessestagiosdaproposta_09891e7c_f84e_491e_90a4_706df054fa7a
csh_bpfsalesprocessestagiosdaproposta_4103a550_fe28_480c_a05e_9e07ca05f897
csh_bpfsalesprocessestagiosdaproposta_4cacab60_a89a_4dfd_b132_66550f0df4cf
csh_bpfsalesprocessestagiosdaproposta_6792a961_5148_4129_912c_5e9aac0326c7
csh_bpfsalesprocessestagiosdaproposta_75414b9e_30af_49bc_a2ae_d060fbc7683b
csh_bpfsalesprocessestagiosdaproposta_a9d9e921_397b_46a9_91d2_98a395181309
csh_bpfsalesprocessestagiosdaproposta_b50d8daa_24ca_4797_bfef_932ff31274b3
csh_cep_051be8d1_0c89_4d91_80f8_98960c567e34
csh_cep_09b5d45a_bc36_4c07_8da1_3072374231ac
csh_cep_23730193_bd9f_42ee_9e5f_738bce628fd0
csh_cep_399ca220_8340_4610_9be2_2b2ea7adf4b9
csh_cep_47f7cc9a_9bc8_4436_a3a9_08905d0f0911
csh_cep_6b839f57_fecc_4655_ae0b_a9545a8aa8ad
csh_cep_88b3d01c_c6ad_44f3_9141_c22b091ef1bb
csh_checklistjuridico_2ce7df97_0745_42a0_ab8f_38e2568032f2
csh_despesa_358151ab_35c2_485f_b257_03ca43129bcd
csh_despesa_6cf932b6_b2dd_4d54_bc02_e0a323cd5628
csh_despesa_f5b5b453_ad63_4ff2_a3c5_1702a6f7879a
csh_dividaproponente_39fff4ff_6f57_476c_b008_9477a3a87c2a
csh_dividaproponente_3e22b95e_45ea_40f1_888f_4b9ac1dc5401
csh_dividaproponente_c90e26ce_bddd_4d7b_a263_7efc458b6647
csh_dividaproponente_ce1c69db_9dff_434b_b342_e4d7332600f9
csh_documento_0014df07_2f39_441a_8a43_6d9a7bf2c5f3
csh_documento_165259db_8e7a_4c31_9db0_11aa54ff44bd
csh_documento_6518e2e6_e654_42a0_8efb_cf9c028f32ea
csh_documento_6ed2967e_fba9_4380_8065_af59efa5bcc1
csh_documento_8e0a3926_45e4_4b10_8bab_5d20927fac6a
csh_garantia_07e2681d_d522_41c5_8261_fa0df4e47a97
csh_garantia_cb7a8c24_1652_4fb4_992b_8836fadb730d
csh_garantia_cd6d7721_5110_42e7_a436_ccf7e4f39f6c
csh_imovel_088c7b78_78b1_4c43_a60d_64aa95ab339c
csh_imovel_9aac372c_b9e7_4576_8ad2_d7d31909a465
csh_imovel_a6c1a430_14a0_438b_bcd2_5d1e7888efc9
csh_imovel_eb751f53_8313_48e6_856e_201a2df9f2c3
csh_imovel_fd1ba9ac_9e7a_40f4_8ab8_c07a4f26ada0
csh_imovel_ff9ed004_aa3f_4f28_9445_e05150820032
csh_imovelxcliente_163466ef_e6a8_4801_8b93_29632c5bd83e
csh_motorneurotech_50b4090c_4947_4129_91ce_0162aa3a4039
csh_motorneurotech_b813db11_bcf9_4661_ae30_47965b8bf536
csh_motorneurotech_bacc0466_1ec2_41e0_a645_8bf951e64bc6
csh_motorneurotech_c27a8066_c4d2_47d4_a72c_9d41b3052d17
csh_motorneurotech_c61aef48_8a7d_4acf_b533_ec701f5d4fe4
csh_motorneurotech_de2937f2_0de4_4077_ae53_beb22b21ac7f
csh_pagamentoefetuado_6efe81fd_5dea_4f08_bd30_696a2d7250fb
csh_pagamentoefetuado_76f429ac_81c1_4b94_ab1c_7340ed3bb0ad
csh_pagamentoefetuado_833425e3_4bae_42b1_b3ae_90a9ffa23b84
csh_pagamentoefetuado_856ff739_0b77_4064_9f3f_a892cf04912a
csh_pagamentoefetuado_953152f1_d457_4ec1_85d2_0e7f4e5e4655
csh_parecer_6c31ac77_0c05_4b71_9f9f_571a6b314c28
csh_parecer_f3a037f9_bb69_4b5d_8928_a834091a8339
csh_proponente_252c8679_41ab_4206_824e_12fbaa87f357
csh_proponente_2f31a7ef_5ad1_4016_9964_16ba7bcb9423
csh_proponente_48448d63_1897_4d02_9bed_805f268a67fd
csh_proponente_6bb3e007_ef37_4c71_904c_f0befd9be559
csh_proponente_6c54d39b_c6c2_4380_a008_93e298c14351
csh_proponente_896cf043_d99d_4352_824a_0ca9d780b78a
csh_proponente_ae4de127_ce49_481e_9254_07566ad2c2d1
csh_proponente_b9c47f42_a9e8_4178_b9e4_71effb3e00bc
csh_proponente_e012d9f7_e704_44a3_b2e8_e7f027ecb2ca
csh_sladeatendimento_10a4d560_98b3_451c_9209_42cfcc657e53
csh_sladeatendimento_2e6cd269_12ad_415b_a9d9_2ea7c0e7c839
csh_sladeatendimento_60ef7c55_7a70_4efc_9de0_3732883c53df
csh_sladeatendimento_7a9f2456_d6af_4207_b7fa_39d812a8c122
csh_sladeatendimento_8fabbcad_fa87_49c8_a2ce_31276d0d938e
csh_sladeatendimento_907890c7_1944_488f_8122_7c0791bc1edb
csh_sladeatendimento_937aef3c_94d8_42c4_9324_4093638c983f
csh_sladeatendimento_ca16e44c_eb40_4469_97e4_b27220007c1f
csh_sladeatendimento_d2c67120_f189_4035_ae88_d3386e9e2acf
csh_sladeatendimento_e774a42b_39df_43b1_bee6_638f0bca4270
csh_solicitacao_89055808_60ac_4389_b7ad_2fc4256852c6
csh_solicitacao_c9bed9d9_287e_453b_9537_f60fe7ddf524
csh_solicitacao_f89f1041_0c0f_44e5_84ac_062e86c66756
email_12aa7a9b_18ee_4ae4_9ab6_6946d808d7b9
email_6817bee7_c12c_4047_8979_36d621f57890
email_6ccd58e9_7541_4dd8_9d84_ce9c75cd1800
email_b50de034_8248_4f62_a05d_530a693af095
email_bb73d9f5_16a4_41a0_b966_0d92a8faafdd
email_ce7877f2_8e51_47eb_b11d_7a5feee61da0
email_dbab438b_0292_4023_97ae_0129118e0d31
invoice_8598c379_3204_41d2_8b57_13679f39e414
invoice_900e0c5d_0647_4e31_88be_16806489e140
invoice_f6d81f32_ce94_48c1_ac2c_c4d00cfdf3d9
invoice_f7c5ada9_91bf_4515_880f_c7d77292985a
lead_d5296f98_c969_4ea9_a08b_1a0ded1ccfaa
lead_e0580ce6_73ef_4654_9dcb_3d200efbfdad
opportunity_099c3a5c_9f00_4a7a_aa39_5f6e000d3c36
opportunity_57ba194a_a24b_4467_880a_a1162ac36ae6
opportunity_7e0457f9_b039_4f14_bb50_1d526899390d
opportunity_7f9af2cd_e731_4d55_85e6_09f3a74a7c5a
opportunity_8e4b08e3_3e55_4265_8685_02a8794c9721
opportunity_9c456c5b_f4b4_4c9e_837e_770fd8584f24
opportunity_fab30d57_3e33_4ef0_8ace_768386dda19a
quote_57e44a1b_bf18_49ca_849f_0cad5d742d63
quote_6774397f_c41f_4e4b_9796_bcdab4240ad7
quote_757c25bc_fb1d_46b5_958e_03413061363b
quote_b5607235_ed57_4bb6_aa06_3e0af3f5a3ef
quote_d20a3f34_6c04_4c3f_8682_a390862f9a25
salesorder_6b702d71_5231_468a_bd67_7bb24f2f2ded
salesorder_a73ba984_a90d_4e43_ac51_19d61c15f1dc
systemuser_10130217_02c7_4ff9_be76_9b31f5cba325
systemuser_af3ad922_7b74_40b7_a5c1_0886ca555b06
systemuser_cf1ccbe6_0765_45dc_bb55_3e4e2cb8b5d0
systemuser_dc5cc831_94b7_4964_9c50_a993b7d2078d
systemuser_fcf502a1_5553_4920_9355_e652cd97c96e
task_217fb101_214c_4bfd_a8eb_47f8e5e7154c
task_774e95d4_16fb_4a56_86b6_a83d0a44ac1f