https://community.databricks.com/t5/data-engineering/address-validation-correction-and-enrichment-with-databricks/m-p/4096#M910 <P>Hi all!</P><P></P><P>In our project, we're thinking about "Validation, Correction and Enrichment of Postal Addresses" with Databricks. For sure we'd need some kind of batch processing, because we have millions of addresses in our system.</P><P></P><P>I'm aware of <A href="https://docs.informatica.com/data-integration/common-content-for-data-integration/10-5-4/developer-transformation-guide/address-validator-transformation/address-validator-transformation-in-a-non-native-environment/address-validator-transformation-on-the-databricks-spark-engine.html" alt="https://docs.informatica.com/data-integration/common-content-for-data-integration/10-5-4/developer-transformation-guide/address-validator-transformation/address-validator-transformation-in-a-non-native-environment/address-validator-transformation-on-the-databricks-spark-engine.html" target="_blank">Address Validator Transformation on the Databricks Spark Engine</A></P><P></P><P>I know about other solutions (from my previous projects) too:</P><UL><LI>"Informatica Address Validator" (formerly known as AddressDoctor) - see link above</LI><LI><A href="https://www.precisely.com/product/precisely-trillium/trillium-geolocation" alt="https://www.precisely.com/product/precisely-trillium/trillium-geolocation" target="_blank">Trillium Geolocation</A></LI><LI><A href="https://developers.google.com/maps/documentation/address-validation" alt="https://developers.google.com/maps/documentation/address-validation" target="_blank">Address Validation API developers.google.com</A></LI><LI>...</LI></UL><P></P><P>Does anybody uses any (Postal) Address Validation/Correction/Enrichment solution on Databricks?</P><P></P><P><B>Scope</B>: European countries/addresses now, non-European countries should follow soon.</P><P></P> Mon, 22 May 2023 07:48:02 GMT de-hru 2023-05-22T07:48:02Z https://community.databricks.com/t5/data-engineering/address-validation-correction-and-enrichment-with-databricks/m-p/4096#M910 <P>Hi all!</P><P></P><P>In our project, we're thinking about "Validation, Correction and Enrichment of Postal Addresses" with Databricks. For sure we'd need some kind of batch processing, because we have millions of addresses in our system.</P><P></P><P>I'm aware of <A href="https://docs.informatica.com/data-integration/common-content-for-data-integration/10-5-4/developer-transformation-guide/address-validator-transformation/address-validator-transformation-in-a-non-native-environment/address-validator-transformation-on-the-databricks-spark-engine.html" alt="https://docs.informatica.com/data-integration/common-content-for-data-integration/10-5-4/developer-transformation-guide/address-validator-transformation/address-validator-transformation-in-a-non-native-environment/address-validator-transformation-on-the-databricks-spark-engine.html" target="_blank">Address Validator Transformation on the Databricks Spark Engine</A></P><P></P><P>I know about other solutions (from my previous projects) too:</P><UL><LI>"Informatica Address Validator" (formerly known as AddressDoctor) - see link above</LI><LI><A href="https://www.precisely.com/product/precisely-trillium/trillium-geolocation" alt="https://www.precisely.com/product/precisely-trillium/trillium-geolocation" target="_blank">Trillium Geolocation</A></LI><LI><A href="https://developers.google.com/maps/documentation/address-validation" alt="https://developers.google.com/maps/documentation/address-validation" target="_blank">Address Validation API developers.google.com</A></LI><LI>...</LI></UL><P></P><P>Does anybody uses any (Postal) Address Validation/Correction/Enrichment solution on Databricks?</P><P></P><P><B>Scope</B>: European countries/addresses now, non-European countries should follow soon.</P><P></P> Mon, 22 May 2023 07:48:02 GMT https://community.databricks.com/t5/data-engineering/address-validation-correction-and-enrichment-with-databricks/m-p/4096#M910 de-hru 2023-05-22T07:48:02Z https://community.databricks.com/t5/data-engineering/address-validation-correction-and-enrichment-with-databricks/m-p/56817#M30659 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/57277">@de-hru</a>&nbsp;, were you able to find more about this. We have a similar need also. Thanks!</P> Wed, 10 Jan 2024 00:02:17 GMT https://community.databricks.com/t5/data-engineering/address-validation-correction-and-enrichment-with-databricks/m-p/56817#M30659 svj 2024-01-10T00:02:17Z https://community.databricks.com/t5/data-engineering/address-validation-correction-and-enrichment-with-databricks/m-p/67484#M33354 <P>Happy to help. Feel free to reach out&nbsp;</P><P><A href="https://www.linkedin.com/in/saleh-sultan-143ab036?utm_source=share&amp;utm_campaign=share_via&amp;utm_content=profile&amp;utm_medium=android_app" target="_blank">https://www.linkedin.com/in/saleh-sultan-143ab036?utm_source=share&amp;utm_campaign=share_via&amp;utm_content=profile&amp;utm_medium=android_app</A></P> Sat, 27 Apr 2024 21:02:35 GMT https://community.databricks.com/t5/data-engineering/address-validation-correction-and-enrichment-with-databricks/m-p/67484#M33354 Sam99 2024-04-27T21:02:35Z